Michiel Wories' WebLog

An insightful article on a recent Windows Azure service disruption

This was such a great read that I wanted to share it out......

Author: Michiel Wories - MSFT Date: 03/22/2012

The use of Write-Host and SQL Server Agent PowerShell job steps

SQL Server Agent implements a job subsystem that allows users to directly run PowerShell scripts in...

Author: mwories Date: 09/30/2009

PowerShell Tips & Tricks: Getting more detailed error information from PowerShell

Allen White wrote this handy blogpost on how to handle error message and get more information out of...

Author: mwories Date: 06/08/2009

Talking about SQLPS (SQL Server Powershell extensions) on Runas Radio

I was recently interviewed on RunAs Radio on the new Powershell extensions that we developed for SQL...

Author: mwories Date: 09/24/2008

What? No cmdlets? -- SQL Server Powershell

When you start using the SQL Server Powershell extensions, you will find there are not a whole lot...

Author: mwories Date: 06/25/2008

Some background on the use of minishells, such as SQLPS

Jeffrey Snover posted a very clear article about minishells and SQL Server's use of it:...

Author: mwories Date: 06/23/2008

Evaluating SQL Server Policies through Powershell

I found this ping-back on my previous blog post which gives a good overview of one very useful...

Author: mwories Date: 06/20/2008

SQL Server Powershell is here!

I am very excited that SQL Server will ship with a pretty solid first release of Powershell...

Author: mwories Date: 06/14/2008

How to change the SQL Server password programmatically

Every now and the question comes up how to programmatically modify the service account or password...

Author: mwories Date: 11/03/2006

SMO Sample: Enable TCP/IP Server protocol of SQL Server 2005

Purpose of sample: Enable the TCP/IP server protocol. This sample shows you how to change a server...

Author: mwories Date: 02/10/2006

Add oil to fire: SMO and Monad -- a flammable combination

Euan pointed me to an interesting article about the use of Monad together with SMO. Those who know...

Author: mwories Date: 01/03/2006

SQL Server 2005 -- it's a wrap; but wait -- it's just the beginning!

I'm sure there are lots of coworkers blogging about this. We're done with SQL Server 2005 and it's a...

Author: mwories Date: 10/28/2005

SMO Samples Galore

With much of the SQL Server 2005 devcelopment behind us, I am starting to have some more time to...

Author: mwories Date: 10/25/2005

SMO Sample: Which SQL Server version is supported by the property?

Purpose of sample: List metadata information about SMO object properties SMO's object model is...

Author: mwories Date: 10/25/2005

SMO Sample: Create and Start a Job

Purpose of sample: Create simple job and start the job after creation. Server svr = new...

Author: mwories Date: 10/24/2005

SMO Sample: Backup database to Mirrors

Purpose of sample: Backup database to various mirrors Server svr = new Server(); Backup b = new...

Author: mwories Date: 10/18/2005

SMO Sample: Partitions

Purpose of sample: create a partition function and partition scheme on an existing database Server...

Author: mwories Date: 10/18/2005

SMO Sample: Transfer

Purpose of sample: Transfer a database; all objects and data Server tgt = new Server("."); // Setup...

Author: mwories Date: 10/18/2005

SMO Sample: Table column default constraint

Purpose of sample: show how a column constraint can be created. Table tbl = new Table (db,...

Author: mwories Date: 10/18/2005

TechED: SMO session done! Now what?

The SMO session was on today! Wow the Euro-crowd is tough! (which I heard uttered by various...

Author: mwories Date: 07/06/2005

Project code named 'Mercury' (not "SQL Server Web Data Administrator")

Granted, I was asking for this. When we were starting the development of the follow-up version of...

Author: mwories Date: 07/05/2005

Upcoming at TechED: Web Based SQL Server Management Tool (Shared Source!)

Visual Studio .NET 2003 shipped a web based sample application for management of SQL Server, based...

Author: mwories Date: 07/04/2005

SQL Server 2005 Easter Egg

In an interview with Gert Drapers, SQLCMD was mentioned as SQL Server 2005's Easter Egg (Gert: "one...

Author: mwories Date: 06/24/2005

SQL Server: Table Partitioning in SQL Server 2005

Table and Index partitioning is one if the new SQL Server 2005 features that willl improve life for...

Author: mwories Date: 06/24/2005

Scripting in Microsoft SQL Server 2005 Web Cast Resources

This article contains extra information with regard to the web cast "Scripting in Microsoft SQL...

Author: mwories Date: 06/21/2005

Scripting in Microsoft SQL Server 2005 -- Web Cast has finished

I just finished the Scripting in Microsoft SQL Server 2005 webcast. Thanks all for being online (and...

Author: mwories Date: 06/21/2005

DMO FAQ

Q: Is SQL-DMO still supported with SQL Server 2005?A: Yes, SQL-DMO will be fully supported (albeit...

Author: mwories Date: 06/20/2005

SQL Server: Capture Object changes with SMO Capture Mode

In a previous article I have showed how a SMO object can be serialized into a Transact-SQL script,...

Author: mwories Date: 05/31/2005

SQL Server: SMO Scripting Basics

Let's first clarify what I mean by "scripting". It often happens during talks or when I explain SMO...

Author: mwories Date: 05/07/2005

SMO FAQ

Q: With which SQL Server versions is SMO compatible?A: SQL Server 2000, and SQL Server 2005. Q: Is...

Author: mwories Date: 05/02/2005

I'm starting to post articles around SMO and other topics, like WMI, SQLCMD, and other areas. This...

Author: mwories Date: 05/02/2005

Sql Server: Everything you always wanted to know about SMO Connections

There are several ways of controlling connections in SMO -- you can control pretty much any aspect...

Author: mwories Date: 05/02/2005

SQL Server: Tuning your SMO Application for great performance -- PART 2

In the previous post I provided you with a fundamental tool to minimize the amount of SQL statements...

Author: mwories Date: 05/02/2005

Starting with SQL Server 2005 WMI with help of Scriptomatic

SQL Server 2005 introduces a new WMI Provider that allows configuration of Services, Client Network...

Author: mwories Date: 04/27/2005

I'm ramping up for TechED 2005 (Both USA and Europe) and will be giving a couple of talks on SMO....

Author: mwories Date: 04/22/2005

Moving over to a new blog... And something about me

Moving over my blog from sqljunkies. At sqljunkies I had made a start with some background articles...

Author: mwories Date: 12/22/2004