Half Of You Don’t Understand Variables and Transactions.

Do table variables and variables respect transactions? If we set the value of a variable during a transaction, and we roll it back, what happens?

Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication

Learn how to get Windows Authentication working on an Ubuntu SQL Server on Linux instance.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

The Best Security for Database Administrators

Today Steve talks about limiting security issues for administrators.

The Future of DevOps

Join Microsoft MVP Kendra Little to discover how you can fully left-shift your deployments with version control and automatic cloning using Redgate's latest innovations.

Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets

In this article we look at two methods of using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets.

Downloading a CSV File from an API Using Azure Data Factory

In this article, learn how to use Azure Data Factory with a REST API to download files.

Labor Day 2020

A holiday message from Steve.

How to Use Parameters in PowerShell Part II

PowerShell is a basic skill any administrator working in Windows or Azure should know. After writing his first article about PowerShell parameters, Greg Moore realized that there is even more to talk about. This article covers using pipelined parameters and more.

Introduction to Analyzing Waits using SQL Monitor

Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like SQL Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events.