Click here to Skip to main content
15,115,411 members
Everything / Database Development / SQL Server / SQL Server 2005

SQL Server 2005

SQL-Server-2005

Great Reads

by Wonde Tadesse
This tip/trick helps to set a default value for blob data type such as Image, VarBinary.
by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
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

SQL Server 2005 

Please Sign up or sign in to vote.
24 Aug 2009
Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
6 Sep 2007
aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
Please Sign up or sign in to vote.
25 Oct 2008
Abhijit Jana
Overview of Log Shipping in SQL Server 2005
Please Sign up or sign in to vote.
27 Jun 2012
freedeveloper
A small control to control paging in Windows Presentation Foundation.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
15 Sep 2008
Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
Please Sign up or sign in to vote.
25 Oct 2012
Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
Please Sign up or sign in to vote.
2 Aug 2009
Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Jul 2009
Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
28 Aug 2012
akhil khare
Find multiple strings (delimenated by space) in all selected columns.
Please Sign up or sign in to vote.
27 Sep 2010
venugopalm
Integrating database development into Visual Studio to collaborate application development team and the database designers
Please Sign up or sign in to vote.
1 May 2012
Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
Please Sign up or sign in to vote.
7 Aug 2012
ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
Please Sign up or sign in to vote.
31 Mar 2009
BobP1339
Explains how to do multi language reports in SSRS
Please Sign up or sign in to vote.
26 Jul 2009
AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
7 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.
Please Sign up or sign in to vote.
17 Dec 2007
mfmaneef
Explains how to send bulk records to a database using OPENXML.
Please Sign up or sign in to vote.
29 Apr 2009
Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
Please Sign up or sign in to vote.
27 Apr 2009
Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
Please Sign up or sign in to vote.
11 Jan 2010
Divan van der Watt
Column search functionality that works as easy as sp_help.
Please Sign up or sign in to vote.
11 Oct 2011
KP Lee
Specific example for improving some SQL performance problems
3 Feb 2006
Redgate Software
Essential tools for easy migration to SQL Server 2005.
2 May 2006
Petr Palas
This article compares various approaches to storing, editing, and displaying structured content on the web. It shows the advantages and disadvantages of using XML and relational SQL databases.
30 Jun 2006
Redgate Software
SQL Dependency Tracker allows you to graphically visualize database object dependencies. This means that users can track down potential "collateral damage" before pushing database changes through. With this ingeniously simple to use tool, you can also document database dependencies.
1 Nov 2006
Redgate Software
This article describes how you can use SQL Refactor to sharpen up your T-SQL.
7 Nov 2006
Daniel Wood
Learn how changing the way you write queries can make them run faster. This article will describe the automated approach to optimizing SQL. DBA's have been doing it for years, now it's available for developers.
7 Dec 2006
James Westgate
Use an agile managed database framework, and feel you've finally reached programming heaven.
21 Dec 2006
Redgate Software
Database professionals have a special role in their workplace because they bear responsibility for customer database integrity. This article argues that the 'online' or 'lock ladder' database development model, which uses live instances is the only way to ensure true database integrity.
7 Jan 2007
Robyn Page
Some seemingly simple requirements such as getting the DATETIME for the "start of the month" can be surprisingly tricky.
10 Apr 2007
Petr Palas
Do you spend days and nights developing dynamic web sites in ASP.NET? Do you need to simplify your job, get more sites done and gain more clients? Kentico CMS for .NET will help you.
15 Jun 2007
Atanu Banerjee
A composite application is a collection of software assets assembled to provide a business capability. These assets can be deployed independently, enable composition, and leverage specific platform capabilities. Microsoft Office's comprehensive platform for this is Office Business Applications (OBA)
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
16 Jan 2014
Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
Please Sign up or sign in to vote.
11 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.
Please Sign up or sign in to vote.
11 Jun 2011
Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
Please Sign up or sign in to vote.
19 Apr 2012
Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
Please Sign up or sign in to vote.
6 Aug 2013
Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
Please Sign up or sign in to vote.
21 Jan 2014
Christian Graus
A description of the best way to create tally tables, and how to use them
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
24 Oct 2012
Enrique Albert
WCF service response message patterns
Please Sign up or sign in to vote.
3 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.
Please Sign up or sign in to vote.
25 Jul 2009
Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
Please Sign up or sign in to vote.
26 Mar 2007
Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
Please Sign up or sign in to vote.
30 Jan 2010
Bryan Thomas Weikel
LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier WinForms application.
Please Sign up or sign in to vote.
12 May 2011
Niladri_Biswas
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
Please Sign up or sign in to vote.
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!
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
19 Aug 2009
Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
Please Sign up or sign in to vote.
26 Jun 2008
johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
Please Sign up or sign in to vote.
30 Nov 2006
siva pinnaka
This article explains how to migrate data between different SQL Server environments.
Please Sign up or sign in to vote.
13 Jan 2013
liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
Please Sign up or sign in to vote.
14 Oct 2011
Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
Please Sign up or sign in to vote.
12 Dec 2013
Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
Please Sign up or sign in to vote.
7 Aug 2006
craigd
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
Please Sign up or sign in to vote.
4 Oct 2009
lepipele
Generate Word documents by appling XSLT on XML data.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
1 Aug 2008
Jammer
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Jul 2010
Md. Marufuzzaman
Overview of SQL server stored procedure
Please Sign up or sign in to vote.
15 Jun 2009
Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
Please Sign up or sign in to vote.
11 Jun 2010
theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
Please Sign up or sign in to vote.
7 Jan 2010
hussain.attiya
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.
Please Sign up or sign in to vote.
14 Oct 2011
Enrique Albert
Unit of work pattern on NHibernate using repositories.
Please Sign up or sign in to vote.
9 Dec 2010
AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
Please Sign up or sign in to vote.
20 Oct 2009
trantrum
An article about unravelling a large database
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
23 Jun 2008
Samir NIGAM
This article describes how to create a slide-show user control with the help of the DataList control.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
24 Feb 2017
Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
Please Sign up or sign in to vote.
25 Aug 2009
Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
Please Sign up or sign in to vote.
20 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.
Please Sign up or sign in to vote.
26 Jan 2010
BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
Please Sign up or sign in to vote.
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!
Please Sign up or sign in to vote.
30 Jun 2008
junnark
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
30 Jan 2008
Sam Shiles
A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Sep 2009
Md. Marufuzzaman
A simple example of SQL server admin tools.
Please Sign up or sign in to vote.
4 Oct 2009
lepipele
Overview of deployment techniques using example WSE 3 enabled solutions
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
Please Sign up or sign in to vote.
29 Apr 2009
Kamran Hazari
How to create Linked servers in a minute in an easy way
Please Sign up or sign in to vote.
9 Jun 2011
Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
Please Sign up or sign in to vote.
6 Aug 2007
Omar Al Zabir
Learn about 13 production disasters that can bring down your business
Please Sign up or sign in to vote.
1 Jan 2010
Shakeel Iqbal
Manage your daily tasks and To-Do list using some exciting features of Windows 7.
Please Sign up or sign in to vote.
28 Mar 2013
Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
27 Feb 2009
emad_awad
How to use LINQ to SQL in N-Tier architectures.
Please Sign up or sign in to vote.
13 Apr 2009
shteff
How to do a sort on alphanumeric strings in SQL Server.
Please Sign up or sign in to vote.
1 Sep 2016
NaibedyaKar
SQL Server database project creation using Visual Studio 2013
Please Sign up or sign in to vote.
17 Nov 2007
pinaldave
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
Please Sign up or sign in to vote.
26 Jul 2008
Shakeel Iqbal
A powerful tool for rapid application development.
Please Sign up or sign in to vote.
29 Jan 2009
Nitesh Maharaj
1 alternative  
How to create simple and advanced pivot tables in C# and ASP.NET
Please Sign up or sign in to vote.
3 Jun 2006
Shabdar Ghata
Restore/backup selected objects in SQL Server.
Please Sign up or sign in to vote.
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!
Please Sign up or sign in to vote.
4 Sep 2013
Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
Please Sign up or sign in to vote.
22 Sep 2009
Nitin Chilka
An article on how to handle deadlock
Please Sign up or sign in to vote.
3 Sep 2008
pinaldave
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
Please Sign up or sign in to vote.
2 Nov 2015
icemanind
Easily create Business and Data Layers!
Please Sign up or sign in to vote.
8 Jan 2009
Paw Jershauge
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
Please Sign up or sign in to vote.
7 Jan 2011
Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
Please Sign up or sign in to vote.
29 Dec 2008
Tomz_KV
Introduces a methodology for authenticating user in cross domain/platform and transferring user data from one site to another during the authentication process.
Please Sign up or sign in to vote.
5 Sep 2008
Niklas Henricson
Migrate MySQL to Microsoft SQL Server in just a few simple steps
Please Sign up or sign in to vote.
28 Jul 2009
Abhijit Jana
Overview of Views, system Views, creation of Views, and binding and securing Views.
Please Sign up or sign in to vote.
12 Feb 2009
junnark
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
18 Dec 2010
Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
Please Sign up or sign in to vote.
4 Jul 2007
Padoor Shiras
Automated Windows DTS Package for SQL Server 2005 Database Backup
Please Sign up or sign in to vote.
24 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.
Please Sign up or sign in to vote.
19 Apr 2007
Frank Kerrigan
Using SQL Server to do paging of sql results.
Please Sign up or sign in to vote.
13 Feb 2009
Sandeep Mewara
How to localize the SQL Server Reporting Services Reports
Please Sign up or sign in to vote.
29 Jul 2009
Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
20 Apr 2008
gan.gary
An article on a SQL IDE for different type of RDBMS databases
Please Sign up or sign in to vote.
6 Jan 2014
Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
Please Sign up or sign in to vote.
4 Nov 2006
Uwe Keim
An application to manage support request with tickets and events
Please Sign up or sign in to vote.
23 Nov 2010
Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
Please Sign up or sign in to vote.
11 May 2006
Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
Please Sign up or sign in to vote.
22 Aug 2007
Brady Kelly
An application that seeks to emulate the F4 object search function from Query Analyser
Please Sign up or sign in to vote.
9 Sep 2009
Virat Kothari
CLR Stored Procedures can be efficiently implemented in an n-tier architecture.
Please Sign up or sign in to vote.
11 Jan 2012
Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
Please Sign up or sign in to vote.
7 Sep 2006
Shahed.Khan
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.
Please Sign up or sign in to vote.
21 Dec 2011
Uwe Keim
An application that helps you in starting tasks at predefined times and with various dependencies.
Please Sign up or sign in to vote.
26 Apr 2008
Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
11 Oct 2009
db_developer
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
Please Sign up or sign in to vote.
22 Sep 2009
Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
Please Sign up or sign in to vote.
4 Apr 2006
Salvatore Vetro
The art of swap from a database to another changing a flag
Please Sign up or sign in to vote.
19 May 2007
Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
28 Sep 2005
Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
Please Sign up or sign in to vote.
17 Oct 2009
Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
Please Sign up or sign in to vote.
17 Aug 2009
P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
Please Sign up or sign in to vote.
26 Jul 2008
Ali Daneshmandi
CLR Function for Persian Date Converter in Microsoft SQL Server
Please Sign up or sign in to vote.
5 Nov 2010
Enrique Albert
Introducing the RepositoryLocator pattern.
Please Sign up or sign in to vote.
17 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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
25 Mar 2008
Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
Please Sign up or sign in to vote.
28 May 2007
Dmitry Tsuranoff
Determining SQL Server performance for temporary tables and and table variables.
Please Sign up or sign in to vote.
5 Jan 2005
Teo Lachev
Introducing Microsoft Reporting Services.
Please Sign up or sign in to vote.
26 Jul 2009
Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
Please Sign up or sign in to vote.
20 Dec 2008
T MacLachlan
SQL Mirroring made easy - setting up a mirror for a database
Please Sign up or sign in to vote.
23 Jan 2014
Christian Graus
A discussion of ways to create random number sequences in SQL Server
Please Sign up or sign in to vote.
11 May 2011
Niladri_Biswas
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
Please Sign up or sign in to vote.
16 May 2013
Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
25 May 2008
Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
Please Sign up or sign in to vote.
9 Aug 2009
Wael R. Mansour
Convert numbers to characters for Arabic applications.
Please Sign up or sign in to vote.
21 Feb 2005
Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
Please Sign up or sign in to vote.
14 Sep 2006
ShirleySW
How to use the ASP.NET 2.0 ReportViewer control in Local mode.
Please Sign up or sign in to vote.
2 May 2013
Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
18 May 2008
defwebserver
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.
Please Sign up or sign in to vote.
28 Feb 2009
Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
Please Sign up or sign in to vote.
18 Dec 2008
Mycroft Holmes
A workaround for the limitation of only being able to pivot one column.
Please Sign up or sign in to vote.
17 Mar 2008
Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
4 Mar 2007
Mark J. Miller
Understanding how the SQL Server and CLR security models work together to keep your database secure
Please Sign up or sign in to vote.
14 Sep 2012
Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
Please Sign up or sign in to vote.
5 Jan 2013
Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
Please Sign up or sign in to vote.
30 Oct 2008
Mohamed Abdelghani
How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005
Please Sign up or sign in to vote.
11 Dec 2007
Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
Please Sign up or sign in to vote.
16 Aug 2018
Narapareddy Shyamprasad
SQL Dynamic Pivots
Please Sign up or sign in to vote.
19 Aug 2008
khatri.hitesh
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.
Please Sign up or sign in to vote.
15 Apr 2008
Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
Please Sign up or sign in to vote.
19 Mar 2008
Dennis Betten
Export all tables and data to an Excel file.
Please Sign up or sign in to vote.
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
Please Sign up or sign in to vote.
10 Feb 2009
ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
Please Sign up or sign in to vote.
9 Aug 2009
Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
Please Sign up or sign in to vote.
2 Oct 2008
Andrew J Dixon
Explaining Database deadlocking to non-technical people
Please Sign up or sign in to vote.
15 Oct 2010
Sohail Maroof, Farrukh Hashmi
Exception handling in 3-Tier Architecture using Enterprise Library
Please Sign up or sign in to vote.
4 Jan 2008
Mustafa Ismail Mustafa
An alternative approach to blogging engines
Please Sign up or sign in to vote.
31 Oct 2008
Todd Smith
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery, and JSON.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
4 Oct 2013
Mubin M. Shaikh
Auto Monitoring On Schema Change within Database in SQL Server and Email Alert
Please Sign up or sign in to vote.
19 May 2011
Niladri_Biswas
In this article we will see how we can consume a web service expose through HTTP Endpoint via Web Service Task of SSIS
Please Sign up or sign in to vote.
30 Oct 2009
Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
Please Sign up or sign in to vote.
6 Apr 2010
Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
Please Sign up or sign in to vote.
28 Aug 2008
Muhammad Shujaat Siddiqi
shujaatsiddiqi.blogspot.com
Please Sign up or sign in to vote.
19 Sep 2009
Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
16 Oct 2006
Sean Goodpasture
An article describing a way to find the differences between two database instances
Please Sign up or sign in to vote.
12 Dec 2006
ShirleySW
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.
Please Sign up or sign in to vote.
27 Jan 2006
Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
Please Sign up or sign in to vote.
17 Jul 2007
Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
13 Feb 2006
IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
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.
Please Sign up or sign in to vote.
15 Oct 2007
Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
Please Sign up or sign in to vote.
21 Aug 2007
Lorenzo Consegni
This article extends Leonardo Salvatore's project using the Web Service Software Factory
Please Sign up or sign in to vote.
19 Jul 2006
Dan Radu
This article describes how to efficiently store and access tree structures in a SQL Server database, and how to use them in OLAP implementations.
Please Sign up or sign in to vote.
12 Dec 2006
ShirleySW
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.
Please Sign up or sign in to vote.
3 Sep 2008
Mohammad Al Hoss
This article shows how to import Excel files to SQL Server dynamically.
Please Sign up or sign in to vote.
23 Jan 2008
Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
Please Sign up or sign in to vote.
15 Feb 2007
Ben Allfree
Learn how to store data with a version history.
Please Sign up or sign in to vote.
7 Aug 2009
Md. Marufuzzaman
Overview of SQL Server database Triggers
Please Sign up or sign in to vote.
6 Nov 2007
Navdeep Bhardwaj
Concatenate field values in one string using CTE in SQL Server.
Please Sign up or sign in to vote.
28 Jun 2006
Not Active
Using SQL Server 2005 and SqlDependency to keep your application's data updated.
Please Sign up or sign in to vote.
22 Mar 2006
Michael Vanhoutte
This article explains how to give a user the minimum rights required for SqlDependency to work
Please Sign up or sign in to vote.
27 Nov 2013
S. M. Ahasan Habib
In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
Please Sign up or sign in to vote.
21 Jan 2008
Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
Please Sign up or sign in to vote.
8 Jun 2008
Evaldas Jocys
Provides required tables and data for multilanguage projects
Please Sign up or sign in to vote.
22 Sep 2009
Niladri_Biswas
Access multiple databases by a single SSRS report.
Please Sign up or sign in to vote.
4 Oct 2009
Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
Please Sign up or sign in to vote.
13 Jan 2014
Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
Please Sign up or sign in to vote.
19 Sep 2013
Shivprasad koirala
Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).
Please Sign up or sign in to vote.
4 Jun 2006
r.stropek
SSIS has a built in function for loops. In this blog article, I want to demonstrate how to use SSIS's Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e.g. name, language, version, etc.) about them.
Please Sign up or sign in to vote.
16 Nov 2009
Uwe Keim
A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules
Please Sign up or sign in to vote.
3 Mar 2006
Declan Brennan
Extending the RichTextBox to support form persistance and data binding.
Please Sign up or sign in to vote.
21 May 2012
Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
Please Sign up or sign in to vote.
8 Nov 2007
John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
Please Sign up or sign in to vote.
17 Jun 2007
Geek2Simon
A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)
Please Sign up or sign in to vote.
11 Jun 2008
Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
Please Sign up or sign in to vote.
17 Mar 2009
junnark
In Part 1, we built a simple web chat using Silverlight 2. We are going to add functionalities so that users are able to choose from multiple chat rooms as well as chat privately with other users.
Please Sign up or sign in to vote.
18 Mar 2008
Jason Witty
In this article I walk through an example that binds a gridview control to an ObjectDataSource and uses Linq queries to paginate to achieve true data pagination.
Please Sign up or sign in to vote.
22 May 2009
Md. Marufuzzaman
An easy technique to store any file into SQL database
Please Sign up or sign in to vote.
17 Sep 2008
santosh poojari
This article demonstrate the step by step procedure to create SSIS Package and Execute the same using ASP.net
Please Sign up or sign in to vote.
10 Sep 2004
Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
Please Sign up or sign in to vote.
5 Apr 2006
Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.