SQL Server with Mr. Denny:

August, 2015

August 26, 2015  6:00 PM

Connecting To SQL Server Running On An Azure VM

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, Cloud Virtual Machine Security, SQL Server, Virtual Machine Security, Virtual Machines, Windows Azure

If you have setup a Windows Azure Virtual Machine running SQL Server you may have noticed that you might not be able to connect to the SQL Server running on the machine by using SQL Server Management Studio on your workstation (desktop, labtop, etc) from your home or office. This is normal and...

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

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: