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.

All Articles

top

SQL Server 2000

Passing a Comma Delimited Parameter to a Stored Procedure

29 Jan 2004 by -Dr_X-

Passing multiple values as a single Parameter to a Stored Procedure

SQL

C++

Windows

SQL-Server

Simple Data Access in C#

11 Jan 2009 by 6opuc

Fast and easy to use data access class library.

Writing SQL queries in XML – A support intensive approach

31 Jul 2005 by _Asif_

Article that helps writing SQL in XML to provide better support

Having the CheckBoxList support many-to-many relationships

4 Jul 2007 by _JERKER_

Example of implementing many-to-many multiple choice functionality the declarative way.

SQL Framework

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.

Custom print procedure in MS SQL 2000/7/6.5

23 Dec 2003 by Abhay Dubey

This procedure can be called in another Stored procedure or function and quite handy in debugging and development

Quick Overview: Temporary Tables in SQL Server 2005

22 Sep 2009 by Abhijit Jana

Basic overview of temporary Tables in SQL Server 2005

Pitfalls Encountered and their Workarounds during Development of BizTalk Projects

9 Sep 2010 by Abhijit Mahato

This article discusses the pitfalls encountered and their workarounds during development of BizTalk Projects

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux (Race to Linux)

5 Oct 2005 by Abi Bellamkonda

ASP.NET TimeTracker Starter Kits Porting from Windows to Linux using Mainsoft's Grasshopper

ASP.NET Reports Starter Kits Porting from Windows to Linux (Race to Linux)

30 Sep 2005 by Abi Bellamkonda

ASP.NET Reports Starter Kit Porting from Windows to Linux using Mainsoft's Grasshopper

Auto Adjusting Date Ranges on Entry of a New Range using SQL

27 Sep 2009 by acarpio1975

Given date ranged data, adjust existing ranges on entry of a new ranged data.

How to conduct an SMS survey using a cell phone connected SMS gateway and MS Access

16 Oct 2007 by Adam Page

Setting up an SMS gateway to conduct an SMS survey and storing the survey results in an MS Access database, from which you can generate/print out reports.

SqlProcedure - Improve Database Performance, Eliminate Errors and Reduce Code

23 Nov 2007 by adambl

Provides a utility to generate a wrapper for stored procedures to improve performance and eliminate certain run-time errors

Building Blocks For ASP.NET Applicationa: Part 1

30 Jan 2006 by Agha.net

This is a series of articles providing Building Blocks for any ASP.NET application.

How to Set Up SQL Server Integrated Security For Using With SMS

19 Apr 2005 by Ahmed_EL Sayed

How to set up SQL Server Integrated Security for using with SMS.

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

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

Power yourself against XSS

7 Aug 2007 by albert arul prakash

XSS gaining popularity to hack into websites. This article describes how to power yourself against XSS

Improve performace with Sessions using Cache

20 Jul 2005 by Albert Pascual

I wrote this short article to improve your ASP.NET application Sessions using Cache.

Simulating Recordsets with ADO.NET

2 Oct 2004 by Alberto Venditti

A proposed class to simulate the ADODB.Recordset behavior in .NET.

ASP.NET configuration management: an alternative to web.config

14 Feb 2005 by Alberto Venditti

An alternative and flexible way to manage config settings for multiple web applications.

A general-purpose service engine for unattended processing execution

23 Sep 2015 by Alberto Venditti

Using a .NET Windows service as an engine for specialized custom plug-ins execution

Using SQL Bulk Load to Upload Fixed Width Text Files

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.

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

6 Sep 2007 by aleksisa

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

SQL Server 2000 Collation Changer

3 Mar 2008 by Alex Baker

Change collation order for all text columns in a database

agStoredProc

19 Nov 2004 by Alexander German

With agStoredProc, you can generate a C# class out of all the stored procedures in a MS-SQL database. No Microsoft ApplicationBlocks needed.

sqlTunes - Query Your iTunes Library

7 Mar 2008 by Alexander Kojevnikov

sqlTunes is a small tool that exports iTunes library information to the SQL server.

TransactionScope in .NET 1.1

1 Jun 2005 by Alexander Shirshov

Emulate TransactionScope functionality coming in .NET 2.0 with .NET 1.1.

Uploading / Downloading Pictures to / from a SQL Server

28 Oct 2004 by Alexandru Ghiondea

Describes how to upload and download pictures to and from a SQL Server database.

Microsoft Indexing Service and OLEDB

15 Apr 2008 by Ali Hamdar

How we can access the Windows Indexing Service using OLEDB.

Using Multiple NHibernate Assemblies with NHSessionManager

1 Feb 2007 by Ali Ozgur

This article describes how NHSessionManager can be configured to use multiple NHibernate assemblies

NHibernate DaoFactory Exposer with Castle MikroKernel

2 Feb 2007 by Ali Ozgur

How to create DaoFactory instances with Castle/MikroKernel in NHibernate applications

How to retrieve SqlConnection statistics for executed T-SQL commands

7 Oct 2007 by Ali Ozgur

Sample code describing how to retreive statistical information about the T-SQL commands executed.

Creating and Deploying Reporting Services using Custom Assembly

14 Jun 2007 by alifaraze

Custom assembly and reporting services

Using config file for Custom Assembly in Reporting Services (Step by Step)

15 Jun 2007 by alifaraze

A trick to use config file for Custom assembly in reporting services

Paging and Sorting on SQL Server and Oracle using Sql.Net

21 Feb 2005 by Alon_Catz

This article presents an alternative solution to paging large datasets using Open Source Sql.Net library.

Integrated College Management System[Credit Hours Sys.] --Part 1-- Class Library & Database

21 May 2005 by Ameen AboDabash

This project is established for helping students to make registration easily. It also simplifies this process for both students and employees and prevent usual problems the Credit Hours System faces.

Fully Customized Reusable ASP+ Vertical/Horizontal Marquee Consuming XML/MS SQL

23 May 2005 by Ameen AboDabash

Vertical/horizontal Marquee Web Custom Control consuming SQL Server DB/XML, with great design time attributes.

Database Comparator

8 Jan 2009 by Amir Mehrabi-Jorshari

With this tool, you can compare two databases and generate a difference report.

ASP.NET using GridView Control as Lookup

22 Nov 2008 by Amit K Bhagat

ASP.NET using GridView control as lookup

SQL injection attacks

18 Jul 2005 by Amit Kukreti (A)

An article on SQL injection attacks.

Integrating Microsoft Access DB, SQL Reporting Services and Visual Studio .NET

13 May 2005 by Anand Santhanam

In this article, I would like to demonstrate how we can leverage the SQL Reporting Services feature on to a Microsoft Access database, using the Visual Studio .NET as IDE.

Web Service via Data Access Object Pattern

9 Oct 2007 by Andrew Golik

A Data Access Object pattern implementation

Database Deadlocks for Dummies

2 Oct 2008 by Andrew J Dixon

Explaining Database deadlocking to non-technical people

Rapid Web Application Development

27 Sep 2005 by Andrew M Baldwin

An article about the Multiformity Open Source project.

Dynamic Creation of DTS-packages in VB

29 Sep 2009 by Andrey Chuvahin

Example dynamic configuration of DTS-packages for transferring DBF files to SQL Server with VB

Data Access Layer (DAL) with SqlWrapper library

12 Jun 2005 by Andrey Shchurov

With SqlWrapper, you can easily create your DAL classes writing the most minimum amount of code.

SqlDataSource with Transactions

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.

Using CheckBoxes within the DataGrid control to select records

3 Jul 2004 by Ansil

This article is about using CheckBoxes in a Datagrid control to select records as in a mail box.

Architectural Best Practices - Automating SQL Parameter Creation and Assignment

18 Jul 2007 by Anton Pious Alfred

Most systems that use Stored Procedures make use of SQL parameters to send and receive information from the database. The code to create these SQL parameters and then populating them is repeated throughout the system. This article describes how to automate this code.

Data Structure Implementation to Query Binary Tree for Upline / Downline Node without using Recursion

9 Dec 2010 by AnupKumarYadav

Can be used in Multilevel Marketing with binary tree (can be modified accordingly to be used for n Tree)

Server Side Message Box in VB.NET and C#

22 Nov 2004 by Anwar Hussain (Technical Specialist)

A custom control - server side MessageBox in VB.NET and C#.

Schema.ini override and bulk upload using SQLXML

15 Mar 2007 by Aravind Rajagopal K

Schema.ini override and bulk upload using SQLXML

Add/Drop LinkedServers using SMO

31 Jan 2006 by arunpv

Add/drop Linked Servers using SQL Server 2005 SMO

Handling Keyboard Events of DataGrid Cells

9 Mar 2006 by Asher Syed

Handling Key-Down and similar events for DataGridCells in a DataGrid

Automate query execution by using xml and helper class

26 Jun 2006 by ashishinfra

The generalized class has static functions that return dataset and datareader objects , It accepts string(name of xml tag that stores the query) and value to be supplied in case query accepts parameters

Format Number to 2 Decimals in MS SQL without Rounding

15 Oct 2004 by ashishnaik1

Format any Number to 2 decimal Number without Rounding

Solving problems while passing XML into a Stored Procedure

23 Sep 2004 by Ashutosh Singhal

Having problems while passing XML into a Stored Procedure because of Namespaces? This script would probably solve it.

Dynamic Data Grouping Using Microsoft Reporting Services

4 Aug 2006 by Asif Sayed

Generate multiple outputs from a single physical report template using dynamic data grouping.

Reporting Services 2005 101 using Web Client

15 Sep 2006 by Asif Sayed

A step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client..

Simplify data entry with AutoComplete

15 Jan 2007 by Asif Sayed

A tutorial demonstrating the power of the AutoComplete feature of the TextBox control using a Windows Forms client and SQL Server 2000 data.

Database Viewer and Updater for any Database

25 Jul 2006 by avronp

View and update any database table and metadata. Includes sample databases.

SQL And C#

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

Highlighting Important Dates in Calendar

9 Aug 2004 by azamsharp

Highlighting important dates in the Calendar control.

Creating Auto-Suggest Textbox Using ASP.NET 2.0 Client Callbacks

15 Jun 2007 by azamsharp

Implementing an auto-completion feature using ASP.NET 2.0 client callbacks

Stored Procedure class generator

21 Nov 2004 by b_hardman

Generate code classes to access stored procedures via web services.

Controlling the XML output when using the FOR XML AUTO statement in SQL Server

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.

Loading image files from a database, using ADO

27 Jan 2006 by Bahrudin Hrnjica

Putting and retrieving images files to and from a database, via ADO.

Sample code for AJAX in VB.NET, ASP.NET without using Ajax.dll

6 Feb 2007 by Bala Murali S

Sample project containing source code to implement AJAX without Ajax.dll in VB.NET, ASP.NET.

Quick Screen Development in ASP.NET

20 Jul 2004 by Balachandar Ganesan

Auto Generate the ASPX page quickly

SQL Server 2005 Database Backup and Restore using C# and .NET 2.0

7 Jun 2008 by Bappi M Ahmed

SQL Server 2005 database backup and restore using C#, .NET 2.0, and SMO.

Generic Login Control

8 Jan 2005 by Barathan

Generic Customizable login control for VB.NET Windows Forms.

Simple Data Paging

23 Oct 2005 by Barend Jnr

Simple Data Paging

Record Versioning with SQL Server

15 Feb 2007 by Ben Allfree

Learn how to store data with a version history.

Generate Insertion Scripts Using .NET 2.0

23 Jul 2007 by Benedict Chan

Using .NET 2.0 to get the SQL Server schema and generate insertion statements.

Using RowCount for sorting when paging large result sets

5 Sep 2004 by benoityip

Fast paging with large result set.

NHibernate Best Practices with ASP.NET, 1.2nd Ed.

11 Jun 2008 by Billy McCafferty

This article describes best practices for leveraging the benefits of NHibernate 1.2, ASP.NET, generics and unit testing together.

Row Paging Using Temporary View

8 May 2005 by bluechip_asia

Row Paging Using Temporary View

Other Row Paging Technique Using T-SQL

27 Apr 2005 by bluechip_asia

Simple Row Paging Using T-SQL at Stored Procedure

Reading RPT File Then Display Report as PDF

23 Oct 2005 by bluechip_asia

This Article Teach You How To Use External RPT File Rather Than Embedded RPT File (.DLL)

BooProd.Core - Context sensitive Connexion String

13 Dec 2004 by Boo!

This article is to help you create context sensitive connexion string: choosen dynamically, depending on which server the application is running.

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

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!

Generator-less! C# wrapper for SQL Stored Procedures

20 Sep 2005 by Brian Perrin

Eliminate the pain of calling SQL stored procedures from C#.

Find Stored Procedures called within a procedure

25 Apr 2005 by brip

Sometimes its tedious to find all calls made to different stored procedures within a stored procedure and generate reports in case we have large databases. This tool is aimed to script all SPs and extract SP calls made with additional information such as author name and description.

Retrieving and Storing Call History

19 Dec 2007 by Bryan Sachdeva

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

Visual Representation of SQL Joins

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.

T-SQL Coding Standard

1 Oct 2008 by Casper Leon Nielsen

T-SQL Coding Standard - for programming the Microsoft SQL Server 2005 (DRAFT)

Easier Database Transactions - Extending the Using Statement to Perform Automatic Database Transactions

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.

SQL Database Relation Builder

23 Aug 2004 by Charl Pohlmann

An article on automatically building the relationships between tables in a DataSet.

SQL Database Editor

25 Aug 2004 by Charl Pohlmann

An article on a SQL database editor.

Wrapper Generator for SQL Server Stored Procedures

30 Jun 2004 by Charles Horan

A utility application that generates .NET code for wrapping stored procedures.

Complete Remote (Intra/Inter) SQL Server Manager

3 Feb 2004 by Chaudhary

SQL Server manager for remote monitering and managing.

MCMS Manager

11 Jul 2005 by Chester Ragel

A tool which can be used to do common tasks which Microsoft Content Management Server API provides.

Everything you wanted to know about State Management in ASP.NET

16 Mar 2005 by chintu222

This article will emphasize on the mechanisms of State Management that are available with ASP.NET and the steps to learn and understand their implications for usability, performance and scalability.

Impersonation using Code

8 Mar 2007 by Chirag R Darji

Impersonation using Code

SQL