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?
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put these posts together, I should throw my post in the ring. Especially since today is Thanksgiving and my food coma is starting to dissipate. It only took the second leftover plate to reach the current … Continue reading What Am I Thankful For
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
About this time last year, Digineer had an internal event where we could share messages of thanks. These messages were all gathered up and shared between all of us in our weekly newsletter. I plan to participate again this year but was going to put it out as a blog post. Since I am going … Continue reading What are you thankful for?
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
Strate SQL 