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

While Microsoft SQL Server is capable of supporting huge databases and applications, one of its marketing strengths in smaller organizations and departments is the perception that it “just runs itself ...

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

In SQL Server 2005 we were given the Surface Area Configuration tool to assist us in terms of security. The idea was to help us reduce the “surface area” of the SQL Server from a security point of ...

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

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes. The Import Flat File Wizard streamlines the process of ...

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

PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about all the gory details I was talking to a good friend at Microsoft last week, telling him about the problems I’ve ...