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.

Defaults In msdb Database

Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of “Say No to Defaults.” You can read more about that from the invite – here. I already participated in the party but did also want to discuss defaults a little bit more. That said, this article […]

By |July 15th, 2015|SQL, SQL Group|0 Comments

SHUTDOWN SQL Server

Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server.  That disruption comes in the form of the SHUTDOWN TSQL command.  You can read what Chris wrote from his article here.

Granted, you do need to have elevated permissions such as sysadmin, serveradmin or securityadmin. […]

By |June 3rd, 2015|SQL Group|0 Comments

Interview Trick Questions

Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want to dive into a something a little more fun.

Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an […]

By |May 21st, 2015|SQL, SQL Group|0 Comments

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.  In addition, they may need to know by what means people have access within your databases.

When that need arises, it is frequently adequate to just perform a quick audit and […]

By |May 13th, 2015|SQL, SQL Group|0 Comments

Upgrading From SQL Server Profiler

You may recall an article I had written a couple months back describing how to use Extended Events to perform your SQL Server Profiler duties. If not, you can read all about it here.

In that article, I showed one common use-case for SQL Server Profiler and how to achieve the same result via Extended Events. […]

By |April 22nd, 2015|SQL, SQL Group|0 Comments

Where did the Database Go?

What do you do when a developer comes to you and asks, “Where did the database go?  The database was there one minute, and the next it was not.”  Only one thing could be worse than the feeling of losing a database on your watch, and that would be losing a production database. It’s like […]

By |April 7th, 2015|SQL, SQL Group|0 Comments

How To: XEvents as Profiler

A common excuse for not delving into extended events seems to be the jump from Profiler to extended events.  There appears to be an inherent fear with how to use extended events.  In addition to that fear, is the fear that extended events does not do what Profiler can do so easily.

Today, I would like […]

By |March 11th, 2015|SQL, SQL Group|2 Comments

How to: File Target use in Extended Events

I have been doing a lot of posts of late about extended events but have failed to share some of the essential building blocks. I am not looking to do a series of definitions, but just share a couple of quick tips and examples here and there that will make the use of extended events a […]

By |February 17th, 2015|SQL, SQL Group|0 Comments

Capture Index Maintenance Operations

One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform routine index maintenance, some people do not, and still others have done some sort of “set it and forget it” script provided by a vendor and may or may not […]

By |January 21st, 2015|SQL, SQL Group, SQL Server|3 Comments

Adventures with NOLOCK

Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK.  For one reason or another this query directive (yes I am calling it a directive* and not a hint) is loved and idolized by vendors, applications, developers, and upper management alike.  The reasons for this vary from one […]

By |January 6th, 2015|SQL Group|2 Comments