Michael David discusses how XQuery was designed from the ground up to process hierarchical XML data, but it is still missing capabilities that a hierarchical query processor product should have and did have originally.
2008-07-14
2,422 reads
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
86 reads
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
63 reads
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
58 reads
Are you aware that SQL Server 2005 can have up to ten services running? Working with that many service accounts can be a challenge. Steve Jones takes a look at these services and a few of the things that you will want to know before setting up SQL Server 2005.
2008-07-11 (first published: 2006-03-23)
50,579 reads
This article is about using VBscript hacks to overcome two limitations of DTS packages.
2008-07-11
9,681 reads
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
2008-07-11
2,077 reads
The Microsoft Jet 4.0 relational database engine utilizes character sorting tables when creating and querying field indexes made up of character data. Two Microsoft Windows APIs are generally utilized for this functionality:
2008-07-11
3,944 reads
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-11
219 reads
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
2008-07-11
220 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers