I’ve been trying out the new supported Windows Azure PowerShell Cmdlets this week and I’d have to say I’m impressed. I’ve only used the ones for setup (Get-AzureSettingsFile and friends) and the ones for Windows Azure SQL Database (WASD) so far, and there’s a new one for WASD I really like. The original Codeplex WAAPS […]
Bob Beauchemin
SQL Server Blog
Getting Windows Azure SQL Database diagnostics using Windows Azure cmdlets
Posted on: January 11, 2013 1:59 pm
Using PowerShell with DAC 3.0
Posted on: June 18, 2012 10:34 am
At my DAC talk at TechEd last week, the thing that seemed to cause the most interest was the PowerShell scripts to use DACPACs/BACPACs. I thought I'd post that here, along a question about cmdlets in general. Using PowerShell against the library allows admins to use all of the functionality that's in SSMS, with the […]
There are some new PowerShell Cmdlets in Denali CTP1
Posted on: November 11, 2010 1:17 am
Quick correction to my PowerShell Denali CTP1 post here. Max Trinidad did the obvious get-command call and found some new PowerShell cmdlets related to the new HADR feature. Knew I should have tried that. 😉
SQL Server Denali CTP1 – PowerShell and XEvents
Posted on: November 9, 2010 1:47 pm
Just having a look at PowerShell support in SQL Server Denali CTP1. In Denali you must install PowerShell V2 or it will be installed as part of the installation process. Although the minishell architecture of SQLPS is unchanged so far. Rumor is that changing this (maybe into a module, like Chad Miller did?) might in […]
Programming SQLRegistration in the SQL Server PowerShell Provider
Posted on: July 8, 2008 7:23 am
I've noticed that some folks have written PowerShell scripts that execute against a list of servers. In the scripts, they read the names of the servers from XML files. But the SQL Server PowerShell provider in RC0 has a useful "component" called SQLRegistration; its "path" is SQLSERVER:\SQLRegistration that they can use instead. This path permits enumeration […]
Using PowerShell to program SQL Server’s Policies and Data Collection
Posted on: July 8, 2008 7:11 am
I received a question today about whether I'd converted my Policy-Based Management examples using SMO (see the multi-part "Programming Policy-Based Management with SMO" series, starting here) from C# to PowerShell yet. I did do this a while ago; they're available as a script download on the SQLskills website (look on the "Past Conferences" page under TechEd […]
Changes to the SQL Server PowerShell provider in RC0
Posted on: June 9, 2008 9:59 pm
Last week at TechEd Developers, I gave a talk on PowerShell and SQL Server. I mentioned some upcoming changes in RC0, and have just had a chance to check them out. The PowerShell provider for SQL Server has been expanded to handle not only a "SQL" subdirectory (which enumerates database objects) and "SQLPolicy" (which enumerates […]
Accessing multiple servers with the SQL Server 2008 PowerShell provider
Posted on: March 25, 2008 7:21 am
Short post this evening… Just in case anyone else flails around looking for this feature, its right under your nose. When you use the PowerShell SQL Server 2008 provider, you have visibility to a single, local machine (and all its SQL Server instances you can access with integrated security) by default. To get access to […]
Powershell and SQL Server’s 2008 SMO – the reprise
Posted on: October 31, 2007 9:12 pm
In the last few years, I've done a few talks at various conferences on the integration of SMO (SQL Server Management Objects) and Powershell. My friend and co-author of the SQL Server 2005 books, Dan Sullivan, got me into using Powershell and SMO and has written quite a number of excellent blog entries and articles about it. […]
SMO and Powershell: Better Together, The Scripts
Posted on: November 7, 2006 3:32 pm
Sorry, I know that slogan has been used already. Thanks to everyone who showed up for the SMO/Powershell chalk talk at TechEd Barcelona today. Here, as promised, are the demos. Thanks especially to Jeffrey Snover, the "dad" of Powershell for showing up and showing me some neat shortcuts… as I typed. Many of the scripts were […]
SMO scripting at TechEd Europe
Posted on: November 6, 2006 10:07 am
I'm in Barcelona in TechEd and tomorrow I'm going to be doing a chalk talk on SQL Server Management Objects (SMO). Although I'd usually done my SMO coding in C#, I decided (based on my co-author Dan Sullivan's blog post on the subject) to try out using Powershell along with SMO. So, although when most folks […]
