Find UDF useage

Find all stored procedures that use UDFs

SQL Login Password Audit

Audit you SQL Logins

In-Place Upgrade or Migration

To upgrade or migrate, that is the question. And I have an answer.

Azure DWH part 1:Common questions about Azure SQL Data Warehouse

This article compiles some common questions and answers about Azure SQL Data Warehouse.

Data Mining Part 37: The Data Mining query transformation task

This new chapter will show you how to work with the SSIS Data Mining Query Transformation Task

Extracting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern

SQL Explained

A short explanation and infographic of what SQL is. For the non-SQL people in your life.

10 SQL Snippets For Faster, More Effective Code

How many hours per week do you spend writing the same SQL again and again?

Size of nvarchar(max)??

Converting to data-driven code

How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs