Click here to Skip to main content

Submit your article

SQL Server

SQL-Server

Great Reads

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

Entity Framework: Storing Complex Properties as JSON Text in Database

by Jovan Popovic(MSFT)

Mapping properties in EF model to database columns that contain JSON

AJAX-enabled Name Selector User Control

by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

Create & Populate Time Dimension with 24 Hour+ Values

by Mubin M. Shaikh

Create time dimension with 24 hour plus values and time buckets in your data warehouse

Latest Articles

Using IDistributed Cache with EF Core

by Bert O Neill

In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.

Query Excel or CSV files with T-SQL

by Federico Di Marco

Query Excel or CSV files with T-SQL without importing them in a table first

SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)

by Bert O Neill

This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.

Reorganize and Rebuild Indexes and Update Statistics

by GabrieleTronchin

A simple stored procedure to add at your database to keep it reactive

All Articles

SQL Server

Entity Framework: Storing Complex Properties as JSON Text in Database

18 Jan 2017 by Jovan Popovic(MSFT)

Mapping properties in EF model to database columns that contain JSON

entity-framework

AJAX-enabled Name Selector User Control

24 Aug 2009 by Steve Krile

Fully AJAX-enabled user control used to select names from a database in a drop-down format.

SQL-Server-2005

How to Organize Clean Architecture to Modular Patterns in 10 Minutes

22 Oct 2017 by thangchung

Learn to organize clean architecture to modular patterns

Notification of Silverlight Applications about Database State Changes

27 Nov 2009 by Max Paulousky

This article presents the techniques and caveats of building Silverlight applications that can be notified about database state changes via polling duplex. WSHttp binding and CLR triggers are used to implement the solution as well.

SQL-Server-2005

Online Backgammon

19 Nov 2022 by KristianEkman

An online Angular, .NET 7 Web API, SQL Server on Azure backgammon game

Introduction to Model Driven Development with Sculpture – Part 1

3 Sep 2008 by Ahmed Negm

This article introduces how to create and manage .NET enterprise applications using your favorite technology (Data Access Application Block, LINQ, NHibernate, ASMX, and WCF) with the Model Driven Development approach by Sculpture.

SQL-Server-2005

SQLoogle - Part 1 of 2

16 May 2013 by dale.newman

Google your SQL.

The alxBase classes for work with DBF files

5 Nov 2002 by Alexey

The alxBase classes for work with dbf files.

Zip Rendering Extension for SQL Server Reporting Services 2005/2008/2012

14 Aug 2013 by Harmen Brouwer

How to create and deploy a SSRS rendering extension, explained by a functional Zip Rendering extension for SSRS 2005, 2008 (R2) and 2012.

SQL-Server-2008

SQL-Server-2005

CRM Customization - Import Leads from Excel via Email into MS CRM

6 Sep 2007 by aleksisa

Build a process to import Leads records from Excel into MS CRM via email.

SQL-Server-2005

SQL-server-2000

Learning Entity Framework (Day 4): Understanding Entity Framework Core and Code First Migrations in EF Core

9 Oct 2018 by Akhil Mittal

Entity framework core, code first migrations and data annotations in EF Core

entity-framework

Authenticate .NET Core Client of SQL Server with Integrated Security from Linux Docker Container

10 Jan 2019 by Andi Kleinbichler

Illustrates the implementation of a .NET Core app, running in a Linux container, connecting to a SQL Server database with integrated security.

SPA^2 using ASP.NET Core 1.1 + Angular 2.4 - Part 3

9 Mar 2017 by Robert_Dyball

Custom Code-Generator Using ASP.NET Core

1 May 2018 by Shashangka Shekhar

In this post, we will get an overview and generate a basic level code using our database table column that will help in development.

An Overview of Log Shipping in SQL Server 2005

25 Oct 2008 by Abhijit Jana

Overview of Log Shipping in SQL Server 2005

SQL-Server-2005

WCF by Example - Chapter VII - Decoupling of WCF Services from the ViewModel

11 Oct 2011 by Enrique Albert

Baseline WCF Distribution Layer - Decoupling of WCF Services and ViewModels.

SQL Server Express Edition on Steroids

13 Mar 2021 by Sergii Syrovatchenko

How to omit many restrictions on SQL Server Express Edition

Nullable datetime column in .NET DataGrid with DateTimePicker

17 Aug 2009 by vic_ch2000

A nullable datetime column in .NET DataGrid with DateTimePicker.

MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API

5 Nov 2018 by Jovan Popovic(MSFT)

Create powerful REST API with just few lines of C# code using MsSql.RestApi package

SQL-Server-2016

Dynamic Excel file loading with SSIS

23 Apr 2012 by Kuthuparakkal

SSIS and Excel Automation

SQL-Server-2008

EF Data Annotations and Code Fluent

17 Apr 2012 by Nadege Rouelle

Shows how to configure Entity Framework Code First with Data Annotations and Code Fluent.

entity-framework

Small Paging Control for Windows Presentation Foundation (WPF)

27 Jun 2012 by freedeveloper

A small control to control paging in Windows Presentation Foundation.

SQL-Server-2005

SQL Server Governor: The unknown hero

7 Sep 2012 by Shivprasad koirala

This article will discuss about SQL Server governer.

The Product Aggregate in T-SQL Versus the CLR

22 Feb 2013 by Scott Burkow

An exercise in algorithm analysis and design.

Combination of Id-ParentId and HierarchyId Approaches to Hierarchical Data

17 Jul 2017 by Vadim Loboda

Combine Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order

Asynchronous T-SQL Execution Without Service Broker

15 Sep 2008 by Oleg Vorkunov

Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.

SQL-Server-2005

DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation

31 Mar 2006 by Dan Radu

The DACBuilder application provides auto-generation features from multiple database systems in multiple programming languages.

Data Visualization in WPF with LINQ to SQL and Data Binding

21 Dec 2007 by Bruno Sonnino

This article will show how to use data binding and styles to show data coming from a Microsoft SQL database using the new object-relational model introduced in Visual Studio 2008, LINQ to SQL, allowing grouping, sorting and filtering of data with almost no code.

SQL-Server-2005

7 Sep 2009 by Tamer Oz

PocketPcAgent is an application that can be installed on Windows Mobile devices that are running Windows Mobile 5.0 or higher. The application listens to events such as SMS Received, Call Missed, E-Mail Received, Battery Strength Changed, and much more on the Pocket PC.

ASP.NET Web API - Keeping It Simple

25 Nov 2016 by kannankeril

This article is an attempt at splitting out the controller layer to reduce its complexity and improve quality and maintainability of the resulting code.

CSV to SQL Server

11 Jul 2023 by Igor Krupitsky

This application lets you copy tables from folder with CSV files to SQL Server

SQL Server CLR Functions

17 Jun 2009 by Sacha Barber

SQL Server CLR functions

Database script execution with test

3 Feb 2013 by S. M. Ahasan Habib

Database script execution with testing

LINQ to Entities, Cross Apply, and Left Outer Join

12 May 2017 by DaveDavidson

In this article, I show LINQ to Entities syntax that will produce queries with CROSS APPLY and LEFT OUTER JOIN clauses.

entity-framework

SQLXAgent - Jobs for SQL Express - Part 1 of 6

27 Feb 2018 by #realJSOP

Create and run jobs kinda like SQL Server Enterprise - Users Guide

Writing into a File from Database

4 Nov 2016 by Wendelius

Few CLR procedure concepts to write into a file from SQL Server database

The CODBCDynamic class

14 Mar 2000 by Tom Archer

A class to dynamically read data from any ODBC data source

Automatic Script SQL Server 2005 Objects and Commit under Subversion

9 Oct 2009 by Ferreri Gabriele (Megasoft78)

Automatic script SQL Server 2005 objects and commit under Subversion

WCF by Example - Chapter XIV - Validation & Exception Management

25 Oct 2012 by Enrique Albert

WPF Validation using the IDataErrorInfo interface combined with Validation attributes

SQL-Server-2005

Are Using Bitwise Operators for Table Joins Really Taboo?

26 Jul 2017 by Ed Wiebe

Can't we obtain the benefit of using bitwise operators for SQL many-to-many relationships AND maintain referential integrity?

SQL Server: Query to find upcoming birthdays for the current week

13 Sep 2012 by Wendelius

This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"

CODBCAccess: a CDatabase and CRecordset Wrapper

12 Mar 2003 by Alexander Wiseman

A class to wrap the use of CDatabase and CRecordset into one object to communicate with databases

Add "Select All" to parameter lists in SQL Reporting

9 Mar 2005 by Sven Cipido

How to add a "select all" option to your parameter lists in SQL Reporting.

SQL-server-2000

Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 4

27 Jul 2009 by Paul Rony

Programmer's Guide to Starting a Software Company and Building an Enterprise Application

Working with CLR Objects in SQL Server 2005 or Above Part 2

2 Aug 2009 by Abhishek Sur

Gives an introduction of how to create SQL CLR managed objects in SQL server.

SQL-Server-2005

A Palindrome Program in SSIS using Copy Column, Derived Column, Character Map and Conditional Split Transformation

27 Apr 2011 by Niladri_Biswas

This article will discuss about Copy Column, Derived Column, Character Map and Conditional Split Transformation in SSIS with a palindrome example.

SQL-Server-2008

Configuring SQL Server Accent-Insensitivity

21 Feb 2012 by Daniel Miller

This article describes the steps to re-configure SQL Server so that queries return accent-insensitive results. It includes source code (using Microsoft SQL Server 2008 R2 Shared Management Objects) to automate some of the steps in this procedure.

SQL-Server-2008

WPF SQL Replication Tool (Part 1)

4 Nov 2015 by Fred Song (Melbourne)

Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

Persisted Permutations

4 May 2004 by Daniel Aioanei, Adi Malinaru, Andrei Postolache

An article on how to persist permutations of items in relational databases.

SQL-server-2000

Retrieving and Storing Call History

19 Dec 2007 by Bryan Sachdeva

This article describes how to create a wrapper class for the native Phone API, and then uses it to retrieve and store the call history.

SQL-Server-2005

SQL-server-2000

Data Auditing Tool (Audit Trigger Generator)

28 Sep 2012 by J.Jash

Data Auditing Trigger Generator

reporting-services

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.

Indexed Views and How It Can Help in Improving Query Performance

23 Mar 2019 by Minh Tuan Do

A considerable method to speed up query running time

Entity Factory - Get Your ORM-less Freak On!

4 Nov 2021 by #realJSOP

A tool to generate model and viewmodel classes directly from your selected database

SQL Server JSON: Performance Cookbook

25 Jul 2021 by Sergii Syrovatchenko

Here's everything you need to know about high-performance JSON parsing for SQL Server

Exposing tabular data from your COM object - Part 2

28 Jul 2000 by Len Holgate

The ATL OLE DB Provider templates appear to rely on the fact that your data is kept in a simple array, but that's not really the case at all!

Armstrong Number Generation Within a Range (In SQL Server)

9 Jan 2010 by Niladri_Biswas

How to generate an Armstrong number between 0 and 999.

How to migrate DevExpress XAF SecuritySystemUser to PermissionPolicyUser

8 Nov 2016 by mblataric

Instructions on how to migrate existing XAF security system to new permission policy.

Call a Web Service using SSIS then Store and Query the Results

7 May 2017 by Michael Lockwood

How to call a web service using SSIS, store XML results and then query XML using XQuery

Versioning SQL Server Databases using SSDT

8 Apr 2013 by Shining Dragon

How to effectivley version your SQL Server databases using SQL Server Data Tools

T-SQL reporting engine

20 Jun 2013 by Levente Kupás

If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.

SQL-Server-2008

Streamline Log Shipping Failovers

29 Aug 2018 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.

SQL-Server-2008R2

SQL-Server-2012

SQL-Server-2014

SQL-Server-2016

Temporary Tables and Temporary Variables

31 May 2015 by Milan Matějka

Compare likenesses and differences between Temporary Tables and Temporary Variables

LEADTOOLS Recognition Imaging SDK: Create Imaging Apps Easily

8 Jun 2015 by Dirk_Strauss

LEADTOOLS Recognition Imaging SDK - I had the pleasure of taking the SDK for a spin, and let me tell you it was well worth it.

Real time Spreadsheet

27 May 2016 by Aless Alessio

Reat time Spreadsheet, updating and retrieving data through a Web Service. Using SQL Server DB.If two or more users are working on the same spreadsheet, they can see what the other users are doing. Mouse pointing is highlighted by filling the cell with diagonal stripes, while data saved is highlight

How to correlate IIS, Application and SQL Server Audit logs to achieve full stack audit.

5 Sep 2016 by Z Kavtaskin

Hello World Angular 2+ Data Sample Using JavaScriptServices .Net Core and PrimeNG

13 Mar 2017 by defwebserver

You can create database driven .Net Core applications using JavaScriptServices, and PrimeNG.

Paradox to SQL Server

19 Sep 2017 by Igor Krupitsky

Application lets you copy tables from Paradox to SQL Server

DBF to SQL Server

20 Nov 2019 by Igor Krupitsky

Application lets you copy tables from folder with DBF files to SQL Server

Accessing the Borland Database Engine (BDE) from Visual C++

17 Nov 1999 by Robert Pittenger, MCPD-EAD

Database info tool

26 Oct 2000 by Massimo Colurcio

Explore the structure of tables (and views)

SqlTimeSpan

30 Jul 2009 by Giovanni Bejarasco

Porting of System.TimeSpan as a SQL Server UDT.

SQL-Server-2008

SQL-Server-2005

Verify SQL Server Backup

21 Dec 2012 by mparvez

If you wanted to check the status of all your database backup then this script will do the task.

Keep everyone away from breaking your database object naming convention with SQL Server Policy Based Management.

19 Feb 2013 by Khorshed Alam, Dhaka

Standardization database object name with SQL Server Policy Based Management.

SQL-Server-2008

On-demand data population, custom paging, client-side sorting and other general functionality in GridView

4 Jul 2013 by Zafar Sultan

An article describing general functionality in GridView.

Facade to disparate databases

19 Sep 2013 by G3Coder

Details using an ORM model to provide a common facade to multiple disparate databases.

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

10 Feb 2016 by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

SQL-Server-2016

Lightswitch: Working with Views

18 Apr 2016 by Ankita Biswas Bhattacharya

Here, I will explain how you can work with SQL views in lightswitch and how you can save data on screens which are created on Views.

Sending Events from Azure Event Hub to Azure SQL Database using Azure Functions

7 Feb 2017 by Jovan Popovic(MSFT)

Making an Event Calendar for Trucking/Shipping with C# MVC and jQuery.Fullcalendar

10 Feb 2018 by Changming Wang

A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

The CAccessReports class

14 Mar 2000 by Tom Archer

A class for Printing and Viewing MS Access Reports

An OLE-DB DLL that you can use in ANSI-C

3 Jul 2002 by roboo

An OLE-DB DLL that you can use in ANSI-C

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.

SQL-Server-2005

SQL-server-2000

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

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

SQL-Server-2005

SQL-Server-2008

SQL-server-2000

Implementing Cumulative total and Select All functionality with Events in ASP.NET GridView

17 Dec 2012 by AshishChaudha

There are many scenarios in which the data can be bound in a Gridview, in which various operation other than provided by default by gridview needs to be implemented. In this article we will try to bind such operations with some more features.

Outlook add-in using VC++ ATL/COM

5 Feb 2013 by Gokulnath007

To get instant control over Outlook and various operations of outlook.

Modeling Supertypes and Subtypes: Part 3

24 Jun 2013 by Scott Burkow

We build the physical design from the logical design.

Job Match

31 Jul 2013 by apmyhr

Job Match helps job seekers find employment with the right company

System Availability Charts in SSRS

6 Nov 2013 by Sichen D

How to build system availability timeline in SSRS

Graphical Representation of Data in ASP.NET Web Page

24 Jun 2015 by Khaled Abdelhamid

Drawing on a web page on the fly using GDI+ and Flood-Fill Technique

SQL-Server-2008

Automatic Code Generation from Database Model Diagram

21 Feb 2016 by Abdullah Al-Muzahid

This is a RAD tool which can be used to generate codes for CRUD operation in ASP.NET and C# automatically based on Database Model Diagram.

code-generation

Data Version Control on MS SQL Server (using a generic trigger)

4 Oct 2016 by Martin Lachman

How to create a system on MS SQL Server for detection of actual changed records in a database table.

Restricting Logon to SQL Server

18 Oct 2016 by Wendelius

Discussion and a few approaches to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure

SQLXAgent - Jobs for SQL Express - Part 6 of 6

30 Sep 2017 by #realJSOP

Create and run jobs kinda like SQL Server Enterprise - Interesting Coding

HoopDream

17 Nov 2018 by Terence Wallace

A brief article on how to utilize NBA Stats API in a WinForm application

How to Migrate SQL Database to Azure SQL Database using SSMS Export/Import

19 Nov 2018 by Vivek Johari

Migrating SQL Database to Azure SQL Database using SSMS Export/Import Contents

Custom String Split Function with Few Enhancements

26 Dec 2018 by Wendelius

This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.

A Connection String Manager for Multi-Environment Ecosystems

9 Mar 2021 by #realJSOP

This library is intended for use in a multi-environment system, but it certainly be used under less stringent environmental confines, even down to a single desktop machine taht needs to connect to a single database server.

connectionstring

spSearchTables: Search and Find Tables or Columns by Name or Value

21 Nov 2023 by Federico Di Marco

spSearchTables: a helper T-SQL stored procedure for digging into (large) databases