Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. For almost 13 years, Microsoft has tried to make Visual Studio a place where developers can do ...

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.

Every business needs a well-designed database management tool. Finding a well-organized, functional system that allows your team to perform data-related tasks with ease is crucial to the success of ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

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

There are some nifty, better-than-SSMS tools that cost nothing to use. One of them is already in your toolbox and you might not know it. I'm down on SQL Server Management Studio right now. I basically ...