I needed SQL code running in parallel for a demo, so I used sqlcmd and start cmd.exe to run multiple batch files together. Can PowerShell do it better?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
hierarchyid GetAncestor: Stop at the Root
hierarchyid GetAncestor returns a logical ancestor path. Its zero-distance result is the original node, while a request beyond the root returns NULL.
SQL SERVER – Concurrency Problems and their Relationship with Isolation Level
What are the four concurrency problems, like lost updates and dirty reads, and how does each one relate to the isolation level you pick in SQL Server?
SQL SERVER – Demo Script – Keeping CPU Busy
A demo script for keeping CPU busy: I wrote this query at an event to simulate high CPU usage, and it pushed CPU from 10% to 80%.
SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave
Lohith from Bangalore took my Uncut and Unedited video interview, with a few personal questions, a few technical ones and a few secrets shared.
SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart
Michael J Swart asked me about life beyond SQL Server, from family memories to writing in English. Read the original interview and see the caricature Michael created for it.
Wait Stats Summary: Every Wait on One Page
This wait stats summary puts every wait from the series on one page: what it means and the first fix to try. On Night 28 at the Clipboard Diner, the critic finally comes on an ordinary Tuesday. The lesson of the whole series is the same as the story’s: know what normal looks like on your server.
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.