Daily_series

Pinal Dave (blog | twitter) in questa serie di posts ci parla dei vari wait stats e queues.

Introduction to Wait Stats and Wait Types - Wait Type - Day 1 of 28

Signal Wait Time Introduction with Simple Example - Wait Type - Day 2 of 28

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)

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