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

PowerShell to Simulate Load

Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still...

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

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

SQL Bits Precon 2019

I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s...

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

Data Warehousing Tip #3 – Build thin slice

My third data warehousing tip is to build thin slice.  Deliver subsets of valuable functionality. Get feedback and buy in,...

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