Click here to Skip to main content
14,355,618 members


Great Reads

by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Mubin M. Shaikh
Create time dimension with 24 hour plus values and time buckets in your data warehouse
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.

Latest Articles

by Narapareddy Shyamprasad
SQL Dynamic Pivots
by Luca Astolfi
User defined procedure for make an HTML table from T-SQL Select statment
by JasonShort
Wouldn’t it be handy if you could use regular expressions (RegEx) in your SQL code?  You could do some really advanced queries through the ability to specify regular expressions rather than just the simple like % matching you normally use. SQL CLR can do that!
by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages

All Articles

Sort by Score


24 Aug 2009
Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
27 Nov 2009
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.
3 Sep 2008
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.
14 Aug 2013
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.
25 Oct 2008
Abhijit Jana
Overview of Log Shipping in SQL Server 2005
27 Jun 2012
A small control to control paging in Windows Presentation Foundation.
21 Dec 2007
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.
15 Sep 2008
Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
25 Oct 2012
Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
16 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
19 Dec 2007
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.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
17 Oct 2007
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.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
28 Sep 2010
Integrating database development into Visual Studio to collaborate application development team and the database designers
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
8 Aug 2012
This tip demonstrates how table data can be shared in two stored procedures.
8 Jan 2007
William Brewer
With SQL Server, it is strange how some of the most radical improvements that have been introduced over the years have been slipped in almost unnoticed.
31 Mar 2009
Explains how to do multi language reports in SSRS
26 Jul 2009
The article provides a simple interface for handling large text in SqlClient and C# file streams.
12 Jan 2014
Christian Graus
In this third installment, we look at how Common Table Expressions can simplify your SQL and help you perform complex tasks
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
12 Sep 2010
Renil Joy, Bangalore
Custom Rule Engine approach which can evaluate complex combinations of business rules. A sample application is provided in WPF following the MVVM pattern.
11 Jun 2011
Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
29 Oct 2008
Giovanni Bejarasco
A walkthrough in UDT programming with primary focus on database concepts.
19 Apr 2012
Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
6 Aug 2013
Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
29 Oct 2008
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.
24 Oct 2012
Enrique Albert
WCF service response message patterns
4 Feb 2009
C.L. Moffatt
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
26 Mar 2007
Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
30 Jan 2010
Bryan Thomas Weikel
LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier WinForms application.
12 May 2011
In this article we will learn creation of subreports, drilldown reports, custom coding and expression, web service and wcf service consumption frm SSRS,custom paging and sorting, working with databars and indicators with real time examples
9 Nov 2012
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.
3 Oct 2016
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.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
26 Jun 2008
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
30 Nov 2006
siva pinnaka
This article explains how to migrate data between different SQL Server environments.
18 Oct 2013
Brian C Hart
To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
14 Oct 2011
Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
12 Dec 2013
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
14 Jan 2013
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
7 Aug 2006
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
4 Oct 2009
Generate Word documents by appling XSLT on XML data.
29 Dec 2006
Hari Prasad K
The DMVs; newly introduced in SQL Server 2005 gives database administrator information about the current state of the SQL Server machine.
1 Aug 2008
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
8 Nov 2011
Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
20 May 2010
Shivprasad koirala
6 steps to implement DUAL security on WCF using User name + SSL
10 Dec 2008
Wael Alghool
Gathering of various algorithms into one library to transform Hierarchical trees between various formats, and allows them to be represented into SQL 2005, the formats supported are TreeView, Textual, Tabular, Modified Preorder Tree Traversal and Graphical.
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
11 Jun 2010
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
7 Jan 2010
A database-driven banner rotator control rotating based on a specific time (and not on page refresh). Each banner will have a display time (in seconds) to move to the next one.
14 Oct 2011
Enrique Albert
Unit of work pattern on NHibernate using repositories.
9 Dec 2010
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
20 Oct 2009
An article about unravelling a large database
11 Aug 2009
Tanzim Saqib
Turn your current static website or blog into a lifestreaming portal with all your social activities with ASP.NET 4.0, C# 4.0, PLINQ, Task Parallel Library, Dependency Injection, and plug-in architecture.
23 Jun 2008
This article describes how to create a slide-show user control with the help of the DataList control.
27 Mar 2009
Morshed Anwar
Implementing Audit Trail using Entity Framework's caching entries
19 Dec 2011
David Catriel
Creating a .NET trigger for SQL Server that will log (down to the field level) all changes made to tables.
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
21 Mar 2010
Md. Marufuzzaman
Few step(s) to remove SQL Server database user(s) when you are facing error like “The database principal owns a database role and cannot be dropped.” for dropping a user.
26 Jan 2010
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
4 Oct 2009
Overview of deployment techniques using example WSE 3 enabled solutions
23 Jan 2012
Dylan Morley
A WinForms UI using WCF services, Entity Framework, repository data access, repository caching, Unit of Work, Dependency Injection, and every other buzz work you can think of!
23 Aug 2010
Shivprasad koirala
VS 2010 Deployment (Package, One click deploy and Web.config transformation)
30 Jun 2008
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
6 Aug 2007
Omar Al Zabir
Learn about 13 production disasters that can bring down your business
8 Sep 2009
Muhammad Akhtar Shiekh
An artcile on End to End solution to optimized paging and sorting in ASP.NET GridView using Object Data Source.
23 Jan 2005
Colin Angus Mackay
Discusses various aspects of SQL Injection attacks, what to look for in your code, and how to secure it against SQL Injection attacks.
30 Jan 2008
Sam Shiles
A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005
14 Jan 2015
Helmut Obertanner
In this article, you will learn how to customize the built-in Select Names dialog and use different external data sources for your own dialog.
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
10 Jun 2011
Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
14 May 2012
Shivprasad koirala
An introduction to stack, heap, value types, reference types, boxing, and unboxing.
2 Jan 2010
Shakeel Iqbal
Manage your daily tasks and To-Do list using some exciting features of Windows 7.
27 Sep 2005
Mikael Håkansson
QueryCommander SQL editor with IntelliSense, wrapped in a Visual Studio type of environment. QueryCommander supports: Microsoft SQL Server 6.5-2005, MySQL 4.*-5.1, and Oracle 9i.
30 Dec 2007
Rama Krishna Vavilala
This article builds a web based message board and uses several new technologies introduced with Visual Studio 2008 such as LINQ, WCF Web Programming, WCF Syndication, ASP.NET ListView, ASP.NET DataPager etc.
27 Feb 2009
How to use LINQ to SQL in N-Tier architectures.
13 Apr 2009
How to do a sort on alphanumeric strings in SQL Server.
1 Sep 2016
SQL Server database project creation using Visual Studio 2013
17 Nov 2007
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
26 Jul 2008
Shakeel Iqbal
A powerful tool for rapid application development.
29 Jan 2009
Nitesh Maharaj
1 alternative  
How to create simple and advanced pivot tables in C# and ASP.NET
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
3 Jun 2006
Shabdar Ghata
Restore/backup selected objects in SQL Server.
8 May 2008
Danilo Corallo
An easy-to-use .NET solution for Job Scheduling with pluggable actions that runs on a Windows Service. Back up your SQL Server Express and much more!
22 Sep 2009
Nitin Chilka
An article on how to handle deadlock
28 Jul 2008
John Kenedy S.Kom
This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it
2 Nov 2015
Easily create Business and Data Layers!
8 Jan 2009
Paw Jershauge
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
7 Jan 2011
Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
29 Dec 2008
Introduces a methodology for authenticating user in cross domain/platform and transferring user data from one site to another during the authentication process.
5 Sep 2008
Niklas Henricson
Migrate MySQL to Microsoft SQL Server in just a few simple steps
28 Jul 2009
Abhijit Jana
Overview of Views, system Views, creation of Views, and binding and securing Views.
12 Feb 2009
We are going to build a simple web chat application using Silverlight 2 and the technologies surrounding it like, ASP.NET 3.5, C#, WCF, and LINQ-to-SQL. We will use MS SQL Server to store user details and messages from this chat room.
20 Nov 2005
Jason Witty
With the release of SQL Server 2005, Microsoft introduces the long overdue ROW_NUMBER() function. In this article, we will walk through a C# implementation of pagination using the ROW_NUMBER() method.
14 Aug 2012
Duong Ba Hong Minh
A good way to setup and install a multi-tree level structure by using a MS SQL Server database.
18 Dec 2010
Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
22 Mar 2013
Shubham Choudhary
OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.
4 Jul 2007
Padoor Shiras
Automated Windows DTS Package for SQL Server 2005 Database Backup
25 Oct 2006
Jürgen Bäurle
This article describes how to create Data Access Layer Components (DALC) using ASP.NET build providers and a self-defined description language in C#, including an easy scanner, parser, and CodeDOM generator.
19 Apr 2007
Frank Kerrigan
Using SQL Server to do paging of sql results.
13 Feb 2009
Sandeep Mewara
How to localize the SQL Server Reporting Services Reports
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
9 May 2007
Peter Weissbrod
This is the second part in a two-piece article focused on optimizing the efficiency of your NHibernate ORM layer.
20 Apr 2008
An article on a SQL IDE for different type of RDBMS databases
19 May 2011
In this article we will see how we can consume a web service expose through HTTP Endpoint via Web Service Task of SSIS
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
4 Nov 2006
Uwe Keim
An application to manage support request with tickets and events
23 Nov 2010
Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
11 May 2006
Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
22 Aug 2007
Brady Kelly
An application that seeks to emulate the F4 object search function from Query Analyser
9 Sep 2009
Virat Kothari
CLR Stored Procedures can be efficiently implemented in an n-tier architecture.
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
8 Sep 2006
This paper demonstrates an extensible mass emailing framework (Smart Mass Email SME). The demo implementation uses cutting edge .NET technologies available today such as C#, .NET 2.0, Microsoft® SQL Server 2005 Service Broker, MS Provider Pattern, Enterprise Library January 2006 etc.
22 Dec 2011
Uwe Keim
An application that helps you in starting tasks at predefined times and with various dependencies.
26 Apr 2008
Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
11 Oct 2009
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
12 Jan 2007
Mark J. Miller
Defining (rather loosely) ad hoc queries as SQL commands built as strings by an SQL client application and submitted to SQL Server.
4 Apr 2006
Salvatore Vetro
The art of swap from a database to another changing a flag
19 May 2007
Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
12 Mar 2014
Christian Graus
The second in my series digs in to some of the different things you can do within a select statement.
28 Sep 2005
Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
17 Oct 2009
T-SQL script to generate the document of SQL 2000/2005 database
17 Aug 2009
P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
26 Jul 2008
Ali Daneshmandi
Creating a CLR Persian date convertor function for SQL Server.
5 Nov 2010
Enrique Albert
Introducing the RepositoryLocator pattern.
18 Apr 2005
Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
13 Dec 2008
Steve Abraham
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
25 Mar 2008
Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
17 Aug 2010
Shivprasad koirala
.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
28 May 2007
Dmitry Tsuranoff
Determining SQL Server performance for temporary tables and and table variables.
16 Aug 2012
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.
5 Jan 2005
Teo Lachev
Introducing Microsoft Reporting Services.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
20 Dec 2008
T MacLachlan
SQL Mirroring made easy - setting up a mirror for a database
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
12 May 2011
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
16 May 2013
Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
31 Oct 2008
Todd Smith
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery, and JSON.
22 May 2006
Jeff Modzel
How to create your own ASP.NET 2.0 custom resource provider to replace resource files (resx) with SQL Server.
25 May 2008
Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
9 Aug 2009
Wael R. Mansour
Convert numbers to characters for Arabic applications.
21 Feb 2005
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
14 Sep 2006
How to use the ASP.NET 2.0 ReportViewer control in Local mode.
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
13 Feb 2007
Vlad Hrybok
This article describes how to run DotNetNuke content management system on UltiDev Cassini web server, which unlike IIS can run on Windows XP Home and can be redistributed along with the DotNetNuke applications.
18 May 2008
A wizard that allows you to FTP an application to a remote server and then launch the configuration wizard from the web browser to update the database connection.
28 Feb 2009
Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
18 Dec 2008
Mycroft Holmes
A workaround for the limitation of only being able to pivot one column.
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
4 Mar 2007
Mark J. Miller
Understanding how the SQL Server and CLR security models work together to keep your database secure
14 Sep 2012
Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
6 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
30 Oct 2008
Mohamed Abdelghani
How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005
11 Dec 2007
Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
17 Aug 2018
Narapareddy Shyamprasad
SQL Dynamic Pivots
19 Aug 2008
The article explains how to fetch data from Microsoft Analysis Services 2005 (OLAP) Cube using ADOMD.NET and MDX, and display it in the form of a grid.
19 Mar 2008
Dennis Betten
Export all tables and data to an Excel file.
3 Jul 2007
Steve Abraham
This article is an introduction to the SQL Server Virtual Device Interface and how to access it via any .NET language
10 Feb 2009
A VBScript script which allows to script out all the SQL Server objects in each independent file
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
15 Oct 2010
Sohail Maroof, Farrukh Hashmi
Exception handling in 3-Tier Architecture using Enterprise Library
5 Jan 2008
Mustafa Ismail Mustafa
An alternative approach to blogging engines
8 Dec 2008
Anas Karkoukli
A new implementation of the Custom Profile Provider for ASP.NET 3.5, using LINQ, Workflow Foundation, and the Responsibility-Centric-Singleton DataContexts pattern.
4 Oct 2013
Mubin M. Shaikh
Auto Monitoring On Schema Change within Database in SQL Server and Email Alert
6 Apr 2010
Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
28 Aug 2008
Muhammad Shujaat Siddiqi
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
25 Oct 2008
Mohamed Zaki
This custom UI Action for SharePoint extends the lists action menu to allow users to zip document library items and download all of them with or without version.
16 Oct 2006
Sean Goodpasture
An article describing a way to find the differences between two database instances
12 Jan 2014
Christian Graus
In which we talk of ways to pass an arbitrary list of values to SQL Server
12 Dec 2006
This article provides a step-by-step demo on how to create drill-through reports in local mode using SQL Server 2005, Microsoft Application Blocks, and the ReportViewer control in ASP.NET 2.0.
28 Jan 2006
Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
18 Jul 2007
Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
30 Oct 2009
Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
14 Sep 2008
Steven A. Lowe
Dashboards are immensely useful not only for business data but also for business applications, but only if they display metrics that can be used to "drive" (or "steer") in real-time.
13 Feb 2006
A handy command line tool that checks whether stored procedures, views and functions in a database compile
6 May 2008
Igor Krupitsky
Unlike Date Dimension (with Year, Month, Date), Time Dimension (with Hour, Minutes, and Seconds) is not automatically created by SSAS (Microsoft SQL Server Analysis Services). This article explains how to create and use Time Dimension in Microsoft SQL Server Analysis Services.