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

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

Subquery Fundamentals

SQL Server Join Example

How to use Cursor in Sql Server?


How to use Cursor in Sql

SQL Server Cursor Example

Pivot tables

Pivot tables in SQL Server. A simple sample.


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:

Database […]

Entity Framework / Core

From Start to Finish: ASP.NET Core, Entity Framework Core and Visual Studio Code Code-First Development with Entity Framework 4 (huge tutorial about Entity Framework 4) Entity Framework 4.0 – How To POCO Getting Started Entity Framework – MS Quickstart Tutorial ms tutorial – Model-First in the Entity Framework 4 Microsoft […]

sql server 2008 management studio says “Saving changes is not permitted…”

Sql Server 2008 Management Studio “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.” Tools > Options dialog box […]

Ms Sql Compact Edition Tools

SQL Server Compact Toolbox SQL Compact data and schema script utility for more, check:

More tools available as commercial products Data Port Console Data Port Wizard […]

Sql Server Editions and Comparison

Sql Server 2005 Editions Comparison


Sql Server 2008 Editions Comparison


Compare Editions–Compact and Express for 2008


Entity Framework can be used with Sql Server CE !



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