What is the right order of hotfix and service pack installs? You do not need every older service pack. Install the latest service pack and hotfix and you are done.
Sending a Microsoft Teams Alert From a SQL Server Agent Job
Send a Teams alert from a failed SQL Server Agent job with a Workflows webhook, PowerShell, SQL Server 2025 REST calls, and mail fallback.
STDEV and STDEVP: Choose Sample or Population
STDEV and STDEVP report spread in the input’s units. Compare a sample, a full population, duplicates, NULL and a single observed value.
SQL SERVER – List All Objects Created on All Filegroups in Database
A reader asked which object belongs to which filegroup. Here is how to list all objects created on all filegroups in a database, with a sample database.
SQL SERVER – Create Multiple Filegroup For Single Database
How to create multiple filegroup for a single database, both for a new database and an existing one, using T-SQL as well as SSMS.
SQL SERVER – Difference Between Candidate Keys and Primary Key
What is the difference between a candidate key and a primary key? A table can have many candidate keys, but only one of them becomes the primary key.
SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct to correct this problem. in a modal dialog with the title SQL Writer
SQLDUMPER library failed initialization in a SQL Writer dialog does not mean you must reinstall SQL Server. Remove SQL Server VSS Writer and reboot.