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 …

31 days with SQL Server Management Studio

Una interessante panoramica sulle funzionalità del SQL Server Management Studio scritta da Russ Thomas. Day 1:    Knowing Options Leads to ShortcutsDay 2:    Query Like a ProDay 3:    Query Like a BossDay 4:    Query Like a GodDay 5:    Generating Scripts (pre-written code 1)Day 6:    Leveraging Templates (pre-written code 2)Day 7:    Leveraging Snippets (pre-written code 3)Day 8:    Debugging T-SQL with …

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 …