career development
What Do You Know About Our Company?
Continuing my series on tough interview questions, I'd like to cover one that can really set you apart from the crowd. This one is testing you on how much
Latest
SQL301
SQL 301-FOR XML EXPLICIT
OK, so far I've covered FOR XML RAW. It's a pretty simple way to crank out some XML when you need to. FOR XML AUTO has better support for hierarchies, but it
Moving a Company Out of the Closet: Our First Azure Migration
The server room at this particular client's office was a repurposed coat closet behind the receptionist's desk. I know this because I could see the old coat hooks through the cable runs. The server — singular — sat on a wire shelf next to a UPS that beeped
SQL301
SQL 301-FOR XML AUTO
In my previous XML article, I covered FOR XML RAW. It's useful, if limited. This time I'd like to cover XML AUTO. It's still limited, but if you're looking to
career development
Tell Me About Yourself
I'm going to take the next couple posts and cover some of the interview questions people have told me they struggle with the most during an interview. I want to
SQL301
SQL 301-FOR XML RAW
OK, I need to study my XML queries, so I'm going to write them up as I go. That way you can learn along with me. In a normal query we return the results in
Certification
My First Attempt at the 70-433
A couple weeks back I made my first attempt at the 70-433 SQL 2008 Database Developer exam. I was nervous, it was obvious to me and to those who know me best.
career development
Dating and Job Seeking
There's two things I've noticed about the job search right now. If you're employed your more desired than if you're single unemployed. If you're desperate,
etl
SQL 301-BIDS, The First time around
In my last post, we used the Import and Export wizard to create a simple Load process. We loaded names.csv into a simple table. Let's open Visual Studio 2008
SQL301
SQL 301 — SSIS Import And Export Wizard
OK, let's dive right into the Import and Export Wizard. If you're on Vista or Windows 7, hit start, then begin typing "Import and Export Data" It should find
career development
Persuasion and The Interview
Persuasion is an art. But it's an art form that can make your interview go completely differently. Getting the job is always a bout convincing the hiring
SQL301
SQL 301 – Introduction to SSIS
I've been getting requests to cover SSIS, so here we go. Over the next few months I'm going to give you a course that will help you go from knowing what SSIS