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

Annunci

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 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

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