$500 discount deadline today, and NT SQL User Group meeting

Today is the last day to register and save $500 off the regular PASS conference rate.  Just use the registration code 24HR3D!

Reminder: The North Texas SQL Server User Group meeting is day after tomorrow, Thursday 9/17.  We may, just may, have some prototype MidnightDBA shirts to give away!.  Geoff Hiten will give a talk titled Bad SQL – Why Does This "Perfectly Good" T-SQL Run So Slow?  You all the info is on the NTSSUG site, but I'll give it here too anyway:

The North Texas SQL Server User Group meets on the third Thursday of every month, at the Microsoft Facilities located in Las Colinas (address below)

The typical meeting schedule is as follows:

6:30 – 7:15 – General Q&A session & Announcements & Food
7:15 – 8:30 – Presentation(s)
8:30 – 8:45 – Door prizes and Question & Answer session

Location: 7000 North Highway 161 Irving, Texas 75039 (See on Live Search Maps)

Microsoft is between Highway 114 and MacArthur Boulevard in Irving (Las Colinas), on Highway 161. The easiest way to get to there is to take the outer access road for Highway 161 North and exit into the Microsoft parking lot. It is the first building you will see once you exit. We'll be in the first building, LC-1.

Please park in the front of the building that faces Highway 161. Enter the front of the building and sign-in at the front desk.

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

 

How did I get involved with this SQL Server thing?

I'm seeing this question all over SQL Server blogs, and I know you've all been too shy to ask, so I'll tell you 😉

In college I landed a paid internship at FedEx that I managed to keep for 3 years, and then turn into a permanent position after graduation.  Among the toying around with web pages, Windows installations, programming and scripting, I had a small project to insert and update data to an Oracle database.  I had only the vaguest understanding of what a database was, and no idea of how complicated the whole field was, until then friend Sean McCown started giving me material and encouragement to switch fields. My work at FedEx was stagnating, so I jumped in with both feet.  SQL 6.5 whitepapers, Windows resource kits, surfing technet, exploring BOL…I look back on my days of study with quite a lot of fondness. I guess I just liked databases better than anything I'd done up until then, plus I had the internet to look up answers – widespread internet usage was really a college era thing for me – and I had the mentors to make things make sense.  I landed a job with Brinks as a DBA in the early 2000s.

It was GREAT…I'd gotten a huge pay raise by switching jobs, and I was able to dig into performance tuning and monitoring, backup solutions, clustering architecture and hardware specs in the first few weeks.  I was a star with the developers, who'd been largely sequestered from the DB team, and pleased management enough to be sent to BI training.  Not to speak ill of jobs deceased, but I left when politics made it easier to find a new job rather than to stay.

I next joined a very small team at InfoIntegration, in a very fashionable office in Dallas, and spent a large part of my work day deep in DTS.  Hey, remember DTS?  Setting environment variables, adding multiple database connections, ordering all your icons so the whole thing looked pretty?  Ahhh, good times, good times.  But I only stayed there a few months before project funding ran out.  It was hard for my manager to say, sorry, we just can't pay you any more, but I had no hard feelings.  Besides, the next gig I landed was like winning the lottery. 

I interviewed with Microsoft in Irving and started in the SQL Server phone support queues.  Oh, heaven!  It's a great campus, a great setup, and a great team.  I got six weeks of SQL training, answered questions and worked people through the most common and farfetched problems. I got to work under and next to SQL demigods.  I was three cubes down from Ken Henderson, for dog's sake.  Interesting tangent: I might never have actually spoken to him, but Sean was a big fan, and asked me to get his autograph on Ken's Internals book.  Specifically, Sean told me to ask him to write "Sean, thanks for last night."  Ken actually laughed, and wrote it.  They became friends after that.

Back to me.  We timed the end of my Microsoft contract to coincide with the end of my first pregnancy, and I stayed home with the babies for a few years.  In that time I kept up the studies, motivated by the occasional SQL or web contract. And this year I'm back in the official workforce, at Amerisource Bergen.  I'm getting some really solid development work, and SSIS, and all of my favorite things.

That's the story so far.  Wasn't that great?  Hello? 

Always like to keep my audience riveted.

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