How-To: Common Data Patterns with LINQ to SQL
http://blog.jemm.net/articles/databases/how-to-common-data-patterns-with-linq-to-sql/

Frequently Asked Questions (LINQ to SQL)
http://msdn2.microsoft.com/en-us/library/bb386929.aspx

http://www.infoq.com/news/2008/01/sqlite-in-three-minutes

Using XQuery to Manage XML with SQL Server 2005
http://www.informit.com/articles/article.aspx?p=468058

XQuery 1.0: An XML Query Language
http://www.w3.org/TR/xquery/

XML Support in Microsoft SQL Server 2005
http://msdn2.microsoft.com/en-us/library/ms345117.aspx

Performance Optimizations for the XML Data Type in SQL Server 2005
http://technet.microsoft.com/en-us/library/ms345118.aspx

Business Intelligence Platforms, 2008   http://mediaproducts.gartner.com/reprints/microsoft/vol7/article3/article3.html

Gartner Magick Quadrante =;-0  http://www.valleyofthegeeks.com/News/GartnerQuadrant.html

Another great post by Rick Strahl
An easier Table Design View in Sql Server Management Studio

This tool proved to be pretty handy -->
http://www.codeproject.com/KB/database/DataMigrationApplication.aspx

http://www.exforsys.com/tutorials/sql-server-2005/maintaining-sql-server-indexes.html

An Overview of XML Support in SQL Server 2005
http://www.15seconds.com/issue/050803.htm

Improving XML Data Access Performance with SQL Server 2005
http://www.15seconds.com/issue/050811.htm

Improving XML Update Performance with SQL Server 2005
http://www.15seconds.com/issue/050818.htm

http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

http://www.setfocus.com/TechnicalArticles/sql-server-2005-tsql-3.aspx

http://geekswithblogs.net/lorint/archive/2006/08/04/87166.aspx

USE AdventureWorks;
GO
-- Passing values as constants.
EXEC dbo.uspGetWhereUsedProductID 819, '20050225';
GO
-- Passing values as variables.
DECLARE @ProductID int, @CheckDate datetime;
SET @ProductID = 819;
SET @CheckDate = '20050225';
EXEC dbo.uspGetWhereUsedProductID @ProductID, @CheckDate;
GO
-- Try to use a function as a parameter value.
-- This produces an error message.
EXEC dbo.uspGetWhereUsedProductID 819, GETDATE();
GO
-- Passing the function value as a variable.
DECLARE @CheckDate datetime;
SET @CheckDate = GETDATE();
EXEC dbo.uspGetWhereUsedProductID 819, @CheckDate;
GO

http://msdn2.microsoft.com/en-us/library/ms189915.aspx

http://www.w3schools.com/sql/sql_select_into.asp

http://www.msdner.com/dev-archive/84/19-85-847101.shtm

SELECT
Cast(a.XML_Data as XML) as XML_Data
FROM
OPENQUERY([LINKED SERVER NAME HERE],'
SELECT
Cast(XML_Data as Varchar) as XML_Data
FROM
[DATABASE NAME].[SCHEMA].[TABLE NAME]'
) A

Basically, the data is queried on the remote server, converts the XML data to a varchar, sends the data to the requesting server and then reconverts it back to XML.

StephenDudzic at 2007-9-3 22:09:22 >

"Re: XML data type not supported in Distributed Queries This is a limitation in SQL Server 2005. Columns of xml type or CLR type cannot be queried directly or referenced from one server to another - this means the following:

1. You cannot use a table or view that contains xml or clr type as 4-part name in your query
2. You need to cast the column to either nvarchar(max) or varbinary(max) or other appropriate type to use
3. If you have a table that has xml type for example then you need to create a view that contains all columns other than xml and query it instead. Or you can issue a pass-through query using OPENQUERY with the appropriate columns only."

http://blogs.msdn.com/raulga/archive/2006/03/11/549754.aspx

http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx

http://www.codeproject.com/vb/net/SQLAgent.asp

http://codeplex.com/SqlServerSamples

http://msdn2.microsoft.com/en-us/library/ms141767.aspx

http://www.simple-talk.com/sql/sql-server-2005/practical-sql-server-2005-clr-assemblies/

http://www.microsoft.com/technet/prodtechnol/sql/2005/impprfiv.mspx

http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server/2/

CREATE TRIGGER trig_updateAuthor
ON authors
FOR UPDATE 

AS

DECLARE @oldName VARCHAR(100)
DECLARE @newName VARCHAR(100)

IF NOT UPDATE(au_fName) AND NOT UPDATE(au_lName)
BEGIN
   RETURN 
END

SELECT @oldName = (SELECT au_fName + ' ' + au_lName FROM Deleted)
SELECT @newName = (SELECT au_fName + ' ' + au_lName FROM Inserted)

PRINT 'Name changed from "' + @oldName + '" to "' + @newName + '"'

http://technet.microsoft.com/en-us/library/ms345144.aspx

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1474613&SiteID=17

http://www.databaseanswers.org/data_models/

http://www.devx.com/dbzone/Article/21410/1954?pf=true

WITH cteStatusCounts(FormsCount, SubjectID,StatusCodeID)
AS
(
    SELECT     COUNT(FormID) AS FormsCount, SubjectID,StatusCodeID
    FROM         tblFeedbackForms
    Where SubjectAreaID=2
    GROUP BY SubjectID,StatusCodeID
)

SELECT
    FormsPivot.SubjectID as KeyID,
    stTotalIncoming=ISNULL([1]+[2]+[3]+[4],0),
    stOpen=ISNULL([1], 0),
    stMoreInfo=ISNULL([2], 0),
    stWithdrawn=ISNULL([3], 0),
    stCoached=ISNULL([4], 0)
FROM
    cteStatusCounts
PIVOT(sum(FormsCount) FOR StatusCodeID in([1],[2],[3],[4])) as FormsPivot
Order by FormsPivot.SubjectID

http://vyaskn.tripod.com/code.htm#inserts