Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules (beta)
Getting Started with ASP.NET MVC - Part 6:
ASP.NET MVC and Entity Framework
First Time? You can support us by signing up. It takes only 5 seconds. Click
here
to sign up. If you already have an account, click here to
login
.
Loading
Jacob's Blog
Home
Contact
RSS for Posts
My technology blog on SQL Server, TSQL, XML, FILESTREAM and other areas of SQL Server.
Recent Blog Posts
XQuery Lab 65 – Restructuring an XML document using...
SQL Server book from Pinal Dave
XQuery Lab 64 – Reading values from an XML column
SQL Server–Partitioning FILESTREAM data with RANGE...
Getting started with SQL Server Wait Types
T-SQL Tuesday #016 - Summarizing data using GROUPING...
SQL Server – TSQL – Quiz 2011 is here, your chance...
Happy Birthday to TSQL Challenges and its younger sibling...
What is SQL Server Juneau?
What is SQL Server Crescent?
Most Viewed
XQuery Labs - A Collection of XQuery Sample Scripts
(43,615)
XML Workshops
(24,632)
SQL Server - How do I Insert an explicit value into...
(17,986)
XQuery Lab 58 - SELECT * FROM XML
(16,835)
Converting VARBINARY to VARCHAR using FOR XML
(16,547)
FOR XML EXPLICIT Tutorial – Part 4
(14,184)
My Latest Book: “The Art of XSD - SQL Server XML Schema...
(12,628)
SQL Server - Server-side paging with Row_number() function
(12,313)
FOR XML EXPLICIT Tutorial- Part 1
(11,478)
FOR XML Tutorials
(7,649)
Archive
December 2011 (1)
August 2011 (1)
July 2011 (1)
June 2011 (1)
March 2011 (3)
February 2011 (3)
January 2011 (2)
December 2010 (2)
November 2010 (4)
September 2010 (1)
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)
Having huge amounts of traffic can be a problem. Aside from the usual maintenance, you also need to check on the server load. Having a
virtual dedicated server hosting
can solve these problems.
March 2010 - Posts
XQuery Lab 54 – Modifying an XML document with a SELECT Query
This post explains how to modify an XML document from a SELECT query in TSQL...
by
Jacob Sebastian
on 03-31-2010 | 2,762 Views
XQuery Lab 53 – Reading information from SQL Server Extended Event Information XML
This installment of XQuery Labs explains how to read information from the XML document generated by SQL Server Extended Events....
by
Jacob Sebastian
on 03-23-2010 | 2,060 Views
Completely Removing FILESTREAM features from a SQL Server 2008 database
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...
by
Jacob Sebastian
on 03-11-2010 | 3,973 Views
SQL Server XML - Generating an RSS Feed with iTunes extension using TSQL
This article demonstrates how to generate an RSS 2.0 feed with iTunes extension using TSQL. It presents two version of the TSQL query, one using FOR XML PATH and the other FOR XML EXPLICIT. ...
by
Jacob Sebastian
on 03-08-2010 | 3,539 Views
What is the FILESTREAM access level on your server instance? Oh I have got a “3”
Excepts from a conversation between Sumit and Leena, that I overheard last week. Don’t know who they are?? Never mind, I will introduce them later! Leena : “Sumit, I am playing with the FILESTREAM access level and I am bit confused as I am getting a ...
by
Jacob Sebastian
on 03-02-2010 | 4,805 Views
Copyright © Beyondrelational.com