We can achieve a professional database design by avoiding a few pitfalls and following some guidelines but still, these are only guidelines and not an exact rule-set which can guarantee a professional database.

Building a Better mouse-trap – Improving the Creation of XML Message Requests using Reflection, XML & XSLT

by Paul S. Chapman

How to improve the creation of XML message requests using Reflection, XML and XSLT

Calling a Basic Stored Procedure using StoredProcedureFramework

by dibley1973

How to call a basic stored procedure using StoredProcedureFramework

Camel Case Table Names in MySQL

by stephen.vaubell

A solution to casing problems in MySQL

Cartesian join for numbers

by Andrew Zwicker

An example of using a Cartesian [cross] join.

Cassandra Chapter 4: Data Partitioning With Random and Byte-Ordered Partitioners

by mumera

Data partitioning with random and byte-ordered partitioners in Cassandra

Choose the Right Model: Comparing Relational, Document, and Graph Databases

by Arctype SQL

There are three major types of database models in use today. Learn about their differences and what applications they are good for.

Christmas Carol: XML Signatures

by Ivan Krivyakov

Christmas Carol: XML Signatures

Common Problems in Xamarin.Android and their Solutions

by Afzaal Ahmad Zeeshan

In this article, I cover the most widely faced problems in Xamarin installation and setup for Android application development.

Connecting to External Oracle Database with Symfony 4 Framework

by Alvin Bunk

How to connect to external Oracle database with Symfony 4 Framework

Contained Database – A New Feature in SQL SERVER 2012 TIP #81

by Rajat-Indiandotnet

Contained Database–A new feature in SQL SERVER 2012 TIP #81

Controlling Collation Order On DB2/400

by Joe Rattz

How to control collation order on DB2/400

Counting Consecutive Dates Using SQL

by Tharaka MTR

How to count consecutive dates using SQL

Creating a Data Access layer using Unity

by Martin Hinshelwood

I am always pulling out the Unity assemblies. Maybe it is just because I am lazy, but I really can’t be bothered rolling my own dependency injection and mapping framework!

Creating an Entity Framework Connection from Another One

by James Curran

How to create an Entity Framework Connection from another one

Cross-Tabulation (Pivot Tables) with MySQL

by Cale Dunlap

Example of using code-based query generation, transposition, cross-tabulation, and normalized data to produce a query result that can feed a simple chart from data which was not originally designed with reporting or charting in mind.

Database Documentation with a Data Dictionary - Part 2

by Andrew Zwicker

A continuation of the data dictionary discussion with information about how the documentation is done

Database naming conventions

by Andrew Zwicker

Having clear, concise names for tables, procedures, etc., is important for many reasons.

Database Programming Rant

by Ivan Krivyakov

Database programming rant

Database Table Documentation with a Data Dictionary

by Andrew Zwicker

Why table and column documentation is useful and some SQL for setting up the data dictionary tables

DbKeeperNet - How to Seed ASP.NET Users and Roles

by voloda2

DbKeeperNet - How to seed ASP.NET Users and Roles

Dynamically Setting the Elmah Connection String at Runtime

by Williarob

Dynamically setting the Elmah connection string at runtime/

Easy Way to Change Collation of All Database Objects in SQL Server

by Raymund Macaalay

How to change collation of all database objects in SQL Server

Error Accessing Oracle Database Objects via Linked Server in SQL Server (The OLE DB provider "OracleOLEDB.Oracle" for linked server reported an...

by Manjuke Fernando

Error accessing Oracle Database Objects via Linked Server in SQL Server

Exclusive Access Could Not Be Obtained Because the Database is in Use ~ Resolved

by Manjuke Fernando

How to resolve this issue

From Zero to Hero in JSON with C#

by Afzaal Ahmad Zeeshan

JSON format of data interchange and its use with C#

Generate insert Statements from a Specific Table Data using SQL Server

by Tharaka MTR

Generate insert statements from a specific table data using SQL Server

Get Ready to Learn SQL Server 19: Introduction to Sub Queries

by essentialSQL

The purpose of this article is to introduce you to subqueries and some of their high-level concepts. There are a lot of details to cover in order to learn sub queries, but you’ll see we cover those in depth in later articles.

Get Ready to Learn SQL Server: 17. How to Use the Intersect Operator

by essentialSQL

How to use the Intersect Operator in SQL Server

Get Ready to Learn SQL Server: 5. Filter Results Using Patterns

by essentialSQL

In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.

Get Ready to Learn SQL Server: What is a Database NULL Value?

by essentialSQL

What is a Null Value? In databases a common issue is what value or placeholder do you use to represent a missing values. In SQL, this is solved with null. It is used to signify missing or unknown values. The keyword NULL is used to indicate these values.

Get Ready to Learn SQL Server: 13. Introduction to Inner Joins

by essentialSQL

Introduction to Inner Joins in SQL Server

Get Ready to Learn SQL Server: 15. Combine Table Rows Using UNION

by essentialSQL

How to combine table rows using UNION in SQL Server

Get Ready To Learn SQL Server: 3. How to Filter Your Query Results

by essentialSQL

In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.

Get Ready to Learn SQL Server: 4. Query Results Using Boolean Logic

by essentialSQL

Learn more about filtering results returned from your queries using the WHERE clause

Get Ready to Learn SQL Server: 6 – Group and Summarize Your Results

by essentialSQL

Grouping results returned from your queries using the GROUP BY clause

Get Ready to Learn SQL: 12. Introduction to Database Joins

by essentialSQL

Introduction to database joins in SQL

Get Ready to Learn SQL: 10. Database Second Normal Form Explained in Simple English

by essentialSQL

Database Second Normal Form explained in simple English

Get Ready to Learn SQL: 5. Query Results Using Pattern Matching

by essentialSQL

Query Results Using Pattern Matching in SQL

Get Ready to Learn SQL: 6. How to Group and Summarize your Results

by essentialSQL

How to Group and Summarize your Results in SQL

Get Ready to Learn SQL: 7. Simplified Data Modeling

by essentialSQL

Simplified Data Modeling in SQL

Get Ready to Learn SQL: 9. Database First Normal Form Explained in Simple English

by essentialSQL

Database First Normal Form explained in simple English

Get Ready to Learn SQLServer: 18. How To Use the EXCEPT Operator

by essentialSQL

How to use the Except Operator in SQLServer

Getting Started with SQL Server: 1. Simple SELECT Queries

by essentialSQL

Simple SELECT queries in SQL Server

Getting Started With SQL Server: 2. Sort Your Query Results

by essentialSQL

How to sort your query results in SQL Server

How Do I Use SQL Server to Sort Alphanumeric Values?

by essentialSQL

Sort Alphanumeric Values with SQL Server

How to configure and use Entity Framework

by Libish Varghese Jacob

Configuring and using Entity Framework 4.1 for my Open Source project.

How to Connect ASP.NET Website to Remote Database for CRUD Operations

by Afzaal Ahmad Zeeshan

An overview for connecting an ASP.NET website or a web application to a remote SQL Server database

How to do Step by Step Merge Join Transformations – #123

by Rajat-Indiandotnet

Step by step merge join transformations

How to Fix Orphaned SQL Users

by Tharaka MTR

This post will show you how to fix orphaned SQL users.

How to Make Database Offline or Online

by Vivek Johari

This post will show you how to make database offline or online.

How to Multicast messages with SQL Server Service Broker

by rusanu

How to Multicast messages with SQL Server Service Broker

How to Return Random Rows Efficiently in SQL Server

by Nadeem Afana

Illustrates an efficient method of returning random rows from a SQL Server database

How to Solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

by Shahriar Iqbal Chowdhury/Galib

This post shows you how to solve SSIS Error Code 0xC020801C/0xC004700C/0xC0047017

How to Update a Table with a columnstore Index

by rusanu

A technique to make tables with columnstore indexes updateable

How to Use columnstore Indexes in SQL Server

by rusanu

A very simplified explanation of how column store indexes can be used

How to Use Existing Database in Windows Phone

by Anuraj Parameswaran

Using existing database in Windows Phone

How to Use ROW_NUMBER() to Enumerate and Partition Records in SQL Server

by Dave C Andrews

Use ROW_NUMBER() to enumerate and partition records in SQL Server

Introduction to IndexedDB

by Sibeesh Passion

Some information about IndexedDB

Is NoSQL the SQL Sequel?

by Keyhole Software

I expect that most people with skin in the game will not be serious NoSQL users for a while. This should not discourage developers and architects from experimenting with various NoSQL DBMS now, so as to make choices based on knowledge.

It’s Simple!! Or Pseudo Simple Anyway

by derekman9707

Pseudo-simple recovery model

Learning SQLite databases in Xamarin for Android

by Afzaal Ahmad Zeeshan

In this article I will give you a complete overview of SQLite databases in Android and how to consume them using Xamarin APIs.

LINQ Group By with NULL Database Values

by JasonShort

LINQ Group By with NULL database values

Load XML And Show As li In Angular JS

by Sibeesh Passion

How to load an XML file and show as li using ng-repeat in Angular JS

Log4j2.xml Tweaks

by Jameson Triplett

Log4j2.xml Tweaks

Merge Smarter with Semantic Merge

by Rion Williams

How to merge smarter with Semantic Merge.

Merge Statement in SQL Server 2008

by Basavaraj P Biradar

The new Merge statement in SQL Server 2008.

Modifying GhostDoc XML Comment

by Mahmudul Haque Azad

A simple trick to add to custom node to the XML commenting.in GhostDoc

NHibernate and Complex Types for Native Keys

by Jeremy Likness

Learn how to use complex classes as primary (not composite!) keys with NHibernate

No More Stray User Tables in Master

by Tim Golisch

The Master database often seems to be the "Lost & Found" bin of the SQL Server world. There are two popular ways for preventing this kind of problem. Read on...

Online non-NULL with Values Column Added in SQL Server 11

by rusanu

Adding a new non-NULLable column with default values to an existing table in SQL Server 11

Online Tools for Troubleshooting Web, SQL, XML and JSON

by Tharaka MTR

Some online tools for troubleshooting web, SQL, XML and JSON

Oracle – Forward Slash Contd… (PL/SQL)

by Sam Varadarajan

Oracle SQL*Plus - Forward slash contd... (PL/SQL)

Oracle Sequence Promotes Poorly Maintainable Code

by snorkie

Oracle tables have no built-in mechanism for auto numbering. Instead, you must create a separate unique Sequence object and use it each time a record is inserted into the database.

Oracle: Commit and Forward Slash

by Sam Varadarajan

Commit and forward slash in Oracle

Oracle: Forward Slash in SQL*Plus – Take 2

by Sam Varadarajan

Oracle - Forward slash in SQL&Plus - Take 2

Overview of ADO.NET

by JasonShort

ADO.NET is a set of libraries included in the .NET Framework to facilitate the communication of applications with various data storage mechanisms. These libraries form the basis for all third parties to provide database access.

Processing SQL Server FILESTREAM Data - Part 1

by Bob McGowan

Processing SQL Server FILESTREAM Data - Part 1

Processing SQL Server FILESTREAM Data: Part 2 - The Setup

by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Processing SQL Server FILESTREAM Data: Part 3 - Creating Tables

by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Progress Bar in Cell – Excel

by johnniealan

This article describes about adding progress bar in cell.

Reduce the Size of MongoDB Documents Generated from .NET/C#

by Pragmateek

How to reduce the size of MongoDB documents generated from .NET/C#

Refresh ASP.NET Membership Database with SSIS

by Mario K. Tacke

Refresh ASP.NET Membership Database with SSIS

Remove Slow Startups and Enjoy Less “Suspense” through .NET 4.5.1′s App Suspend Feature

by Rion Williams

This article covers one of the switches that you might be interested in flipping, the App Suspend feature, which is available in .NET 4.5.1 on Windows Server 2012 R2.

Repairing Suspect SQL Database

by Raymund Macaalay

Repairing Suspect SQL Database

Resource: Brad's Sure Guide to SQL Server Maintenance Plans

by Bryan O'Connell

Review of the ebook: Brad's Sure Guide to SQL Server Maintenance Plans.

Revisiting XML Configurations In Unity

by Gil Fink

Revisiting XML Configurations In Unity In the past I wrote a few tutorials about Unity application block. One of the things I wrote about was how to configure a Unity container using design time configuration.

Safely Deploying Changes to Production Servers

by Omar Al Zabir

Steps to ensure that the web sites are properly recycled, caches are cleared, all the data stored at Application level is initialized

Schedule a Daily Backup with SQL Server Express

by outcoldman

Schedule a daily backup with SQL Server Express

Seed Your Database with Test Data Using the Entity Framework

by wullinkm

Seed your database with test data using the entity framework

Serialization 101 - Part III: XML Serialization

by MBigglesworth79

XML Serialization

Serializing and Deserializing Objects…to and from…XML

by Steve Wellens

Over on the ASP.NET forums I recently had the opportunity* to help a few lost souls by showing them how to serialize objects to XML and deserialize the XML back into objects.

Setting up XCode 3.0 with SVN

by User 1556233

codeproject Everyone knows SVN (Subversions) is the best version control tool on the planet. XCode, though, might not be as great as eclipse or Visual Studio, it offers one of the best integration with open platforms than both eclipse and Visual Studio.

Shrink All Databases on SQL Server

by Manas Bhardwaj

This post is intended to be used as a hack for developers to release some disk space. Please do not use on actual production environments.

Some Hidden Facts: Stored Procedure and Its Optimization

by Dinesh K Mandal

Some Hidden Facts about Stored Procedure and Its Optimization

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35

by pinaldave

Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35

by pinaldave

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series

SQL Server - Undocumented Stored Procedure sp_MSforeachtable

by Nuno M. F. Gomes

I'm not an every day SQL Server user but I use SQL Server regularly since 7.0 version until the 2005 version (not yet tried 2008 in a serious way) and from time to time I still find some nice hidden gems.A few days ago I needed to created a cleanup script for an application and one of the t

SQL Server and Duplicate Indexes

by Martin Thwaites

Finding and removing indexes in SQL Server is an excellent way to remove bottlenecks, especially if you've "inherited" the application.

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

by aasim abdullah

SQL Server: A Query Slow in SSMS, Fast in Application, WHY?

SqlConnection.Dispose internals

by zenwalker1985

SqlConnection.Dispose internals

Struggling with System.IO.Packaging when Creating a CLR Procedure

by Wendelius

System.IO.Packaging namespace in WindowsBase may cause problems when trying to create a CLR procedure.

Table Backups and the TableArchive Database

by Andrew Zwicker

A discussion of how a separate database is used for storing table backups.

The Entity Framework (v1 and v4) Deal Breaker: TPT Inheritance

by Sam Meacham

So what’s wrong with EF’s TPT inheritance? The SQL that EF generates. With some simple testing (2 or 3 subclasses) everything may appear to be fine. In fact, you may even be impressed that EF manages to fetch all the data you need in a single trip, indeed, in a single query.

The Server Principal “xxxx” is Not Able to Access the Database “msdb” under the Current Security Context.

by Rohitmssqlfun

The server principal “xxxx” is not able to access the database “msdb” under the current security context.

The Stored Procedure Framework Now Supports A Stored Procedure With Dynamic Fields

by dibley1973

The Stored Procedure Framework now supports a stored procedure with dynamic fields

Three Tricks to Get More Out of SQL Server in Common Web Scenarios

by Leland Richardson

Several little-known SQL tricks/techniques used to improve query times and enforce business rules with common everyday web-development scenarios

TSQL Recursive Split Function

by Shahriar Iqbal Chowdhury/Galib

TSQL Recursive Split function

Understanding JOINs in SQL Server

by Manjuke Fernando

It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.

Unlock User or Reset Password via Database Query – ASP.NET Membership

by Chris_Green

Programmatically unlock a user

Using a Staging Environment for Tracking Down Bugs

by Andrew Zwicker

A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.

Using Entity Framework 4.1 Code First with an Existing Database

by Caprica1

How to use the Entity Framework 4.1 RC Fluent API with an existing database

Using LINQ to SQL for ETL projects

by Bryan O'Connell

Using LINQ to SQL for ETL projects.

Using Nightly Populated Tables for Faster SQL Queries

by Andrew Zwicker

A discussion about nightly populated tables and how they have reduced SQL Server load

Using SQL Server’s Registered Servers Functionality Effectively

by Mohit1110

Using SQL Server’s Registered Servers Functionality Effectively

Vacuole Encapsulation

by Keyhole Software

Encapsulation approach to bring data sources and implementations closer together, allowing reflection-like behavior in a format that mere mortals can read.

WCF: Loose coupling of WCF Service and Data Contracts

by Sky Sanders

A strategy for implementing maintaining separation of concerns and implementation hiding.

What is the Difference Between Cast and Convert?

by essentialSQL

Difference between Cast and Convert

What is the Difference between GROUP BY and ORDER BY

by essentialSQL

What is the difference between GROUP BY and ORDER BY

What is the Difference between Inner and Outer Joins?

by essentialSQL

Difference between inner and outer joins

Why Would You Use Common Table Expressions?

by Gaston Verelst

Why you would use Common Table Expressions

Windows Azure Storage Emulator failed to install

by AssemblySoft

Upgrading Windows Azure Storage Emulator fails with error message 'Windows Azure Storage Emulator failed to install'

WPF: Merged dictionary parser depends on XML attribute order

by Ivan Krivyakov

Attribute order should not matter in XAML, but sometimes it does...

XML Databases

by AlexTatiyants

JSON-oriented document stores like Mongo and Couch have really become the darlings of the web application crowd. Of course, JSON (or BSON) isn't the only game in town. When it comes to document store formats, the other white meat if you will is XML.

XML Manipulation With XML Copy Editor

by Keyhole Software

XML Manipulation With XML Copy Editor

Your ADO is Broken

by WebBiscuit

Microsoft has violated the holy rules of COM and broken their msado15.dll. The violation occurs after the installation of Windows 7 Service Pack 1 (version 6.1.7601.17514).