|
|
-
|
|
Microsoft announced the release of SQL Server 2008 R2 (Release to manufacturing) today (21st April 2010). See the official announcement here. The key enhancements Microsoft emphasized in the release note are: Managed self-service business intelligence (BI) for reporting and analysis Enterp......
|
|
-
|
|
In the previous workshop we examined the usage of FOR XML AUTO. Today, we will examine FOR XML RAW, which is a bit more powerful when it comes to customizing the structure of XML output. Let us start with looking into the differences between the two.
To run the examples in this post, you need to......
|
|
-
|
|
Introducing Microsoft SQL Server 2008 R2 is a 10 chapter, 216 page book writtenby Ross Mistry and Stacia Misner. Microsoft has made it available as a free ebook. You can download the ebook in XPS format here and in PDF format here.......
|
|
-
|
|
The PASS European Conference 2010 is just a week away and it is time for me to start packing my stuff so that I don’t have to run at the last hour. Every PASS conference I attended have significantly contributed in enhancing my SQL Server skills. PASS Summit is not only for attending the presen......
|
|
-
|
|
One of the challenges I always faced when working on an environment with database mirroring is managing the SQL Server jobs on the principal and mirror server. It was always a head-ache enabling and disabling the jobs on the SQL Server instances that host the principal and mirror databases. Just ca......
|
|
-
|
|
Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element. Here is the input data for this challenge.
abc
Some Value
SKU,AlphaNumeric......
|
|
-
|
|
An XML document can be generated from the result of a SQL Server relational query using FOR XML. FOR XML can be used along with AUTO, RAW, PATH or EXPLICIT directives which offer different levels of control over the structure of the XML output. Out of the four directives that can be used with......
|
|
-
|
|
Here is an interesting XQuery requirement that one of my friends sent me. The challenge is to modify an XML document stored in an XML column as part of a SELECT query. Here is a simplified representation of the problem. Take a look at the source data before we proceed with the query. id d......
|
|
-
|
|
One of my friends recently sent me the following XML fragment and asked me if I can help writing a query to pull the information out of the XML document.
8134
16
<frame level='1'
handle='0x010007007845CB27D81B4308000000000000000......
|
|
-
|
|
Configuring a software feature is usually much harder than removing it. Most of the times, removing a feature could be just a matter of a mouse click or a simple command/statement. So what do you think about this question? Enabling FILESTREAM storage on a database and removing it completely from a ......
|
|