Jacob's Blog

	Home Contact RSS for Posts

Recent Blog Posts

• SQL Server - Server-side paging with Row_number() function
• Tips and Tricks for Error Handling in ASP.NET Web Applications
• SQL Server FILESTREAM feature and Differential Backups
• Getting started with PIVOT Queries in SQL Server 2005...
• How to load a huge file into a FILESTREAM column quickly
• Backup of a FILESTREAM database may include garbage...
• Support for Paging Queries in SQL Server CE 4.0
• XQuery Lab 62 – Revisiting simple TSQL SELECT operations...
• XQuery Lab 61 – Writing a Recursive CTE to process...
• XQuery Lab 60 – Executing dynamic query strings with...

Most Viewed

• XQuery Labs - A Collection of XQuery Sample Scripts (16,892)
• My Latest Book: “The Art of XSD - SQL Server XML Schema... (6,484)
• XQuery Lab 58 - SELECT * FROM XML (5,688)
• XML Workshops (5,427)
• Converting VARBINARY to VARCHAR using FOR XML (4,394)
• SQL Server - How do I Insert an explicit value into... (4,242)
• FOR XML EXPLICIT Tutorial – Part 4 (3,540)
• FOR XML EXPLICIT Tutorial- Part 1 (3,253)
• FOR XML Tutorials (2,995)
• XQuery Lab 48 - Sorting Query files in SQL Server Management... (2,476)

Archive

• August 2010 (5)
• July 2010 (3)
• June 2010 (9)
• May 2010 (3)
• April 2010 (5)
• March 2010 (5)
• February 2010 (4)
• January 2010 (4)
• December 2009 (3)
• November 2009 (1)
• October 2009 (4)
• September 2009 (4)
• August 2009 (14)
• July 2009 (2)
• June 2009 (15)
• May 2009 (7)
• April 2009 (1)
• March 2009 (10)
• February 2009 (8)
• January 2009 (15)
• December 2008 (1)
• November 2008 (3)
• October 2008 (14)
• September 2008 (32)
• August 2008 (30)
• July 2008 (15)
• June 2008 (6)
• January 2008 (4)
• December 2007 (6)
• November 2007 (2)
• October 2007 (1)
• June 2007 (1)
• January 2007 (1)
• October 2006 (1)
• July 2006 (1)