Jason Brimhall

About Jason Brimhall

As a Microsoft Certified Master/Microsoft Certified Solutions Master and Microsoft SQL Server MVP, I have 19 years’ experience in the technology industry, including more than 10 with SQL Server. I also earned a Bachelor’s Degree in Business Information Systems from Utah State University. One of the highlights of my career was co-authoring SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach. I am a frequent presenter at SQL Server events worldwide, which includes SQLSaturdays and User Groups. I am also currently helping lead the Las Vegas SQL Users Group.​ I love finding that magic turbo button to make queries go faster which ultimately leads to huge relief and satisfaction for the client. I have done that sort of work for clients of all sizes throughout the world. I have experience with multi-TB databases as well as environments with thousands of SQL Server instances to manage.

An Extended Event Trifecta

When working with Extended Events, there are times when a little more information is, well, helpful.  You know you want to use extended events to try and monitor for a specific thing to happen.  But sometimes you don’t know if there is an event for that “thing”, or maybe you don’t know if there is […]

By |December 2nd, 2014|SQL Group|2 Comments

Auditing when Database Files Change

As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking when the data file(s) grow(s). Many will argue that there is nothing worse than not knowing when a database-related file changed in size except maybe when […]

By |November 20th, 2014|SQL Group|0 Comments

Capture the Flag – The Trace Flag

Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a change. In some environments, things are more lax, but you still wish you could tell when certain changes were made. That is even true in some of those tightly controlled environments. You know what I […]

By |November 11th, 2014|SQL Group|4 Comments

Ghosts in your Database

Yes Virginia, there are ghosts in your database.  More specifically, there are ghosts in your SQL Server database.  They are not there to haunt you.  They are not there just for this holiday season (speaking of Halloween Month).

How can there be ghosts in the database?

Why would there be ghosts in the database?

Do they happen because […]

By |October 15th, 2014|SQL Group|2 Comments

The Mystery of Missing Backup Files

We are now on the eve of Halloween Month. Yes, the holiday of Halloween is much better when celebrated all month rather than just a single day. What better way to kick it off than with a bit of a mystery?

Not only is this mystery of missing backup files worth discussing now, but has been a mystery […]

By |September 30th, 2014|SQL, SQL Group, SQL Server|0 Comments

Encrypting a Database Never Finishes

There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a database.  In SQL Server, we have the ability to comply with these regulations in a couple of different ways.  We can choose to encrypt at the column level or we can choose to encrypt the […]

By |September 2nd, 2014|SQL, SQL Group|9 Comments

ArithAbort and SQL Agent Failures

I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous clients.  The code was pretty straightforward and addressed a concern for the client.  Having used it for several previous clients, I felt pretty confident in the code.  The main purpose was simply to audit index […]

By |August 5th, 2014|SQL Group|0 Comments

Synonyms in SQL Server – Good and Bad

When SQL Server 2005 was released, a nifty little feature was included called synonyms.  Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.

Today I want to share a couple of examples.  We will take a look at examples of […]

By |July 1st, 2014|SQL, SQL Group|0 Comments

Missing Indexes Script v2

By Jason Brimhall 
Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them are good (some may stink).
Well, this may just be another one of those <items>.  Whether it stinks or not may depend on your mileage.
I had shared a similar script back in January 2012 and […]

By |June 15th, 2014|SQL Group, SQL Server|0 Comments

Maintenance Plan Owner

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit some things that are not so good.  Other times we inherit some things that are just plan annoying.  Yet other times, we inherit things that may be annoying and we probably just haven't discovered them yet.

By |June 25th, 2012|SQL, SQL Group|Comments Off on Maintenance Plan Owner