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.

Spectre and Meltdown Exploits

Spectre and Meltdown
In recent weeks, a significant security risk was exposed. This exploit has been named in two fashions: Spectre and Meltdown. We at SSG feel it important to help disclose the severity and impact of these exploits with this formal release.

Unauthorized Memory Disclosure through CPU Side-Channel Attacks

(“Meltdown” and “Spectre”)

Overview
Vulnerabilities exist in multiple modern CPU architectures that could […]

By |January 18th, 2018|News, SQL, SQL Group|0 Comments

Changing Default Logs Directory – Back to Basics

In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used during install. Fair enough, there may not be massive need to change that location

By |January 4th, 2018|SQL, SQL Group|Comments Off on Changing Default Logs Directory – Back to Basics

Linked Servers and Stats

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers.

By |October 17th, 2017|SQL, SQL Group|Comments Off on Linked Servers and Stats

Easy Permissions Audit

Something I have written about more than a handful of times is the need to audit. When people think about audits, the first thing that comes to mind is most likely the IRS and taxes. More than taxes are audit-able. Despite that tendency to first think taxes when somebody says “audit”, I am not writing about […]

By |February 13th, 2017|Security, SQL Group, SQL Server|0 Comments

sp_server_diagnostics – Black Box Recorder

A few months back I began a series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore, there was a brief introduction into the three components […]

By |July 26th, 2016|Extended Events, SQL, SQL Group|0 Comments

SQL Black Box Recorder part II

A few months back I began a series, about the SQL Black Box Recorder that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore, there was a brief introduction into the three components […]

By |April 6th, 2016|Extended Events, SQL, SQL Group|0 Comments

Indexed Views – Performance Panacea or Plight

Indexed View(s)
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many times we see that an indexed view would be created to help improve performance. Far too often, an indexed view is created without consideration for the […]

By |January 28th, 2016|SQL, SQL Group|2 Comments

Disk Space and SQL Server

Disk Space in SQL Server
One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a production outage, the need exists.

As a hard working DBA, you want to make sure you hit all of the notes to make […]

By |January 21st, 2016|SQL, SQL Group|2 Comments

SQL Black Box Recorder

Across many professions and industries there is often a need to have some sort of device that “audits” everything that happens with a device or process. We are probably all quite familiar with the infamous black box recorders used by the passenger airline and train industries. It is also quite possibly fairly common knowledge that […]

By |January 12th, 2016|Extended Events, SQL, SQL Group|0 Comments

Freakin’ out on XE at the FreeCon

Just a couple weeks ago I announced that SQL Solutions Group was getting ready to host a day of free training—a FREECON if you will—in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.

I am hopeful to see the room filled with people looking to […]

By |September 29th, 2015|SQL Group|0 Comments