The last day at South Asia MVP Open Day in Goa: Open Space sessions at midnight, Nitin Paranjape on being an entrepreneur, and a quiet walk on the beach.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 2
Day 2 at MVP Open Day in Goa ran from 8 AM to 2 AM: technical sessions, a river cruise and a dance party at the casino with fellow MVPs.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1
Day 1 of South Asia MVP Open Day 2008 in Goa: thanks to the Microsoft team who made it happen, a few photos, and a Goan party on the beach with fellow MVPs.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Link List
I have reached Goa for MVP Open Day 2008. Here is the proposed agenda for November 15 to 17, from the welcome note and MVP lead briefing to a Windows 7 demo.
Nullable NOT IN: Read the Row Count Spool Carefully
Nullable NOT IN needs a clear rule for unknown identifiers. Compare NULL and empty-set results before changing the query or interpreting a Row Count Spool.
Reading the Default Trace
Reading the default trace can reveal recent object and configuration changes while its rolling files still retain the evidence.
Baselines: Knowing What Normal Looks Like
Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.
SQL SERVER – Delete Backup History – Cleanup Backup History
SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.
SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB
A quick script to check database integrity for all the databases on a server with DBCC CHECKDB and sp_msforeachdb, and how to read its output.
Why WHERE Runs Before SELECT
Learn logical query processing to understand WHERE, SELECT aliases, grouped filters, and ordering without confusing syntax with execution.