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

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

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

Seed Post for SSG Syndication

Some Text here to seed the syndication. Related Posts:Database In Recovery Update May 18, 2015 T-SQL Tuesday #081: Sharpen Something July 27, 2016 SSRS Subscription Schedules May 23, 2017 Last Execution of a Proc February 17, 2015 T-SQL Tuesday #081: ...

By |September 27th, 2017|SQL, SQL Group|Comments Off on Seed Post for SSG Syndication

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