Call for Speakers – SQLSaturday Tampa 2019

SQLSaturday Tampa just went live and the call for speakers is open through February 23, 2019. I’ll be attending, hope to see you there!

Call for Speakers – SQLSaturday Tampa 2019

SQLSaturday Tampa just went live and the call for speakers is open through February 23, 2019. I’ll be attending, hope...

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

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