SQL Server (RSS)


PowerShell Tips & Tricks: Getting more detailed error information from PowerShell
08 June 09 08:41 AM | mwories | 0 Comments   
A handy little trick to quickly get much more error information out of PowerShell Read More...
Filed under: ,
Talking about SQLPS (SQL Server Powershell extensions) on Runas Radio
24 September 08 10:42 AM | mwories | 2 Comments   
I was recently interviewed on RunAs Radio on the new Powershell extensions that we developed for SQL Server 2008. If you want to learn more about SQL Server Powershell download the podcast here : http://www.runasradio.com/default.aspx?showNum=75 If you Read More...
What? No cmdlets? -- SQL Server Powershell
25 June 08 12:25 AM | mwories | 2 Comments   
When you start using the SQL Server Powershell extensions, you will find there are not a whole lot of cmdlets. The expectation is indeed that Powershell support means: cmdlets for every administrative operation you can perform. Did we miss something here? Read More...
Some background on the use of minishells, such as SQLPS
23 June 08 09:58 AM | mwories | 0 Comments   
Jeffrey Snover posted a very clear article about minishells and SQL Server's use of it: http://blogs.msdn.com/powershell/archive/2008/06/23/sql-minishells.aspx Jeffrey is Powershell's Architect, well respected in the Powershell community, and it's good Read More...
Evaluating SQL Server Policies through Powershell
20 June 08 10:27 AM | mwories | 0 Comments   
I found this ping-back on my previous blog post which gives a good overview of one very useful cmdlet that we ship with the Powershell extensions that SQL Server 2008 will deliver. A very helpful article one of the SQL Server MVPs, Lara Rubbelke , on Read More...
SQL Server Powershell is here!
14 June 08 03:35 PM | mwories | 23 Comments   
I am very excited that SQL Server will ship with a pretty solid first release of Powershell extensions with SQL Server 2008. The SQL Server Powershell extensions deliver on a vision that we’ll expand on in the next releases to come. So what’s in this release of SQL Server Powershell? Read More...
How to change the SQL Server password programmatically
03 November 06 04:32 PM | mwories | 2 Comments   
Every now and the question comes up how to programmatically modify the service account or password of SQL Server. There basically two ways to accomplish this, using SMO, or WMI. This article shows you how to use WMI and VBScript to accomplish this task. Read More...
Filed under: ,
Add oil to fire: SMO and Monad -- a flammable combination
03 January 06 11:35 AM | mwories | 13 Comments   
Euan pointed me to an interesting article about the use of Monad together with SMO . Those who know me well, know I am somewhat of a scripting biggot and still install Cygwin on all of my boxes as I cannot live without bash, awk, perk, sed, expr and the Read More...
Filed under: ,
SQL Server 2005 -- it's a wrap; but wait -- it's just the beginning!
28 October 05 08:54 AM | mwories | 2 Comments   
I'm sure there are lots of coworkers blogging about this. We're done with SQL Server 2005 and it's a very interesting and good feeling. Having worked 5 year on the project, many long days, many weekends, having to fight many battles, and at the same time Read More...
Filed under:
SMO Samples Galore
25 October 05 09:47 AM | mwories | 3 Comments   
With much of the SQL Server 2005 devcelopment behind us, I am starting to have some more time to post some SMO samples . Most of these are inspired on questions in the beta newsgroups or the SMO/DMO forum . Additionally, SQL Server 2005 ships with a pretty Read More...
Filed under: ,
SMO Sample: Which SQL Server version is supported by the property?
25 October 05 09:24 AM | mwories | 1 Comments   
Purpose of sample: List metadata information about SMO object properties Read More...
Filed under: ,
SMO Sample: Create and Start a Job
24 October 05 06:07 PM | mwories | 5 Comments   
Purpose of sample: Create simple job and start the job after creation. Read More...
Filed under: ,
SMO Sample: Backup database to Mirrors
18 October 05 02:53 PM | mwories | 1 Comments   
Purpose of sample: Backup database to various mirrors Read More...
Filed under: ,
SMO Sample: Partitions
18 October 05 02:42 PM | mwories | 1 Comments   
Purpose of sample: create a partition function and partition scheme on an existing database Read More...
Filed under: ,
SMO Sample: Transfer
18 October 05 02:31 PM | mwories | 3 Comments   
Purpose of sample: Transfer a database; all objects and data Read More...
Filed under: ,
More Posts Next page »
Page view tracker