I’m Your DBA Blog

Our Favorite Educational Blog

By |2020-06-25T08:28:58-05:00May 23rd, 2019|Education, SQL Server|

Brent Ozar is a staple of the SQL Server community, plain and simple.  His daily blogs are always educational, well researched and well formatted to get the point in the short amount of time we have as DBA's.  If you aren't using the sp_Blitz tools he provides FOR FREE in the First Responder Kit, then

Read-Write Secondary in 2019

By |2020-06-25T08:29:42-05:00December 20th, 2018|I'm Your DBA Blog|

Microsoft just keeps knocking it out of the park lately.  The most recent announcement to catch my eye is that in SQL Server 2019, they are introducing Read-Write Secondaries for Availability Groups.  Meaning the end user doesn't have to know the listener name, they can be pointing to a secondary server directly by name and,

Accelerated Database Recovery

By |2020-06-25T08:31:32-05:00December 9th, 2018|Articles, Azure SQL|

Accelerated Database Recovery (ADR) is poised to be one of the biggest updates to SQL Server in the last few years.  ADR introduces in-line row versioning, which allows long running transactions (such as an offline clustered index rebuild, or a large insert/update/delete statement) to be rolled back immediately.  This will help with a few things

PASS Summit 2018 Highlights

By |2020-06-25T08:33:41-05:00November 10th, 2018|Career, I'm Your DBA Blog, SQL Server|

Another year down and PASS Summit 2018 in Seattle was an immersive learning and networking experience yet again. This year my time was mostly dedicated to sessions around query performance tuning and Azure high availability technologies. Before listing the highlights, I’ll say again, that if you aren’t attending PASS, you are really missing out.  I

PASS Summit 2018

By |2020-06-25T08:33:57-05:00November 2nd, 2018|Career, I'm Your DBA Blog|

Well, it's that time again. PASS Summit 2018 is right around the corner and thousands of SQL professionals will be gathered together to network and learn. I've said it before and I'll say it again, you should be attending! PASS Summit is a conference where you will see and meet your mentors, MVP's that

Power Settings Are Important To SQL Server

By |2020-06-25T08:34:24-05:00October 19th, 2018|I'm Your DBA Blog|

Power Settings are important to SQL Server Performance! Not long ago we had a client that was constantly having a problem with a secondary replica server that couldn’t keep up with the traffic from the primary. It would work fine for a few days, and then suddenly it was hours behind and never catching up.

PASS Summit – You Should Be Attending

By |2020-06-25T08:34:43-05:00November 4th, 2017|Career|

After spending an exhausing week at PASS Summit in Seattle, I have to point out that if you are a DBA and are not attending, you are doing yourself a huge disservice. Whether you think your company just won’t pay for it, whether you think to yourself that it’s just too expensive; whatever the reason,


By |2020-06-25T08:35:05-05:00September 14th, 2016|Career, I'm Your DBA Blog, SQL Server|

Cover Your A** (And don't be stupid) I was recently called up for Jury Duty by the Dallas County court system (for the first time in my life).  Though I cringed when they called my name as a selected juror, it did teach me about and remind me of a lot of very important things

Power BI On-Premise

By |2020-06-25T08:35:38-05:00July 2nd, 2016|Power BI, SQL Server|

  Found this blog post from Sam Lester...here's to hoping we see Power BI on-prem in SQL 2016 SP1! https://blogs.msdn.microsoft.com/samlester/2016/04/18/power-bi-ssrs-2016-in-an-on-premises-environment/

Failed SSIS Packages From SQL Agent

By |2020-06-25T08:22:14-05:00November 17th, 2015|SQL Server|

So a really weird thing happened this weekend. Our infrastructure group did the Windows updates like they normally do and suddenly on Monday one of our active/active/active clusters (which means they are named instances) jobs started failing only for SSIS Packages in the SSIS Catalog with error 0x80131904 and "A network-related or instance specific error