Posts

In questa serie di posts Ted Krueger riporta i principali “tips” per chi amministra SQL Server.

SQL Server DBA Tip 1 - Server Configuration - MAX Memory SQL Server DBA Tip 2 - Server Configuration - Data/Log Files SQL Server DBA Tip 3 - Server Configuration - Model Database SQL Server DBA Tip 4 - Server Considerations - 32 bit / 64 bit SQL Server DBA Tip 5 - Server Considerations - Installing Features (SSIS, SSRS, Engine, SSAS) SQL Server DBA Tip 6 - Server Security - Windows Authentication / SQL Authentication SQL Server DBA Tip 7 - Server Security and grouping - Schema Control SQL Server DBA Tip 8 - Server Monitoring - Baseline SQL Server DBA Tip 9 - SQL Server Monitoring - Default Trace SQL Server DBA Tip 10 - SQL Server Reporting - Offload the reporting factor SQL Server DBA Tip 11 - SQL Server Configuration - MIN Memory SQL Server DBA Tip 12 - SQL Server Tuning - Missing Index DMV SQL Server DBA Tip 13 - SQL Server built in DR/HA Solutions SQL Server DBA Tip 14 - SQL Server General - Updating Production Data SQL Server DBA Tip 15 - SQL Server Agent - Job ownership SQL Server DBA Tip 16 - Working with Files and Folders

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)

Rilasciata la Cumulative Update #10 per SQL Server 2008 R2 SP1:

http://support.microsoft.com/kb/2783135

Dopo aver applicato la CU10, la versione di SQL Server 2008 R2 (SP1) sarà: 10.50.2868.0.

Rilasciata la Cumulative Update #4 per SQL Server 2008 R2 SP2:

http://support.microsoft.com/kb/2777358

Dopo aver applicato la CU4, la versione di SQL Server 2008 R2 (SP2) sarà: 10.50.4270.0.

Rilasciata la Cumulative Update #5 per SQL Server 2012:

http://support.microsoft.com/kb/2777772

Dopo aver applicato la CU5, la versione di SQL Server 2012 sarà: 11.0.2395.0.

Ritorna, con una nuova edizione, il più importante evento formativo online gratuito per la piattaforma SQL Server e Business Intelligence, il 24 Hours of PASS!

La prossima edizione di questo grande evento sarà completamente dedicata all’analisi dei dati, alla loro visualizzazione e distribuzione. Il 24 Hours of PASS: Business Analytics Edition è schedulato per il 30 Gennaio 2013 alle ore 13:00 GMT, vi consiglio di non lasciarvelo scappare.

Dal portale redgate è possibile scaricare, gratuitamente (in formato PDF),  la seconda edizione dell’eBook: SQL Server Execution Plans di Grant Fritchey. Il libro in formato cartaceo è ovviamente acquistabile su Amazon.

Riporto di seguito la prefazione seguita dall’elenco dei capitoli.

Editorial Review

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?