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
963 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,544 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,170 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,003 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,066 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
988 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,667 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,967 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,228 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,368 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers