A Monumental Migration to SQL Server 2016 - Part 1

A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from...

ArithAbort and SQL Agent Failures

ARITHABORT can be a short termed head scratcher.  Pay close attention to what has changed in the environment.  Test alternatives.  And check those connection strings.
Related Posts:

Failed to Create the...

ArithAbort and SQL Agent Failures

ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...

Azure SQL DB VS SQL Server For the DBA

Being the start of the new year and with new projects most likely starting again I would like to share...

Five database management trends to embrace in 2019

In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment....

Five database management trends to embrace in 2019

In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...

How to Change Suspect Mode to Normal Mode in SQL Server Database

If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also...

How to Change Suspect Mode to Normal Mode in SQL Server Database

If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also means that your database has gone into the suspect...

Profiler Is Dead, Long Live Extended Events

OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...

Query plan hash

This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...