|
|
-
|
|
This installment of XQuery Labs presents a script that reads information from an RDF document using TSQL and XQuery.
One of my friends approached me recently with a request to write a TSQL query that reads information from an RDF document. Here is the sample XML document he wanted to process.
......
|
|
-
|
|
My favorite author Brad Schulz comes up with another master piece TSQL fiction. I never thought reading too much TSQL code demonstrating different syntaxes and usage patterns will ever be fun. There is certainly something to learn from some one with more than 30 years of database experience. http:......
|
|
-
|
|
One of the questions that I always hear in the forums is about moving data in and out of a SQL Azure database. People who intend to move their existing applications to SQL Azure need to find a way to load their existing data into SQL Azure databases. Since the current version of SQL Azure does not s......
|
|
-
|
|
I was asked this question in one of the SQL Server forums recently. The OP wanted to generate an XML document with CDATA sections and NAMESPACE declarations. SQL Server 2005 introduced WITH XMLNAMESPACES() which is very handy to generate namespace declarations in the output XML document generated b......
|
|
-
|
|
Brent Ozar comes up with a very interesting blog post that lists a collection of SQL Azure frequently asked questions. A recommended read for SQL Azure enthusiasts. Read the post: http://www.brentozar.com/archive/2010/01/sql-azure-frequently-asked-questions/......
|
|
-
|
|
This follow-on video expands on what was set up in part 1 to use the Microsoft Sync Framework libraries and providers from .Net code. This allows to embed the synchronisation capabilities into applications and hook into the various available events. Watch the Video: http://msdn.microsoft.com/en-us/......
|
|
-
|
|
This is the second part of my interview with Microsoft Technology Evangelist, Vinod Kumar. You can find the first part of this interview at here.
Jacob: Could you briefly explain "SQL Server Data Services"?
Vinod: Microsoft SQL Data Services (SDS), formerly known as SQL Server Data......
|
|
-
|
|
Another great video by Hilton Giesenow which shows us how to set up a powerful and easy-to-use synchronization model between a local Microsoft SQL Server database and a Microsoft SQL Azure database with the Microsoft Sync Framework tools for SQL Azure. View the Video: http://msdn.microsoft.com/en-u......
|
|
-
|
|
I will be doing a webcast on error handling in SQL Server for PASS Application Development Virtual Chapter on 26 January 2010. You can find the session schedule and registration link at http://appdev.sqlpass.org/ This will be the ‘virtual’ version of the session “Best Practices for Exception ......
|
|
-
|
|
I was eagerly waiting to look at the session evaluation data after my presentation at PASS 2009 Summit (Seattle, WA) in November 2009. I had written a detailed post sharing my experience at PASS 2009 some time back. You can find the post here: http://beyondrelational.com/blogs/jacob/archive/2009/11/......
|
|