career development
70-451 Prep–SQL Server Agent
Well, now that I've passed the 70-433, I've moved on to preparing for the 70-451 PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server
Latest
SQL Azure vs SQL Server IaaS: Your First Big Azure Architectural Choice
When Azure went generally available, you suddenly had two ways to run SQL Server in Microsoft's cloud. They looked similar from the outside — both gave you a SQL Server endpoint you could connect to — but the architectural implications were completely different. Getting this choice wrong in 2011 cost
SQL201
SQL201-The Syllabus
It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be
career development
Tell me about your strengths
The next tough interview question I’ve often received is “What are your strengths?” As a knowledge worker you’ve got two ways to go here. You
SQL301
SQL301–XML VALUE Method
Last time, I covered the EXIST Method. This time around I wanted to show you how to pull out values from XML stored in SQL. Let's start with what should have
career development
Why Did You Leave Your Last Job?
Continuing with my series on tough interview questions, I'm going to take on one of the tougher ones. I've gotten a variation of this question at least once
SQL301
SQL 301-XML EXIST Method
And now it's time to wrap up the XML in SQL posts. At least, this is the last of the information you're required to know for the 70-433. Anything above and
microsoft sql
SQL 301-The XML Data Type
We’ve spent the last few posts working on getting relational data out of our tables and into XML format. Most of the time, that’s what I’ve used XML
career development
What Interests You About This Opening?
We're back to my series on tough interview questions. It's my hope that by covering these questions, you're able to put together a plan on how you'll respond
SQL301
SQL301-Nesting For XML Queries
Given the 4 options I've shown you for creating XML output from SQL, you should be able to create nearly any structure you'd want (especially considering FOR
SQL301
SQL 301–FOR XML PATH
OK, I've covered FOR XML RAW for simple quick XML outputs. Then I covered FOR XML AUTO, while it automatically handles simple hierarchical data, it's still
Certification
I’ve Passed the 70-433!
I wanted to write up a post about passing my exam, and share everything I learned during this process. I had considered drawing parallels between the