DBA Checklist Updated
I have recently updated and revised my DBA Best Practices Checklist, which is hosted on www.Simple-Talk.com. The goal of the...
2010-01-22
809 reads
Blog Posts
Final Reminder – SQLSaturday #32 in Tampa on Jan 23, 1010
I’ve had to cancel my plans to attend, which also included plans for a late lunch at the Green Iguana...
2010-01-22
538 reads
Microsoft – Follow best practices!
Best practice is to use parametrized queries to enable plan reuse. Will someone please tell Microsoft this.
Presently dm_exec_cached_plans on...
2010-01-22
1,017 reads
SSIS Checkpoints with Tasks Running in Parallel
Several months ago I blogged about why Checkpoints are a great feature in SSIS to use. It seems with every...
2010-01-22
3,481 reads
Andy on Twitter
Just prior to the 2009 PASS Summit I posted about giving Twitter a try, and thought I’d report back on...
2010-01-21
2,191 reads
Azure platform CTP accounts are about to expire?
I recieved the notification from Azure Platform Team that the CTP accouct will be closed at the end of the...
2010-01-21
387 reads
Creating the SSC Maintenance Plan: Part 3
Note: This is an in-depth article that exceeds 5,000 words, and provides a case-study of how a maintenance plan could...
2010-01-21
1,756 reads
Getting here from there
Another month, another blog chain, this time started by Paul Randal. I got tagged by both Grant and Steve, on...
2010-01-21
397 reads
How Do You Handle the Stress of Being a DBA?
This is a reprint of my editorial at SQLServerCentral.com. There is a lively discussion at the SSC forum on this...
2010-01-21
414 reads
Instant File Initialisation
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,417 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers