If you're reading this, it must be Monday morning. Oh dear, that means I am officially starting my public studying for the Microsoft Certified Master (MCM) exam. I've already failed this exam once and am not really up for failing again. To help prevent this, I figured studying through my blog and noting the things … Continue reading MCM Live Blog – Week December 13
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in town. It’s SQLRally! This is a 3-day conference that will occur in Orlando, FL. Instead of the typical unlimited number of seats that accompanies the PASS Summit, SQL Rally will be capped at 500 people. … Continue reading SQLRally Call for Presenters
Protect Your Password!As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password practices of others. One of the most shocking things I’ve come to discover is how loose people are with their passwords. At times, I am even included in this group. Over the past two years, I’ve … Continue reading Do You Protect Your Passwords?
Learning XQuery can be a pain. There are a lot of different uses for XML and different languages implement it in many different fashions. To help clear the air a bit, I wrote a number of posts on XQuery; which this post is a part of. Now that I’ve posted my initial posts on what … Continue reading XQuery for the Non-Expert – Resources
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the previous post, I discussed the value() method as part of my XQuery for the Non-Expert series. This next post will deal with a topic similar to the exist() method – the determination of whether a element … Continue reading XQuery for the Non-Expert – Exist
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the query() method in my XQuery for the Non-Expert series. With this next post, we’ll be working on taking data out of the XML fragments and placing them into columns with the … Continue reading XQuery for the Non-Expert – Value
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed the nodes() method in my XQuery for the Non-Expert series. With this next post, we’ll be looking into the query() method. The main use for the query() method is to retrieve child … Continue reading XQuery for the Non-Expert – Query
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. In the last post, I discussed XMLNAMESPACES in the XQuery for the Non-Expert series. With this post, we’ll be looking into the nodes() method. Where XMLNAMESPACES is the map through the XML document, the nodes() method is the … Continue reading XQuery for the Non-Expert – Nodes
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. Let’s talk about XMLNAMESPACE. Are you excited? Does your skin crawl with excitement – or rather unease at the thought of leveraging this T-SQL clause? The goal here is to make XQuery and it’s functions and clauses easier … Continue reading XQuery for the Non-Expert – XMLNAMESPACE
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post. It’s time for a new series to blog posts – XQuery for the Non-Expert. The purpose for these posts will be to provide a foundation for using XQuery against XML. Myself, I am not an XQuery expert. These … Continue reading XQuery for the Non-Expert – Terminology
Strate SQL 