How to Rename a Column in SQL Server

Learn how to effectively rename columns in SQL Server using our comprehensive guide. Explore the use of sp_rename, limitations, and best practices

Exporting and Importing Registered Servers in SSMS

This article shows how to import and export a list of registered servers from SSMS.

A First Look at SSMS 20

Recently Microsoft released SQL Server Management Studio (SSMS) v20.0, which is a major release of the primary tool that many of us use to work with SQL Server. Over the last few years, the tools team at Microsoft has worked to separate the tools from the various editions, giving us separate SSMS downloads. There have […]

How Often Do You Update SSMS?

I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop […]

Install SSMS using Powershell DSC

Learn how you can install SMSS automatically using PowerShell DSC as this series continues.

Log File Viewer

How to Import and Export Connections from SQL Server Management Studio

In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.

Recover Recently Closed Tab in SSMS

Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.

Views in SQL Server 2019 with SSMS

This article explores how to create and use views in SQL Server 2019 using SSMS.

Azure Data Studio vs SSMS - Who is the winner?

Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]