SQLRally Session Submissions

Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of those people submitting a session.  I’m not going to be a pot calling the kettle black. Below are the two sessions that I submitted.  Hopefully they will appeal to enough people that I’ll get a … Continue reading SQLRally Session Submissions

Last Call SQLRally Call for Presenters

Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the upcoming SQLRally! Some details if you are on the unawares – SQLRally is a 3-day SQL Server conference that will occur in Orlando, FL.  Unlike the PASS Summit, SQLRally will be capped to 500 people. … Continue reading Last Call SQLRally Call for Presenters

MCM Live Blog – Week December 13

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

SQLRally Call for Presenters

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

Do You Protect Your Passwords?

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?

XQuery for the Non-Expert – Resources

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

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

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

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