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.

XML

SQL

.NETCF

.NET

Data Science - Journey through Life Cycles. Part 1

26 Nov 2019 by @Abdul Azeez Thekkekandy

This article explores Data Science lifecycles - Business Understanding, Data Understanding and Data Preparation

Writing SQL queries in XML – A support intensive approach

31 Jul 2005 by _Asif_

Article that helps writing SQL in XML to provide better support

Verifying Database Design Issues Against Predefined Quality Rules Using Schema Views

6 Dec 2016 by _Asif_

This article helps in identifying database design issues like certain fields missing, nullable fields, Primary key not found issues in production environment using SQL Server schema views.

Implementation of a B-Tree Database Class

29 Jun 2006 by _oti

An article and source code regarding the implmentation of B-Trees in C++.

PostgreSQL/libpqxx Class Generator

18 Aug 2006 by _oti

Automated generation of PostgreSQL data transfer classes.

WrapSP - A Wrapper Class Generator for SQL Stored Procedures

8 Aug 2009 by _Reinhard

A simple to use tool that generates ADO based classes for calling SQL Stored Procedures. Only a few clicks, and you can access any Stored Procedure in your database.

Working with database one more time

5 Aug 2014 by a.alghabban

using ADO.net

SQL

VS2013

ADO

SecurePHPWebAppCoding - SQL Injection - What is it and How to Stop It?

14 Sep 2014 by Abani Kumar Meher

This article describes how we write code while developing web application which results in SQL injection vulnerability and how we should write code to prevent it.

Parent/Child (Hierarchical) Relational Treeview User Control Development in ASP.NET

14 Aug 2012 by Abdul Quader Mamun

Custom TreeView web user control for parent child relatioinal data upto infinity

Effective Paging with GridView Control in ASP.NET

16 Nov 2010 by Abdul Quader Mamun

Paging must be effective for large scaleable applications. Without smart and effective paging and sorting for huge amount of data, user request takes more time and uses more resources.

Effective paging with List View control in ASP.NET

9 Nov 2012 by Abdul Quader Mamun

To develop scalable applications, effective paging is essential. Devoid of smart and effective paging and sorting to handle thousands of thousand data takes extra time and system resources.

SQL Framework

16 Aug 2012 by Abdul Quader Mamun

Framework makes application more organized and efficient way to coding. It is helpful for newly assigned developer to understand code structure within a short time. It is essential for large application.

Reading Online CSV File and Manage it into Microsoft SQL Database

7 Aug 2012 by Abdul Quader Mamun

How to read an online Excel file and manage it in Microsoft SQL database

Crystal Reports with Dynamic Number of Columns with Typed Dataset

4 Aug 2010 by Abdul Quadir Saifee

Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005

Custom print procedure in MS SQL 2000/7/6.5

23 Dec 2003 by Abhay Dubey

This procedure can be called in another Stored procedure or function and quite handy in debugging and development

Displaying Images from a Database in a GridView

9 Dec 2010 by Abhijit Jana

A simple guide for beginners, explaining one method of displaying images taken from a database on a GridView inside an ASP.NET web page

Overview of Views in SQL Server 2005

28 Jul 2009 by Abhijit Jana

Overview of Views, system Views, creation of Views, and binding and securing Views.

Pitfalls Encountered and their Workarounds during Development of BizTalk Projects

9 Sep 2010 by Abhijit Mahato

This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects

How to get the Menus Based on Role in XML Format and Bind them to the Menu Control in ASP.NET

30 Jan 2012 by abhijit.dalvi29

This article describes how to get the Menus Based on Role in XML Format and Bind them to the Menu Control in ASP.NET

XML

SQL

ASP.NET

E-Commerce Product Management Database Model with Coder's and DBA Perspective

10 Apr 2016 by Abhinav Kumar singh (Aman)

Learn an interesting way to design database with coder's perspective

SQL

SQL-Server-2008R2

Data Parsing SQL to JSON

5 Sep 2014 by Abhishek Jaiswall

Data parsing SQL to JSON

SQL

XML

Ultrabook Development My Way

9 Jan 2013 by Abhishek Nandy

In depth details of an Ultrabook

Working with CLR Objects in SQL Server 2005 or Higher: Part I

2 Aug 2009 by Abhishek Sur

Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.

Query Notification using SqlDependency and SqlCacheDependency

3 Nov 2012 by Abhishek Sur

The article demonstrates how you can use SQL Server Query Notification feature to get notification from database whenever the result of a command gets changed. Sample application demonstrating SqlDependency and SqlCacheDependency is also included.

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux (Race to Linux)

5 Oct 2005 by Abi Bellamkonda

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper

ASP.NET Reports Starter Kits Porting from Windows to Linux (Race to Linux)

30 Sep 2005 by Abi Bellamkonda

ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper

RemoteLib - DLL Injection for Win9x & NT Platforms

10 Jan 2005 by Abin

A DLL injection library that works on both Win9x & NT platforms.

Auto Adjusting Date Ranges on Entry of a New Range using SQL

27 Sep 2009 by acarpio1975

Given date ranged data, adjust existing ranges on entry of a new ranged data.

Software Configuration Management (SCM) Considerations for Agile Development

9 Jan 2008 by AccuRev

Why organizations considering moving to an Agile development methodology to increase product quality, decrease costs and respond more quickly to market needs should also consider the changing requirements that the new model places on the SCM system and which aspects are critical to success.

How to make a random selection from an SQL table

2 Mar 2005 by Ach1lles

A simple technique for selecting random records from a table.

Mapping Zip Code From Your Database

25 Jul 2004 by Adam A. Mitteer

Using longitude, latitude, and zip code to map the United States, and then mark the zip codes that are matched in your database

Depth-wise Ordering for Trees in SQL

7 Jun 2007 by Adam Hurwitz

Using a modified Adjacency List model in SQL, can you retrieve a depth-wise ordered subtree?

C# class that creates 'INSERT INTO' SQL queries

16 Dec 2004 by Adam Klobukowski

Class that creates INSERT INTO SQL queries.

Continuous Integration for Databases with Visual Studio

23 Nov 2010 by Adam Nachman

Provides a framework for predictably compiling, extracting, and deploying a database project.

Implement Phonetic ("Sounds-like") Name Searches with Double Metaphone Part IV: SQL Server and Advanced Database Topics

19 Mar 2007 by Adam Nelson

Presents a SQL Server Extended Stored Procedure wrapper around the author's C++ implementation, and discusses use of Double Metaphone with relational databases in general.

How to conduct an SMS survey using a cell phone connected SMS gateway and MS Access

16 Oct 2007 by Adam Page

Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.

Auto-Generating a Comprehensive C# Data Access Layer

6 Nov 2006 by adamAFA46

Simple but powerful GUI O/R Mapper which generates C# 2.0 to handle all of your object relational persistence.

SqlProcedure - Improve Database Performance, Eliminate Errors and Reduce Code

23 Nov 2007 by adambl

Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors

ADO.NET Data Access Component for SQL Server in C# and VB.NET

28 Sep 2012 by AdamNThompson

A data access component for SQL Server in VB.NET.

SQL Server 2005 Distilled - Chapter 3: Enterprise Data Management

31 Mar 2006 by Addison-Wesley

This chapter covers what's new in enterprise database administration. It doesn't just look at the product from a feature list, but groups the features according to some tasks common to database administration.

ASP.NET 2.0 Illustrated - Chapter 2: Is It Really This Easy?

20 Jul 2006 by Addison-Wesley

This chapter presents a scenario-based demonstration focused on a day in the life of a developer who is in the process of fulfilling the requirements of a fictional customer.

NoSQL: MongoDB for Beginners

21 Feb 2016 by adityaswami89

NoSQL: MongoDB for beginners

SQL

NoSQL

database

Unknown Class Dynamically Generated at runtime for Entity Framework, WCF OData and dynamic client consumption

7 Nov 2014 by Adriaan Booysen

An example of a nearly complete unknown type being used accross EF, WCF and consumed client side

How to make an online conversion from code page to Unicode in your SQL scripts.

19 May 2002 by Adrian Bacaianu

This article shows how to use directly in your Microsoft SQL, an extended stored procedure that makes conversions between Unicode and code page data.

Discover SQL: Dynamically recomputing columns

17 May 2002 by Adrian Bacaianu

How to perform different computations for each row of a certain table, with each computation involving several columns.

Transferring backup files from a remote SQL Server instance to a local machine without network shares, FTP, HTTP

8 Mar 2009 by Adrian Pasik

This article is about transferring backups without raising the privileges of SQL Server, or using custom copying tools.

Using PostgreSQL in your C# (.NET) application (An introduction)

15 Nov 2008 by Adrian Pasik

In this article, I would like to show you step by step how to use this fantastic database in your C# application.

MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET

24 Sep 2021 by adriancs

A tool to export and import MySQL database in .NET

Creating a shop website in ASP.NET

9 Aug 2014 by Afzaal Ahmad Zeeshan

This articles describes how to kick start a shop website using ASP.NET and the software Microsft WebMatrix

How to Connect SQL Database to your C# Program - Beginner's Tutorial

30 Sep 2014 by Afzaal Ahmad Zeeshan

This article tells the beginners the basic concepts about connecting to the SQL Server database using C#.

Reading and writing Unicode data in .NET

11 Apr 2015 by Afzaal Ahmad Zeeshan

This article is for beginners about writing and reading Unicode data from different data sources; including text files, user input, databases. It also demonstrates how to display that data in .NET applications, including ASP.NET web applications.

Mission Impossible: Migrating .NET Core 1.x to 2.0

19 Aug 2017 by Afzaal Ahmad Zeeshan

.NET Core 2.0 brings a lot of improvements to the system, and it brings a lot of pain to the developers as well. I had a lot of problems upgrading .NET Core 1.x apps to .NET Core 2.0; I yet have to feel the promise it makes about performance and so, but let us see how to upgrade our existing applica

SQL Server 2005 - Merge Replication Step by Step Procedure

30 Aug 2008 by Ahmad Eid Salim

Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of a database and share the copy with different users so that they can make changes to their local copy of database and later synchronize the changes to the source database.

Provider Design Patterns in NET 2.0

29 Oct 2008 by Ahmad Eid Salim

Provider Design Pattern is a new pattern that Microsoft formalized in .NET 2 to increase application performance where there is no need to explicitly instantiate classes.

Optimizing Push Framework for the Web: Use of Websocket, SSL, Json, AngularJs and MySQL

29 Nov 2014 by Ahmed Charfeddine

Websocket, SSL, Json, MySQL are all combined together with Push Framework to produce a C++ server that interacts with an Angularjs web front-end. The application shows the ease of implementing CRUD.

A Simple GUI Tool for SQL 2005 Reports Deployment Without using BI Development Studio

25 May 2008 by Ahmed IG

A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio

How to Set Up SQL Server Integrated Security For Using With SMS

19 Apr 2005 by Ahmed_EL Sayed

How to set up SQL Server Integrated Security for using with SMS.

SQL Database Restore

1 Apr 2009 by Ahmet Göktaş

T-SQL string maker for backup with a MEDIAPASSWORD database.

FOR XML Basics (RAW Mode): 1 of 4

2 Jun 2017 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

FOR XML Basics (AUTO Mode): 2 of 4

2 Jun 2017 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

1 Jun 2017 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

Searching Music Incipits in Metric Space with Locality-Sensitive Hashing

27 Nov 2018 by Ajcek84

Using locality-sensitive hashing algorithm to improve performance of searching of musical incipits

Javascript

SQL

Blazor

Database Script Generator

9 Oct 2006 by Ajey Dudhe

This utility can be used to compare two MS Access databases for changes in the data. You have the option of generating the SQL scripts and\or a summary XML

Learn Datawarehouse Concepts

23 Jul 2014 by Ajit Kumar Thakur Microsoft

This article describes concepts and terminologies used in Datawarehouse. This will help beginners to understand datawarehouse concepts. This will also help developers who wish to design and develop SSAS cube, design data model of datawarehouse system.

Designing SSAS Cube

25 Jul 2014 by Ajit Kumar Thakur Microsoft

This article explain step by step approach to implement SSAS Cube.

SQL

DBA

SSAS

Reading OLAP Cube using MDX: Part 1

29 Jul 2014 by Ajit Kumar Thakur Microsoft

This article explains the step by step process to learn MDX query. It will help user to read data from OLAP cube.

Reading OLAP Cube using MDX: Part 2

1 Aug 2014 by Ajit Kumar Thakur Microsoft

Reading OLAP Cube using MDX: Part 2

SQL

MySQL Table Manager

4 May 2008 by AKA MAJO

The MySQL engine permits user level locks. This article explains how to manipulate these lock types.

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

Find multiple strings (delimenated by space) in all selected columns.

Learning MVC - Part 2: Creating MVC Application and Perform CRUD Operations Using LINQ to SQL

17 Mar 2015 by Akhil Mittal

Creating MVC Application & Perform CRUD operations using LINQ to SQL

Learning MVC - Part 3: Creating MVC Application & Perform CRUD Operations Using EntityFramework

17 Mar 2015 by Akhil Mittal

How to create MVC application and perform CRUD operations using EntityFramework

Learning MVC - Part 5 Repository Pattern in MVC3 Application with Entity Framework

17 Mar 2015 by Akhil Mittal

Repository pattern in MVC3 application with entity framework

CRUD Opearations using AutoMapper in an MVC Application

26 Nov 2014 by Akhil Mittal

How to do custom mapping and entity to entity mapping with the help of AutoMapper.

Learning MVC Part 6: Generic Repository Pattern in MVC3 Application with Entity Framework

17 Mar 2015 by Akhil Mittal

Unit of Work Pattern and Repository Pattern, and how to perform CRUD operations in an MVC application.

Introduction to Knockout.js and CRUD Operations in ASP.Net Web Forms Using Knockout.JS

26 Nov 2014 by Akhil Mittal

This article is an introduction to Knockout.js and CRUD Operations in ASP.NET Web Forms using Knockout.JS.

RESTful Day #1: Enterprise Level Application Architecture with Web APIs using Entity Framework, Generic Repository Pattern and Unit of Work

1 Mar 2016 by Akhil Mittal

Enterprise level application architecture with Web APIs using Entity Framework, Generic Repository pattern and Unit of Work.

RESTful Day #2: Inversion of control using dependency injection in Web APIs using Unity Container and Bootstrapper

1 Mar 2016 by Akhil Mittal

My article will explain how we can make our Web API service architecture loosely coupled and more flexible.

RESTful Day #3: Resolve dependency of dependencies using Inversion of Control and dependency injection in ASP.NET Web APIs with Unity Container and Managed Extensibility Framework (MEF)

1 Mar 2016 by Akhil Mittal

Resolve dependency of dependencies using Inversion of Control and dependency injection in Asp.net Web APIs with Unity Container and Managed Extensibility Framework (MEF).

RESTful Day #4: Custom URL Re-Writing/Routes using Attribute Routing in MVC 4 Web APIs

1 Mar 2016 by Akhil Mittal

In this article I’ll explain how to write your own custom routes using Attribute Routing.

RESTful Day #5: Security in Web APIs-Basic Authentication and Token based custom Authorization in Web APIs using Action Filters

1 Mar 2016 by Akhil Mittal

This article will explain how to make WebAPI secure using Basic Authentication and Token based authorization.

RESTful Day #7: Unit Testing and Integration Testing in WebAPI using NUnit and Moq framework (Part 1)

1 Mar 2016 by Akhil Mittal

In this article we learn how to write unit tests for core business logic and primarily on basic CRUD operations.

RESTful Day #8: Unit Testing and Integration Testing in WebAPI using NUnit and Moq framework (Part2)

7 Mar 2016 by Akhil Mittal

In this article we’ll learn on how to write unit tests for WebAPI controllers i.e. REST’s actual endpoints.

RESTful Day #9: OData in ASP.NET Web APIs

1 Apr 2016 by Akhil Mittal

This is the last article of the RESTful series in which I’ll explain how you can leverage OData capabilities in ASP.NET WebAPI. I’ll explain what OData is and we’ll create OData enabled RESTful services.

Creating Self Hosted ASP.NET WebAPI with CRUD operations in Visual Studio 2010

14 Apr 2016 by Akhil Mittal

In this article I’ll explain how we can host aWebAPI in another process independent of IIS.

Formatters and Content Negotiation in ASP.NET Web API 2

5 Jul 2016 by Akhil Mittal

This article will focus on practical aspects of formatters and content negotiation in ASP.NET Web API

Introducing Distributed Messaging using Service Broker in SQL Server 2005

28 Sep 2005 by Akram Hussein

An article on distributed messaging using Service Broker in SQL Server 2005.

Strongly Typed DataSet Generator

2 Dec 2009 by Akram Mellice

Generate strongly typed datasets

How to Manipulate Hierarchical Information in Flat Relational Database Tables

21 May 2020 by Akshay Srinivasan2

This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table with only one table scan.

Display/Store and Retrieve Image Data from Database to Gridview, and also on Mouse Over

15 Oct 2011 by Al Moje