Blog

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.

It’s an Honor: Microsoft MVP

By Jason Brimhall | July 1, 2019

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

Related Posts:

Public Role Permissions – Back to Basics

By Jason Brimhall | June 17, 2019

If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want to have a data breach, or c) you are testing in a sandbox to improve your skills.

Database Offline – Redux

By Jason Brimhall | April 15, 2019

A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help you get a reasonable deduction for that offline event in the absence of better data.

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

By Wayne Sheffield | March 11, 2019

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.

The post Scalar UDF Inlining in SQL Server 2019 – Simpler functions appeared first on Wayne Sheffield.

Scalar UDF Inlining in SQL Server 2019

By Wayne Sheffield | February 25, 2019

SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.

The post Scalar UDF Inlining in SQL Server 2019 appeared first on Wayne Sheffield.

CLR Strict Security in SQL 2017

By Wayne Sheffield | January 21, 2019

Locking down CLR

SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!

The post CLR Strict Security in SQL 2017 appeared first on Wayne Sheffield.

Quick Permissions Audit

By Jason Brimhall | January 14, 2019

DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.