In questo post riepilogativo voglio segnalare, a chi sta approcciando SQL Server o a chi vuole approfondire questi argomenti, alcune serie di post che esperti di SQL Server hanno scritto sui temi più vari.

A SQL Server DBA Myth a day
di Paul Randal

(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

Per i più pigri Sorriso:Paul ha condensato il tutto in questo pdf.

An XEvent a Day
di Jonathan Kehayias

(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

SQL Server DBA Tips
by Ted Krueger

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

A DMV A Day
by Glen Berry

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

A SQL Server Hardware Nugget A Day
by Glen Berry

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)

Glenn ha pubblicato anche il libro SQL Server Hardware, che potete scaricare gratuitamente in format pdf dall’ottima libreria di Red-Gate !

A Join A Day
by Sebastian Maine (sqlity.net)

Come sempre… enjoy SQL Server ! Sorriso

Chi sono

  • Danilo Dominici
  • Send mail to the author(s) Email
  • Skype
  • View my profile on LinkedIn

Tags

Calendario

<2017 October>
SunMonTueWedThuFriSat
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

Archivio posts

Blog che leggo

Subscribe to this weblog's RSS feed with SharpReader, Radio Userland, NewsGator or any other aggregator listening on port 5335 by clicking this button.

Statistiche

Total Posts: 139
This Year: 0
This Month: 0
This Week: 0
Comments: 30