SQL Server with Mr. Denny:

SQL Server


August 19, 2015  6:00 PM

pssdiag has some useful parameters

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

Anyone who has ever called Microsoft's CSS team for support for a SQL Server has probably been told to run pssdiag against the server while reproducing the issue, or for some period of time. To run pssdiag we just run pssdiag.cmd and let it do it's thing, then press +C to stop it. But there's...

August 14, 2015  4:00 PM

Recommended reading from mrdenny for August 14, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

This week I’ve found some great things for you to read. These are a few of my favorites...


August 12, 2015  6:00 PM

The concurrent snapshot for publication ‘X’ is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for

Denny Cherry Denny Cherry Profile: Denny Cherry
Replication, Snapshot, SQL error messages, SQL replication, SQL Server, SQL Server replication, SQL Server transaction logs, SQL transaction logs, Transaction logs

Recently I was working on SQL Server Replication for a client, specifically removing and reading a table from replication to fix a different problem. After putting the table back and running the snapshot agent to create a differential snapshot I was greeted with the error message "The concurrent...


August 3, 2015  5:00 PM

PASS 2015 1st Timers Webcast

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

Like I've done for the last several years, I'll be presenting this years PASS Summit 1st Timers webcast, which really needs a new name as it really isn't just for PASS Summit First Timers anymore. But anyway, during this webcast I'll be giving some information about the convention center,...


July 31, 2015  7:20 PM

Recommended reading from mrdenny for July 31, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

This week I’ve found some great things for you to read. These are a few of my favorites that...


July 24, 2015  3:57 PM

Recommended reading from mrdenny for July 24, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

This week I’ve found some great things for you to read. These are a few of my favorites...


July 22, 2015  6:00 PM

Updating All Jobs To Check For AG Primary Replica

Denny Cherry Denny Cherry Profile: Denny Cherry
High Availability, Job scheduling, SQL job scheduler, SQL scripts, SQL Server

One of the really annoying things about moving existing SQL Server databases into an Availability Group is setting up the jobs to work within the confines of the AlwaysOn Availability Group. This is because you have to manually create the jobs on each server, then modify the jobs on each server to...


July 20, 2015  6:00 PM

If You Thought Database Restores Were Slow, Try Restoring From an EMC Data Domain

Denny Cherry Denny Cherry Profile: Denny Cherry
Backup and restore, backup appliance, Data Domain, EMC, Restore Database, SQL Server

Recently I did something which I haven't had to do for a VERY long time, restore a database off of an EMC Data Domain. Thankfully I wasn't restoring a failed production system, I was restoring to a replacement production system, so I was getting log shipping setup. I've worked in plenty of...


July 17, 2015  6:00 PM

Recommended reading from mrdenny for July 17, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server

This week I’ve found some great things for you to read. These are a few of my favorites that...


July 15, 2015  6:00 PM

Multi-threading Backups

Denny Cherry Denny Cherry Profile: Denny Cherry
Backup and Recovery, Database performance, SQL Server

In the modern world of huge amounts of data backing up databases within a reasonable amount of time has become harder and harder for people which massive amounts of data to do. Several of my clients have so many databases, with so much data on them that they simply can't complete full backups of...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: