Category: Beginner

Custom Keyboard Shortcuts in SSMS

Post author By Jen McCown
Post date March 26, 2010
Categories In Beginner, Random helpfulness, sqlserverpedia-syndication, SSC, Tips, TSQL
3 Comments on Custom Keyboard Shortcuts in SSMS

Content rating: Beginner, Tip I KNOW I blogged about custom SSMS shortcuts before, but dang if I can find it. I use certain commands SEVERAL times a day, and I’m in love with shortcuts. So the SMS keyboard shortcuts dialog is just perfect for me. You already have three default shortcuts when you install SSMS: […]

SSIS: Deploy Packages, Part 1

Post author By Jen McCown
Post date September 9, 2009
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSIS, Tips

This is the companion text to the video SSIS: Deploy Packages. This will be a two- or three-part series, I think. There are two ways to deploy SIS packages, and the difference becomes important when you have a lot of packages. The first way is just to individually deploy a package directly to SQL (or […]

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 […]