Working with Indexes on SSMS

Overview In SQL Server, indexing is a technique used to improve the performance of queries by reducing the amount of data that SQL Server needs to scan. You can think of it like a table of contents in a book—it helps SQL Server find data more quickly. In this article, we will cover the following […]

Helpful Management Studio Settings and Features

Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.

The End of Azure Data Studio

Azure Data Studio is being retired.

Dark Mode in SSMS 21 and overall first impressions

Let me cut to the chase. If you are like me, you may have been searching for: How to turn on Dark Mode in SSMS V21. Searching for that very thing today inspired me to write this blog to help others do the same thing because I couldn’t seem to find an easy answer.

SSMS Export to Excel

You’re running an ad-hoc query in a Microsoft SQL Server database with SQL Server Management Studio (SSMS) and need to further analyze the result set in an Excel spreadsheet. How do you export the data?

A First Look at SSMS 21

This isn't really a first look, per se. I've seen Erin Stellato present on this a few times in MVP sessions and at the PASS Data Community Summit. However, this is a look on my machine, where I'm in control. The new version preview was announced recently, and this looks at the new process to […]

A Strange Result

Using Registered Servers in SSMS

One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]

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.