The Mysterious Black Box of R - For the SQL Server Guy

Took a class from Jamey Johnston @ SQLSaturday #516 in Houston. Lots of great information covered. Follow him for a much...

Hello SQLSaturday Houston!

I've been looking forward to speaking at SQLSaturday Houston again all year!

Big thanks to the organizing crew behind this great...

The New Global Dashboard

Redgate recently released SQL Monitor 5.2, which is the latest upgrade to our monitoring/alerting/troubleshooting product for DBAs. This was the...

SQL Nexus

I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a...

See you Saturday in Houston!

Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions...

Use The Correct Data Type

Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Saying that you should use the...

Free eBook – Modern Storage Strategies for SQL Server

I’m pleased to announce the general availability of a new free ebook collaboration with James Green from ActualTech Media called...

Comparing the contents of two tables

I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...

PowerShell – SQL Database Refresh -Restore – Multiple Databases

.SYNOPSIS
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
.DESCRIPTION
The...

Find Unused Database Objects in SQL Server

Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...