Slipstreaming Updates lets SQL Server Setup apply a selected CU during installation with UpdateSource and avoids a separate patch pass.
Splitting Full Names Into First, Middle and Last in T-SQL
Try splitting full names with T-SQL string functions, preserve token order, and flag suffixes or compound surnames for review.
Installing sqlcmd and bcp on a Clean Machine
Installing sqlcmd and bcp on Windows starts with the current Microsoft command line utilities, then PATH and version checks.
Handing Over a Database to Another Team
Handing over a database should include a current map, tested recovery path, access transfer, open risks, and a defined support period.
SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis
Can you write an INNER JOIN using LEFT JOIN? Yes, and the result is the same, but my performance analysis in AdventureWorks shows why you should not.
Seeing What Is Running Right Now
See what is running right now in SQL Server with request DMVs, statement text, plans, waits, and blocking details in one reusable query.
Author Visit – MVP Open Day 2008 – Goa – November 15-17
MVP Open Day 2008 in Goa: my original event announcement, the November 15 to 17 dates, and reflections on meeting friends in the MVP community. Read the original account and follow the rest of the Goa event series.