SQL Server with Mr. Denny:

SQL Server


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


June 10, 2015  6:00 PM

Buffer Pool Extension File Location

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, SQL Server 2014

If you are planning on using Buffer Pool Extension (BPE) in SQL Server 2014 or SQL Server 2016 you need to think about where you want to put the BPE file on the SSD, especially as it relates to the Windows OS Security on the file system.  The most important think to remember when placing the BPE...


June 10, 2015  5:58 PM

Recommended reading from mrdenny for June 05, 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: