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

Upcoming SQL Saturdays - June 2016

I am speaking at two different SQL Saturdays in June!
--

First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517)...

PowerShell – Backup Specific group of SQL Databases

<#

.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...