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

Last time we discussed creating a script that can retrieve configuration settings from a list of SQL Servers and placing that data into a SQL Server table. Now, let's take a look at another technology ...

Microsoft’s Active Directory has enabled Group Policy since Windows 2000. Policies can be set once then applied continually to hundreds or even thousands of machines within a network enabling central ...

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

The latest version has reached general availability a few months after the release of v18.4. It brings a bunch of new features and general bug fixes, along with more specific improvements. In November ...

It doesn’t seem like it was that long ago that my company’s IT department was bracing for a major new line of work. Back in the mid 1990s, we were going full steam into client-server technology. At ...

Microsoft has announced the general availability of the SQL Server 2025 update policy for Azure SQL Managed Instance, providing customers with expanded control over how and when n ...

Microsoft has revealed some details about what's next for SQL Server Management Studio (SSMS). Customers should expect multiple SSMS releases soon. SQL Server Management Studio (SSMS) is the tool of ...

I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

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