SQL Server with Mr. Denny:

ITKE grandparent


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


July 8, 2015  6:00 PM

Be Careful When Starting Up Azure VMs Running SQL Server

Denny Cherry Denny Cherry Profile: Denny Cherry
Firewall configuration, SQL Azure, SQL Server, Windows Azure

So Microsoft has done something pretty dumb with the Azure VMs which are running Microsoft SQL Server. By default the front end firewall (the one that allows or blocks traffic from the public Internet to the VMs) allows traffic to the default SQL Server port 1433. At first this is fine, until you...


July 1, 2015  10:00 AM

Splitting Files for SQL DW

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, SQL Azure, SQL Server, Windows Azure

When doing data warehouse loads into SQL DW you'll want to break your single large file that you extract into multiple smaller files in order to do loads into the SQL DW (via Azure Blob Storage) as fast as possible. There's a few ways that you can do this. One way would be to handle this in your...


June 27, 2015  5:36 AM

Recommended reading from mrdenny for June 26, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
Internet of Things, Net Neutrality, SQL Server, SQL Server transaction logs

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


June 24, 2015  6:00 PM

Why I WILL Be Speaking at @VMworld

Denny Cherry Denny Cherry Profile: Denny Cherry
Conferences, IT conferences, IT conferences and events, SQL Server, VMware, VMworld

Back on June 17th, 2015 I posted about how I wouldn't be speaking at VMworld 2015. Oh what a difference a week can make. Apparently that got the attention of some people at VMware, and I'm happy to report that now I will be speaking at VMworld 2015. Now sadly I won't be at VMworld for the...


June 19, 2015  11:46 PM

Recommended reading from mrdenny for June 19, 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...


June 17, 2015  6:00 PM

Why I Will Not Be Speaking at VMworld

Denny Cherry Denny Cherry Profile: Denny Cherry
Conferences, IT conferences, IT conferences and events, SQL Server, VMware, VMworld

I love speaking at conferences. I get to meet new people, I sometimes get to visit a new city. But I'm sad to say that I will not be speaking at the North America or Europe VMworld events this year, even though I was accepted. My reasons are pretty basic. VMware (who puts on VMworld) has...


June 12, 2015  6:00 PM

Recommended reading from mrdenny for June 12, 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...


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: