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

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

23 Dec 2015 by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

A Simple Example of Microsoft SQL Server Pad String

18 Dec 2015 by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

ADO.Net Connectivity using Stored Procedure and Output parameters

10 May 2015 by Ankit Bansal MVP

This articles explains the insertion of data into SQL Database using Stored Procedures with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.

Apply Operator in SQL Server Simplified

14 Mar 2015 by Gaurav_Chaudhary

This tip is a brief introduction to Apply operator in SQL server

SQL-Server-2014

SQL-Server-2012

CLR Stored Procedure in SQL Server

10 Mar 2015 by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

SQL-Server-2014

stored-procedure

Create Insert SQL Statement from the Records in an Existing Table

8 Mar 2016 by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

SQL-Server-2008

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Creating a SQL Server Database Project Use in Visual Studio 2012 and Use TFS for Version Control

8 Jun 2015 by Diluka Wittahachchige

Creating SQL Server database project use in Visual Studio 2012 and maintain versions use in TFS

SQL-Server-2008

SQL-Server-2005

CURSOR in T-SQL

9 Jul 2016 by Prakash Lekhak

Dynamic SQL to get the list Table names

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Cursors Vs. Sets

19 Nov 2014 by Sums Mohs Eds

A brief discussion of when to use cursors and when to use sets.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

data-visualization

Dynamic Pivot Query in SQL Server

22 Jul 2015 by Chetan Naithani

Transforming dynamic row-level data into columns

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Easy Database Table Change History

5 Nov 2014 by Johnny L Washington

Capture data changes in history table

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

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

26 Sep 2015 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.

SQL-Server-2012

SQL-Server-2014

Export Primary, Unique, Foreign Key and Default Constraints in SQL Server

26 Sep 2014 by Anil kumar Bhardwaj

Export all the primary, Unique, Foreign key and default constraints from existing database

SQL-Server-2014

SQL-Server-2012

Extracting the filename from a full path in SQL Server

19 Jan 2015 by OriginalGriff

Sometimes, you want to extract the filename (with or without the extension) from the full path of a file. It's easy in C# and so forth - just use the Path.GetFileName method. But what if you want it in SQL?

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Fill factor in SQL server.

22 Oct 2014 by Jitendra Ku. Sahoo

In this article we will discuss about fill factor and its effect on query performance.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Find the Size of Database mdf and ldf File in sql server

30 Oct 2014 by Arvind Singh Baghel

I show a SQL query which finds the size of database mdf and ldf file in SQL Server.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

How to Change Date Format in Crystal Report

23 Jul 2015 by Mian Adnan

Using Microsoft Visual Studio Professional 2012, .NET 4.5 and Crystal Report Version regarding .NET 4.5 and VS 2012

SQL-Server-2014

How to Conditionally Filter the data in text file in Java

10 Oct 2014 by Member 10843807

An example to illustrate how esProc Helps Process Structured Text in Java–Conditional Filtering

SQL-Server-2014

How to fix "LocalDB - Requested Login failed"

20 May 2014 by Ed Nutting

How to fix LocalDB / SQL Server: "Cannot open database "XYZ" requested by the login. The login failed. Login failed for user ABC"

How to place an even-numbered SSRS report parameter at the start of a new row

20 Apr 2015 by Karsten Krug

A workaround for reporting services' missing ability to customize report parameter placement.

SQL-Server-2014

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015 by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Implement Split A/B pages in your ASP NET project

20 Aug 2014 by TheCardProject.co.uk

Quickly set up the ability to serve up several pages and record which was served in SQL Server

SQL-Server-2008R2

Import CSV or txt File Into SQL Server Using Bulk Insert.

21 May 2014 by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Integrate Google Analytic Data to Local Database using SSIS

31 May 2015 by Asanka Perera

This process shows how you can integrate Google analytic data into your reporting server database in order to have daily reports and analysis to include data of your Google analytic account using a free available plugin for SQL Server Integration service called SSIS GoogleAnalyticsSource.

SQL-Server-2014

Microsoft SQL: Increase Existing Value In Row Or Add New Row If None Exists

20 Mar 2015 by furytrader

Yes, Virginia, You Can Do This All With One Simple SQL Statement

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

Random Date/Time Test Data Generation

25 Aug 2016 by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

SQL-Server-2005

SQL-server-2000

Recursive CTE in SQL Server Simplified

7 Feb 2015 by Gaurav_Chaudhary

This tip is a brief introduction to Recursive CTE in SQL Server and how to implement it.

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Resource Governor Enhancements in SQL Server 2014

14 Jan 2015 by CharlieBrown1433

Resource Governor Enhancements in SQL Server 2014

SQL-Server-2014

Restart a SQL Server Scheduled Job If Hanged

15 Jul 2014 by anki.mathur

Restart hanged SQL Server scheduled job

SQL-Server-2014

SQL-Server-2008R2

Run Single Page Applications (SPA) Template using AngularJS, Web API, Owin Token Based Authentication and Mediator Design Pattern

23 Mar 2016 by Ahmet AYDIN

This post describes step by step how to run a Single Page Application template using ASP.NET Web API 2 and angularJS and how to use Web Application Project whose name is Dalyan.

Running the SQL Script File By Using The System.Diagnostics.Process Class

1 Jul 2014 by madhusudhanReddy

Running the SQL Script File

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Save your Data from LDAP Injection Attack

9 Jul 2014 by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

SQL-Server-2008R2

Select Statement to HTML Table

2 Feb 2018 by Luca Astolfi

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

SQL-Server-2008

SQL-Server-2008R2

SQL-Server-2005

SQL Server Database Backup Status Report

5 Jun 2015 by Dathuraj Pasarge

Know whether your databases are backed up successfully in the last 24 hours or not !!!

SQL-Server-2005

SQL-Server-2008

SQL-Server-2008R2

SQL-server-2000

SQL Server Health Check Script with Powershell

3 Dec 2014 by Atul_Kapoor

Perform SQL Server Instance health check simultaneously on more than one server using Powershell

SQL-Server-2008

SQL-Server-2005

SQL Server: Doing String Split And Join

19 Feb 2019 by DiponRoy

How to do string split and join in SQL Server

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL Server: Find Table Order/Generation And Relation Details

29 May 2019 by DiponRoy

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

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

SQL Server: Query to Get the Date of First Monday of September

12 Sep 2014 by Mohamad Cheaito

SQL Server: Query to get the date of first Monday of September

SQL-Server-2012

SQL-Server-2014

SQL-Server-2008R2

Tricky SQL Questions

18 Sep 2014 by sukeshchand

Unexpected SQL Interview Questions

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

UniDAC - database's direct connection

29 Sep 2015 by Thiago Gaidzinski

UniDAC allows you to connect your cross-platform application directly with many database's types.

Update Database using Stored Procedure and DataAdapter

20 Jun 2015 by Naresh Patidar

Insert, update and delete operations using stored procedure and DataAdapter in C#

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

WPF and MVVM pattern

5 Aug 2014 by Oussama_Kahoul

Introduction to WPF technology and the MVVM design pattern