SQL Server with Mr. Denny:

SQL Server


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


June 3, 2015  6:00 PM

Why don’t the memory usage numbers from Task Manager and vSphere match?

Denny Cherry Denny Cherry Profile: Denny Cherry
Performance Monitor, Performance monitoring, SQL Server, Task Manager, VMware vCenter

This question comes up a lot. Windows Admins and DBAs see one number in Task Manager and the VMware Admins see another number in vSphere. And often the VMware Admins want to reduce the amount of memory that the server has available because of the memory utilization number. Here we see two...


May 22, 2015  5:49 PM

Recommended reading from mrdenny for May 22, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
CDC, SQL Azure, SQL Server, SQL Server 2005, VMware vSphere, Windows Azure

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


May 20, 2015  4:00 PM

India Here I Come

Denny Cherry Denny Cherry Profile: Denny Cherry
IT conferences, SQL, SQL Server

I'm thrilled to report that I'll be presenting at the first SQL Server conference in India later this year. The conference organizer Amit Bansal made the official announcement last week. A...


May 8, 2015  11:22 PM

Recommended reading from mrdenny for May 08, 2015

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

Microsoft Ignite was great, but I still found the time this week to find some great things for you to read. These are a few of my favorites that I’ve found this week.


April 29, 2015  4:00 PM

Stop Touching the Public Database Role

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, SQL Server, SQL Server security

Odds are you don't need to make permissions changes to the public database role. Back in the SQL 7 days making...


April 22, 2015  4:00 PM

Take Your Time With Azure Site to Site VPN Configurations

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

Setting up Azure Site to Site VPN Endpoints can be a real treat sometimes. Recently I was setting up a site to site VPN between two Azure sites. One in the US West data center and the other was in the West Europe data center. Now the annoyance when setting up a site to site VPN between two Azure...


April 17, 2015  6:00 PM

Recommended reading from mrdenny for April 17, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
Apple, SQL, SQL Azure, SQL Server, SQL Server Integration Services

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


April 15, 2015  4:00 PM

Where to find the Azure PowerShell SDK ToolKit

Denny Cherry Denny Cherry Profile: Denny Cherry
download, downloading, Powershell, SQL, SQL Azure, SQL Server, Windows Azure

If you do basically any work with Azure you'll need to get the Azure PowerShell ToolKit at some point. Now finding the Azure PowerShell SDK Download page is a royal pain. So to make life easier I've setup a quick redirection that will get you to the correct place. Simply browse to

    0 Comments     RSS Feed     Email a friend


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: