Modernize legacy T-SQL by replacing old joins, TEXT columns, and fragile RAISERROR forms with clear, tested alternatives.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Modeling Data Before Writing Tables
Modeling data before tables clarifies entities, relationships, keys, and grain so schema changes do not discover the rules too late.
SQL SERVER – Order of Columns in Update Statement Does not Matter
Does the order of columns in UPDATE statements matter? No. Setting Col1 before Col2 or the other way round gives the same result in SQL Server.
SQL SERVER – Rollback TRUNCATE Command in Transaction
Many believe TRUNCATE cannot be rolled back. It can. Here is a Rollback TRUNCATE command example inside a transaction, and why TRUNCATE is logged.
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT
A Performance Comparison of INSERT TOP (N) INTO a table versus INSERT with SELECT TOP (N). The first is clearly faster, but the two can give very different results.
TechEd Sri Lanka 2010: Two Sessions and a Room Full of Questions
TechEd Sri Lanka ran at Waters Edge in Colombo from February 8 to 10, 2010, and I presented two sessions there. This post looks back at the index session, rated 8.9, and the change data capture session, rated 7.8, and what each one still teaches. It also shares attendee feedback and photos of the people who made the event.
SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement
SQL Server 2008 data and page compressions cut disk space and I/O. I explain ROW and PAGE compression and how to set them on tables, indexes and partitions.
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.