Tag Archives: Azure

Using Redgate SQL Monitor with Azure Virtual Machines

Posted on November 9, 2015 by thomasrushton

We have an environment built out of SQL Servers installed on Azure Virtual Machines. We want to use Redgate’s SQL Monitor to monitor this environment; however, as of version 4.x it wasn’t completely supported on the Azure platform. Mainly, I … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | 1 Comment

SQL Server TempDB, Azure Virtual Machines, and the D: Drive

Posted on November 3, 2015 by thomasrushton

Why put the TempDB on the D: drive? In the wonderful world of Azure Virtual Machines, for certain VM types, the D: drive is hosted on SSDs – great for performance. However, in this world, the D: drive is “non-persistent … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

Notes on Instant File Initialization and Running Scripts on Multiple Servers

Posted on November 2, 2015 by thomasrushton

Instant File Initialization (IFI) IFI can be a useful performance booster if you’re in an environment where your database files grow regularly, although there’s an argument that if that happens regularly, you should grow them massively up front in a … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

Azure CustomScriptExtension – Are there limits?

Posted on September 28, 2015 by thomasrushton

Yes, another in a series of disjointed short notes about Azure. I’ve been buildings PowerShell scripts to automate the build of SQL Server AzureVMs. Part of that effort has been using the Azure Custom Script Extension to help get stuff … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Problems with Azure VMs of different sizes

Posted on September 24, 2015 by thomasrushton

Just a quick note… If you’re building an Azure Cloud Service with multiple Virtual Machines of varying sizes, does it matter which order you create Azure VMs? I created a new Azure Cloud Service by building a machine of size … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Azure Windows Server 2012 VMs – non en-US Locale

Posted on August 3, 2015 by thomasrushton

Just a quick scream out into the void… You know when you build a new server, a real one, you get to choose what locale / regionalisation / language settings you want the server to be installed with? How are … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

SQL Server 2016 – New Feature – Stretch DB

Posted on July 24, 2015 by thomasrushton

This applies to the CTP – it might not apply to any RTM version Have you been following the SQL Server 2016 at Microsoft.com site? I really haven’t had much time to pay attention to this recently, but this one … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

New-AzureVM : BadRequest: The virtual network <foo> does not exist.

Posted on July 17, 2015 by thomasrushton

Just a quickie. It’s been a long week, and I’ve been trying to get my head around using PowerShell to automate deployments in Azure. However, I did come across a little glitch in the way that this is supposed to … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 10 Comments