SQL Server for Beginners: Part III – SQL Server Management Studio

Once you have SQL Server and all the necessary updates installed, the next step is to learn how to create databases and work with them. The easiest interface available to the beginner is Microsoft SQL Server Management Studio (SSMS), a graphical environment where you can view and manipulate all of the databases and other objects…

SQL Server for Beginners: Part II – Installing SQL Server Express

Just like with any software, SQL Server uses a standard installation program to install its components on your system. Depending on the edition that you’re using, you will be installing it from media that you purchased or from the free install packages that you can download from Microsoft’s website. Unlike other installs, the SQL Server…

Looking for Square Pegs: Finding a Solution and Turning it Into Code

(Previously published on AndrewComeau.com.) Introduction Programming and software development is a type of engineering. More than just sitting down and typing code, it’s about designing solutions to everyday problems using technical knowledge gained over years of training and experience. Larger projects can include a series of challenges to solve, some of which can’t be foreseen until they’re staring you…

Sorting it all out …

I wrote awhile back about how I used Outlook to keep track of things I’m working on and store reminders for project ideas that would be great to work on someday.  I’m still getting the hang of it but I’m a little closer.  The Outlook calendar is a great tool.  I hadn’t used it much before…