Click here to Skip to main content

Submit your article

SQL Server 2012

SQL-Server-2012

Great Reads

Executing Stored Procedure with User Defined Table Type Parameter in Entity Framework Using EntityFrameworkExtras

by AshishShukla6

This tip describes step by step implementation of executing stored procedure having user-defined table type as a parameter in entity framework using EntityFrameworkExtras package.

Reset SQL Server SA (System Admin) Password

by Sarathi Balakrishnan

Reset SQL server SA (System Admin) Password when you have lost all possible ways to connect to SQL server and your server has only Windows authentication disabled. You should have Windows administrator permission to do this.

FOR XML Basics (AUTO Mode): 2 of 4

by AhsanAhmed

A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

Latest Articles

SQL Server: Find Table Order/Generation And Relation Details

by DiponRoy

A utility query to find table generations in SQL Server relational database

SQL Server: Doing String Split And Join

by DiponRoy

How to do string split and join in SQL Server

Streamline Log Shipping Failovers

by Micah Nikkel

SQL script that dynamically generates the DR scripts for failing over/back all Log Shipped databases. While it makes even a single database failover/failback a more streamlined process, it's most helpful for servers with multiple databases, such as SharePoint, consolidated SQL Servers, etc.

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

All Articles

SQL Server 2012

Generate insert Statements from a Specific Table Data using SQL Server

27 May 2013 by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

SQL-Server-2008

SQL-Server-2005

Using Stored Procedures in Entity Framework Model First Approach (Part I - Adding New Stored Procedure)

15 Apr 2014 by SRS(The Coder)

How to use Stored Procedures in Entity Framework Model First Approach

SQL-Server-2008R2

SQL-Server-2012

No More Stray User Tables in Master

19 Jul 2014 by Tim Golisch

The Master database often seems to be the "Lost & Found" bin of the SQL Server world. There are two popular ways for preventing this kind of problem. Read on...

SQL-Server-2012

SQL-Server-2008R2

Counting Consecutive Dates Using SQL

17 Feb 2013 by Tharaka MTR

How to count consecutive dates using SQL

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

9 Jan 2013 by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

SQL-Server-2008

SQL-Server-2012

Get Ready to Learn SQL: 6. How to Group and Summarize your Results

23 Oct 2014 by essentialSQL

How to Group and Summarize your Results in SQL

SQL-Server-2012

Get Ready to Learn SQL: 5. Query Results Using Pattern Matching

23 Oct 2014 by essentialSQL

Query Results Using Pattern Matching in SQL

SQL-Server-2012

Getting Started With SQL Server: 2. Sort Your Query Results

24 Oct 2014 by essentialSQL

How to sort your query results in SQL Server

SQL-Server-2012

Get Ready to Learn SQL Server: 17. How to Use the Intersect Operator

31 Oct 2014 by essentialSQL

How to use the Intersect Operator in SQL Server

SQL-Server-2012

Get Ready to Learn SQL Server 19: Introduction to Sub Queries

4 Feb 2015 by essentialSQL

The purpose of this article is to introduce you to subqueries and some of their high-level concepts. There are a lot of details to cover in order to learn sub queries, but you’ll see we cover those in depth in later articles.

SQL-Server-2014

SQL-Server-2012

Using SQL Server’s Registered Servers Functionality Effectively

16 Jun 2015 by Mohit1110

Using SQL Server’s Registered Servers Functionality Effectively

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

SQL Server: Controlling SQL Server Log Information

15 Sep 2012 by aasim abdullah

How to control SQL Server Log Information

SQL-Server-2008

SQL-Server-2012

SQL-Server-2005

Book Review: Reporting with Microsoft SQL Server 2012

16 Jun 2014 by Sampath Lokuge

The book is Reporting with Microsoft SQL Server 2012.

SQL-Server-2012

How to use recursive CTE calls in T-SQL

15 Nov 2013 by Johan Ohlin

How to use recursive CTE calls in T-SQL.

SQL-Server-2012

How Do I Use SQL Server to Sort Alphanumeric Values?

14 Nov 2014 by essentialSQL

Sort Alphanumeric Values with SQL Server

SQL-Server-2012

Generic Repository Pattern MVC

29 Apr 2016 by Mayur V Lohite

Generic Repository Pattern MVC

SQL-Server-2005

SQL-server-2000

Get Ready to Learn SQL Server: 4. Query Results Using Boolean Logic

24 Oct 2014 by essentialSQL

Learn more about filtering results returned from your queries using the WHERE clause

SQL-Server-2012

Get Ready To Learn SQL Server: 3. How to Filter Your Query Results

24 Oct 2014 by essentialSQL

In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.

SQL-Server-2012

Getting Started with SQL Server: 1. Simple SELECT Queries

25 Oct 2014 by essentialSQL

Simple SELECT queries in SQL Server

SQL-Server-2012

Get Ready to Learn SQL Server: What is a Database NULL Value?

23 Oct 2014 by essentialSQL

What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing values. In SQL, this is solved with null. It is used to signify missing or unknown values. The keyword NULL is used to indicate these values.

SQL-Server-2012

Get Ready to Learn SQLServer: 18. How To Use the EXCEPT Operator

21 Dec 2014 by essentialSQL

How to use the Except Operator in SQLServer

SQL-Server-2012

Get Ready to Learn SQL Server: 5. Filter Results Using Patterns

29 Oct 2014 by essentialSQL

In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.

SQL-Server-2012

Contained Database – A New Feature in SQL SERVER 2012 TIP #81

26 Feb 2015 by Rajat-Indiandotnet

Contained Database–A new feature in SQL SERVER 2012 TIP #81

SQL-Server-2012

Group concatenation in T-SQL using CTE

15 Nov 2013 by Johan Ohlin

Group concatenation in T-SQL using CTE.

SQL-Server-2012

Error Occurs When CTE Alias is ‘RESULT’ - Incorrect Syntax Near 'RESULT'

3 Jun 2015 by Manjuke Fernando

Error occurs when CTE Alias is ‘RESULT’ - Incorrect syntax near 'RESULT'. Succeeds on some SQL Server databases but fails on others.

SQL-Server-2012

Execute SQL Query on Mutiple SQL Servers or Databases Simultaneously

2 Jun 2015 by Mohit1110

In this blog we would learn how to execute a SQL Query on multiple databases of single DB Server or on a single Database on multiple DB Servers.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

What is the Difference between GROUP BY and ORDER BY

23 Feb 2015 by essentialSQL

What is the difference between GROUP BY and ORDER BY

SQL-Server-2012