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.
SQL SERVER – What is Interim Table – Simple Definition of Interim Table
What is an interim table? A simple question started a long debate on a call with developers. Here is my simple definition of interim table.
SQL SERVER – Connect Item – Vote for Feature Request Function TRIM
SQL Server has LTRIM() and RTRIM() but no function TRIM. I asked the product team for it twice, and here is the Connect item where you can vote for it.
SQLAuthority News – Summary of TechEd India 2009 – A Grand Event
My summary of TechEd India 2009: Steve Ballmer’s keynote, a talk by the Oscar winning sound designer of Slumdog Millionaire, tech sessions and great community spirit.
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.