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

Data Warehousing Tip #4 – Trust your instinct

My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you...

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

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

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

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

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

One Long Week

It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this...

One Long Week

It started on Saturday. I usually have lunch with one or both of my daughters on the weekend and this week it was just my oldest, going on 15....