Category: Powershell

Script SQL Objects with Powershell

Post author By Jen McCown
Post date May 26, 2010
Categories In Powershell, Random helpfulness, sql server, sqlserverpedia-syndication, Uncategorized
12 Comments on Script SQL Objects with Powershell

Like so many of you out there in Internetland, I’m fairly new to Powershell, which is fairly new to the world. Recently I wanted a simple way to script out database objects, and a couple of you were kind enough to share your solutions with me. Sean Likes Powershell I also worked with Sean, who […]

Scripting DB Objects in Powershell – video transcript

Post author By Jen McCown
Post date May 3, 2010
Categories In Powershell

I like our videos, and I think they're a great way to teach, and an easy way to demo what we're trying to do. It's a lot easier and quicker than explaining things in text. BUT, they're not so great for reference after the first viewing. Sometimes I just want to FIND the CODE I NEED… […]

Index Rebuilds: SQL vs. PowerShell

Post author By Jen McCown
Post date August 28, 2009
Categories In Beginner, Intermediate, Powershell, sql server, Tips, TSQL
1 Comment on Index Rebuilds: SQL vs. PowerShell

I thought this conversation worth reporting…Sean and I were comparing our scripts to create rebuild / reorgs, and he sent this: DECLARE @currSchema VARCHAR(100) , @currTableName VARCHAR(100) , @SQL NVARCHAR(200) DECLARE Tables CURSOR read_only FOR SELECT SS.name , SO.name FROM sys.objects SO INNER JOIN sys.schemas SS ON SO.schema_id = SS.schema_id […]