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
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server Microsoft Certified Master. Second, I failed said exam. While that might be a circumstance for pity, we should all be glad. Where’s the bar? First off, the exam is tough. Anyone that thought that the … Continue reading Cry, Baby, Cry! Failing the MCM Test
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
Since it's Sunday (almost Monday), I thought I would chip into Un-SQL Friday. Before I get down to brass tacks, an explanation is probably in order. Last week, Jen McCown (Blog | @midnightdba) suggested a new blog round table that has nothing to do with SQL Server but is adjacent to SQL Server. This month’s … Continue reading Un-SQL Friday 001: Branding
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
Strate SQL 