A reader wanted to reverse string word by word, so “I am Pinal Dave” becomes “Dave Pinal am I”. Here is the function that does it.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – FIX: Error 5161 – An Unexpected file id was Encountered
While building a tempdb demo, SQL Server would not start and ERRORLOG showed Error 5161, an unexpected file id was encountered. I explain what caused it.
SQL SERVER – The Basics of the SSIS Data Flow Task – Notes from the Field #057
Andy Leonard explains the basics of the SSIS Data Flow Task and how a novice developer can learn SSIS from the beginning.
SQL SERVER – Beginning with SQL Server Security Aspects
A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.
SQL SERVER – How to Disable and Enable All Constraint for Table and Database
Readers often ask how to disable and enable all constraint for table and database. Here are simple ALTER TABLE scripts for both, plus one for a single constraint.
Hash Index Bucket Count for Memory-Optimized Tables
Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.
SQL SERVER – Inside Temp table Object Creation – Part II
A first year developer wrote in with a question after my post on temp table object creation. Here is my answer, with a closer look at tempdb.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.