Click here to Skip to main content

Submit your article

SQL Server 2014

SQL-Server-2014

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.

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

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.

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 2014

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 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-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

Streamline Log Shipping Failovers

29 Aug 2018 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.

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL Server Disk Usage Statistics

24 Sep 2015 by Dr. Song Li

This is an example to check the SQL server disk and data file usage statistics.

SQL-Server-2014

FOR XML Basics (EXPLICIT Mode): 3 of 4

1 Jun 2017 by AhsanAhmed

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL-Server-2008

Synchronization between local and Azure SQL DB using SLQ Management Studio "Export Data..."

17 Mar 2015 by Sergey Kizyan

This article explains how to merge your local SQL DB content to Azure DB from scratch

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Amazon Web Services part 2 - Adding a database to your web site

24 Mar 2015 by Matt Perdeck

Add a database to your web site on AWS with automatic fail over using RDS

SQL-Server-2014

FOR XML Basics (RAW Mode): 1 of 4

2 Jun 2017 by AhsanAhmed

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

Retrieve/Update SQL Records based on Barcodes

26 Jun 2014 by Philipp Katscher

Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool

SQL-Server-2008R2

SQL-Server-2012

SQL Server: Detect Circular Relations In A Relational Database

4 Mar 2015 by DiponRoy

Table Hierarchy or Generation Finder For Relational Database In SQL Server

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Handling NULL in T-SQL

23 Jan 2017 by Bhim B Thapa

Handling NULL in T-SQL

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Another C# SQL class

1 Apr 2014 by formlesstree4

Another article on C# .NET SQL, but with smarts

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

How to check whether a measure group is mapped with the dimension group

4 May 2015 by Sibeesh Passion

This article shows how to check whether a Measure Group is mapped with the Dimension Group.

SQL-Server-2014

Building a Basic Test Data Generator for Books in SQL

13 Nov 2017 by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

ASP.NET MVC-5 CRUD Using AngularJS

23 Jan 2016 by Shashangka Shekhar

In this article we will get a short overview on AngularJS, then we will create a ASP.Net MVC-5 CRUD application using AngularJS(v1.4.8).

Yet another Home Monitor

5 Mar 2015 by 65Goat

This contest submission is for a home monitoring solution that reads temperature, humidity and states from various sensors around a home. The data is stored in Azure and can be accessed via mobile devices.

Sargable query in SQL server.

12 Oct 2014 by Jitendra Ku. Sahoo

In this article we will discuss how to write Sargable query in SQL server.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Create SSRS Report in SQL Server

12 Dec 2014 by pritik889

In this article, we will learn how to create a SSRS report, how to configure the reporting server and how to deploy the report.

SQL-Server-2014

Sql Server In Clause With Multiple Literal Values Performance Behaviour

26 Aug 2016 by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL-Server-2008

SQL-Server-2005

SQL recursive common table expression in Project Scheduling practice

14 Oct 2015 by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

SQL-Server-2008

SQL-Server-2008R2

stored-procedure

Role Based Security Architecture Using .NET MVC & JS

23 Feb 2015 by Tushar_Gupta

A custom security architecture for role based access to components in a page

Column Store Indexes in SQL Server 2012

10 Sep 2014 by Vijendra(VJ)

This article explains the internals of column store index and the pros and cons of it.

SQL-Server-2014

SQL-Server-2012

Angular 2 & .NET Core Developing Web App From Scratch Part 1: Implementing Restful Web Server

2 Feb 2017 by O.Nasri

Great article to learn how you can create web application from scratch using Angular2 & .NET Core Web API

SQL-Server-2014

Having Not ONE But TWO Identities in Single SQL Server Table

12 Apr 2016 by Aqeeel

Having not ONE but TWO Identities in a single SQL Server Table

SQL-Server-2012

SQL-Server-2014