Beh, non propriamente uno al giorno, ma comunque utilissimi per comprendere alcuni dei meccanismi “dietro le quinte” di SQL Server
#1 March 2011: RESTART option for RESTORE commands (video | demo code)
#2 March 2011: Logging during SELECT-INTO operations (video | demo code)
#3 April 2011: Undocumented DBCC commands (video | demo code)
#4 April 2011: Log file performance analysis (video | demo code)
#5 May 2011: Nested transactions (video | demo code)
#6 May 2011: Checkpoint tracking (video | demo code)
#7 May 2011: Trusting the tools – Kimberly (video)
#8 June 2011: Tempdb latch contention (video | demo code)
#9 June 2011: Wait stats for a single operation (video | demo code)
#10 July 2011: Database snapshots (video | demo code)
#11 July 2011: Undroppable log files (video | demo code)
#12 August 2011: Tail-of-the-log backups (video | demo code)
#13 August 2011: Error log management (video)
#14 September 2011: Inconsistent analysis (video | demo code)
#15 October 2011: Fully logged operations (video | demo code)
#16 October 2011: Tempdb space tracking (video | demo code)
#17 October 2011: Deadlock analysis – Joe (video | demo code)
#18 November 2011: Query timeout debugging (video | demo code)
#19 December 2011: Deadlock debugging – Joe (video | demo code)