Using SQL Server Joins: Inner, Outer, Cross, Self Join Statements

Using SQL Server Joins: Inner, Outer, Cross, Self Join Statements http://technet.microsoft.com/en-us/library/ms191472%28v=sql.105%29.aspx

Subquery Fundamentals http://technet.microsoft.com/en-us/library/ms189575%28v=sql.105%29.aspx

SQL Server Join Example http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/

How to use Cursor in Sql Server?

DECLARE CURSOR (Transact-SQL) http://technet.microsoft.com/en-us/library/ms180169.aspx

How to use Cursor in Sql http://www.codeproject.com/Tips/277847/How-to-use-Cursor-in-Sql

SQL Server Cursor Example http://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/

Pivot tables

Pivot tables in SQL Server. A simple sample. http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx

Using PIVOT and UNPIVOT http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Simple Way To Use Pivot In SQL Query http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

Working with Data-tier Application projects in Visual Studio 2010

From Channel 9: “Working with Data-tier Application projects in Visual Studio 2010”

“This demonstration shows the database-developer related enhancements in Visual Studio 2010 and introduces the concept of a data-tier application project. It shows how to issue T-SQL commands directly from within Visual Studio and how to work with graphical execution plans.” reference: http://channel9.msdn.com/Learn/Courses/SQL2008R2TrainingKit/SQL10R2UPD04/SQL10R2UPD04_DEMO_03

Database […]

About Sql Server VSS Service

The Basics of the Volume Shadow Copy Service (VSS), by Jose Barreto 10 Oct 2007 9:32 PM How to Disable the SQL Server VSS Writer Service, By Jon Guenther, September 6, 2010 SQL Writer Service, SQL Server 2008 R2, MSDN reference […]

Ms Sql Compact Edition Tools

SQL Server Compact Toolbox http://sqlcetoolbox.codeplex.com/ SQL Compact data and schema script utility http://exportsqlce.codeplex.com/ for more, check:

http://www.codeplex.com/site/search?query=SQL%20Server%20Mobile%20or%20Compact&ac=8

More tools available as commercial products Data Port Console Data Port Wizard http://www.primeworks-mobile.com/ […]

Sql Server Editions and Comparison

Sql Server 2005 Editions Comparison

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

 

Sql Server 2008 Editions Comparison

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

 

Compare Editions–Compact and Express for 2008

http://www.microsoft.com/sqlserver/2008/en/us/compare-specialized.aspx

 

Entity Framework can be used with Sql Server CE !

http://blogs.msdn.com/sqlservercompact/archive/2008/03/07/my-first-entity-application-against-sqlce.aspx

 

 

SQL Express v LocalDB v SQL Compact Edition https://blogs.msdn.microsoft.com/jerrynixon/2012/02/26/sql-express-v-localdb-v-sql-compact-edition/

 

 

 

[…]

xml bulk import to sql server

How to import XML into SQL Server with the XML Bulk Load component, using SQLXMLBulkLoad.SQLXMLBulkLoad Using SQLXML Bulk Load in the .NET Environment XML Bulk Load Examples (SQLXML 4.0)

Playing with Vertial and Horizontal Tables

Pivot Transformation SQL Server 2005 Integration Services – Part 38 – Pivot Transformation Horizontal vs. Vertical Database Design Using PIVOT and UNPIVOT

[…]

About SqlCacheDependancy, Personalization, and Sql’s Xml DataType

Dependant Cache to Sql Server Using SqlDependency in a Windows Application ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe) Enabling Query Notifications Using Query Notifications MSDN forum thread about sqlCacheDependancy Personalization Info [How Do I:] Utilize Web Parts and Personalization? WebPart.AuthorizationFilter Property How To get Web Parts to work with SQL Server 2005 (not Express) Sql Server […]