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. Here ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

Sometimes, life really is like a box of chocolates. The same can also be said for software upgrades. Take, for instance, Visual Studio 2008. After all its various CTPs and RTMs, I feel like I've been ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...

Fresh on the heels of SQL Server 2014 being released to manufacturing, the SQL Server Data Tools (SSDT) team yesterday announced support for the new version, along with numerous other enhancements.

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

Most people know that SQL Express differs from other editions by the maximum database size (10GB) it allows and by its lack of SQL Agent. In addition to these differences, there are many others, some ...

SQL Server Integration Services (SSIS) is now officially supported in the latest SQL Server Management Studio (SSMS) 22 ...

We take pride in delivering innovation with each new version of Microsoft SQL Server. However, there comes a time when product lifecycles must conclude. On July 14, 2026, SQL Server 2016 will reach ...