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
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft Certified Master (MCM) Program. The MCM program is Microsoft’s upper tier database administration certification. It is aimed at providing a validation of skills and knowledge for those with 5 or more years experience with SQL … Continue reading The SQL Server MCM Training Has Changed
Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am pretty pumped that my series won. When I originally envisioned the posts, I was just hoping to put together some sample code that I could use to understand how sys.dm_db_index_operational_stats functioned. And, obviously, others were … Continue reading SQLServerPedia Awards Winner
The PASS Summit is complete and we got what we asked for from David Dewitt. He spoke on the third day of the PASS Summit and received quite the applause when his presentation ended. David Dewitt came to us at the request of the community. When he was mentioned at an MVP meeting on there … Continue reading David Dewitt at the PASS Summit
Final post for the countdown – a little later in the week than I wanted. Right now there is less than 1-week until the PASS Summit. There’ve been a few posts over the last few weeks on the upcoming summit (1 , 2 , 3 , 4, 5, 6). These have also been aimed at … Continue reading 1-Week to PASS Summit 2010 – After Hours
I thought this week was going to be pretty low key. SQL Saturday 58 has wrapped up. The PASS Summit Ask the Experts scheduling is completed. But it never plays out that way… And this is a good thing. A few of my blog posts have been nominated for the SQLServerPedia Awards. The nice thing … Continue reading SQLServerPedia Award Nomination
Time for another T-SQL Tuesday and this time I'll finish my entry in time. This month we are talking about why DBA skills are necessary. Definitely a topic right up my alley since I've been having discussions along these lines with peers and co-workers for some time now. a.k.a. What You Don't Know Can Hurt … Continue reading Why are DBA skills necessary? #TSQL2sDay
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country from Orlando to San Diego to Minnesota. At many of these events there are shirts given away to speakers and/or the attendees. PASS Fashion I was thinking about this and wondering what I should wear … Continue reading “Wear Your SQL Saturday Shirt Day”
Strate SQL 