To find the current language of a SQL Server session, read @@LANGUAGE or @@LANGID, or query sys.dm_exec_sessions. This post tests each one, switches the session to German and British, and shows how the language changes month names and how text turns into dates.
Visual Studio – FIX: The ‘SqlStudio Profile Package’ Package Did Not Load Correctly
Launching Visual Studio on my VM failed with: The ‘SqlStudio Profile Package’ package did not load correctly. I gathered a list of fixes that can solve it.
SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?
A client’s availability group showed in SSMS, but no role appeared in Failover Cluster Manager. Here is the sequence of steps that causes this and what to do.
SQL SERVER – Say No To Database Engine Tuning Advisor
I review Database Engine Tuning Advisor recommendations against the workload before applying them. That was the point behind my original opinion.
WRITELOG Waits: Finding What Slows Transaction Log Writes
Diagnose WRITELOG waits with log-file latency, commit patterns, and measured choices for batching, storage, and durability.
Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211
Do parallel threads process equal rows? Usually no, and a simple AdventureWorks query with its actual execution plan proves it in a few seconds.
SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation
Removing extra TempDB files failed with Msg 2555: Cannot move all contents of file to other places to complete the emptyfile operation. Let me show you the steps.