LINQ Reference Documentation

http://blogs.msdn.com/charlie/archive/2008/11/23/linq-reference-documentation.aspx

The LINQ documentation created by Microsoft is available both inside Visual Studio, and for free via the MSDN library found on the WEB. Here are some important pages from that documentation that can help you navigate through the online reference material that Microsoft has prepared for LINQ developers:

· The Root MSDN Library Page: http://msdn.microsoft.com/en-us/library/default.aspx

· .NET Development: http://msdn.microsoft.com/en-us/library/aa139615.aspx

· .NET Framework 3.5: http://msdn.microsoft.com/en-us/library/w0×726c2.aspx

· System.Linq: http://msdn.microsoft.com/en-us/library/system.linq.aspx

· System.Data.Linq: http://msdn.microsoft.com/en-us/library/system.data.linq.aspx

· System.Xml.Linq: http://msdn.microsoft.com/en-us/library/system.xml.linq.aspx

· Code Generation: http://msdn.microsoft.com/en-us/library/bb399400.aspx

· More on Joins: http://msdn.microsoft.com/en-us/library/bb311040.aspx

· For more information on the operators, see the section of the online help called “The .NET Standard Query Operators.” It is written by Anders Hejlsberg and Mads Torgersen. The URL is http://msdn.microsoft.com/en-us/library/bb394939.aspx

I would not suggest using these references materials as a primary means of learning LINQ. However, if you have a book or other guide to LINQ development, then this reference material can be a useful addendum to that text. If you understand in a general way how LINQ works, but need answers to detailed questions, the links provided here may sometimes help you find answers.

Journey to SQL Authority with Pinal Dave – Notes of a SQL Server MVP and Database Administrator

http://blog.sqlauthority.com/

John DaCosta’s SQL & Technology Weblog

http://dacosta9.wordpress.com/

SQL SERVER HELP

http://sqlhelp.wordpress.com/

http://sqlhelp.wordpress.com/2008/12/01/sql-server-settings-optimization-tips/

How to activate xp_cmdshell for SQL Server 2005

http://shakalakababy.wordpress.com/2008/12/01/how-to-activate-xp_cmdshell-for-sql-server-2005/

General Information:
With the aid of xp_cmdshell it is possible to execute programs within SQL Server Scripts. First of all it is necessary to create a Windows or a Domain User account with the permissions to execute the desired programs. In this tutorial i want to give you a concrete example how to activate this sqlserver function.

Step 1: Switch to ‘master’ Database
USE master
GO

Step 2: Enable the advanced options of the SQL Server
EXEC master.dbo.sp_configure ’show advanced options’, 1
RECONFIGURE

Step 3: Enable xp_cmdshell
EXEC master.dbo.sp_configure ‘xp_cmdshell’, 1
RECONFIGURE

Step 4: Assign the proxy account for xp_cmdshell – the proxy account is used to execute the programs
EXEC master.dbo.sp_xp_cmdshell_proxy_account ‘Domain\User’, ‘password’

Step 5: Grant the right to xp_cmdshell for SQL User Login
GRANT EXECUTE ON master.dbo.xp_cmdshell TO [SQL_USER]

There is also an alternative way to activate xp_cmdshell with the Tool: SQL Server Surface Area Configuration.

Cumulative update package 5 for SQL Server 2005 Service Pack 2

http://support.microsoft.com/kb/943656/