This is probably what you are looking for http://gallery.technet.microsoft.com/scriptcenter/2fdeaf8d-b164-411c-9483-99413d6053ae

Note it uses bulkcopy and there are some restrictions with that.

It would follow "it depends". Pushing a procedure to production during business hours is something that is done consistently (depending on the change, impact, etc).

Not entirely sure...

This should do it -

Set-ExecutionPolicy RemoteSigned

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")

Function Get-DatabaseFilesBySpaceAvailable ([Microsoft.SqlServer.Management.Smo.Server] $SmoSqlServer

, [decimal] $sizeThreshold=0.80)

{

$sqlServer.Databases | Where-Object{$_.Status -eq "Normal"} `

| Select-Object FileGroups -ExpandProperty FileGroups `

| Select-Object Files -ExpandProperty Files `

| Where-Object {$_.MaxSize...

@Nadrek - Its a preference really, I don't like having lots of maintenance jobs on my servers, and when I come up with something new to check, the single deployment...

@Nadrek - using SQL is the normal way for most of us.

At some point, you are going to have too many servers to manage doing on a server by...

The hard way.... sheesh 🙂

Pass in an SMO sql object and here you go! (doing the log files is that easy as well)

Function Get-DatabaseFilesBySpaceAvailable ([Microsoft.SqlServer.Management.Smo.Server] $SmoSqlServer

, [decimal] $sizeThreshold=0.85)

{

$sqlServer.Databases |...

You can dump directly to SQL, I do that for gathering stats for our VM admins. I don't like looking at csvs or text files anymore than the next...

I don't have anything step by step - but I could easily create a step by step article or a set of blog posts that cover it. Is that...

Thanks. If folks have ideas on things to add to it, let me know and I can work them in and share the script.

Overall, the law has been a good thing as many expressed above. Allowing DBAs to tighten down production, while using SOX as the vehicle to get it done. ...

In the cubicle world - I think headphones and music are a must. The type of music listened to usually corresponds with what I need to accomplish. If...

For those of us who live in the Hinterlands - taking the kids out into the woods to explore is all it takes.

Whether its simply throwing sticks, or picking mushrooms,...

Funny, I saw the other day how to name the file much simpler than the hokey way I did - I think it was on Power Tip of the day....

Good Point on pooling - I will make a note to work on an implementation of that.

Very interesting Kendall - I was focusing on simplicity I suppose, I will try that out and re-post the new script if its possible.

katesl - The simple reason to use...