MSSQLTips.com Rookie of the year 2018

You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...

CLR Strict Security in SQL 2017

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...

CLR Strict Security in SQL 2017

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...

CLR Strict Security in SQL 2017

Locking down CLR
I recently ran into SQL 2017’s new CLR Strict Security. I was working with a client where we...

Get Your Learn On

There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...

MSSQLTips.com Rookie of the year 2018

You need a lot of hard work for success!2018 was a good year for me in a lot of areas...

Easy Permissions Audit

This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
Related Posts:

Failed to Create the Audit File December 31, 2017

Quick Permissions...

Easy Permissions Audit

Something I have written about more than a handful of times is the need to audit. When people think about...

Read-only tables

Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...

Memory Grants part 4: The Resource Semaphore

Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...