SQL Server 2014

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.

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

How to do string split and join in SQL Server

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.

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

How to do string split and join in SQL Server

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.

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