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......
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...
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...
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...
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...
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:...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 10/18/2005
SMO Sample: Partitions
Purpose of sample: create a partition function and partition scheme on an existing database Server...
Date: 10/18/2005
SMO Sample: Transfer
Purpose of sample: Transfer a database; all objects and data Server tgt = new Server("."); // Setup...
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,...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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...
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...
Date: 05/02/2005
Index for SQL Server related articles
I'm starting to post articles around SMO and other topics, like WMI, SQLCMD, and other areas. This...
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...
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...
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...
Date: 04/27/2005
SQL Server: Tuning your SMO Application for great performance - PART 1 (featured at TechED)
I'm ramping up for TechED 2005 (Both USA and Europe) and will be giving a couple of talks on SMO....
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...
Date: 12/22/2004