Tag Archives: PowerShell

PowerShell – Slicing

I was skimming through the first part of the Simple-Talk series on PowerShell Desired State Configuration, and I got to the bit that says “To install them, all you need to do is copy and paste them into your PowerShell … Continue reading

Posted in SQLServerPedia Syndication | Tagged | 4 Comments

PowerShell – Prompts, Paths, Profiles

PowerShell – PowerShell_ISE, Profiles and Prompts By default, your PowerShell prompt is “PS <<path>> >”. So normal; so dull. However, that can be easily changed. In my case, I want to add: the current time (well, the time at which … Continue reading

Posted in SQLServerPedia Syndication | Tagged | 4 Comments

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

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

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

Windows Server 2012 Core – Server Configuration, Add/Remove Features, SysPrep

Recently, I started building a Windows 2008 R2 / SQL 2008 R2 environment as per Jonathan Kehayias’s (blog|@SQLPoolBoy) series of articles on “Building A Free Test Environment“, I found myself wondering about doing similar in Windows 2012, specifically in Windows … Continue reading

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