Toolbox - Exporting SSMS Results to Excel

I was working on another post when I found myself needing to dump out query results to a grid format...

Webinar: Change Detection in SQL Server

Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the...

Webinar: Change Detection in SQL Server

Change detection is a critical component of any system that moves data from one structure to another. Most data movement...

Microsoft Azure – How to create the Azure Active Directory (AD) using Azure Portal

Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the...

SQL Server 2017 Reporting Services: The Basics Part 5

We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to...

There is Now A Delete Activity in Data Factory V2!

Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less...

Using docker named volumes to persist databases in SQL Server

I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...

Disabling and enabling triggers

I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...

Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.

Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.

Problem: SQL server database refresh / restore...

[[ This is a content summary only. Visit my website for full links, other content,...