SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,205 reads
Blog Posts
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
505 reads
Twitter: The Next Best Thing To Being There
Why do DBAs want to go to PASS, TechEd, or SQLConnections? If asked, I suppose that many would point to...
2010-08-24
741 reads
Use ReadOnlyVariables and ReadWriteVariables properties in Scripts
For those of you just starting out with SQL Server Integration Services, you'll find a LOT of information out there...
2010-08-24
6,626 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,718 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,119 reads
Fall Speaking Schedule
I just got back from speaking at SQL Saturday #51 in Nashville, which was a lot of fun. I’ll write...
2010-08-23
809 reads
Free SQL Server Training for the Week of August 23, 2010
Note: I got some of the dates mixed up, so I'm re-publishing this post.
Monday
SQL Lunch - Troubleshooting SSIS Package Development - Dustin...
2010-08-23
942 reads
Getting Drive Info Part 2, DTS
In this installment of the drive info series we will gather the drive information via a DTS package. Part 1...
2010-08-23
1,101 reads
Incremental Load - TSQL
For my first technical post in a short while I thought I would look at something I have worked on...
2010-08-23
11,041 reads
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers