After 36 flights in two months, my airline review of Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines and Spicejet, ranked by preference.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian
Jacob Sebastian shows how to validate an XML Document in T-SQL with XSD. An XML Schema Collection checks the structure and values of an XML column or variable.
Reading the Error Log With T-SQL
Reading the error log with T-SQL helps you search current and archived SQL Server messages, then set a useful log cycle schedule.
SQL SERVER – Size of Index Table for Each Index – Solution
Two reader solutions to my puzzle: queries that show the size of the index table for each index, accurate in nearly all of my tests.
SQL SERVER – Azure Start Guide – Step by Step Installation Guide
My Azure start guide for the SQL Azure CTP: sign in with your Live ID and invitation code, create a server and database, and set firewall rules.
What Is Installed? Finding Every SQL Server Component
Finding every SQL Server component starts with the Setup discovery report, then checks services, engine versions, and separate client tools.
Following a Blocking Chain to the Head Blocker
Follow SQL Server blocking_session_id through a blocking chain, identify the head blocker, and choose a safe ending for the wait.
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.