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.

SQL

XML

Windows

dbase

SQL-Server

DBA

Using Oracle SQL Developer to Connect to MySQL/Mariadb Databases

29 Jun 2017 by Alvin Bunk

How to use Oracle SQL Developer to connect to MySQL/Mariadb databases

SQL

WCF

Troubleshooting SQL Code Using Comments

3 Feb 2018 by Alvin Bunk

How to troubleshoot SQL code using comments

SQL

WCF

Adding Items in Comma-separated String into Separate Rows in SQL Server

2 May 2013 by Amogh Natu

This post shows how to insert a comma-separated string into multiple rows in a table in SQL Server.

New Features for Database Developers in SQL Server 2012: Simpler Paging, Sequences and FileTables

20 Aug 2012 by Andrei Ion Rînea

Simpler paging, sequences and FileTables in SQL Server 2012

SQL

SQL-Server

Random Performance Findings

20 Aug 2012 by Andrei Ion Rînea

Some performance tips

OUTPUT Clause in UPDATE Statements

20 Aug 2012 by Andrei Ion Rînea

OUTPUT clause in UPDATE statements

SQL

Cartesian join for numbers

12 May 2011 by Andrew Zwicker

An example of using a Cartesian [cross] join.

SQL

Dev

DBA

Is there a better way?

12 May 2011 by Andrew Zwicker

Do you find yourself or others doing repetitive tasks? The solution – automate if possible.

SQL

Dev

Preventing Duplicates in the Data

16 May 2011 by Andrew Zwicker

How to prevent duplicates in the data

SQL

data

database

Where to put the logic? SQL? Code?

19 May 2011 by Andrew Zwicker

The decision of where to put logic isn’t always clear cut.

SQL

Dev

Forum Fun: Running Calculation SQL

22 May 2011 by Andrew Zwicker

A discussion about a forum post for handling a running subtraction in a SQL query.

SQL

Dev

SQL Joins and Subqueries

23 May 2011 by Andrew Zwicker

A discussion about SQL joins and subqueries with information about how to format join statements properly

SQL

database

Efficiency of Subqueries and OR conditions in SQL

25 May 2011 by Andrew Zwicker

A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.

SQL

database

Using Views for Faster SQL Query Development

29 May 2011 by Andrew Zwicker

A discussion of how views give a more denormalized means for querying against normalized tables.

SQL

SQL Query Run Time Estimation

31 May 2011 by Andrew Zwicker

SQL Query run time estimation

SQL

Avoiding OR Conditions with Joins

4 Jun 2011 by Andrew Zwicker

Why OR conditions in join statements should be avoided and an example fix

SQL

Dev

DBA

Database Table Documentation with a Data Dictionary

10 Jun 2011 by Andrew Zwicker

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

Database Documentation with a Data Dictionary - Part 2

13 Jun 2011 by Andrew Zwicker

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

Replacing Cursors with Set-Based SQL Queries – Part 2

22 Jul 2011 by Andrew Zwicker

This is part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.

SQL

Replacing Cursors with Set-Based SQL Queries – Part 1

22 Jul 2011 by Andrew Zwicker

How to replace cursors with set-based SQL queries - Part 1

SQL

Test Cases Statistics with SSRS and TFS Data Warehouse

26 Apr 2015 by Anton Angelov

Tutorial how to create test cases statistics for the automation status and their distribution by priority. Steps how to setup SSRS and TFS Data Warehose.

SSRS SQL Server Reporting Services- Subscriptions for Reports

4 Jun 2015 by Anton Angelov

Tutorial on how to set up an email subscription for reports generated in SSRS (SQL Server Reporting Services). Step by step explanations with a lot of images.

SQL

WCF

SQL Fast GUID List Generator

27 Jun 2009 by Anton Burtsev

The article shows how one can use Microsoft SQL Server to generate millions of guids in seconds.

SQL

SQL. Fast GUID List Generator

30 Aug 2017 by Anton Burtsev

If you want your database to be fast with a huge amount of data, you should test it with large test database.

SQL

A Complete Tutorial to Connect Android with ASP.NET Core Web API

21 Jul 2021 by Aram Tchekrekjian

In this tutorial, we will learn how to connect Android with ASP.NET Core Web API.

Apply JWT Access Tokens and Refresh Tokens in ASP.NET Core Web API 6

17 Feb 2022 by Aram Tchekrekjian

How to apply JWT Access Tokens and Refresh Tokens in ASP.NET Core Web API 6

Decoding Django Sessions in PostgreSQL

24 Mar 2021 by Arctype SQL

When solving a problem that requires you to link a user's session data to their actual user object, Postgres comes in handy.

SQL

Django

Postgres Notify for Real Time Dashboards

24 Mar 2021 by Arctype SQL

Using pg_notify in Postgres alongside the NOTIFY and LISTEN syntax is all that's needed to build a real time updating dashboard

SQL

PostgreSQL

A Complete Guide to UUIDs in PostgreSQL

24 Mar 2021 by Arctype SQL

Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.

SQL

PostgreSQL

Anatomy of a PostgreSQL Query Plan

9 Apr 2021 by Arctype SQL

Explanation of how a query gets execution and understanding the EXPLAIN command

Collaborative Filtering in MySQL: A Tutorial

22 Apr 2021 by Arctype SQL

Simple examples of collaborative filtering with fundamental logic behind all of these systems boiling down to same principles used here

How I Learned to Stop Worrying and Love NULL in SQL

22 Apr 2021 by Arctype SQL

Write your query in a way to overcome the limitations of NULL rather than avoid using it.

SQL

Using Cursors and for Loops in MySQL

19 Nov 2021 by Arctype SQL

Learn how to write a MySQL cursor or a MySQL loop

SQL

MySQL

Need a UUID Generator for Postgres? Here are Two Ways to Set One Up.

1 Dec 2021 by Arctype SQL

In this article, you'll learn about Postgres UUIDs and how to generate them with examples from two different modules.

SQL

PostgreSQL

Deploy and Manage PostgreSQL on Kubernetes

31 Mar 2021 by Arctype SQL

Easily deploy PostgreSQL pod in Kubernetes

Data Replication for DBMS using the Commit Log

24 Jul 2021 by Arctype SQL

As a business expands, the need to ethically leverage data is not a luxury anymore, but a necessity.

SQL

architecture

SQL Bulk Copy from DataTable using XML

30 Jun 2015 by Arkadeep De

SQL bulk copy from DataTable using XML

SQL

WCF

SQL Server – What Exactly is COALESCE Function?

20 Jan 2014 by Arun Ramachandran India

What exactly is COALESCE function in SQL Server?

SQL

Windows

server

ADO.NET – What is Meant by SQL Injection Attack?

10 Feb 2014 by Arun Ramachandran India

ADO.NET - What is meant by SQL injection attack?

SQL

WCF

SQL Server – How to Write Stored Procedures With Output Parameters?

9 Jul 2014 by Arun Ramachandran India

How to write stored procedures with output parameters in SQL Server

SQL

server

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 3

12 Jan 2012 by atverma

This is the third post of this series.

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4

24 Jan 2012 by atverma

Utility to Generate Word Documents from Templates Using Visual Studio 2010 and Open XML 2.0 SDK - Part 4

Merge Statement in SQL Server 2008

21 May 2013 by Basavaraj P Biradar

The new Merge statement in SQL Server 2008.

Difference Between SET QUOTED_IDENTIFIERS ON and OFF settings

21 May 2013 by Basavaraj P Biradar

Difference between SET QUOTED_IDENTIFIERS ON and OFF settings.

SQL

Best Practice Front-end Architecture using Microsoft ASP.NET MVC and Rivets.js

28 May 2014 by Ben Liebert

Best practice front-end architecture using Microsoft ASP.NET MVC and Rivet.js

Best Practice Front-end Architecture Using Microsoft ASP.NET MVC and Rivets.js

30 May 2014 by Ben Liebert

Best practice front-end architecture using Microsoft ASP.NET MVC and Rivets.js

An Introduction to Bitronix JTA Transaction Manager with MySQL

6 Jan 2011 by Bikash Shaw

An Introduction to Bitronix JTA Transaction Manager with MySQL

SQL

Java

All-Topics

Processing SQL Server FILESTREAM Data - Part 1

21 Sep 2014 by Bob McGowan

Processing SQL Server FILESTREAM Data - Part 1

Processing SQL Server FILESTREAM Data: Part 3 - Creating Tables

24 Sep 2014 by Bob McGowan

Utilizing SQL Server FILESTREAM capabilities from .NET

Did I Say I Wanted to Start Debugging? Huh? Did I?

7 Oct 2017 by Brady Kelly

Making F5 execute your query

SQL

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

17 Aug 2012 by Bryan O'Connell

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

Using LINQ to SQL for ETL projects

20 Jun 2013 by Bryan O'Connell

Using LINQ to SQL for ETL projects.

Three-tier .NET Application Utilizing Three ORM Technologies

23 Dec 2009 by Bryan Thomas Weikel

CodeProject"LEK" is a three-tier .NET WinForms accounting application that can be configured at run time to use either LINQ to SQL, Entity Framework or NHibernate to access data in either a "main" or "testing" SQL Server database.

Cross-Tabulation (Pivot Tables) with MySQL

10 Apr 2012 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.

Demystify LocalDB in ASP.NET with sqlcmd

18 Jan 2016 by Camilo Reyes

Demystify LocalDB in ASP.NET with sqlcmd

SQL

ASP.NET

Programming for Date Ranges

25 Sep 2009 by Charles Boyung

How to program for date ranges

SQL

Windows

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

30 Mar 2011 by Chris_Green

Programmatically unlock a user

Row-Level Security in Azure SQL with Entity Framework

15 Feb 2016 by Craig Pickles

Row-Level Security in Azure SQL with entity framework

SQL

security

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

31 Dec 2011 by Dave C Andrews

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

How to Use Computed or Calculated Columns

3 Jan 2012 by Dave C Andrews

You can have your tables make computations themselves, without running through a view.

SQL

Dev

Conditional Sums in SQL Aggregate Methods

5 Jan 2012 by Dave C Andrews

Count the records in a table which are of a certain type.

SQL

Dev

How to Join Multiple Columns with Linq To SQL

27 Jan 2012 by Dave C Andrews

How to join multiple columns with Linq to SQL

SQL

LINQ

Learn Docker by building a Microservice

19 Apr 2016 by Dave Kerr

If you are looking to get your hands dirty and learn all about Docker, then look no further!

SQL

Node.js

docker

Generic Functions to Generate INSERT, UPDATE & DELETE Oracle SQL Query

28 May 2014 by Debopam Pal

This example shows how you can generate INSERT, UPDATE & DELETE SQL Query for Oracle DB.

SQL

Run SQL Script (.sql) Containing DDL, DML, SELECT Statements & PL/SQL Block through Reader in Java

30 Jul 2014 by Debopam Pal

How to run SQL script containing DDL, DML, Select statements and PL/SQL block through reader in Java

SQL

WCF

SSIS Do I Union All or Merge??

28 Mar 2014 by derekman9707

SSIS - Do I Union All or Merge?

SQL

All-Topics

A SQL Cmdlet a Day 2 Piping and Select

5 Apr 2014 by derekman9707

A SQL Cmdlet a Day 2 Piping and Select

SQL

It’s Simple!! Or Pseudo Simple Anyway

10 Sep 2014 by derekman9707

Pseudo-simple recovery model

SQL

DBA

What are the Different Types of Database Backups?

14 Sep 2014 by derekman9707

Different types of database backups

All About SSIS Variables Part 3 Variable Assignment

26 Sep 2014 by derekman9707

This post discusses about variable value assignment in SSIS.

SQL

SSIS

Some Hidden Facts: Stored Procedure and Its Optimization

9 Jul 2011 by Dinesh K Mandal

Some Hidden Facts about Stored Procedure and Its Optimization

Usage of @@Error within a transaction

29 Jan 2013 by DiscoverSQL

Using @@Error within a transaction.

SQL

Angular and .NET Core Web API Starter Application

2 Nov 2020 by DotNetLead.com

Angular/.NET Core Web API application that can be used as the starting point for building your applications.

Deploying Full Stack ASP.NET Core with API and SQL Server Databases to Docker Containers

1 Dec 2022 by DotNetLead.com

Deploy existing ASP.NET Core UI, API, and SQL Server to Docker containers

Inside a 'LINQ to SQL classes' file

6 Dec 2009 by Duy H. Thai

Explore the essence of an 'LTS classes' file, the classes it generates, and how it connects the object model to the database model...

Video Games Statistics Using Web API 2 and SQL Server Reporting Services

15 Jun 2015 by Eduardo Fonseca

Video Games Statistics Using Web API 2 and SQL Server Reporting Services

SQL

WCF

Using SQL Compact for Integration Tests with Entity Framework

7 Jan 2013 by eric hexter

How to use SQL Compact for Integration Tests with Entity Framework

SQL

Missing Server side dependencies - Problems and Solutions

7 Sep 2011 by Eric Xue (brokensnow)

Missing Server side dependencies - Problems and Solutions

SQL

Windows

SharePoint User Profile Export from the UserProfile Database

7 Sep 2011 by Eric Xue (brokensnow)

Extracting the entire UserProfile AD user details into a CSV file

SQL

Windows

Dev

Check And Upgrade Existing Database

7 Sep 2010 by Ernest Poletaev

How to change database schema, add or delete a field or table, be sure that new version of application will work correctly and existing users will not lose their data

SQL

All-Topics

Get Ready to Learn SQL: 11. Database Third Normal Form Explained in Simple English

3 Nov 2014 by essentialSQL

Database Third Normal Form explained in simple English

SQL

normalization

database

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

21 Oct 2014 by essentialSQL

Database Second Normal Form explained in simple English

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

21 Oct 2014 by essentialSQL

Database First Normal Form explained in simple English

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

22 Oct 2014 by essentialSQL

How to combine table rows using UNION in SQL Server

SQL

DBA

database

Get Ready to Learn SQL Server: 14. Introduction to Outer Joins

22 Oct 2014 by essentialSQL

Introduction to Outer Joins in SQL Server

SQL

dbase

SQL-Server

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

22 Oct 2014 by essentialSQL

Introduction to Inner Joins in SQL Server

SQL

SQL-Server

DBA

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

22 Oct 2014 by essentialSQL

Introduction to database joins in SQL

SQL

DBA

Get Ready to Learn SQL: 8. Database Normalization Explained in Simple English

22 Oct 2014 by essentialSQL

Database normalization in SQL explained in simple English

SQL

normalization

database

Get Ready to Learn SQL: 7. Simplified Data Modeling

23 Oct 2014 by essentialSQL

Simplified Data Modeling in SQL

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

23 Oct 2014 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: 6. How to Group and Summarize your Results

23 Oct 2014 by essentialSQL

How to Group and Summarize your Results in SQL

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