Davide Mauri

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)

E’ ormai da tempo risaputo che il supporto ad OLEDB è stato deprecato in favore del più standard ODBC. SQL Server 2012 è l’ultima versione di SQL Server a supportare il provider OLEDB.

Per questo motivo, Microsoft ha pubblicato un Whitepaper, curato dal SQLCAT team, che indica il percorso corretto per convertire le proprie applicazione dall’uso di OLEDB ad ODBC:

http://msdn.microsoft.com/en-us/library/hh967418.aspx

Glen Berry in questa serie di posts ci porta all’interno delle DMVs più utilizzate per monitorare SQL Server.

Day 1 sys.dm_os_buffer_descriptors Day 2 sys.dm_exec_sessions Day 3 sys.dm_os_sys_info Day 4 sys.dm_os_sys_memory Day 5 sys.dm_db_mirroring_auto_page_repair Day 6 sys.dm_db_index_usage_stats Day 7 sys.dm_db_missing_index_group_stats Day 8 sys.dm_fts_active_catalogs Day 9 sys.dm_os_schedulers Day 10 sys.dm_exec_procedure_stats Day 11 sys.dm_db_index_usage_stats Day 12 sys.dm_db_partition_stats Day 13 sys.dm_io_virtual_file_stats Day 14 sys.dm_os_wait_stats Day 15 sys.dm_os_performance_counters Day 16 sys.dm_exec_cached_plans Day 17 sys.dm_db_index_usage_stats Day 18 sys.dm_clr_tasks Day 19 sys.dm_os_wait_stats Day 20 sys.dm_exec_cached_plans Day 21 sys.dm_os_ring_buffers Day 22 sys.dm_exec_query_memory_grants Day 23 sys.dm_os_process_memory Day 24 sys.dm_exec_requests Day 25 sys.dm_os_memory_cache_counters Day 26 sys.dm_exec_procedure_stats Day 27 sys.dm_tran_locks Day 28 sys.dm_io_pending_io_requests Day 29 sys.dm_exec_connections Day 30 sys.dm_os_buffer_descriptors

Sebastian Maine (sqlity.net) in questa serie di posts ci mostra le varie tipologie di join presenti in SQL Server.

A SQL Server DBA Myth a day In questa serie di posts di Paul Randal vengono sfatati alcuni “miti” diffusi tra i DBA SQL Server.

(1/30) in-flight transactions continue after a failover (2/30) DBCC CHECKDB causes blocking (3/30) instant file initialization can be controlled from within SQL Server (4/30) DDL triggers are INSTEAD OF triggers (5/30) AWE must be enabled on 64-bit servers (6/30) three null bitmap myths (7/30) multiple mirrors and log shipping load delays (8/30) unicorns, rainbows, and online index operations (9/30) data file shrink does not affect performance (10/30) database mirroring detects failures immediately (11/30) database mirroring failover is instantaneous (12/30) tempdb should always have one data file per processor core (13/30) you cannot run DMVs when in the 80 compat mode (T-SQL Tuesday #005) (14/30) clearing the log zeroes out log records (15/30) checkpoint only writes pages from committed transactions (16/30) corruptions and repairs (17/30) page checksums (18/30) FILESTREAM storage, garbage collection, and more (19/30) TRUNCATE TABLE is non-logged (20/30) restarting a log backup chain requires a full database backup (21/30) corruption can be fixed by restarting SQL Server (22/30) resource governor allows IO governing (23/30) lock escalation (24/30) twenty six restore myths (25/30) fill factor (26/30) nested transactions are real (27/30) use BACKUP WITH CHECKSUM to replace DBCC CHECKDB (28/30) BULK_LOGGED recovery model (29/30) fixing heap fragmentation (30/30) backup myths