T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026

Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...

Data experiments with salary survey – I

As someone who just crossed three decades of working in technology – I have a sudden renewed interest in understanding how...

Getting Started With R In SQL Server 2017

Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...

Recruitment Agents are not bad people...despite what you might read

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...

SQL Vulnerability Assessment for Azure SQL Database

Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....

Dates and Times in SQL Server: DATETIME2

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

Extended Events File Initialization Failure

It should come as no surprise that I write a lot of articles about Extended Events (XE). This happens to...

Moving a table using BCP and native format

You need to move a table from one instance to another with the following requirements:
The instances are on separate domains....

PowerShell script repository - SQL Server

A simple get-help output
PowerShell is a .Net based command line tool designed for automation.

It is recommended to script repetitive task...

Redgate SQL Test utility isn’t showing up in SSMS

I had recently installed the SQL Toolbelt from Redgate at a client site on a laptop they’d supplied me.
(Fantastic product...