Where do you put your business logic? In stored procedures?

There seems to be two trains of thought and I think this is mainly down to who and where your...

Big Data architectures

Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...

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

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

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

SQL Nexus

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

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

Word-wrap in SQL Server Management Studio

I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...

Azure Speed Testing

Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...

Possible PARAMETER SNIFFING Scenario in SQL

When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...