Have I mentioned I’m busy?

So, yeah. I got a couple things going on.  *Deep breath* site upgrade 3 projects at the job blogging and articles for sqlserverpedia planning sql saturday for january three major trips in the next six months. Plus I think I'd like to learn to play guitar.

We're watching the pilot of Star Trek Next Generation, by the way, and the just did the saucer separation for the first time, with that insanely triumphant music.  you know?  It's still kinda cool.  And the engine section still looks beheaded to me.

Okay, two new videos from Sean at MidnightDBA:

  • Add User to Windows Group with Powershell (13 min) – I love this video because it's so unusual to find something like it in the DBA community.  We're quite often called on to do things outside of our direct job descriptions and this is something I have to do a lot.  So I'm showing you how to add a user to a Windows group so you don't have to TS into a lot of boxes to add someone.
  • Fix SSIS Pkg Import Errors (5 min) – This is a live troubleshooting video.  I had an error importing an SSIS pkg so I turned on the camera and worked the issue live for you.  A couple of the symptoms are not being able to copy tasks inside Visual Studio and getting an error about not being able to serialize the runtime object.  This is one of those cases where at least being exposed to the types of things that can go wrong will help you come up with a solution even when you've never seen a specific error.

Some new articles from me:

  • Generate Insert Statement for Table – Here's a simple enough procedure to generate an insert statement for a given table. I know you can do this through SSMS, but I dislike having to navigate through the tree to get to the table I want.
  • Functions – @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT – When you insert a row into a table with an identity column, SQL generates the identity value and inserts it behind the scenes. There are several ways to retrieve that value…
  • Identities Overview – I contributed the IDENTITY INSERT section.  Go-go identity insert!

 And happy days for all.

-Jen McCown, http://www.MidnightDBA.com