Build a restartable load with durable batch identity, transactional progress, repeatable input, and retries that do not duplicate business effects.
SQLAuthority News – 1700th Blog Posts – Over 25 Millions of Views – A SQL Milestone
My 1700th blog post is a milestone with over 25 million views. I look back at 2011 so far, from my wait types series to my SQL Server Quiz question.
What Is ETL? Extract, Transform and Load Explained
ETL means extract, transform and load, and only the middle word is interesting. What each stage really does, why transform eats most of the schedule, and what changes when a team says ELT instead.
SQL SERVER – What is a Technology Evangelist?
What is a technology evangelist? Someone who spreads the news about new products, but unlike a salesperson, stays brutally honest even if it costs a sale.
Using Query Store to Prove an Upgrade Did Not Hurt
Plan a Query Store upgrade comparison with a captured baseline, matched workload periods, regression review, and carefully monitored plan forcing.
Restoring to a Newer SQL Server Is a One-Way Trip
Plan a restore to newer SQL Server with the version boundary in mind, preserve the original backup, and understand options for moving data back.
How to Check Your SQL Server Version, Edition and Patch Level
Check your SQL Server version, edition and patch level with one query. How to read the build number, why ProductLevel still says RTM on a patched server, and the edition surprise a health check finds most often.