Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group
Migration of SQL Server 2012 database mirroring to AlwaysOn Availability Group can be tricky. Here is the setup and the migration process, step by step.
Agent Tokens in Job Steps: Job Name, Step and Start Time
A copied job should log its own name, not the old one. Agent tokens do that, if you escape them the right way.
SQL Puzzle – A Quick Fun with Bit Wise Operator – Part 2
Part 2 of my quick fun with Bit Wise Operator puzzle uses OR. Why does SELECT 1 | 100 return 101? Leave your answer in the comments.
SQL Puzzle – A Quick Fun with Bit Wise Operator
A quick Friday SQL puzzle on the Bit Wise Operator: SELECT 10 & 10 returns 10, so why do 10 & 0 and 1 & 100 both return zero?
SQL SERVER – Learning SSIS – Where Do I Start? – Notes from the Field #014
Where do you start when learning SSIS? I asked SSIS expert Andy Leonard, and he shares how a novice developer can learn it from the beginning.
SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column
SSMS will not display all the text in a long VARCHAR(MAX) column. Here is how I retrieve all of it by exporting the data to a text file.
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.