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

What could you achieve with 60% more time?

Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...

Move database between drives

SQL server Move user database steps and scripts:...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Move database between drives

AdvertisementsSQL server Move user database steps and scripts:
Check you have a free space on the moving drive and make sure...