Rilasciata la Cumulative Update #2 per SQL Server 2012 SP1:

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

Dopo aver applicato la CU2, la versione di SQL Server 2012 SP1 sarà: 11.0.3339.0.

Tra le cose da notare di questa CU, sicuramente spicca la possibilità di fare backup e restore di database su Azure:

**Backup and Restore to Cloud Simplified in SQL Server 2012 SP1 CU2
**http://sqlblog.com/blogs/sqlos_team/archive/2013/01/24/backup-and-restore-to-cloud-simplified-in-sql-server-2012-sp1-cu2.aspx

Rilasciata la Cumulative Update #9 per SQL Server 2008 SP3:

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

Dopo aver applicato la CU9, la versione di SQL Server 2008 sarà: 10.00.5829.00

ApexSQL Refactor è un bel tool free che si integra con il Management Studio è permette di riformattare il codice T-SQL per rendere non solo bello da vedere ma anche più facile da leggere e quindi da gestire, modificare e ottimizzare

http://www.apexsql.com/sql_tools_refactor.aspx

Oltre alla formattazione del codice permette anche di effettuare del refactoring sullo stesso, ad esempio espandendo le wildcard o rinominando oggetti gestendo in automatico l’aggiornamento dei vari riferimenti.

La Call for Paper per l’ottava edizione della SQL Server & BI Conference è ufficialmente aperta.

La SQL Server & Business Intelligence Conference rappresenta la più importante conferenza italiana sulla tecnologia SQL Server e Business Intelligence, quest’anno si terrà a Milano il 28 e 29 Maggio 2013; due giornate di formazione e networking, come sempre ricche di contenuti!

Jason Strate (blog | twitter) in questa serie di posts ci porta nel mondo di SSIS, con esempi pratici e suggerimenti per sfuttarlo al meglio.

1. 31 Days of SSIS - Raw Files Are Awesome (1/31)
2. 31 Days of SSIS - Using Breakpoints (2/31)
3. 31 Days of SSIS - Data Flow Breakpoints?! (3/31)
4. 31 Days of SSIS - Folder Structures (4/31)
5. 31 Days of SSIS - One Variable to Rule Them All (5/31)
6. 31 Days of SSIS - Recursive SSIS Package (6/31)
7. 31 Days of SSIS - What The Sorts?! (7/31)
8. 31 Days of SSIS - Merge Join Is My Friend (8/31)
9. 31 Days of SSIS - Override Variables (9/31)
10. 31 Days of SSIS - Pivot Transformation (10/31)
11. 31 Days of SSIS - UnPivot Transformation (11/31)
12. 31 Days of SSIS - UnPivot Alternative (12/31)
13. 31 Days of SSIS - Create XML Document (13/31)
14. 31 Days of SSIS - Instant Excel Spreadsheet (14/31)
15. 31 Days of SSIS - Every Which Way Outputs (15/31)
16. 31 Days of SSIS - 10 Things About Expressions (16/31)
17. 31 Days of SSIS - Environmental Variable(17/31)
18. 31 Days of SSIS - SQL Server Configuration (18/31)
19. 31 Days of SSIS - DTSConfig Configuration (19/31)
20. 31 Days of SSIS - No More Procedures (20/31)
21. 31 Days of SSIS - Controlling Your Flow In The Control Flow (21/31)
22. 31 Days of SSIS - Data Flow Expressions (22/31)
23. 31 Days of SSIS - Generating Row Numbers (23/31)
24. 31 Days of SSIS - One Package, Unlimited Databases (24/31)
25. 31 Days of SSIS - One Package, Unlimited Tables (25/31)
26. 31 Days of SSIS - Small Package, Big Win (26/31)
27. 31 Days of SSIS - Adding Some Delta Force (27/31)
28. 31 Days of SSIS - Jim Croce and the Foreach (File) Loop Container (28/31)
29. 31 Days of SSIS - Exporting Execution Plans (29/31)
30. 31 Days of SSIS - Importing Execution Plans (30/31)
31. 31 Days of SSIS - SSIS Naming Conventions (31/31)

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)

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