How Do You Drive Your DBA Mad?
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
2010-03-01
1,585 reads
Blog Posts
March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-03-01
1,008 reads
PowerShell for Batch Operations
I’m right in the middle of moving one of our databases from Oracle to SQL Server (and I just love...
2010-03-01
1,688 reads
Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-01
3,481 reads
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-01
3,204 reads
Speaker Evaluations for SQLSaturday #32 – Tampa
I recently received my Speaker Evaluations for my session, Why I Use Stored Procedures, from Pam Shaw (@pamshaw) and as...
2010-03-01
440 reads
Speaking at Charlotte, NC - SQL Saturday #33
If you are near Charlotte, NC, I will be speaking at their SQL Saturday on March 6th, 2010. My session, SQL Server...
2010-03-01
500 reads
SSRS – KPIs without Analysis Services
During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...
2010-03-01
2,408 reads
Tsunami in Paradise
Not a tsunami, but high surf on the Kohala Coast, near where we live.
We received the first phone call at...
2010-03-01
734 reads
Rocky Mountain Tech Trifecta – Beginning SQL Server
At the Rocky Mountain Tech Trifecta this past weekend in Denver, I presented a talk on “Beginning SQL Server”, a...
2010-02-28
1,572 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 include the Resource Database?
See possible answers