Azure SQL Database – Reduce the workload before initiating another service objective update

Getting straight to the point, I initiated a very common task recently, another scale up request. However, a new message...

Call for Speakers – SQLSaturday Jacksonville 2019

SQLSaturday Jacksonville 2019 is scheduled for May 4, 2019. The call for speakers closes on March 5.

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