Articoli

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

Ancora Glenn Berry nella sua serie di posts dedicati all’hardware: utile punto di partenza per chi sta per scegliere il server da acquistare per SQL Server. La serie è del 2011, ma molti posts sono ancora attuali. Per chi necessita di informazioni ancora più recenti, vi rimando al blog di Glenn.

Day 1  (Westmere-EP) Day 2 (Westmere-EX) Day 3 (AMD Opteron 6100) Day 4 (AMD Bulldozer) Day 5 (Hardware ID - DMVs) Day 6 (Hardware ID - Built-in) Day 7 (CPU-Z) Day 8 (Recommended Intel Processors) Day 9 (Recommended AMD Processors) Day 10 (Old Intel Processor Numbering) Day 11 (New Intel Processor Numbering) Day 12 (AMD Processor Numbering) Day 13 (Intel Turbo Boost) Day 14 (Intel Tick Tock Release Strategy) Day 15 (Power Plans and CPU performance) Day 16 (SQL Server 2008 R2 and Hardware) Day 17 (Geekbench) Day 18 (AMD Turbo CORE) Day 19 (RAID Controllers) Day 20 (Building a Desktop Test System) Day 21 (Processor Cache Size) Day 22 (32-bit vs. 64-bit) Day 23 (Two Socket vs. Four Socket) Day 24 (TPC-E Benchmark) Day 25 (DB Server Processor Selection) Day 26 (Laptop Processor Selection) Day 27 (Crystal DiskMark) Day 28 (Intel Chipsets and SSDs) Day 29 (Hardware Resiliency) Day 30 (RAID Level Primer)

In questa serie di posts di Jonathan Kehayias si parla di come utilizzare gli Extended Events per monitorare SQL Server.

(1 of 31) - An Overview of Extended Events (2 of 31) - Querying the Extended Events Metadata (3 of 31) - Managing Event Sessions (4 of 31) - Querying the Session Definition and Active Session DMV’s (5 of 31) - Targets Week - ring_buffer (6 of 31) - Targets Week - asynchronous_file_target (7 of 31) - Targets Week - bucketizers (8 of 31) - Targets Week - synchronous_event_counter (9 of 31) - Targets Week - pair_matching (10 of 31) - Targets Week - etw_classic_sync_target (11 of 31) - Targets Week - Using multiple targets to simplify analysis (12 of 31) - Using the Extended Events SSMS Addin (13 of 31) - The system_health Session (14 of 31) - A Closer Look at Predicates (15 of 31) - Tracking Ghost Cleanup (16 of 31) - How Many Checkpoints are Issued During a Full Backup? (17 of 31) - A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1) (18 of 31) - A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2) (19 of 31) - Using Customizable Fields (20 of 31) - Mapping Extended Events to SQL Trace (21 of 31) - The Future - Tracking Blocking in Denali (22 of 31) - The Future - fn_dblog() No More? Tracking Transaction Log Activity in Denali (23 of 31) - How it Works - Multiple Transaction Log Files (24 of 31) - What is the package0.callstack Action? (25 of 31) - The Twelve Days of Christmas (26 of 31) - Configuring Session Options (27 of 31) - The Future - Tracking Page Splits in SQL Server Denali CTP1 (28 of 31) - Tracking Page Compression Operations (29 of 31) - The Future - Looking at Database Startup in Denali (30 of 31) - Tracking Session and Statement Level Waits (31 of 31) - Event Session DDL Events

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