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...

Return of the .NET - NYC

Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...

What is RapidMiner

RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner.  RapidMiner is an open...

Transaction Logging & Recovery (part 3)

Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server:...

Power BI and Google Analytics

One of the more underused features of Power BI is the Google Analytics data source.  Working closely with marketers and...

Installing SQL Server 2016 Community Technology Preview

This post is designed to explain the installation steps of some of the new features in 2016 and just how...

Advent of Code–Day 2

I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it...

HA/DR for Azure SQL Database

Azure SQL Database is a relational database-as-a-service in the cloud.  It uses a special version of Microsoft SQL Server as...