Prepare your first SQL Server talk with one real problem, two resettable demos, a timed thirty-minute outline, a rehearsal, and a backup plan.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.
Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111
Can a single column and single row result do an entire table scan? I recently got this question in my Comprehensive Database Performance Health Check.
Dirty Read with NOLOCK – SQL in Sixty Seconds #110
Recently I noticed that my client has been using the WITH NOLOCK hint with their queries and expecting that it will improve the queries performance.
Undo Human Errors in SQL Server – SQL in Sixty Seconds #109 – Point in Time Restore
In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let us learn today.
Solve Puzzle about Data type – SQL in Sixty Seconds #108
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback.
How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? One of the most popular questions, I often receive from my client.
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.