Click here to Skip to main content
15,867,453 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.
15 Sep 2008 by Oleg Vorkunov
Set of SQL CLR Stored Procedures to execute T-SQL asynchronously without using a Service Broker.
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.
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
16 Oct 2007 by Adam Page
Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.
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.
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.
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.
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.
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 Dec 2006 by James Westgate
Use an agile managed database framework, and feel you've finally reached programming heaven.
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)
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
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.
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.
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.
13 Jul 2010 by Md. Marufuzzaman
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.
6 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.
7 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
29 Jan 2009 by Nitesh Maharaj
How to create simple and advanced pivot tables in C# and ASP.NET
16 Nov 2007 by pinaldave
SQL SERVER - 2005 - Generate Script with Data from Database - Database Publishing Wizard