Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2009

ADO.NET in PowerShell

I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things the way one would think. The result is that the performance is unacceptable when dealing with multi-terabyte databases....(read more)

Read more

0 comments, 151 reads

Posted in Allen White on 22 September 2009

Browse and Script

One of the cool features of the SQL Server PowerShell snapins is the the ability to browse SQL Server as though it was a file system. While Management Studio has the nice graphical tree structure, sometimes I find it more productive to walk up and down...(read more)

Read more

0 comments, 116 reads

Posted in Allen White on 16 September 2009

Use the Best Tool for the Task - Part 2

Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database with very large files. Today I'd like to point out that creating the database I used to test that fix was far easier with PowerShell...(read more)

Read more

0 comments, 131 reads

Posted in Allen White on 3 September 2009

Use the Best Tool for the Task

Last February I wrote an article for Simple-Talk called Let PowerShell do an Inventory of your Servers . This script was useful to me then, and it continues to be so, but it recently ran into a glitch. Here is the code in the script to gather data on...(read…

Read more

0 comments, 125 reads

Posted in Allen White on 2 September 2009

24 Hours of PASS Tonight

For those of you who may have missed it, the 24 Hours of PASS conference starts tonight at 8pm EDT! I'll be presenting my introductory PowerShell for SQL Server session at 9pm EDT, so if you're interested in getting started with PowerShell, please join...(read more)

Read more

0 comments, 108 reads

Posted in Allen White on 1 September 2009