Does SET NOCOUNT change @@ROWCOUNT? I ran a quick demo in a session and ten hands went up before I even hit execute. The script and what it shows.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Storing Email Addresses: Length, Case and Unique Keys
Two accounts for one customer usually means nobody wrote down the case rule. Build the table, break each rule, and see what the database can promise.
SQL SERVER – Fix: Error: File Cannot be Loaded Because the Execution of Scripts is Disabled on This System
After a fresh install, PowerShell stopped me with an error: execution of scripts is disabled on this system. The fix takes two lines with Set-ExecutionPolicy.
Handling the Row That Arrives Late
Handle late arriving data with explicit event dates, inferred dimension members, replay windows, and a clear policy for correcting published history.
Listing Server Logins Not Mapped to Any Database User
A login with no database user is not automatically unused. Build the report, compare by SID, and check server roles before you touch anything.
SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server
A PowerShell way to get a list of fixed hard drives and free space on server: MVP Ravikanth’s short script with Get-WmiObject and Win32_LogicalDisk.
SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree
Need to list a directory structure from T-SQL? The undocumented xp_dirtree procedure does it, and here is how to save its output in a temp table.
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.