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
Latest
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
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
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