SQL Server with Mr. Denny:

Windows Azure


August 2, 2016  7:19 AM

Site to Site VPNs no longer needed for vNets in the same Azure region

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, Networking, Windows Azure

Up until August 1st if you had 2 vNets in the same Azure region (USWest for example) you needed to create a site to site VPN between them in order for the VMs within each vNet to be able to see each other.  I'm happy to report that this is no longer the case (it is still the default...

August 1, 2016  4:00 PM

SQL Azure != SQL Server

Denny Cherry Denny Cherry Profile: Denny Cherry
AWS, AWS EC2, Azure, Capacity planning, Disaster Recovery, High Availability, SQL Azure, SQL Database, SQL Server, Windows Azure

This may come as shocking news to some, but Microsoft SQL Server and Microsoft Azure SQL DB (Azure SQL Database, Azure SQL DB, SQL Azure Database, or whatever name you know it as) are very much not the same thing.  They may look similar and they may act similar, but they are very much not the same...


June 8, 2016  4:00 PM

Getting around annoying outbound firewall rules at venues when presenting.

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

Presentations that are given are user groups, events, etc. often require demos. Sometimes those demos are to large or comple 0 Comments     RSS Feed     Email a friend


May 11, 2016  4:00 PM

Viewing task status for related objects in the Azure Portal

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, Windows Azure

When working in the Azure portal finding task information when performing tasks against an object that is related to an object can be tough.  Before I dive into the how, let me demystify what I'm talking about a little more, as that first statement is a little vague.  In the case of my example I...


February 8, 2016  7:40 PM

Would you like Microsoft to pay for you to move to Azure?

Denny Cherry Denny Cherry Profile: Denny Cherry
Cloud azure, Cloud migration, SQL Azure, SQL Server, SQL Server migration, Windows Azure

Have you been wanting to move some of your services up to Azure, but you don't have the budget to move them up to th 0 Comments     RSS Feed     Email a friend


December 16, 2015  5:00 PM

Get Operation Status of an Azure Async Operation

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, Powershell, PowerShell Scripts, SQL Server, Windows Azure

Recently I was trying to make a drive bigger on an Azure VM by simply using Set-AzureOSDisk PowerShell commandlet (and the -ResizedSizeInGB switch). The problem is that this command is asynchronous meaning that it tells you that it's done, even if it hasn't finished yet. The problem with this,...


November 4, 2015  4:00 PM

In Azure CApS MatTers

Denny Cherry Denny Cherry Profile: Denny Cherry
Azure, PowerShell cmdlets, PowerShell Scripts, SQL Server, Windows Azure, Windows PowerShell

Recently I was doing some work for a client moving some vDisks from standard storage to premium storage. Overall it was a pretty easy migration to do, just requiring a little PowerShell to make it all happen. The part that made it hard to get done is that the PowerShell parameters for file...


September 30, 2015  6:00 PM

Upgrading a SQL FCI to Premium Storage in Azure Without Downtime

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

Recently I was asked by a client to upgrade their SQL Server Failover Cluster from standard storage to Azure premium storage with as little downtime as possible. Due to the fact that the SQL Server instance was clustered already this was actually a pretty straight forward process. The first...


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


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: