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.

Another C# SQL class

by formlesstree4

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

Arkitech Platform Framework

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

Audit Trail and Data Versioning with C# and MVC

by DataBytzAI

Method for implementing an audit-trail

Build a website with Kaliko CMS using ASP.NET MVC

by Fredrik Schultz

Introduction to Kaliko CMS - an open source content management system for ASP.NET MVC

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.

Capture of a Typical SQL Server Database Workload

by Tomáš Bauer

Capture of a Typical SQL Server Database Workload

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 First SSRS Report with SQL Server Analysis Services OLAP Cube

by Mubin M. Shaikh

This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube

Custom Queries with RAW SQL under ADO.NET EF

by Tamas Lorincz

Customer Invoicing System/Applying Visitor Design Pattern using ASP.NET MVC5 and C#

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

ERP INFRASTRUCTURE

by databaseobjectmodel

A sample infrastructure project such as erp, mrp, crm, admin panel.

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

Get Ready to Learn SQL Server: 15. Learn to use Union, Intersect, and Except Clauses

by essentialSQL

Learn to use Union, Intersect, and Except clauses

Handle NULL in SQL Server

by Math08avan

The important things to understand, how missing values are treated in SQL Server

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 Send Mail Using SQL Server: Part 3

by Manish kumar choudhary

In this article, I will explain how to schedule a daily mail from SQL Server 2008.

IOBOT : Build your own Azure powered Robots

by Naren Neelamegam

Building robots from the scratch with speech recognition, remote voice control, learning intelligence with Raspberry PI, Intel Galileo and Microsoft Azure.

IoT Makes the Perfect Microwave Burrito

by Todd Christell, Canin Christell

Creating a Microwave Oven IoT Application

Lookup Control for ASP.NET Web Applications

by Manoj K Bhoir

Lookup web user control with some basic properties and functionalities

Moving from Old Sharepoint Server? Something to Import inside SharePoint 2013?

by Elia Conchione

Moving from old SharePoint server? Something to import inside SharePoint 2013?

Multi-Tenancy System With Separate Databases in MVC

by Gavin Coates

Creating a multi-tenancy system where each tenants data is stored in a separate database, using ASP.NET MVC

Nested XML from SQL to JSON

by Jose Segarra

Getting SQL Server XML nested data as a JSON string

Querying SQL Server 2012: Part I

by Sander Rossel

The first of two, everything you need to create the most amazing queries!

Querying SQL Server 2012: Part II

by Sander Rossel

The second of two; everything you need to create the most amazing queries!

Refering dlls in SSIS Script Task

by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

RESTful SignalR Service

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

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

Sargable query in SQL server.

by Jitendra Ku. Sahoo

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

Sending Email Using Stored Procedures in SQL Server

by Passion4Code

How to send email using stored procedure 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 error details.

by Jitendra Ku. Sahoo

Overview of SQL server error anatomy.

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

SqlDependency .NET library can work to detect updates automatically

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

SSIS Import Text File Using Validation

by Math08avan

Import text file data to SQL database using foreign key relation and validation.

Stored Procedure for Single & List Object in ASP.NET MVC with angularJS

by Md._Mehedi_Hasan

CRUD operation in .net MVC using Stored Procedure for Single and List Object Data along with SQL Transaction.

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

Use one SSRS Report to Find All Your Microsoft SQL Servers, Out of Date Editions, and Service Packs

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

Use SQL to develop your REST API

by Ole Oren

Fast and simple REST development for SQL devs