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 […]
2024-07-31
1,871 reads
Learn how to effectively rename columns in SQL Server using our comprehensive guide. Explore the use of sp_rename, limitations, and best practices
2024-06-24
3,032 reads
This article shows how to import and export a list of registered servers from SSMS.
2024-04-29
1,838 reads
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 […]
2024-03-27
10,489 reads
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 […]
2024-02-02
282 reads
Learn how you can install SMSS automatically using PowerShell DSC as this series continues.
2024-01-31
2,405 reads
2022-09-09
560 reads
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.
2022-07-04
Learn different ways to recover a T-SQL script when using SQL Server Management Studio if SSMS is accidently shutdown without saving the script.
2022-06-13
1,881 reads
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
6,226 reads
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item AI Sings the Blues
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers