SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals.

Another option would be to follow the SQL Server Management Studio pattern and break it down into fine-grained sub-folders. There are two ways to add new items to the project.

Here’s a beginner-friendly project outline for SQL Server that will walk you through designing a schema, creating tables, populating them with data, and writing queries to analyze and manage data.

There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.