Notes from SQLSaturday #480 in Nashville

Late posting, so reduced notes!
Speaker party was good. Room was loud when full due to wood walls and nothing to...

The SQL Server Security Model, Part 1: Logins [Foundations Friday]

How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...

Using Change Tracking in SSIS

Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...

What Do You Want?

It’s that time of year, planning for PASS Summit 2016.  We’ve already put out the Call for Volunteers, which closes...

Overview of Published Articles – 2015Q4

Here is an overview of the articles I published in the final quarter of 2015:
Integrated Logging with the Integration Services Package...

Foundations Friday starts now

Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...

Push Button Deployments

I worked in an Agile team in 2000 and we deployed changes to our web platform every Wednesday for over...

Easy Installing .NET 3.5 for SQL Admins

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed.

This is a common problem and relatively easy fix for...

Book review – Extending SSIS with .NET Scripting

Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...

Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks

There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...