Msg 8909, Level 16, State 1, Line 1 Table error: Object ID index ID partition ID

Advertisements 
Being a DBA , you will see database corruptions in your environments. I got four or five and not affected much...

Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment

Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Chicago on March 23rd 2018! This...

Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment

Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop...

The Top 4 Data Technology Trends Every DBA Should Know About in 2019

Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm...

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