SQL Server with Mr. Denny:

Windows Azure

1

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

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


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


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


February 27, 2015  6:38 PM

Recommended reading from mrdenny for February 27, 2015

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

The most important thing to read today is the New York times notice of

    0 Comments     RSS Feed     Email a friend


October 10, 2014  5:33 PM

Recommended reading from mrdenny for October 10, 2014

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

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


October 4, 2014  2:01 PM

Recommended reading from mrdenny for October 03, 2014

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

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


June 26, 2014  4:50 AM

SQL PASS 2014 Here I Come

Denny Cherry Denny Cherry Profile: Denny Cherry
Hyper-V, Server virtualization, SQL, SQL Server, SQL Server 2014, VMware vSphere, Windows Azure

I'm pleased to report that I'll be presenting at the SQL PASS 2014 Summit this year. I'll be presenting two breakout sessions this year. The first session that I'm presenting is "Optimizing SQL Server Performance in a Virtual Environment" where we'll talk about the various ways that we can make...


1

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: