Category: Tech and Learning

SQL Trace Events Reference

Post author By Jen McCown
Post date July 19, 2010
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication
3 Comments on SQL Trace Events Reference

I’ve mentioned before that I’m something of an absentminded DBA – I know where to find information, even if I can’t keep it in my head all the time. One of the lookups I have to do most often is for server side trace / SQL Profiler event numbers and names. See, when you create […]

SSIS Ground Zero at NTSSUG – #6

Post author By Jen McCown
Post date July 16, 2010
Categories In News-ish, NTSSUG, sql server, SQLPASS, sqlserverpedia-syndication, SSIS
1 Comment on SSIS Ground Zero at NTSSUG – #6

Sean is insane, but he’s good enough to get away with it. By that I mean this: He’s been teaching this monthly SSIS class at the NTSSUG meetings for six months, and he’s waiting later and later to figure out what he’s going to teach. Last month, he was busy enough that he had to […]

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