Back up SQL Server to Azure Blob Storage with a version-appropriate SAS credential, a new blob name and a tested recovery plan.
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
Can you give someone near DBA rights without full sysadmin access? Here is how to create a database administrator group using user-defined server roles.
SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”
Creating a linked server between two local instances failed with OLE DB provider SQLNCLI11 returned Invalid authorization specification. Here is the fix.
SQL SERVER – Three Simple Guidelines for System Maintenance – Notes from the Field #098
Notes from the Field #098: three simple guidelines for system maintenance. Automate what you can, document the rest, and always validate.
SQL SERVER – What Does WHERE 1=1 Mean in the Code?
Why do people write WHERE 1=1 in code? It makes building dynamic WHERE conditions easy, since each optional filter can just add an AND clause.
SQL SERVER – What is Windows Internal Database Edition?
Ever seen Windows Internal Database in an ERRORLOG? I explain what this special edition of SQL Server is and where you are likely to find it.
SQL SERVER – Fix: SQL Server CPU Schedulers Offline
A reader’s 80 core server was not using all cores in SQL Server. Here is how to spot CPU schedulers offline and the usual reasons behind them.