Blog

Data Platform MVP 2020

By Jason Brimhall | August 12, 2020

I am humbled to be among so many great professionals and honored at the same time for having been chosen.

Related Posts:

Unconscious Bias

By Jason Brimhall | August 11, 2020

This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.

Related Posts:

Availability Group issues fixed with Alerts

By Wayne Sheffield | August 6, 2020

Availability Group issues - job to resume data movement

Learn how to use the SQL Server Agent Alerting system to capture Availability Group related errors and to respond to them by running jobs.

The post Availability Group issues fixed with Alerts appeared first on Wayne Sheffield.

Decoded Statistics Names and More

By Jason Brimhall | April 17, 2020

Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we can decode those names and reveal what the names really mean. 

Related Posts:

Using Google Chrome with SSRS

By Wayne Sheffield | February 18, 2020

Kerberos Double Hop issue in SSRS

In this post, you will learn how to resolve the Kerberos Double-Hop issue and SSRS browser login when using Google Chrome to run SSRS reports.

The post Using Google Chrome with SSRS appeared first on Wayne Sheffield.

CRM Data Source Connection Error

By Jason Brimhall | January 23, 2020

This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM reports working properly within Report Manager (via SSRS), the reports would fail in CRM.

Related Posts:

Where is that Mask?

By Jason Brimhall | December 28, 2019

In this article, I share one easy script that could help eliminate one database feature as a culprit to an anomalous data masking suddenly getting enabled.

Ad Hoc Queries Disabled

By Jason Brimhall | December 20, 2019

This article takes a look at an error that may occur depending on your use of linked servers and the use of openrowset.

When Too Much is Not a Good Thing

By Jason Brimhall | December 13, 2019

Explore how to avoid unwanted results that oft occur due to lack of attention to detail, use of internet examples, misunderstanding of the requirements; and always from granting way too much access.

Who needs data access? Not You!

By Jason Brimhall | December 12, 2019

With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.