Performance Tuning Pre-con and More at SQLSaturday 277 RVA
Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and...
2014-02-04
961 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Schema-only Backups and Restores
I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to...
2014-01-20
1,541 reads
DBA: Guardian of the Data
I was asked recently by Idera to take a look at the things that could cost a DBA their job....
2014-01-17
1,166 reads
T-SQL Tuesday #50: Doing More With Less
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is...
2014-01-14
1,002 reads
Who Owns SQL Backups?
I was asked by Idera to take a look at the things that could cost a DBA their job. This...
2014-01-10
1,064 reads
When DMVs Cost Me My Job
Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA...
2013-12-27
980 reads
T-SQL Tuesday #49: Wait For It Roundup
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,662 reads
Enabling High Performance Power Plan via PowerShell
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,965 reads
T-SQL Tuesday #49: My Go-To Query For Waiting Tasks
I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL...
2013-12-10
1,224 reads
Never an Infinite Loop Around When You Need One
You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time....
2013-12-09
1,363 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers