SQL-Server-2014

Great Reads

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

by Md. Marufuzzaman

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

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

ADO.Net Connectivity using Stored Procedure and Output parameters

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.

Amazon Web Services part 2 - Adding a database to your web site

by Matt Perdeck

Add a database to your web site on AWS with automatic fail over using RDS

Latest Articles

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

by Md. Marufuzzaman

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

A Simple Example of Microsoft SQL Server Pad String

by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

ADO.Net Connectivity using Stored Procedure and Output parameters

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.

Amazon Web Services part 2 - Adding a database to your web site

by Matt Perdeck

Add a database to your web site on AWS with automatic fail over using RDS

All Articles

top

SQL-Server-2014

Amazon Web Services part 2 - Adding a database to your web site

by Matt Perdeck

Add a database to your web site on AWS with automatic fail over using RDS

Angular 2 & .NET Core Developing Web App From Scratch Part 1: Implementing Restful Web Server

by O.Nasri

Great article to learn how you can create web application from scratch using Angular2 & .NET Core Web API

Another C# SQL class

by formlesstree4

Another article on C# .NET SQL, but with smarts

ASP.NET MVC-5 CRUD Using AngularJS

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

Building a Basic Test Data Generator for Books in SQL

by Haroon Ashraf

This article helps beginners to generate over million records of random test data for a database object like books in SQL.

Column Store Indexes in SQL Server 2012

by Vijendra(VJ)

This article explains the internals of column store index and the pros and cons of it.

Create SSRS Report in SQL Server

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

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

FOR XML Basics (EXPLICIT Mode): 3 of 4

by AhsanAhmed

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

FOR XML Basics (RAW Mode): 1 of 4

by AhsanAhmed

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

Handling NULL in T-SQL

by Bhim B Thapa

Handling NULL in T-SQL

Having Not ONE But TWO Identities in Single SQL Server Table

by Aqeeel

Having not ONE but TWO Identities in a single SQL Server Table

How to check whether a measure group is mapped with the dimension group

by Sibeesh Passion

This article shows how to check whether a Measure Group is mapped with the Dimension Group.

Retrieve/Update SQL Records based on Barcodes

by Philipp Katscher

Fetching Records from a DB using Barcode and updating the same or others with this nifty configurable tool

Role Based Security Architecture Using .NET MVC & JS

by Tushar_Gupta

A custom security architecture for role based access to components in a page

Sargable query in SQL server.

by Jitendra Ku. Sahoo

In this article we will discuss how to write Sargable query in SQL server.

SQL recursive common table expression in Project Scheduling practice

by csabahegyi79

Project Scheduling Engine with recursive SQL common table expression

SQL Server Disk Usage Statistics

by Dr. Song Li

This is an example to check the SQL server disk and data file usage statistics.

Sql Server In Clause With Multiple Literal Values Performance Behaviour

by Neeraj Prasad Sharma

This article deals with performance difference with literal values

SQL Server: Detect Circular Relations In A Relational Database

by DiponRoy

Table Hierarchy or Generation Finder For Relational Database 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.

Synchronization between local and Azure SQL DB using SLQ Management Studio "Export Data..."

by Sergey Kizyan

This article explains how to merge your local SQL DB content to Azure DB from scratch

Yet another Home Monitor

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