Tag Archives: Azure

Using Redgate SQL Monitor with Azure Virtual Machines

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

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 , , | Leave a comment

Notes on Instant File Initialization and Running Scripts on Multiple Servers

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?

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

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

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

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