Allow users to start/stop Azure VMs

Today I wanted to cover how you can grant the least privilege required to stop, start or restart an Azure VM. This is also a fun great example of...

ANSI_WARNINGS = OFF can break update statements with some SQL features

Working on a SQL 2017 database where an external, non-Microsoft application has direct access to read/write data via the ODBC Driver 17 for SQL Server.

They suddenly began to experience...

Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2

(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for Azure Data Factory - Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and...

Cool Stuff in Snowflake – Part 11: RESULT_SCAN

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....

Demystifying STUFF() function

This article will talk about myth with Stuff() function that it can be only used for concatenation. We'll do the reality check to demystify the Stuff() function.

Installing and Configuring the Undercover Catalogue

Quick video showing you how to install and configure the SQL Undercover Catalogue

Introduction to StudyYourServer

 I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...

Introduction to StudyYourServer

 I made a video (in Spanish) on how to use and which features offer my open-source project StudyYourServer
You are free to collaborate, fix it and add new functionalities!
The...

SQL Server Identity Skipping

My Pluralsight course for new SQL Server DBAs SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why: Too long, didn’t watch version:...

Temporarily enable TLS 1.0/1.1? - Be sure you check this keys

There are some actions that we know that will have to be repeated from time to time, but the surprise comes when it’s time to do so and the...