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

Select Statement to HTML Table

by Luca Astolfi

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

All Articles

top

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.

.NET4.5

.NET

MVC

SQL-Server-2012

SQL-Server-2014

Visual-Studio

Dev

SQL Server: Doing String Split And Join

19 Feb 2019 by DiponRoy

How to do string split and join in SQL Server

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.

Save your Data from LDAP Injection Attack

9 Jul 2014 by Jason Parms

Lightweight Directory Access Protocol (LDAP) Injection

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

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.

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.

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

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

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?

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.

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.

Resource Governor Enhancements in SQL Server 2014

14 Jan 2015 by CharlieBrown1433

Resource Governor Enhancements in SQL Server 2014

SQL-Server-2014

DBA

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"

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

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

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

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

Cursors Vs. Sets

19 Nov 2014 by Sums Mohs Eds

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

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

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.

Easy Database Table Change History

5 Nov 2014 by Johnny L Washington

Capture data changes in history table