Click here to Skip to main content
14,879,366 members
Everything / Database Development / SQL Server / SQL Server 2012

SQL Server 2012

SQL-Server-2012

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 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.
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

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 2012 

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.
6 Sep 2015
Math08avan
Import text file data to SQL database using foreign key relation and validation.
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.
10 Apr 2015
Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
Please Sign up or sign in to vote.
28 Jun 2014
Elia Conchione
Moving from old SharePoint server? Something to import inside SharePoint 2013?
Please Sign up or sign in to vote.
22 Jun 2015
Terence Wallace
The primary purpose of this article is to provide quality sample source code for VB.NET developers interested in building data-centric applications using the .NET Framework.
Please Sign up or sign in to vote.
25 Feb 2015
Todd Christell, Canin Christell
Creating a Microwave Oven IoT Application
Please Sign up or sign in to vote.
3 Oct 2016
Mark W Solomon
In this article, I developed a way to determine all the SQL Servers in our environment at will and filter this information into Microsoft's Sunset report for Microsoft SQL Server and present all this information in an SSRS report.
Please Sign up or sign in to vote.
11 Mar 2014
mbarbac
Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM
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.
20 Jan 2017
Ole Oren
Fast and simple REST development for SQL devs
Please Sign up or sign in to vote.
23 Jan 2016
Fredrik Schultz
Introduction to Kaliko CMS - an open source content management system for ASP.NET MVC
Please Sign up or sign in to vote.
27 Oct 2015
Wonde Tadesse
An article that explain hows to expose SignalR feature through an ASP.NET Web API, which helps applications that can use REST service and to broadcast a real-time message to their clients.
Please Sign up or sign in to vote.
24 Jan 2014
Sander Rossel
The second of two; everything you need to create the most amazing queries!
Please Sign up or sign in to vote.
20 Jul 2014
Mubin M. Shaikh
This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
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.
15 Dec 2015
databaseobjectmodel
A sample infrastructure project such as erp, mrp, crm, admin panel.
Please Sign up or sign in to vote.
3 Jan 2014
Sander Rossel
The first of two, everything you need to create the most amazing queries!
Please Sign up or sign in to vote.
7 Nov 2015
Sujeet Bhujbal
Angular js with ASP.NET MVC is more popular now days and for beginners, I will tell you what is angular js and show you a practical example of ASP.NET MVC for inserting, deleting and displaying data using angular js.
Please Sign up or sign in to vote.
31 Mar 2015
Naren Neelamegam
Building robots from the scratch with speech recognition, remote voice control, learning intelligence with Raspberry PI, Intel Galileo and Microsoft Azure.
Please Sign up or sign in to vote.
21 Oct 2014
Jose Segarra
Getting SQL Server XML nested data as a JSON string
Please Sign up or sign in to vote.
22 Sep 2014
Jitendra Ku. Sahoo
Overview of SQL server error anatomy.
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.
17 Aug 2015
DataBytzAI
Method for implementing an audit-trail
Please Sign up or sign in to vote.
2 Oct 2015
Math08avan
The important things to understand, how missing values are treated in SQL Server
Please Sign up or sign in to vote.
22 Jul 2015
Singh Deepika
This article will step by step guide you through the Flow of MVC application clearing your basic concepts of MVC
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.
11 Mar 2016
Kashif-Sohail
In this article, you will learn what data masking is, how to enable data masking in an existing application, how to give access to different users to the masked data.
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.
3 Oct 2017
Gavin Coates
Creating a multi-tenancy system where each tenants data is stored in a separate database, using ASP.NET MVC
Please Sign up or sign in to vote.
24 May 2017
Zahid Nawaz Ch.
SqlDependency ,can be used to pick changes without executing query to see there is any update from database , WHERE CLAUSE can also be applied for narrowing scope, Its way to push changes from SQL Server to SQLDependency , .NET library , SQL Server Broker service sends updates to SQLDependency.
Please Sign up or sign in to vote.
9 Oct 2016
Md._Mehedi_Hasan
CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.
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.
26 Aug 2016
Neeraj Prasad Sharma
This article deals with performance difference with literal values
Please Sign up or sign in to vote.
7 Jun 2015
Gokuldas
This article shows you how to apply Visitor Design pattern in real life software scenario. Also this article covers various features of ASP.NET MVC-5, Entity Framework and C# language features.
Please Sign up or sign in to vote.
8 Sep 2015
Passion4Code
How to send email using stored procedure in SQL Server
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.
29 May 2017
Tomáš Bauer
Capture of a Typical SQL Server Database Workload
Please Sign up or sign in to vote.
22 Mar 2015
Aby Mammen Mathew
IoT devices needs the capability to augment the environment around them, even when sensors utilized by them break down
Please Sign up or sign in to vote.
21 Dec 2014
essentialSQL
Learn to use Union, Intersect, and Except clauses
Please Sign up or sign in to vote.
29 Mar 2015
Manoj K Bhoir
Lookup web user control with some basic properties and functionalities
Please Sign up or sign in to vote.
27 Mar 2016
Manish kumar choudhary
In this article, I will explain how to schedule a daily mail from SQL Server 2008.
Please Sign up or sign in to vote.
12 Apr 2016
Aqeeel
Having not ONE but TWO Identities in a single SQL Server Table