Ok, well I’ve been very busy again and released 3 new PS vids today.
There’s one on dropping tables. I use regex to make this happen, so even if you’re not interested in dropping tables, you can come learn how to do a simple regex.
http://midnightdba.itbookworm.com/VidPages/PowershellDropTables/PowershellDropTables.aspx
http://midnightdba.itbookworm.com/VidPages/PowershellDropTables/PowershellDropTables.wmv
The next one is on truncating tables. Here I just limit it by a specific schema.
http://midnightdba.itbookworm.com/VidPages/PowershellTruncateTables/PowershellTruncateTables.aspx
http://midnightdba.itbookworm.com/VidPages/PowershellTruncateTables/PowershellTruncateTables.wmv
And the last one is just damn good. I show you how to get sp_configure functionality in PS. There’s a trick to it so don’t discard it cause you think you can figure it out on your own.
http://midnightdba.itbookworm.com/VidPages/PowershellServerConfigSettings/PowershellServerConfigSettings.aspx
http://midnightdba.itbookworm.com/VidPages/PowershellServerConfigSettings/PowershellServerConfigSettings.wmv