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

In announcing SQL Server Management Studio (SSMS) 21 Preview 1 this week, Microsoft revealed Copilot AI for the tool is also being previewed, privately. A Copilot for the tool that helps users manage, ...

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS).

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

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

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

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...

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