VSTS extensions, mixing VSS.require and import ... require

I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing...

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...

How to classify your data for GDPR

The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information...

SSMS 17.4 Vulnerability Assessment

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4
It seems...

It’s all about the use cases

There is no better way to see the art of the possible with the cloud than in use cases/customer stories...

It’s all about the use cases

There is no better way to see the art of the possible with the cloud than in use cases/customer stories...

Every Single Execution Plan is an Estimated Plan

All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.

Where...

SQL Homework – March 2018 – Recovery Objectives

My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases...

Error 33206 - SQL Server Audit Failed to Create the Audit File

One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?

https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server DatabaseIn our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using...