Engaged in using #SQLServer and #SSMS to assist a client in better managing their data. It's always rewarding to help clients unlock the full potential of their data. #datamanagement #dataanalytics

Documento. SSMS Vega C User’s Manual. Issue 1 – Revision 0

https://www.infosondas.com/2023/03/documento-ssms-vega-c-users-manual-issue-1-revision-0/

#Vega-C #cohete #ssms #usersmanual #vega-c

What is everyone’s favoured method of finding remote-only #SqlServer jobs? Dedicated websites? LinkedIn? #MicrosoftSqlServer #SSMS #SSIS

Hey #sqlserver #ssms users - anyone else nerding out over the new Output window content in version 19?

Is there a way to suppress the "You are not logged in as the database owner or system administrator" warning in SQL Server Management Studio? ⚠

I've skimmed the #SSMS options, but haven't found anything. Maybe a registry setting exists?

Please note: I am not seeking help with SQL Server authentication/authorizations. This is strictly an SSMS question.

#SQLHelp

2023 and still no dark theme for #Microsoft Server Management Studio #SSMS.

I have two performance tips for #sqlserver #SSMS users.
1. If you are working with a very busy database where backups or deletes are holding locks and SSMS can't expand OE nodes or open property sheets, use this registry hack to put SMO queries in Read Uncommitted mode. https://guibubbles.wordpress.com/2017/06/05/ssms-and-smo-query-isolation/

2. When opening Object Explorer to an Azure SQL Database instance as a non-admin user is taking a long time, set your "Connection Timeout" value to a small number like 10 or even 5 seconds. This will cause some background connections to fail more quickly and unblock the real work.

#SSMS19.0.1 bug with partitioned tables
https://feedback.azure.com/d365community/idea/bba67e86-bea6-ed11-a81b-00224850345d
#ssms

Hear me out on this one. #SSMS #SSMS19

Checking for open transaction before closing query windows is helpful for terrestrial installations of SQL Server.

Checking Azure DB/MI for open transactions, so very not helpful. (Not helpful because of the blocking window per tab that takes 15 seconds to feels like forever to check which is bad for people like me who have easily 30+ open tabs at a time)

So, why not both?

SSMS 19 was released last week, so I figured I'd take this opportunity to go through my usual SSMS configuration preferences.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #ssms
https://vladdba.com/2023/01/31/my-sql-server-management-studio-19-configuration

Just me, being a little #SSMS version goblin

Next week's Louisville Data Technology meeting will be GREAT! Steve Hughes is presenting "Out of your #SSMS world, #Jupyter notebooks in #AzureDataStudio".

If you're available for lunch next Thursday please join us! https://www.meetup.com/Louisville-Data-Technology-Group/events/291286770/

#Louisville #Data #Tech

Hmm, the new #Microsoft #SSMS 19 consistently crashes every time that I right click on a registered server and select "Object Explorer". I guess I'll stick with 18. 😕

The #SQL tools team had a busy January!

#SSMS 19.0 is GA! It supports #SQLServer2022 and has a big list of updates. Check out https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16!

ALSO we released #AzureDataStudio 1.41, and let's read about all the connection updates! https://learn.microsoft.com/en-us/sql/azure-data-studio/release-notes-azure-data-studio?view=sql-server-ver16

"#SSMS 19.0 is the first release that is fully aware of #SQLServer 2022 (compatibility level 160)."

https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16

My developers on the other hand...they would benefit from the x64 version more than they know.

They keep getting tripped up using the Import/Export wizard with Excel files on their machines with the x64 version of MS Office installed. It never works, and I have to keep reminding them #SSMS is an x86 app...that requires the x86 version of Office (or an equivalent Access runtime).

Much has been discussed/debated about x86 vs x64 variants for #SSMS. I'll try the x64 app if/when it comes out. But for now, x86 is just fine by me.

I was today old when I learned #SSMS has an option to suppress the save dialog that pops up each time you try to close a query tab.

#Microsoft pls it's 2023, can we have a sidebar in the file picker for restoring databases in #SSMS? Just let me get to the backup I just downloaded in my 'Downloads' folder 😭

#SSMS users looking for support - you can help us help you by clicking the "Show details" button in the error dialog and sharing the full message. #sqlserver