Click here to Skip to main content
15,498,398 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 

24 Aug 2009 by Steve Krile
Fully AJAX-enabled user control used to select names from a database in a drop-down format.
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.
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.
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.
6 Sep 2007 by aleksisa
Build a process to import Leads records from Excel into MS CRM via email.
25 Oct 2008 by Abhijit Jana
Overview of Log Shipping in SQL Server 2005
27 Jun 2012 by freedeveloper
A small control to control paging in Windows Presentation Foundation.
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.
15 Sep 2008 by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
25 Oct 2012 by Enrique Albert
WPF Validation using the IDataErrorInfo interface combined with Validation attributes
2 Aug 2009 by Abhishek Sur
Gives an introduction of how to create SQL CLR managed objects in SQL server.
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.
30 Jul 2009 by Giovanni Bejarasco
Porting of System.TimeSpan as a SQL Server UDT.
17 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.
28 Aug 2012 by akhil khare
Find multiple strings (delimenated by space) in all selected columns.
27 Sep 2010 by venugopalm
Integrating database development into Visual Studio to collaborate application development team and the database designers
1 May 2012 by Jean-Francois Lanouette
This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"
7 Aug 2012 by ManojKumar19
This tip demonstrates how table data can be shared in two stored procedures.
31 Mar 2009 by BobP1339
Explains how to do multi language reports in SSRS
26 Jul 2009 by AlexS9999
The article provides a simple interface for handling large text in SqlClient and C# file streams.
7 Jan 2007 by 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.
17 Dec 2007 by mfmaneef
Explains how to send bulk records to a database using OPENXML.
29 Apr 2009 by Raspberry Man
How to make custom datasource for CrystalReports engine using push model and .NET
27 Apr 2009 by Aneesur Rehman Khan
Consume 32 bit COM DLL in x64 bit SQL Server 2005
11 Jan 2010 by Divan van der Watt
Column search functionality that works as easy as sp_help.
11 Oct 2011 by KP Lee
Specific example for improving some SQL performance problems
3 Feb 2006 by Redgate Software
Essential tools for easy migration to SQL Server 2005.
2 May 2006 by 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 by 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 by Redgate Software
This article describes how you can use SQL Refactor to sharpen up your T-SQL.
7 Nov 2006 by 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 by James Westgate
Use an agile managed database framework, and feel you've finally reached programming heaven.
21 Dec 2006 by 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 by Robyn Page
Some seemingly simple requirements such as getting the DATETIME for the "start of the month" can be surprisingly tricky.
10 Apr 2007 by 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 by 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)
12 Jan 2014 by 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 by Christian Graus
Discussion on pivot and other ways to turn columns of data in to rows in SQL Server
11 Sep 2010 by 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 by Omar Al Zabir
Building High Performance Queue in Database for storing Orders, Notifications, Tasks
19 Apr 2012 by Sacha Barber
A look at designing a service layer using good practices, and the MSFT technology stack.
6 Aug 2013 by Michiel du Toit
Explaining and demonstrating the use of the APPLY keyword for SQL Server
21 Jan 2014 by Christian Graus
A description of the best way to create tally tables, and how to use them
29 Oct 2008 by 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 by Enrique Albert
WCF service response message patterns
3 Feb 2009 by 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 by Md. Marufuzzaman
This article will demonstrate the procedure to shrink the database transaction log.
26 Mar 2007 by Wojtek Jeziorczak
How to send/receive MSMQ messages in SQL Server using CLR Integration
30 Jan 2010 by Bryan Thomas Weikel
LINQ to SQL, Entity Framework, and NHibernate used in a parallel fashion in a three-tier WinForms application.
12 May 2011 by 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
18 Oct 2013 by 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!
9 Nov 2012 by 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 by 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.
30 Nov 2006 by siva pinnaka
This article explains how to migrate data between different SQL Server environments.
19 Aug 2009 by Md. Marufuzzaman
A list of Global variables in SQL Server and their uses in Transact-SQL
26 Jun 2008 by johnnycantcode
Create and manage your mobile database using SQL Management Studio and export them to SQL Compact Edition databases
13 Jan 2013 by liron.levi
A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB
14 Oct 2011 by Enrique Albert
How to use Spring.Net DI reducing coupling and enhancing automated testing.
12 Dec 2013 by Nirosh
Architecting a Windows Forms based system on top of a framework. This will help you develop a form based application faster.
7 Aug 2006 by craigd
Save your database diagrams *outside* the database in a Transact-SQL text file, for backup and/or source-control.
4 Oct 2009 by lepipele
Generate Word documents by appling XSLT on XML data.
29 Dec 2006 by 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 by Jammer
An article detailing with the odd problems and solutions to using SQL Compact 3.5 in desktop applications.
8 Nov 2011 by Kanasz Robert
This article is about library for scripting SQL Server database objects and examples representing how this library can be used.
10 Dec 2008 by 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.
13 Jul 2010 by Md. Marufuzzaman
Overview of SQL server stored procedure
15 Jun 2009 by Md. Marufuzzaman
This article will demonstrate how we can integrate T-SQL with an external application.
11 Jun 2010 by theit8514
This class will allow you to asynchronously backup a database while also getting progress, message, and error notifications.
7 Jan 2010 by 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.
14 Oct 2011 by Enrique Albert
Unit of work pattern on NHibernate using repositories.
9 Dec 2010 by AnupKumarYadav
Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)
20 Oct 2009 by trantrum
An article about unravelling a large database
11 Aug 2009 by 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 by Samir NIGAM
This article describes how to create a slide-show user control with the help of the DataList control.
19 Dec 2011 by 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 by Ebenezar John Paul
An Ideal Code Review Checklist that applies for most programming languages
25 Aug 2009 by Md. Marufuzzaman
Basic overview of SQL Server 2005/2008 Table Indexing
20 Mar 2010 by 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 by BackyardHackMechanic
Describes how to get more control over the XML output when using the FOR XML AUTO statement. For instance, when adding XML tags.
23 Jan 2012 by 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!
30 Jun 2008 by junnark
We will create a very simple web chat application using the latest ASP.Net 3.5 technologies from scratch.
8 Sep 2009 by 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 by 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 by Sam Shiles
A step by step guide to communicating with WCF from a CLR Trigger in SQL Server 2005
14 Jan 2015 by 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 by Md. Marufuzzaman
A simple example of SQL server admin tools.
4 Oct 2009 by lepipele
Overview of deployment techniques using example WSE 3 enabled solutions
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to split a string using Transact-SQL.
29 Apr 2009 by Kamran Hazari
How to create Linked servers in a minute in an easy way
9 Jun 2011 by Md. Marufuzzaman
How to create your first SQL Server Integration Services (SSIS) package - part 1
6 Aug 2007 by Omar Al Zabir
Learn about 13 production disasters that can bring down your business
1 Jan 2010 by Shakeel Iqbal
Manage your daily tasks and To-Do list using some exciting features of Windows 7.
28 Mar 2013 by Khorshed Alam, Dhaka
How to execute multiple long running SQL Statement Asynchronously in smaller chunks
27 Sep 2005 by 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 by 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 by emad_awad
How to use LINQ to SQL in N-Tier architectures.
13 Apr 2009 by shteff
How to do a sort on alphanumeric strings in SQL Server.
1 Sep 2016 by NaibedyaKar
SQL Server database project creation using Visual Studio 2013
17 Nov 2007 by pinaldave
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard
26 Jul 2008 by Shakeel Iqbal
A powerful tool for rapid application development.
29 Jan 2009 by Nitesh Maharaj
How to create simple and advanced pivot tables in C# and ASP.NET
3 Jun 2006 by Shabdar Ghata
Restore/backup selected objects in SQL Server.
8 May 2008 by 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!
4 Sep 2013 by Mubin M. Shaikh
This article shows how to create and populate date dimension for data warehouse.
22 Sep 2009 by Nitin Chilka
An article on how to handle deadlock
3 Sep 2008 by pinaldave
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
2 Nov 2015 by icemanind
Easily create Business and Data Layers!
8 Jan 2009 by Paw Jershauge
Generate class shells from SQL Server database tables, (SQL 2005 & 2008 only). Output languages supported: C# and VB.NET.
7 Jan 2011 by Enrique Albert
Development of parent/child relationships across application layers - also AutoMapper, a WPF custom converter, and WPF shutdown.
29 Dec 2008 by 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.
5 Sep 2008 by Niklas Henricson
Migrate MySQL to Microsoft SQL Server in just a few simple steps
28 Jul 2009 by Abhijit Jana
Overview of Views, system Views, creation of Views, and binding and securing Views.
12 Feb 2009 by 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.
20 Nov 2005 by 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 by 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 by Enrique Albert
In-proc WCF testing, dynamic client proxies, WCF Request context extension, and WCF client async commands.
4 Jul 2007 by Padoor Shiras
Automated Windows DTS Package for SQL Server 2005 Database Backup
24 Oct 2006 by 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 by Frank Kerrigan
Using SQL Server to do paging of sql results.
13 Feb 2009 by Sandeep Mewara
How to localize the SQL Server Reporting Services Reports
29 Jul 2009 by Md. Marufuzzaman
This article will demonstrate the best practice to protect SQL server code object.
9 May 2007 by 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 by gan.gary
An article on a SQL IDE for different type of RDBMS databases
6 Jan 2014 by Christian Graus
Just a quick explanation of why it's not always a good idea to use DISTINCT
4 Nov 2006 by Uwe Keim
An application to manage support request with tickets and events
23 Nov 2010 by Adam Nachman
Provides a framework for predictably compiling, extracting, and deploying a database project.
11 May 2006 by Bernard Ho-Jim
Extending the Personal Web site Starter kit by implementing efficient data paging to the Photo Gallery.
22 Aug 2007 by Brady Kelly
An application that seeks to emulate the F4 object search function from Query Analyser
9 Sep 2009 by Virat Kothari
CLR Stored Procedures can be efficiently implemented in an n-tier architecture.
11 Jan 2012 by Venkat Chaitanya Kanumukula
T-SQL Code for Converting Stored Procedure results to Tables Dynamically
7 Sep 2006 by 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.
14 Jul 2014 by Misha1964
Learn how to validate complex web forms using business rules engine
21 Dec 2011 by Uwe Keim
An application that helps you in starting tasks at predefined times and with various dependencies.
26 Apr 2008 by Sudipta Chaudhari
This article gives a brief introduction about Triggers in SQL Server 2000/2005.
12 Jan 2007 by 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.
11 Oct 2009 by db_developer
describes how to create SQL Wrapper for Regular Expressions using SQL Server CLR Integration
22 Sep 2009 by Abhijit Jana
Basic overview of temporary Tables in SQL Server 2005
4 Apr 2006 by Salvatore Vetro
The art of swap from a database to another changing a flag
19 May 2007 by Moim Hossain
Describes SQL server 2005 Integration Service object model and different data flow components
12 Mar 2014 by 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 by Akram Hussein
An article on distributed messaging using Service Broker in SQL Server 2005.
17 Oct 2009 by Nitinpatel
T-SQL script to generate the document of SQL 2000/2005 database
17 Aug 2009 by P. Ganesh Kumar
Helps in assigning row numbers in the returned result of an SQL query
26 Jul 2008 by Ali Daneshmandi
CLR Function for Persian Date Converter in Microsoft SQL Server
5 Nov 2010 by Enrique Albert
Introducing the RepositoryLocator pattern.
17 Apr 2005 by Gael Fraiteur
If you want to tune your SQL statements, you need to understand how the server executes them. The article explains this.
27 Sep 2010 by psined
Introduction to Boomerang Framework
13 Dec 2008 by 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 by Matt Sollars
Overcoming challenges with LINQ to SQL and using LINQ with SQL Server Compact Edition.
28 May 2007 by Dmitry Tsuranoff
Determining SQL Server performance for temporary tables and and table variables.
5 Jan 2005 by Teo Lachev
Introducing Microsoft Reporting Services.
26 Jul 2009 by Md. Marufuzzaman
An easy way to get a list of extended storedProcedure allowed to you for common use
20 Dec 2008 by T MacLachlan
SQL Mirroring made easy - setting up a mirror for a database
23 Jan 2014 by Christian Graus
A discussion of ways to create random number sequences in SQL Server
11 May 2011 by Niladri_Biswas
This article will help in understanding the myraid ways of report creation, deployment and invocation of report from various client applications
16 May 2013 by Peter Hancock
Using NAnt and CruiseControl.NET to continuously integrate database changes
22 May 2006 by 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 by Ahmed IG
A Simple GUI Tool for SQL 2005 Reports deployment without using BI Development Studio
9 Aug 2009 by Wael R. Mansour
Convert numbers to characters for Arabic applications.
21 Feb 2005 by Alon_Catz
This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.
14 Sep 2006 by ShirleySW
How to use the ASP.NET 2.0 ReportViewer control in Local mode.
2 May 2013 by Koray Dakan, PMP
DBMapper - A new ORM tool for vendor-neutral solutions
13 Feb 2007 by 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 by 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.
26 Aug 2009 by Andy_L_J
Generate unique column values using UDFs and Stored Procedures
28 Feb 2009 by Igor Krupitsky
This article explains how to do Market Basket Analysis in SSAS 2005 (Microsoft SQL Analysis Services).
18 Dec 2008 by Mycroft Holmes
A workaround for the limitation of only being able to pivot one column.
17 Jan 2014 by Mubin M. Shaikh
Learn Custom MDX Query Step by Step
17 Mar 2008 by Shabdar Ghata
A Windows application to backup and restore SQL server tables,views,user defined functions and stored procedures
28 Jul 2008 by John Kenedy S.Kom
This project enables developer to create a setup package that automatically installs SQL 2005 Express and restores database to it
4 Mar 2007 by Mark J. Miller
Understanding how the SQL Server and CLR security models work together to keep your database secure
14 Sep 2012 by Harry von Borstel
How to use SqlDependency to refresh Entity Framework Object Sets automatically on DB changes
5 Jan 2013 by Vimalsoft(Pty) Ltd
Coding an N-Tier application in C# without using Wizards.
30 Oct 2008 by Mohamed Abdelghani
How to add custom code and custom assemblies to reports in SQL Server Reporting Services 2005
11 Dec 2007 by Danilo Mendez
Describes how to generate NHibernate objects and ASPX pages using Smart Code
16 Aug 2018 by Narapareddy Shyamprasad
SQL Dynamic Pivots
19 Aug 2008 by 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.
15 Apr 2008 by Ali Hamdar
How we can access the Windows Indexing Service using OLEDB.
19 Mar 2008 by Dennis Betten
Export all tables and data to an Excel file.
3 Jul 2007 by 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 by ozkary
A VBScript script which allows to script out all the SQL Server objects in each independent file
9 Aug 2009 by Md. Marufuzzaman
This article will demonstrate how to get a file name or a file extension as well using Transact-SQL.
2 Oct 2008 by Andrew J Dixon
Explaining Database deadlocking to non-technical people
15 Oct 2010 by Sohail Maroof, Farrukh Hashmi
Exception handling in 3-Tier Architecture using Enterprise Library
4 Jan 2008 by Mustafa Ismail Mustafa
An alternative approach to blogging engines
31 Oct 2008 by Todd Smith
How to create an ASP.NET MVC sample using LINQ to SQL, Flexigrid for JQuery, and JSON.
8 Dec 2008 by 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 by Mubin M. Shaikh
Auto Monitoring On Schema Change within Database in SQL Server and Email Alert
19 May 2011 by 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
6 May 2008 by 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.
30 Oct 2009 by Ramy Mahrous
How to deploy your reports programmatically in away like BIDS
6 Apr 2010 by Ayman M. El-Hattab
Four reasons to directly query SharePoint logging database
28 Aug 2008 by Muhammad Shujaat Siddiqi
shujaatsiddiqi.blogspot.com
19 Sep 2009 by Paul Rony
A Programmer's Guide to Starting a Software Company and Building an Enterprise Application
25 Oct 2008 by 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 by Sean Goodpasture
An article describing a way to find the differences between two database instances
12 Dec 2006 by 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.
27 Jan 2006 by Bahrudin Hrnjica
Putting and retrieving images files to and from a database, via ADO.
17 Jul 2007 by Matt Perdeck
Shows how to add a Crystal Reports report to an ASP.NET page, with grouping, filtering, and drill down.
14 Sep 2008 by 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 by IPC2000
A handy command line tool that checks whether stored procedures, views and functions in a database compile
16 Aug 2012 by 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.
15 Oct 2007 by Thanh Huu Nguyen (Tony)
Look up a huge list of stock symbols from MS SQL database
21 Aug 2007 by Lorenzo Consegni
This article extends Leonardo Salvatore's project using the Web Service Software Factory
19 Jul 2006 by 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.
15 Feb 2007 by Ben Allfree
Learn how to store data with a version history.
12 Dec 2006 by 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.
3 Sep 2008 by Mohammad Al Hoss
This article shows how to import Excel files to SQL Server dynamically.
23 Jan 2008 by Muigai Mwaura
LINQ to SQL Transformation: Open Source implementation of IQueryable, examples and source code
27 Sep 2010 by venugopalm
A guided tour of the distributed enterprise application design in .NET
7 Aug 2009 by Md. Marufuzzaman
Overview of SQL Server database Triggers
28 Jun 2006 by Not Active
Using SQL Server 2005 and SqlDependency to keep your application's data updated.
6 Nov 2007 by Navdeep Bhardwaj
Concatenate field values in one string using CTE in SQL Server.
22 Mar 2006 by Michael Vanhoutte
This article explains how to give a user the minimum rights required for SqlDependency to work
15 Nov 2010 by venugopalm
Database and Library Design for Customer Order Management System
27 Nov 2013 by 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.
21 Jan 2008 by Sajid.Majeed
This article will address tools and technologies to identify bottlenecks and key consideration points for performance improvement.
8 Jun 2008 by Evaldas Jocys
Provides required tables and data for multilanguage projects
22 Sep 2009 by Niladri_Biswas
Access multiple databases by a single SSRS report.
4 Oct 2009 by Shaun Wilde
Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.
13 Jan 2014 by Christian Graus
A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012
19 Sep 2013 by Shivprasad koirala
Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).
4 Jun 2006 by 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.
16 Nov 2009 by Uwe Keim
A small console application that helps you in verifying whether your backups succeed by checking files and folders with various configurable rules
3 Mar 2006 by Declan Brennan
Extending the RichTextBox to support form persistance and data binding.
21 May 2012 by Zimin Max Yang
An approach to improve LINQ-to-SQL performance while preserving maintainability over DataReader.
8 Nov 2007 by John-ph
This article shows different methods of implementing Dynamic WHERE-Clause in static SQL.
17 Jun 2007 by Geek2Simon
A free, mean and lean way to create data driven PDF on the fly by using SQL server reporting service (SSRS)
11 Jun 2008 by Jimmy Zhang
Introduces a simple, efficient, human-readable XML index called VTD+XML.
17 Mar 2009 by 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.
18 Mar 2008 by 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.
22 May 2009 by Md. Marufuzzaman
An easy technique to store any file into SQL database
17 Sep 2008 by santosh poojari
This article demonstrate the step by step procedure to create SSIS Package and Execute the same using ASP.net
10 Sep 2004 by Mark Brandon
A helper object library to automate migration of SQL RS items from development to production servers.
5 Apr 2006 by Dwight Johnson
Save hours of time by creating stored procedures and code from database metadata.
19 Jun 2013 by Mayank Dubey
XQuery basics.
20 Jul 2007 by Johan Sassner
An addin to Sql Server Management studio that lets you configure keybindings
16 Dec 2011 by perels
An efficient implementation of paging using a Repeater and the OVER() keyword in SQL Server 2005.
5 Dec 2011 by snp157
Controlling IP traffic from Internet to DMZ or Intranet
25 Nov 2005 by Tommi G
How to create runtime backups from SQL Server 2005 and restore them.
3 Aug 2009 by senguptaamlan
This article and code sample briefly describe the creation of User Defined Function in SQL Server 2005 by using CLR Hosting Feature
23 May 2012 by Cristhian Selah
Perform a conversion in a select, view, and Stored Procedure.
26 Nov 2012 by Ashrafur Rahaman
This article will give you an overview of how to use an ASP.NET GridView completely, and how to use RowEditing, RowUpdating, RowDeleting, RowCommand, RowDataBound, RowCancelingEdit, and Pagination in a DataGrid. From this article, you will have a clear view of GridView data inserting, deleting, and
10 Dec 2007 by Le Sourcier
How to use LINQ to SQL
23 Nov 2007 by adambl
Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors
24 Oct 2012 by Enrique Albert
Generic transaction and exception manager for server side services
19 Aug 2009 by Md. Marufuzzaman
This article will give you an idea about how to use CASE expression in T-SQL or as a formula of a particular column.
18 May 2006 by Dimitar Madjarov
How to use a WebService as a data source to build a report with Microsoft Reporting Services 2005.
20 Nov 2007 by BoneSoft
Describes a method for loading data objects using SQL Server 2005's new FOR XML PATH mode and XML serialization.
16 Jan 2008 by Bryan Avery
I will take you through how to deploy your own Custom Data Process Extension for SQL Server Reporting Server 2005, both on the server and for use within your development environment.
28 Jun 2008 by Simon Gulliver
A lighweight approach to creating AJAX.NET-enabled grids, with advanced functionality built in.
11 Oct 2011 by GraemeKMiller
This article explains how you can use IWA to improve your Users' experience and it also explains how it benefits your IT support team.
16 Jul 2009 by Shivprasad koirala
Tips to improve your LINQ query performance.
27 May 2016 by icemanind
How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database
10 Feb 2011 by KarthikAnbarasan
Part 1 of a series of articles on SQL Server Integration Services - teaches the basics of SSIS and shows how to create packages
12 Oct 2007 by Vincent-Philippe Lauzon
Using XML data types in SQL Server 2005, we can pass an array of values from an application server to the database.
23 Apr 2009 by krysstof
Tool developped to manage and analyse disk space on multiple fileserver in my company
5 Apr 2010 by Indrajeet Sutar
All about SQL Indexes - Query Optimizer, Index, Unique Index, Clustered Index, Full Text Index, XML Index and SQL commands to create, delete, and rename SQL indexes.
15 Jan 2012 by Venkat Chaitanya Kanumukula
Export SQL Server Tables to Excel Files Dynamically
8 Mar 2006 by Brian Bayless
A central key manager for multiple web server clients in a web farm.
19 Sep 2005 by msalmank
A quick hands-on application to guide you in using paneled forms, multi-splash screens, SQL Express, and many more....
1 Feb 2006 by rajiv404
Query Notification in SQL Server 2005 solves the problem of having to maintain a polling database to get the updated data. The new notification service of SQL Server 2005 can perform this amazing task of notifying a .NET code when any DML operations are performed to a specified table.
20 Sep 2006 by subai
An article on how to create user defined data types using .NET languages for SQL Server 2005.
30 Jun 2009 by mohamad halabi
Shows how to build new-design distributed applications with WF 4.0 and Data Services.
20 Jul 2009 by Md. Marufuzzaman
How many records are there in your database?
19 Jul 2009 by Shivprasad koirala
How to handle concurrency in LINQ to SQL?
5 Jul 2009 by david.ribeiro
Developing and invoking RDLC reports without the Reporting Services Server.
25 Apr 2009 by yairrose
Active directory tool - helps manage active directory oparations (query, update and delete) with easy to use GUI
25 May 2006 by Jeff Modzel
Learn how to load and execute a SQL Server 2005 Integration Services package from C# code
3 May 2007 by Pete O'Hanlon
These articles are on prioritizing and improving query performance in SQL Server.
29 Feb 2008 by Evaldas Jocys
How to create and compile SQL XML Documentation comments
30 Apr 2012 by DLM@TD
How SQL Server deletes records
4 Sep 2006 by DDarren
This article provides step-by-step instructions on how to integrate a MS Reporting Services report into an ASP.NET web application using the ReportViewer control. It also includes an HTML template than can be used for the layout and tackles a couple of known problems with the ReportViewer control.
14 Mar 2014 by Christian Graus
In this installment, I talk about working with dates and date functions in SQL Server
1 Jun 2005 by Alexander Shirshov
Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.
5 Jun 2007 by Fadrian Sudaman
This article shows how to easily extend the GridView to support custom paging and remove the restriction of using ObjectDataSource as the data source.
16 Apr 2007 by Bassam Saoud
A Custom TreeView Control that supports auto binding from a single self referencing table
31 Dec 2008 by kvlcek
A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.
25 Mar 2009 by Behrouz Rad
The most advanced things which you can do with GridView in ASP.NET 3.5
14 Sep 2006 by salysle
This article describes an easy approach to examining all of the tables, views, and columns in a database.
23 Oct 2013 by Eduard Keilholz
A quick help for storing images in SQL Server and displaying them on a ASP.NET Website
7 Apr 2008 by Simon Bonello
How to call a Web Service from a SQL Integration Services package.
7 Sep 2007 by Lorenzo Consegni
This article extends Leonardo Salvatore's project "A GPS tracer application for Windows Mobile CE 5" using the Web Service Software Factory. It shows how to create a robust solution for storing the path on a DB server, using Web Services and SQL
28 Jul 2011 by Sachin Somanath Mumbare
Custom control for display client formatted text in Crystal report
29 Apr 2011 by anrorathod
A sample application for beginner users who want to start the Linq implementation in ASP.NET
11 Jul 2006 by Andrew Timberlake-Newell
Demonstrates how to configure a DataGridView control to automatically store edits to bound datasets into the source database.
12 Dec 2006 by 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.
26 Feb 2009 by Lindsey Lewis
An article about a tool for comparing SQL database schema versions
15 Feb 2007 by Mark Bible
Information relevant to installing and configuring Microsoft Visual Studio Team Foundation Server for users who require Secure Sockets Layer (SSL) access over the commercial internet with Basic Authentication in a single-server scenario
11 Jun 2005 by Klaus Salchner (Canada)
Describes how you can link SQL Server with many different data sources like a directory as Active Directory Application Mode, a Microsoft Indexing Server catalog, a Microsoft Access database and a Microsoft Excel spreadsheet. Also explains how to query linked servers using the OPENQUERY command.
28 Aug 2013 by Software Developer's Journal
The goal of this article is to present elements of security in SQL Server such as: restrictive access to the server, blocking and safe configuration of services, and reduction of attack space for new elements. Techniques for creating and managing users and for securing data are illustrated.
27 Jun 2007 by Moim Hossain
Describes how to develop custom business portal application using WSS 3.0 and Office SharePoint Server 2007
20 Jun 2008 by JustChiragPatel
No need to create web service for SSIS package call
18 Jan 2010 by ZHAOBING_NTU
A dynamic Flash chart that can commnunication with your database.
7 Nov 2009 by Max Paulousky
This article presents the techniques and caveats of building Silverlight business applications. It describes breaking down applications into tiers, implementing a data access in N-tier applications, implementing a custom authentication, adding a support of https to Ria Services applications.
23 Aug 2008 by Muhammad Shujaat Siddiqi
Defining SQL Server Alerts (shujaatsiddiqi.blogspot.com)
24 Mar 2009 by Matt Bowman
How to change the angle of the first slice of a Pie chart in SSRS 2005.
27 Oct 2009 by hussain.attiya
DEVELOPING SSIS to import oracle records to sql server
23 Jul 2012 by Scott G Blood
A Cancellable threaded query for SQL Server using .net 3.5
31 Dec 2008 by BobP1339
How to use a script component as a data source for multi-result set Stored Procedures.
2 Oct 2013 by George Ziady
This is an alternative for "Measurement Unit Conversion Library"
26 Aug 2016 by Neeraj Prasad Sharma
This article deals with performance difference with literal values
18 Jun 2006 by gtamir
Overcoming the SqlCommandBuilder.DeriveParameters() problem in .NET 1.1 communicating with SQL Server 2005
15 Apr 2008 by gouravverma
Basic difference between Sql Where and Having Clause
8 Dec 2007 by Hamidreza-Ghasemkhah
Automatically generates the required class and stored procedure to work with SQL databases
14 Nov 2004 by Kevin Staunton-Lambert
A general overview of Internet technologies including what the Internet actually is, what HTML and XML are, using Web forms, CGI/MIME, IIS ISAPI, ASP and creating HTML based front ends to databases via ODBC32, OLE DB, ADO and ASP.NET
23 Feb 2007 by T.Ashraf
GridView Image order page shopping cart page
25 Oct 2004 by Chad Z. Hower aka Kudzu
Any user who works with database updates uses transactions. Transactions in ADO.NET are done using a transaction object, and a try..catch, but there is an easier, one might even say a more C# way to handle database transactions.
13 May 2009 by Paolo Costa
This article provides a T-SQL table valued function that retrieves all the descendant rows of a given row in a hierarchical table.
25 May 2010 by gjvdkamp
A step by step explanation of how a recursive CTE actually works.
23 Oct 2008 by TTGOH
Using TableAdapter to display Pivot result without code.
18 Oct 2013 by 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.
14 Oct 2010 by Ganesan Krishnan
Data Synchronization in SQL Express
31 Mar 2009 by Ravikumar Commuri
How to Create 3DBarChart with Graphics, Bitmap Objects in ASP.NET 2.0
4 Oct 2008 by funklet
Make backups of SQL databases and upload them to FTP server
2 Mar 2009 by pavan k vadlamudi
Creates database documentation table(s) schema
7 Jan 2011 by Denis Strukachev
Create md5 hash-code using assemblies in SQL Server 2005
10 Apr 2007 by Peter Weissbrod
An introductory approach to synchronizing database schema versions
23 Sep 2009 by db_developer
This article consists of a data layer and forms for database tables editing.
21 Oct 2008 by santosh poojari
This article demonstrate use of SSIS package that helps in invoking .Net Assembly having email component in it.
26 Mar 2008 by xExTxCx
C# Utility class for Active Directory, databases, files, networking etc.
26 May 2009 by Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
2 Aug 2009 by Abhishek Sur
Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.
2 Nov 2007 by dakeefer
An exploration of how to use the EntitySpaces business object framework within a WPF application.
31 Mar 2008 by r.stropek
software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.
17 Dec 2008 by Rupesh Tarwade
Setup a connection string by allowing the user to select the server and database
11 May 2009 by Ladislav Nevery
Native MySql Client not requiring any special driver or library
28 Sep 2007 by AdamNThompson
Distribute your site's contents with RSS 2.0 using ASP.NET/VB.NET/MS SQL Server 2005.
9 Jan 2007 by Chris Buckett
Using the Visio database model diagram to design a complex database within sql server (or why it's worth paying for MSDN Premium).
20 May 2009 by Sayedur Rahman
A web application allows user to manage tasks, projects & employees of an organization and also provide reports on them
28 Jul 2009 by Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
5 Feb 2014 by The Cool Wayfarer
A blueprint application to showcase an enterprise standard architecture using the .NET 3.5 technologies like WPF, WCF, and LINQ to SQL.
4 Feb 2007 by Russ Quinn
How to serve XML from SQL 2005 through a WebService
10 Sep 2008 by Dave Elliott
How to sort tables so data can be retrieved for offline sychronization and not violate foreign key relationships.
13 May 2009 by Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
9 Jun 2006 by hong_wei_li@yahoo.com
How to truncate log file in SQL Server 2005
6 Jan 2014 by Hasan Habib Surzo
Class, Database Connection, Login Winform
25 Sep 2007 by Alexander Nowak
In SSRS2005, a new provider is available: XML Data provider. This enables you to create reports from ADO.NET datasets or XML documents from URL-addressable resources, e.g. Web services. This article shows a step-by-step example (basic report, no parameters) how to use this new SSRS 2005 feature.
31 Mar 2006 by Addison-Wesley
This chapter covers what's new in enterprise database administration. It doesn't just look at the product from a feature list, but groups the features according to some tasks common to database administration.
23 Nov 2009 by gaurav_verma_mca
Configuration of .NET applications using database
22 Jun 2007 by Ray Gorski
Create a custom control flow component for SQLServer 2005 Integration Service
26 Jan 2009 by Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
5 Aug 2008 by Ziyad Mohammad
How To: Read and write BLOB data by using ADO.NET through ASP.NET 2.0.
26 Apr 2009 by Shivprasad koirala
Implementing Audit trail using trigger
25 Apr 2010 by Leo Koach
New functionalities for a web browser (for beginners).
21 Feb 2008 by PAPAYA
IGotMesasge is an open source Web-based application that allows individuals to easily record and send video messages to others. The software is free to download, install and use, and is easy to integrate with any website.
2 Nov 2006 by Declan Bright
A helper class to manage static data for dropdown lists with caching.
20 Sep 2011 by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
13 Mar 2007 by Patrickquinn1212
Automation of command parameter building targeting Microsoft Access
1 Feb 2006 by Ted Bouskill
This is a simple console application that can be scheduled to create CSV files with table space used data.
25 Jan 2007 by orinoco77
How to decode a URLEncoded URL with T-SQL
5 Oct 2007 by Babak Ansari
A custom asynchronous setup with progress indicator.
27 Aug 2008 by Shivprasad koirala
ASP.NET interview questions: Part 1.
5 Feb 2006 by Socrate1
This article explains how to implement custom paging in the GridView web control using the ROW_NUMBER() function of SQL Server 2005
12 Jun 2008 by Srinath Gopinath
How to handle an array parameter in a Stored Procedure [SQL Server].
4 Sep 2008 by santosh poojari
This article describes the prerequisite needed for .Net And SSIS integrated deployment.
16 Jan 2009 by Alfredo_Fernandez
Performance comparison - Identity() x NewId() x NewSequentialId.
13 Sep 2007 by Suvendu Banik
How to Restore SQL Server 2005 Suspect Database
25 Jul 2006 by avronp
View and update any database table and metadata. Includes sample databases.
22 Sep 2008 by Steve Marsh
This article describes how to build a logic engine entirely in SQL. In the context of our example, a logic engine is a program that takes in a set of variables and corresponding values, evaluates a set of predefined conditions and builds a result set based on which conditions were found to be true.
18 May 2007 by derekliang
This article is going to be served as an introduction to Expert C# 2005 Business Object by RockFord Lhotka which was written for business application developer.
17 May 2006 by Rajib Bahar
This article is about exception handling improvements in SQL Server 2005.
27 Aug 2008 by Lino Barreca
Use T-SQL and system views/stored procedures to give consistent names to every relation in a database
31 Dec 2009 by Christopher R Davis, Michael S Knight
Extend nHydrate with your own custom generator templates.
9 Jun 2006 by Sivakumar Mahalingam
This article explains how to deploy SQL reports programmatically into Reporting Server 2005, using Web Services exposed by SQL Reporting Services 2005.
1 Nov 2005 by Duncan Edwards Jones
Shows how you can use custom attributes to save .NET classes directly to an SQL Server table
24 Apr 2008 by Jayawant
Connecting .Net & SAP
23 Sep 2010 by B. Verboven
Using Microsoft SQL Server or XML files as datastore
22 Mar 2013 by Shubham Choudhary
OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.
13 Nov 2005 by Daron Yndem
My favorite feature of ASP.NET 2.0 is Web Parts. But the anonymous users in ASP.NET cannot save personalization data and can't use Web Parts design options. This article describes how we can solve this problem in a tricky way.
19 Feb 2010 by Niladri_Biswas
Step by step introduction to Microsoft SQL AZURE
24 Sep 2006 by Emre Onyurt
A password recovery system.
19 Sep 2008 by Emil Lerch
Command line tool to check validity of objects in SQL Server databases
19 Aug 2005 by lintom
An easy way to truncate Transaction Log files to your desired size.
18 Sep 2007 by ganti.r
SQL Reporting Service provides an option for using stored procedure in the SQL Server instead of using a query in the report.This article takes you through step by step process of creating a dataset which used a stored procedure with parameters.
15 Dec 2007 by craigd
Single-player game using GEOMETRY datatype and spatial functions in SQL Server.
3 Mar 2009 by Alden John Snow
This project demonstrates what is likely the fastest way to upload one of those fixed width reports from a mainframe to a SQL server table.
21 Apr 2009 by Ramy Mahrous
How to build Reporting ASP.NET Web application
23 Dec 2007 by james.wren
How to add a modified on column in SQL Server using triggers.
19 Jul 2009 by Md. Marufuzzaman
Get SQL Table Information
8 Dec 2009 by Gordon Kushner
Utility program for generating SQL Server INSERT scripts
16 Jun 2010 by Akbar Ali Bhatti
Executing a web service in a CLR based Table Valued Function resolving the problems faced during its execution and finally representing the IEnumerable output as a table in SQL Server.
20 Nov 2009 by Vilhelms
Retrieving appointments without having to store all future occurrences
22 Sep 2010 by Kannan K R
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.
9 Apr 2011 by Karthik. A
This article extends what was built in the previous article. This is a task manager application that uses the custom provider designed in the last part.
22 Jan 2013 by Levente Kupás
Managing SQL backups can be more simple by using this FileRelay CLR
11 May 2007 by andrewcates
In an attempt to open DotNetNuke to a wider audience, I have converted the original VB code into C#
12 Aug 2006 by Arjan Pot
Retrieving child records from an hierarchical table
8 Aug 2005 by JeyKey
An article on generating dynamic column reports.
13 Aug 2007 by Danilo Mendez
Smart Code the Open Source Code Generator
31 Jan 2007 by jamesplewis
How to check if your Microsoft SQL Server 2005 is ready for the new DST 2007
31 Jan 2008 by Muigai Mwaura
Query multiple databases in one expression e.g. an Microsoft Access Database and an SQL Server Database
19 Oct 2008 by defwebserver
SilverlightDesktop.net is a Open-Source ASP.NET framework that allows you to dynamically load Silverlight modules into resizable draggable windows.
4 Apr 2007 by Fitim Skenderi
Very Lightweight Data Access Layer in C# and .NET 2.0
11 Jan 2009 by 6opuc
Fast and easy to use data access class library.
10 Sep 2007 by idreeskhan
SQL Script Executer or Reader executes the scripts which are already generated and you want to execute them. Just change the path where your scripts reside.
17 Nov 2006 by MarkWei
To dynamically generate a Google Map with combined data sources from an external web service or API and from an internal MS SQL database, using AJAX and the ASP.NET environment.
13 Dec 2008 by Enrique Albert
Console and GUI utility application that executes SQL scripts against SQL Servers (7, 2000, and 2005) - version 2.0.1.2 is now available.
16 Dec 2008 by Navin Pandit
Pagination with Repeater control / custome pagination with data control in C# ASP.NET 2.0
24 Mar 2007 by Todd Wilder
Using the SQLNotificationRequest object and the Service Broker to get row and column change notifications, mimicking supposed SQLDependency capabilities
21 Sep 2007 by idreeskhan
Get or find Primary Key or ID column of Table in SQL Server 2000/2005
22 Aug 2009 by Virat Kothari
CLR Stored procedures are very simple and can be used in most complex scenarios when dealing with database.
23 Sep 2009 by db_developer
An approach to create a master-details grid and to show the parent column in the child table.
3 Apr 2006 by Lou Flees
An ADO.NET toolbox that is meant to serve as the lowest level database IO layer for an application based on an Access, Microsoft SQL Server, or Oracle database.
6 Jul 2005 by Vitaly Tomilov
Demonstrates effective data processing of ADO recordset objects in C++ via Safe Arrays provided by method GetRows.
13 Mar 2008 by Bryan Kowalchuk
Formatting telephone numbers in SQL Server.
17 Nov 2008 by xbadenx
Merge data tables with validation audits and error logging.
24 Jun 2008 by akjoshi
Implementing a tab control like structure in SQL Server 2005 reporting services report using tables and text boxes
12 Oct 2007 by Vincent-Philippe Lauzon
How to use SQL Server 2005 Service Broker technology to simulate monologs and traditional queues
11 Jan 2008 by Vinoth Kumar.S
A tip for one of the problems found with Footer Text of ReportDesigner
24 Jun 2009 by SP.Murugesa Pandian
WCF DataContract
13 Oct 2009 by pinaldave
Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
20 Jan 2008 by parallelcoder
Configuring Plastic SCM database backend
5 Apr 2009 by Tarek Najem
How to delete duplicate entries from a data store, while leaving a single copy.
17 Apr 2009 by Adnan Faisal
In this article, we will learn how to create a JavaScript popup window, how to use the MultiView control to move between two views, and also to use the GridView control with paging.
7 Jan 2007 by InterScape, Inc.
Creating reports today has become a nightmare for a lot of developers. I can contest to the late nights and many lines of code in order to build custom reports, then have a user never use a report because it was slow or did not contain the data they wanted to see.
21 Dec 2005 by Nishith Pathak
Creating managed objects in SQL Server 2005.
9 Jun 2006 by hong_wei_li@yahoo.com
How to Schedule and Run a SSIS package ( DTS ) Job in SQL Server 2005
22 Feb 2008 by Abhijit Jana
SQL Server Profiler Step by Step: SQL Server 2005
25 May 2007 by Igor Krupitsky
SparkLine is a small, high resolution line chart. This article explains how to create and use SparkLines in your ASP.NET application.
28 Sep 2012 by AdamNThompson
A data access component for SQL Server in VB.NET.
5 Jul 2008 by defwebserver
A DotNetNuke style framework that allows you to upload modules to enable an end-user to easily update and enhance a web application.
29 Jul 2008 by George Zabanah
Take a look at two new patterns to help with database concurrency: SIP and SUP.
8 Nov 2007 by Michael Ceranski
Creating a DAL with SubSonic.
8 Oct 2007 by Nick Higgs
Presenting a lightweight method to cut out most of the repetitive work of creating data classes.
5 Jun 2007 by Oleg Sobol
Serverside ViewState management using custom providers based on ASP.NET 2.0 provider pattern architecture.
23 Jan 2008 by Erich Ledesma
This project allows you to store values along with unit information and conversion between different measurement systems. Also provides a hierarchy to create new converters easily.
5 Mar 2009 by Hithendra Reddy
Building Custom Webparts to interact with Database
11 Dec 2007 by felipesabino
Shows a way to map tables, relations between tables, and columns info of a SQL Server 2000/2005 database; also generates INSERT, UPDATE, DELETE, and SELECT SQL statements at runtime using C# (TableReader).
12 Jan 2009 by Vimalsoft(Pty) Ltd
How to use paging without a wizard in ASP.NET.
11 Jan 2008 by David Catriel
An extremely fast and efficient way to import a table from any ODBC-capable database into MS Access (while running in a C# project), by using the Microsoft Access built-in import functionality.
11 Jan 2012 by Venkat Chaitanya Kanumukula
Export SQL Server tables to HTML/Excel/Word Document files dynamically.
9 Oct 2007 by Andrew Golik
A Data Access Object pattern implementation
11 Oct 2009 by gaurav_verma_mca
This article details out the best practices of transaction management across application domains
1 Sep 2006 by ShirleySW
How to dynamically create an ASP.NET 2.0 Wizard control and load child controls at run-time.
14 Sep 2006 by Anil_Kumar_P
One of the best new features of ASP.NET 2.0 will be the SqlDataSource control. However, as I found out in my experimentation, what seems like a simple control has some complex behaviours to master to get it working properly.
19 Dec 2006 by Eugene Mirotin (Guard)
Demonstrates the easiest way to use all the advantages of SqlDataSource and GridView, and to allow flexible DataSource configuration.
17 Oct 2007 by asithangae
Data builder that builds XML from a SQL query in hierarchical format.
7 Oct 2007 by Ali Ozgur
Sample code describing how to retreive statistical information about the T-SQL commands executed.
11 Jan 2009 by Sam Safonov
The tool is based on XML/XSLT, and allows a user to create a Word report from scratch, namely: construct SQL query, construct a WordML template, generate a document.
12 Feb 2009 by Mohammad A Gharakhanlou
this application is answer for ;How to encrypt sql server procedures and functions at a time
31 May 2008 by singh
This article shows general code that creates stored procedures for SQL tables and C# DAL
25 May 2010 by iMuhamad
use date and time as separated components in SQL Server 2000 and above
10 Dec 2009 by Christopher R Davis, Michael S Knight
Generate applications using Inversion of Control with the nHydrate code generator.
12 Apr 2007 by Ole Oren
Describes building a WorkGroup TimeSheet with GridView
22 Jan 2008 by Moustafa Refaat
We are sending and receiving sensitive information over the internet. We want to secure all the messages we are exchanging with our partners.
19 Sep 2008 by Morteza Naeiamabadi
this article demonstrate how to insert a audio file into SQL Server and how to get the audio file from SQL Server and play it in .Net
8 Sep 2009 by Md. Marufuzzaman
How to generate SQL object script using C#.NET
21 Jun 2007 by vivekthangaswamy
An article about how Forms Authentication is enabled in Microsoft Office SharePoint Server 2007
3 Feb 2007 by István Kovács (HU)
Indexing Word, Excel and other types of documents is easy with SQL Server
6 Sep 2007 by pinaldave
SQL SERVER - 2005 - Introduction and Explanation to sqlcmd
11 Oct 2007 by vacen2
Allows you to perform a Distinct query against a Datatable
4 Aug 2010 by Abdul Quadir Saifee
Creating Crystal reports with dynamic number of Columns with Typed dataset with SQL Server 2005
26 Nov 2005 by Wouter van Vugt
A CMS built using WebParts and MasterPages.
25 Jun 2007 by Moim Hossain
Describes how to use the SSIS object model for importing data to SQL server 2005
10 Mar 2008 by Razwan Kader
Implement and maintain multiple profiles of a user using the Membership and Profile API.
6 Jan 2014 by Assil
A tool that facilitates the truncation of SQL log file
30 Dec 2007 by Anders Revsgaard
No matter how well you design your system, a distributed SOA application is always complex. When a SOA application fails, it can be difficult to track down the cause of the problem and the Web service where the error occurred. To handle this difficulty, you need a logging system such as UptoLog.
11 May 2007 by Igor Krupitsky
A complete VB.NET application to schedule DOS command tasks online
25 Apr 2007 by Daniel Kuettel
This article shows a simply method of encrypting connection strings for windows applications
27 Mar 2005 by JSpruell
A primer on creating ASP.NET pages that use User.Identity.Name available from Forms Authentification to permit a customer/employee to logon, retrieve their specific records, and format the information as a Master Detail record.
20 Jul 2005 by Albert Pascual
I wrote this short article to improve your ASP.NET application Sessions using Cache.
27 Jul 2007 by Paul Reynolds
This is phase 2 of a 3 phase project. This phase accesses the database created and loaded in phase one to expose an API of common business date functions.
9 Oct 2008 by R. Giskard Reventlov
Simple export of data from database a to database b using identical tables (SQL Server).
17 Dec 2005 by Dewey Vozel
After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do.
5 Dec 2009 by Muhusin Khan
Effective perfomance for database application uses database
1 Feb 2007 by Ali Ozgur
This article describes how NHSessionManager can be configured to use multiple NHibernate assemblies
9 Aug 2008 by Paul Conrad
Review of Louis Davidson's Pro SQL Server 2005 Database Design and Optimization
24 May 2012 by Vimalsoft(Pty) Ltd
This article will show you how to build an N-Tier application in VB.NET.
5 Apr 2008 by Pramod S Kumar
Implement a Flash ASP.NET AdRotator to fetch ads from a database.
5 Jun 2007 by NagendraGunaga
The purpose of this document is to provide the step by step information about enabling the Form Based Authentication (FBA) for MOSS 2007 site.
3 Mar 2009 by Zenab_Zenab
This article focuses on developing a workflow client device application for Pocket PC in C# 2003.
20 Nov 2007 by Sujith John Thomas
This article explores the concepts of XMLSS and its transformation to XL.
29 May 2009 by qubing
WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005
15 Jul 2007 by MalakieUSN
Code storage tool for any language but developed using Visual Basic .NET 2005. Includes syntax coloring for VB code and can load via the tools menu external option in Visual Studio 2005.
28 Aug 2009 by weilidai2001
Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.
24 Oct 2008 by Moustafa Refaat
In this article, I will explain how to use Microsoft SQL Management Objects (SMO) to create a Microsoft SQL database from C# code.
29 Jul 2007 by pinaldave
I tried to accommodate all of them in the last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer to at your convenience.
18 Jul 2007 by Padoor Shiras
Computed Column Specification for populating nth column
17 Jul 2007 by Paul Reynolds
This is phase 1 of a 3 phase project. Phase 1 accesses a public holiday Web Service, and loads a SQL Server table that can drive dating and aging logic on large sets of data and assist in creating fast-performing queries and reports.
11 Oct 2007 by vacen2
Allows you to perform a Distinct query against a DataTable.
23 Oct 2005 by Sekhar Lanka
This article talks about CLR integration and how to program database objects using managed code by using this cool feature of SQL Server 2005.
20 Jun 2006 by r.stropek
Solving the collation mix with SAP (SQL_Latin1_General_CP850_BIN vs. Latin1_General_CI_AS).
10 Jul 2008 by John Kenedy S.Kom
This is a .NET 3.5 library that acts as Data Access Layer with many automatic features
17 Mar 2008 by Avinish Awasthi
The purpose of the integration is to create collaboration sites on SharePoint 2007 as new accounts or opportunities are created in Microsoft CRM.
4 Aug 2008 by Emrys81055
Lists all instances of SQL Server found on a local network.
9 Aug 2007 by raphadesa
Article explaining how to access a web service using SQL Server integration with VS 2005 (SQLCLR)
5 May 2009 by ColinBashBash
Generate classes / CRUD procedures.
3 May 2007 by Mohammed Ghouse Barq
APPLY operator is a new feature in SQL Server 2005 used in FROM clause of a query. It allows you to call a function-returning TABLE for each row of your outer TABLE. We can pass outer table’s columns as function arguments.
31 Jul 2008 by TSells
Utility to manage multiple DB connection strings for an application.
8 Jun 2009 by noahhath
Building a hybrid Active Directory and SQL table DataSource view.
18 Oct 2008 by Shivprasad koirala
Asp.Net Interview Question Part 3
22 Jul 2008 by Mike Borozdin
Tutorial on using LINQ, ListView, LinqDataSource, DataPager, ASP.NET AJAX
22 Nov 2008 by Amit K Bhagat
ASP.NET using GridView control as lookup
11 Jan 2007 by Pete O'Hanlon
The first in a series of articles on prioritizing and improving query performance in SQL Server.
7 Aug 2017 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!
24 Mar 2008 by jangtimjang
Do you want to know what your DB programmers are doing?
7 Dec 2004 by Nirosh
The application generates database wrapper classes for MS SQL Server databases automatically. I got lots of good reviews and comments as I discussed about this with my colleagues. Now that the application is built, let's see what you have to say about this.
14 Jan 2011 by KarthikAnbarasan
This article explains the new tool in Visual Studio 2010 which most of the users use to see the comparison report of the 2 different database schemas.
14 Dec 2007 by konamiman.MSX
A C# class that uses the local file system to cache binary objects stored in a database.
11 Jan 2008 by wburdick
A tip for one of the problems found with Footer Text of ReportDesigner
26 Mar 2009 by Vimalsoft(Pty) Ltd
How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File
1 Mar 2010 by User-Rock
Approaches describing a design to handle connection objects and pools in C#.
25 Oct 2007 by asithangae
Achieving the DataGrid functionality with paging using User control and Ajax
30 Jan 2009 by GaryWoodfine
An explanation of Views in SQL server 2000/2005 and the advantages of them
7 Aug 2008 by bhadeliaimran
Inserting value of Collection into Database
30 Apr 2007 by Anandhi Swamy
Handles uploading /downloading images into/from database to DataGrid
17 Jun 2007 by Reza Shojaee
In this article, the ability of Microsoft SQL Server database in storing and retrieving trees will be described.
4 Mar 2014 by Shivprasad koirala
ASP.NET Caching Interview Questions Part 2
6 Aug 2006 by ZeroDev
Convert the current Gridview to a datatable
26 Aug 2005 by Krishna Prasad V.R.
This article focuses on the problems you might face and the probable solution when using .NET custom assemblies. This article also gives in-depth details of modifying .NET assemblies for which you do not have the source code.
30 Dec 2007 by Redskin9
A series of Database utilities for lookup and data manipulation written in C#
27 Mar 2016 by Manish kumar choudhary
In this article, you will learn how to select data from a table and send that data to an email using SQL Server 2008.
6 Feb 2010 by Ali Marzban
Changing ConnectionString like an attribute in C#
18 Jan 2007 by n_ahid
SQL Reporting Services doesn’t support exporting reports to MSWord yet. Using render extensions for exporting MSWord is not so easy. This article describes an alternative way of converting a SQL report to an MSWord file.
20 Mar 2006 by Naveen Karamchetti
This article describes the new functoids in BizTalk Server 2006.
8 Sep 2007 by idreeskhan
SQL Script Generator generates the SQL Scripts to run on SQL query to analyze only insert and update queries
27 Feb 2008 by Eddie Velasquez
MRU Manager for Visual Studio 2005/2088 and SQL Server 2005
1 Feb 2009 by Kurush Rastkar
Using most of the recent technologies in one application
19 Sep 2008 by Mohammad Ashraful Alam
Along with specification, examples and tools, a new visual modeling technique is being introduced, termed as “nAML” (.NET Application Modeling Language), which overcomes the limitation of typical modeling languages in a revolutionary way!
14 Jun 2007 by alifaraze
Custom assembly and reporting services
16 Jan 2008 by Paritor
Application to show differences between two SQL Server databases.
26 Sep 2006 by code-frog
Provide a very simple set of instructions for creating your own media gallery and loading your images from SQL Server 2005.
13 May 2007 by Eugene Ochakovsky
A generic procedure to retrieve and delete duplicate records from MS SQL Server tables.
22 Sep 2007 by Triet Ho
Use SQL-DMO Object Library for quick searching and generating stored procedures script
25 Sep 2009 by George Oakes
This library allows a user to use functions in SQL Server to encrypt and decrypt text.
16 Feb 2007 by carlop()
An article about converting ASCII/Multibyte to Unicode using C# and SQL/CLR integration.
14 Apr 2007 by falconsoon
Database Helper Class Library to Ease Database Operation
11 Jun 2009 by Sasha Risner
A C# sample for binding a GridView to a DataTable with sorting, filtering, updating, deleting, and inserting allowed.
10 Feb 2009 by Eddy Vluggen
How to import a database-dump from GeoNames.org into SQL Server
23 Aug 2007 by Praveen Nair (NinethSense)
This article describes how to develop a Microsoft SQL Profiler with .NET.
5 Mar 2010 by Shabdar Ghata
A sample program to demonstrate how to save or store images in SQL server
23 May 2007 by Praveen Nair (NinethSense)
This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases.
24 Jul 2008 by David Hoyt
Easy to use ASP.NET suite that gives you everything you need to get started and makes it all pathetically easy to use - Windows services (with UAC), localization (webpage and e-mail), e-mail templating, configuration, and much, much more!
23 Dec 2007 by Moiz hakimi
This is an article about backup utility of SQL server from Command prompt
19 Mar 2008 by Daniel Ch. Bloch (MCSD, MCAD, MCTS)
SQL 2005+ changes behaviour of order by in relation to Select top 100%
17 Nov 2007 by Waynes World
An article on importing data from external data sources to SQL server without using wizards
20 Jul 2008 by s.s.cheral
This function gives dates for a day between two dates (e.g. All sundays from Jan-08 to Aug-08)
20 Aug 2009 by Nizam Mohd
Am article on how to send multiple rows to SQL Server 2005 database for data modification.
21 Jul 2009 by Tom Bauto
A simple and detailed ASP.NET program using Gridview with paging in SQL 2005
5 Oct 2006 by Joshy_geo
Create database in sql server using asp.net with C# (VS2005)
5 Jun 2008 by Tina83
A cursor for dynamic query.
30 Nov 2005 by Tommi G
Add-in for copying SQL Server 2005 Express data files between project main folder and output folders.
18 Jul 2007 by Jeff Bramlett
Helper classes for automation of stored procedures
29 May 2008 by madgardener
Simple destination script to use do updates with a sub query.
25 Aug 2009 by Jeremy Likness
Common table expressions (CTEs) are a powerful new construct for building advanced queries.
26 May 2006 by hong_wei_li@yahoo.com
How to populate DataGridView, GridView with SQL statement in C#
23 Oct 2005 by Barend Jnr
Simple Data Paging
18 Jan 2008 by RamMajeti
Consider a situation in which you have a datagrid with all or most of its rows in editable mode.
22 Jun 2006 by Thiago Silva
Automate your Reporting Services report deployment and scripting and database tasks by using these custom MSBuild tasks.
6 Mar 2007 by LeleHalfon
A great AJAX Grid very customizable. In English & Spanish traduction
13 Oct 2006 by hong_wei_li@yahoo.com
Configure MS SQL Server 2005 Remote Access ( mixed mode )
29 Dec 2007 by ericm1000
A simple Windows screen host utility that returns connection information (server name and port number) for all instances of SQL Server 2005, 2000, and 7.0 on a local machine.
18 Sep 2007 by Matty22
An introduction to the benefits of ORM using the free Personal Edition of Diamond Binding
24 Mar 2009 by Shivprasad koirala
4 steps to use readymade DAL component (Data application blocks)
9 Mar 2010 by pinaldave
SQL SERVER – Order of Columns in Update Statement does not matter
2 Feb 2007 by Ali Ozgur
How to create DaoFactory instances with Castle/MikroKernel in NHibernate applications
29 Mar 2006 by Suranjan Nandi
The report is build on XML Schema and the data and binded the report at runtime.
12 Nov 2007 by T.Ashraf
Display multi line of text saved in the database
13 Mar 2008 by Bryan Kowalchuk
Efficiently storing telephone numbers in SQL Server.
23 Feb 2009 by wallism
A few simple tips that should help when you are considering setting up CI
7 Aug 2007 by albert arul prakash
XSS gaining popularity to hack into websites. This article describes how to power yourself against XSS
10 May 2008 by Tariq Younas
Article describes how to make backup and recovery plan of MOSS 2007.
22 May 2007 by Yildirim Kocdag
Long SQL query printing.
20 Aug 2007 by Jatin Gupta MS
RDL Programming - some issues and their solutions
25 Oct 2005 by Himanshu Kumar Sinha
I will discuss the Try & catch error handling feature of the SQL SERVER 2005 (Yukon)
2 Sep 2008 by MrTimmins
Introduction to using CLR .NET assemblies in Microsoft SQL Server.
30 Sep 2008 by alon1980
An open source password manager with some advanced features and cool interface
25 May 2007 by Ganesan Sankaran
How to populate a dropdown in another dropdown change
16 Mar 2008 by pengyi
How to select what fields to display on a report from a multi-value
6 Apr 2009 by Vimalsoft(Pty) Ltd
Beginner to intermediate in N-Tier
9 Jun 2008 by Deepak.M
This article describes on building a Database from scratch using Batch File from the existing Database
30 Oct 2007 by Bryan Kowalchuk
Implementing Agile Software Development
29 Aug 2006 by sandeep@s
An introduction to executing SQL Server stored procedures and how to retrieve the return parameters
29 Sep 2005 by VincentGee1
Using SQL trigger to create unlimited unique id's
7 Feb 2006 by HRiazi
Use stored procedures in your code - as simple as 1,2,3
7 Apr 2005 by RichardRoe
CodeSmith template for creating Audit Log Triggers on SQL tables.
23 Feb 2008 by T.Ashraf
How to pass values between user control and ASPX page without JavaScript
12 Sep 2006 by Sivakumar Mahalingam
An article on how to generate PDF reports programmatically using SQL Server Reporting Services 2005, in C#.
4 Jul 2007 by Marek Mizov
Query paging by one trip to MS-SQL Server 2005 via a simple query. Without using a Stored Procedure, View, or others features. Only uses T-SQL and .NET.
27 Oct 2007 by Jatin Prajapati
Here I am showing, How to Create SQL Database and Run SQL Script File Using asp.net.
8 Oct 2006 by Malpani Amol
Here is some cool stuff to call .NET assembly from SSIS
15 Oct 2006 by Malpani Amol
This article will drive you, how deploy and debug CLR store procedure
6 Jun 2007 by veeru.k
Reporting services
17 Dec 2008 by s_arun_kumar
Format Excel Sheet from DTS when Excel is not installed on SQL Server
12 Feb 2008 by Shobhit Dixit
If you have a long list of drop down items and you want to pass in one value, you can use this method
25 Oct 2008 by sada.narayanappa1
This article presents a solution to create a report using SQL reporting service that displays a column data as rows; furthermore, the columns are repeated horizontally for each data row. It also provides a sample source project that uses "Northwind" database for data source purpose
8 Oct 2006 by Malpani Amol
This article will drive you, how to access and update properties and variable of SSIS package using .NET application
4 Feb 2007 by Rajaraman.net05
This sql function is used to find the week in Given Date.
26 Apr 2008 by Sudipta Chaudhari
Tricky Sql Queries most asked in SqlServer/.NET Job Interviews.
2 Oct 2007 by mc_kappa
Using this simple, yet elegant and powerful code, you can provide to your users efficient Office document merging; simply exploiting XML technology and basic string manipulation.
8 Apr 2007 by Patrickquinn1212
Uses DataBase Schema to aid in Parameter Building for commands.
29 Dec 2006 by Deepu M.I
Execute Access 2003 Macros in SSIS Package. How to call Access Macros in SSIS Package
27 Sep 2009 by acarpio1975
Given date ranged data, adjust existing ranges on entry of a new ranged data.
15 Apr 2011 by Ayaz Awan
Generate 100,1000 lines of backend code and stored procedures by just one click on table name in SQL Server
14 May 2008 by Himanshu Thawait
This sample shows BizTalk 2006 consuming a Web Service, then publishing orchestration as a Web Service, and calling it from ASPX.
8 Apr 2010 by Jatin.Prajapati.ER
Hide the datagrid columns which are not intended to be displayed at runtime
27 Aug 2007 by T.Ashraf
Hide and Retrive value of cloumn of a GridView
2 Aug 2006 by efero
Connecting to SQL Express Manualy
10 Apr 2007 by Peter Weissbrod
An introductory approach to synchronizing database schema versions
23 Sep 2009 by db_developer
This article consists of a data layer and forms for database tables editing.
21 Oct 2008 by santosh poojari
This article demonstrate use of SSIS package that helps in invoking .Net Assembly having email component in it.
26 Mar 2008 by xExTxCx
C# Utility class for Active Directory, databases, files, networking etc.
26 May 2009 by Bishoy Demian
How to use Entity framework to do some basic logic when a change happens in related Entities or Associations
2 Aug 2009 by Abhishek Sur
Gives an introduction to CLR programming in SQL Server databases. This is the first part of a two-part article series.
2 Nov 2007 by dakeefer
An exploration of how to use the EntitySpaces business object framework within a WPF application.
31 Mar 2008 by r.stropek
software architects invites you to prove your knowledge about certain subjects concerning Microsoft .NET technology by participating in a monthly quiz. This month the quiz is about SQL Server.
17 Dec 2008 by Rupesh Tarwade
Setup a connection string by allowing the user to select the server and database
11 May 2009 by Ladislav Nevery
Native MySql Client not requiring any special driver or library
28 Sep 2007 by AdamNThompson
Distribute your site's contents with RSS 2.0 using ASP.NET/VB.NET/MS SQL Server 2005.
9 Jan 2007 by Chris Buckett
Using the Visio database model diagram to design a complex database within sql server (or why it's worth paying for MSDN Premium).
20 May 2009 by Sayedur Rahman
A web application allows user to manage tasks, projects & employees of an organization and also provide reports on them
28 Jul 2009 by Shivprasad koirala
Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.
5 Feb 2014 by The Cool Wayfarer
A blueprint application to showcase an enterprise standard architecture using the .NET 3.5 technologies like WPF, WCF, and LINQ to SQL.
4 Feb 2007 by Russ Quinn
How to serve XML from SQL 2005 through a WebService
10 Sep 2008 by Dave Elliott
How to sort tables so data can be retrieved for offline sychronization and not violate foreign key relationships.
13 May 2009 by Mohammad Al Hoss
Passing an array as parameter to SQL server Procedure
9 Jun 2006 by hong_wei_li@yahoo.com
How to truncate log file in SQL Server 2005
6 Jan 2014 by Hasan Habib Surzo
Class, Database Connection, Login Winform
25 Sep 2007 by Alexander Nowak
In SSRS2005, a new provider is available: XML Data provider. This enables you to create reports from ADO.NET datasets or XML documents from URL-addressable resources, e.g. Web services. This article shows a step-by-step example (basic report, no parameters) how to use this new SSRS 2005 feature.
31 Mar 2006 by Addison-Wesley
This chapter covers what's new in enterprise database administration. It doesn't just look at the product from a feature list, but groups the features according to some tasks common to database administration.
23 Nov 2009 by gaurav_verma_mca
Configuration of .NET applications using database
22 Jun 2007 by Ray Gorski
Create a custom control flow component for SQLServer 2005 Integration Service
26 Jan 2009 by Gil Shabat
Real-world Use Case: a flexible approach to present dynamic content with SQL Server, ASP.NET, and XSLT.
5 Aug 2008 by Ziyad Mohammad
How To: Read and write BLOB data by using ADO.NET through ASP.NET 2.0.
26 Apr 2009 by Shivprasad koirala
Implementing Audit trail using trigger
25 Apr 2010 by Leo Koach
New functionalities for a web browser (for beginners).
21 Feb 2008 by PAPAYA
IGotMesasge is an open source Web-based application that allows individuals to easily record and send video messages to others. The software is free to download, install and use, and is easy to integrate with any website.
2 Nov 2006 by Declan Bright
A helper class to manage static data for dropdown lists with caching.
20 Sep 2011 by Pieter Van Parys
Creating profiling information in our ProxyDbxxx classes
13 Mar 2007 by Patrickquinn1212
Automation of command parameter building targeting Microsoft Access
1 Feb 2006 by Ted Bouskill
This is a simple console application that can be scheduled to create CSV files with table space used data.
25 Jan 2007 by orinoco77
How to decode a URLEncoded URL with T-SQL
5 Oct 2007 by Babak Ansari
A custom asynchronous setup with progress indicator.
27 Aug 2008 by Shivprasad koirala
ASP.NET interview questions: Part 1.
5 Feb 2006 by Socrate1
This article explains how to implement custom paging in the GridView web control using the ROW_NUMBER() function of SQL Server 2005
12 Jun 2008 by Srinath Gopinath
How to handle an array parameter in a Stored Procedure [SQL Server].
4 Sep 2008 by santosh poojari
This article describes the prerequisite needed for .Net And SSIS integrated deployment.
16 Jan 2009 by Alfredo_Fernandez
Performance comparison - Identity() x NewId() x NewSequentialId.
13 Sep 2007 by Suvendu Banik
How to Restore SQL Server 2005 Suspect Database
25 Jul 2006 by avronp
View and update any database table and metadata. Includes sample databases.
22 Sep 2008 by Steve Marsh
This article describes how to build a logic engine entirely in SQL. In the context of our example, a logic engine is a program that takes in a set of variables and corresponding values, evaluates a set of predefined conditions and builds a result set based on which conditions were found to be true.
18 May 2007 by derekliang
This article is going to be served as an introduction to Expert C# 2005 Business Object by RockFord Lhotka which was written for business application developer.
17 May 2006 by Rajib Bahar
This article is about exception handling improvements in SQL Server 2005.
27 Aug 2008 by Lino Barreca
Use T-SQL and system views/stored procedures to give consistent names to every relation in a database
31 Dec 2009 by Christopher R Davis, Michael S Knight
Extend nHydrate with your own custom generator templates.
9 Jun 2006 by Sivakumar Mahalingam
This article explains how to deploy SQL reports programmatically into Reporting Server 2005, using Web Services exposed by SQL Reporting Services 2005.
1 Nov 2005 by Duncan Edwards Jones
Shows how you can use custom attributes to save .NET classes directly to an SQL Server table
24 Apr 2008 by Jayawant
Connecting .Net & SAP
23 Sep 2010 by B. Verboven
Using Microsoft SQL Server or XML files as datastore
22 Mar 2013 by Shubham Choudhary
OQMS 1.0 allows you to connect your server online and manage the table like Select, Insert, Update and Delete statements.
13 Nov 2005 by Daron Yndem
My favorite feature of ASP.NET 2.0 is Web Parts. But the anonymous users in ASP.NET cannot save personalization data and can't use Web Parts design options. This article describes how we can solve this problem in a tricky way.