SQL Server DBA tips

Series, SQL Server

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

Annunci

31 days with SQL Server Management Studio

Series, SQL Server

Una interessante panoramica sulle funzionalità del SQL Server Management Studio scritta da Russ Thomas.

Day 1:    Knowing Options Leads to Shortcuts
Day 2:    Query Like a Pro
Day 3:    Query Like a Boss
Day 4:    Query Like a God
Day 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 SSMS
Day 9:    Team Debugging with SSMS
Day 10:  Remote Debugging with SSMS
Day 11:  Working With Designers
Day 12:  Modifying Toolbars
Day 13:  Customizing Connections
Day 14:  Registered Servers / Server Groups
Day 15:  Central Management Server
Day 16:  Monitoring with SSMS
Day 17:  SSMS and SQL Utility
Day 18:  SSMS and MDW
Day 19:  SSMS and Extended Events
Day 20:  SSMS Solutions, Projects, Source Control
Day 21:  SSMS and DacPac
Day 22:  SSMS and ETL (import / export wizard)
Day 23:  Get Fancy with Results
Day 24:  SSMS in SQLCMD Mode
Day 25:  Database Diagraming
Day 26:  Maintenance Plans
Day 27:  Building a Custom Add-In / Extension
Day 28:  Deploying the Add-In
Day 29:  Identifying Options & Debugging Add-In
Day 30:  Moving from Add-In to VSPackage
Day 31:  Wrap Up / Review / Stuff I Didn’t Cover

An XEvent a day

Series, SQL Server

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