Lmst

I wonder in which version of SQL Server Management Studio #SSMS or #SQL it will be before #Microsoft finally fix the most irritating bug...

"Description: Failed to compiled scripts contained in the package."

Failed to compileD??? Grr!

@awilbert
When I first heard about AI/Copilot inclusion with SSMS, I voiced my displeasure on LinkedIn. It was not well received.

But seeing that ad in SSMS made me feel vindicated with regards to my criticism of MS. They have become so terrible. 🙁

#SSMS
#Microsoft

Microsoft tried to stuff an ad bar into #SSMS, then pushed an update saying you can simply disable it if you don't like it... by editing the registry.

I saw some comments in another posting about this where people were saying "SSMS is free, and Microsoft needs to make money somehow." *facepalm*

#SQLServer

https://developercommunity.visualstudio.com/t/Please-dont-show-ads-in-SSMS/11010321

Headline: New Year's Resolution for DBAs: Make Peace with Copilot

Me: This article is quite a bit different than what the title led me to believe. Really good stuff here.

https://www.sqlfingers.com/2025/12/new-years-resolution-for-dbas-make.html

#SQLServer
#Copilit
#AI
#SSMS

Do you write a lot of paper checks? (I don't--typically it's just one per month.) If so, do you screw up the year when writing in the date for the first few weeks/months of the new year?

This is my TSQL version of that. I'm off to a good start. 🙄

#TSQL
#SSMS
#NewYear

Screen shot of SQL Server Management Studio. Here I am using a custom Code Snippet that adds a comment header for documentation to a Stored Procedure, View, et al. There are 'placeholders' for the object schema, object name, and a date for the initial comment.

Same screen shot as before, but I've typed in the date 'placeholder' with the wrong year (2025 instead of 2026),

SSMS 22 Meets Fabric Data Warehouse: Evolving the Developer Experiences
#Development #Datawarehouse #SSMS #MicrosoftFabric #SQLServer
https://blog.fabric.microsoft.com/en-US/blog/ssms-22-meets-fabric-data-warehouse-evolving-the-developer-experiences/?wt.mc_id=DP-MVP-4015656

SQL Server Management studioの拡張機能を作成してみる
https://qiita.com/tenn25/items/1659c1c0cd3a929f37d7?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #SQLServer #SSMS

Updated blog post:
Added information about limitations and a workaround for transferring SSMS 21 connection history data to SSMS 22 when using the classic Connection Dialog.
https://vladdba.com/2025/11/17/import-saved-connections-from-ssms-21-to-ssms-22/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

https://learn.microsoft.com/en-us/ssms/release-notes-22 - #SQL Server Management Studio (#SSMS) 22 includes #GitHub #Copilot. Download it now.

New blog post:
In which I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information.
https://vladdba.com/2025/11/22/powershell-extract-ssms-21-22-saved-connection-information/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

New blog post:
In which I show you how to easily migrate saved connection details from SQL Server Management Studio 21 to SSMS 22.
https://vladdba.com/2025/11/17/import-saved-connections-from-ssms-21-to-ssms-22/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms #PowerShell

Blog alert!

My SQL Server highlights from the Ignite!

#MicrosoftIgnite
#Ignite2025
#sqlserver
#sqlserver2025
#MicrosoftFabric
#DBA
#ssms
#copilot
#github

http://sqlreitse.com/2025/11/18/ignite-announced-sql-server-2025-and-fabric-sql-ga/

New blog post:
In which I share my SQL Server Management Studio 22 configuration.
https://vladdba.com/2025/11/16/my-sql-server-management-studio-22-configuration/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #ssms

Wait you are telling me that the new #SSMS release now supports grouping by schema?

GitHub Copilot is now in preview for SQL Server Management Studio! Elevate your coding efficiency with AI-powered suggestions directly in SSMS. #GitHub #Copilot #SSMS #SQLServer

https://isaacl.dev/gul

"SQL Formatter
Free extension for SSMS v22. It's technically for VS, but you can use it in SSMS, and SSMS will eventually have its own extensions store."

Note: SSMS v22 represents a preview release.

Link:
https://github.com/madskristensen/SqlFormatter

H/t Brent Ozar's weekly email links: https://www.brentozar.com/subscribe/

#SSMS #SQLFormatter #SQL #TSQL #SQLServerManagementStudio #Extension #Formatting #Format