Click here to Skip to main content
15,040,750 members
Everything / Database Development / SQL Server / SQL Server 2014

SQL Server 2014

SQL-Server-2014

Great Reads

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.
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
by DiponRoy
How to do string split and join in SQL Server
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

by DiponRoy
A utility query to find table generations in SQL Server relational database.
by DiponRoy
How to do string split and join in SQL Server
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.
by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment

All Articles

Sort by Score

SQL Server 2014 

Please Sign up or sign in to vote.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in AUTO mode in Microsoft SQL Server to return data in XML format
Please Sign up or sign in to vote.
29 Aug 2018
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.
Please Sign up or sign in to vote.
24 Sep 2015
Dr. Song Li
This is an example to check the SQL server disk and data file usage statistics.
Please Sign up or sign in to vote.
1 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in EXPLICIT mode in Microsoft SQL Server to return data in XML format
Please Sign up or sign in to vote.
17 Mar 2015
Sergey Kizyan
This article explains how to merge your local SQL DB content to Azure DB from scratch
Please Sign up or sign in to vote.
24 Mar 2015
Matt Perdeck
Add a database to your web site on AWS with automatic fail over using RDS
Please Sign up or sign in to vote.
2 Jun 2017
AhsanAhmed
A brief introduction on how to use FOR XML clause in RAW mode in MS SQL Server to return data in XML format
Please Sign up or sign in to vote.
26 Jun 2014
Philipp Katscher
Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool
Please Sign up or sign in to vote.
1 Apr 2014
formlesstree4
Another article on C# .NET SQL, but with smarts
Please Sign up or sign in to vote.
4 May 2015
Sibeesh Passion
This article shows how to check whether a Measure Group is mapped with the Dimension Group.
Please Sign up or sign in to vote.
13 Nov 2017
Haroon Ashraf
This article helps beginners to generate over million records of random test data for a database object like books in SQL.
Please Sign up or sign in to vote.
23 Jan 2016
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).
Please Sign up or sign in to vote.
4 Mar 2015
DiponRoy
Table Hierarchy or Generation Finder For Relational Database In SQL Server
Please Sign up or sign in to vote.
5 Mar 2015
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.
Please Sign up or sign in to vote.
12 Oct 2014
Jitendra Ku. Sahoo
In this article we will discuss how to write Sargable query in SQL server.
Please Sign up or sign in to vote.
12 Dec 2014
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.
Please Sign up or sign in to vote.
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
Please Sign up or sign in to vote.
23 Feb 2015
Tushar_Gupta
A custom security architecture for role based access to components in a page
Please Sign up or sign in to vote.
10 Sep 2014
Vijendra(VJ)
This article explains the internals of column store index and the pros and cons of it.
Please Sign up or sign in to vote.
2 Feb 2017
O.Nasri
Great article to learn how you can create web application from scratch using Angular2 & .NET Core Web API
Please Sign up or sign in to vote.
12 Apr 2016
Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table