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

6 Steps to Enable Transactions in WCF

23 Jun 2021 by Shivprasad koirala

6 steps to enable transactions in WCF

.NET2.0

.NET1.0

ASP.NET

SQL-Server

SQL-server-2000

Architect

Code Review Checklist

24 Feb 2017 by Ebenezar John Paul

An Ideal Code Review Checklist that applies for most programming languages

Use one SSRS Report to Find All Your Microsoft SQL Servers, Out of Date Editions, and Service Packs

3 Oct 2016 by Mark W Solomon

Automatically Create Data Access Layers and Business Layers From Microsoft Access or SQL Server Databases

27 May 2016 by icemanind

How to automatically create data access layers and business layers from a Microsoft Access or a SQL Server database

SQL User Defined Function to Parse a Delimited String

5 Apr 2016 by SQLMonger

SQL Function to parse a delimited string and return it as a table. Handles multi-character delimiters and returns the results as a table.

LayerGenMMX

2 Nov 2015 by icemanind

Easily create Business and Data Layers!

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

SQL Server Unit Testing Framework

24 Sep 2014 by Duncan Edwards Jones

A simple unit testing framework for T-SQL

How to Validate ASP.NET and MVC Web Forms Using Business Rules Engine

14 Jul 2014 by Misha1964

Learn how to validate complex web forms using business rules engine

Thinking in SQL - Working with dates

14 Mar 2014 by Christian Graus

In this installment, I talk about working with dates and date functions in SQL Server

SQL Wizardry Part 2 - Select, beyond the basics

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.

Five steps to using a logging utility in your projects using Application Blocks

5 Mar 2014 by Shivprasad koirala

Steps to use a logging utility in your projects using Application Blocks.

ASP.NET Caching Interview Questions: Part 2

4 Mar 2014 by Shivprasad koirala

ASP.NET Caching Interview Questions Part 2

Thinking in SQL - Generating Random Numbers

23 Jan 2014 by Christian Graus

A discussion of ways to create random number sequences in SQL Server

SQL Wizardry Part Eight - Tally Tables

21 Jan 2014 by Christian Graus

A description of the best way to create tally tables, and how to use them

SQL Wizardry Part Seven - PIVOT and arbitrary lists of data

16 Jan 2014 by Christian Graus

Discussion on pivot and other ways to turn columns of data in to rows in SQL Server

SQL Wizardry Part Six - Windowing Functions

13 Jan 2014 by Christian Graus

A discussion of windowing functions, from sum to row_number(), to the new functions in SS2012

SQL Wizardry Part Three - Common Table Expressions (CTEs)

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

SQL Wizardry Part Five - when not to use DISTINCT

6 Jan 2014 by Christian Graus

Just a quick explanation of why it's not always a good idea to use DISTINCT

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!

SOA Interview Questions: Part 1

19 Sep 2013 by Shivprasad koirala

Software Architecture interview questions (Service Oriented Architecture interview questions: Part 1).

Create and Populate Date Dimension for Data Warehouse

4 Sep 2013 by Mubin M. Shaikh

This article shows how to create and populate date dimension for data warehouse.

Continuous Database Integration

16 May 2013 by Peter Hancock

Using NAnt and CruiseControl.NET to continuously integrate database changes

Create an SQL Server Database Using C#

24 Apr 2013 by Phuong Thanh Nguyen

Create a SQL Server database using C#.

How to execute multiple long running SQL Statements Asynchronously in small chunks

28 Mar 2013 by Khorshed Alam, Dhaka

How to execute multiple long running SQL Statement Asynchronously in smaller chunks

Convert SQL Server DB to SQLite DB

13 Jan 2013 by liron.levi

A C# utility to automatically do conversion from a SQL Server DB to a SQLite DB

Coding an N-Tier Application in C# Without Any Wizard: Part II

5 Jan 2013 by Vimalsoft(Pty) Ltd

Coding an N-Tier application in C# without using Wizards.

Find multiple strings in selected columns

28 Aug 2012 by akhil khare

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

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.

Implementing multi-level trees in MS SQL Server

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.

Table Data Sharing Across Stored Procedures

7 Aug 2012 by ManojKumar19

This tip demonstrates how table data can be shared in two stored procedures.

Building an N-Tier Application in VB.NET, in 8 Steps

24 May 2012 by Vimalsoft(Pty) Ltd

This article will show you how to build an N-Tier application in VB.NET.

Generating INSERT statements in SQL Server

19 May 2012 by ilorgat

This is an alternative for "Generating INSERT statements in SQL Server"

Simple & Advanced Pivots with C# and ASP.NET

1 May 2012 by Jean-Francois Lanouette

This is an alternative for "Simple & Advanced Pivots with C# and ASP.NET"

Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005

15 Jan 2012 by Venkat Chaitanya Kanumukula

Export SQL Server Tables to Excel Files Dynamically

Exporting Stored Procedure Results into Tables Dynamically with T-SQL

11 Jan 2012 by Venkat Chaitanya Kanumukula

T-SQL Code for Converting Stored Procedure results to Tables Dynamically

Dynamically Generating Html/Excel/Word Document Files with SQL Server data using SSIS 2005

11 Jan 2012 by Venkat Chaitanya Kanumukula

Export SQL Server tables to HTML/Excel/Word Document files dynamically.

Using Integrated Windows Authentication (IWA) in a Distributed Application Architecture

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.

AD, SQL Server, GMail synchronizer tool

29 Jun 2011 by michael.neubrander

Multi account synchronizer for GMail, AD, and SQL Server.

SQL Query Optimization FAQ Part 1 (With video explanation)

7 Jun 2011 by Shivprasad koirala

SQL Query Optimization FAQ Part 1 (With video explanation)

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

SQL Server Schema Comparison Tool in Visual Studio 2010

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.

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)

Data Synchronization in SQL Express

14 Oct 2010 by Ganesan Krishnan

Data Synchronization in SQL Express

Dynamic Cross Tabs and Pivots, A Different Approach

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.

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

.NET 4.0 MEF FAQ (Socket, Plug and extension)

8 Sep 2010 by Shivprasad koirala

.NET 4.0 MEF FAQ (Socket, Plug and extension)

Overview of SQL Server Stored Procedure

13 Jul 2010 by Md. Marufuzzaman

Overview of SQL server stored procedure

Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table

4 Jun 2010 by Syeda Anila Nusrat

Create a Business Logic Layer, Data Access Layer classes, and Stored Procedure scripts from a database table.

Date and Time as Separated Types

25 May 2010 by iMuhamad

use date and time as separated components in SQL Server 2000 and above

SQL SERVER – Order of Columns in Update Statement Does not Matter

9 Mar 2010 by pinaldave

SQL SERVER – Order of Columns in Update Statement does not matter

Store or Save images in SQL Server

5 Mar 2010 by User 992674

A sample program to demonstrate how to save or store images in SQL server

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.

Execute DTS Through VB.NET

22 Dec 2009 by Suresh Suthar

How to execute DTS packages through VB.NET and use global variables.

Create INSERT batch files easily with ScriptBuilder

8 Dec 2009 by Gordon Kushner

Utility program for generating SQL Server INSERT scripts

Document SQL Server 2000/2005 Database

17 Oct 2009 by Nitinpatel

T-SQL script to generate the document of SQL 2000/2005 database

Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup

13 Oct 2009 by pinaldave

Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup

Custom MembershipProvider and RoleProvider Implementations that use Web Services

4 Oct 2009 by Shaun Wilde

Custom MembershipProvider and RoleProvider implementations that use web services in order to separate the application and database servers.

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

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.

Datagrid Cell Tooltip

25 Sep 2009 by Thiru Sagadevan

Showing Tooltip for each cell with data of a table in a Datagrid

SQL Encryption and Decryption Library (Using Rijndael)

25 Sep 2009 by George Oakes

This library allows a user to use functions in SQL Server to encrypt and decrypt text.

Quick Overview: Temporary Tables in SQL Server 2005

22 Sep 2009 by Abhijit Jana

Basic overview of temporary Tables in SQL Server 2005

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application - Article 5

19 Sep 2009 by Paul Rony

A Programmer's Guide to Starting a Software Company and Building an Enterprise Application

A simple example of SQL server admin tools.

13 Sep 2009 by Md. Marufuzzaman

A simple example of SQL server admin tools.

Optimized Paging and Sorting using Object Data Source

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.

Very fast test data generation using exponential INSERT

28 Aug 2009 by weilidai2001

Instead of using incremental INSERT to generate test data, this method effectly copies the existing data multiple times.

Uncommon Common Table Expressions (CTEs)

25 Aug 2009 by Jeremy Likness

Common table expressions (CTEs) are a powerful new construct for building advanced queries.

How to Integrate an OLE Object with SQL Server v2

22 Aug 2009 by Md. Marufuzzaman

This article will give you an idea about how to integrate an OLE Object that is a COM+ API with SQL Server and write a message into a Windows event log.

Global Variables in SQL Server

19 Aug 2009 by Md. Marufuzzaman

A list of Global variables in SQL Server and their uses in Transact-SQL

A Simple Use of SQL CASE Expression

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.

Row Numbers in SQL Query (Microsoft SQL Server 2000 and 2005)

17 Aug 2009 by P. Ganesh Kumar

Helps in assigning row numbers in the returned result of an SQL query

An Easy Way to Get a File Name or a File Extension from a User Defined File Path using Transact-SQL

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.

An Easy But Effective Way to Split a String using Transact-SQL

9 Aug 2009 by Md. Marufuzzaman

This article will demonstrate how to split a string using Transact-SQL.

Overview of SQL Server database Triggers

7 Aug 2009 by Md. Marufuzzaman

Overview of SQL Server database Triggers

How Do I Protect My Stored Procedure Code

29 Jul 2009 by Md. Marufuzzaman

This article will demonstrate the best practice to protect SQL server code object.

LINQ FAQ: Part 3

27 Jul 2009 by Shivprasad koirala

Concurrency handling, compiled queries, CRUD implementation, and mapping simple .NET classes with XML file configuration.

Procedure to Shrink the Database Transaction Log

25 Jul 2009 by Md. Marufuzzaman

This article will demonstrate the procedure to shrink the database transaction log.

How To Handle Concurrency in LINQ to SQL?

19 Jul 2009 by Shivprasad koirala

How to handle concurrency in LINQ to SQL?

Optimizing LINQ Queries using DataLoadOptions

5 Jul 2009 by Shivprasad koirala

Optimizing LINQ Queries using DataLoadOptions

Introducing WF4.0: Building Distributed Apps with WF 4.0 and WF 4.0 Services

30 Jun 2009 by mohamad halabi

Shows how to build new-design distributed applications with WF 4.0 and Data Services.

Monitoring Group of Linked SQL Servers from a SQL Server

24 Jun 2009 by Kuldip Rindani

Monitoring group of Linked SQL Servers from a SQL Server

WCF DataContract with FaultException Details

24 Jun 2009 by SP.Murugesa Pandian

WCF DataContract

Check Database Size with Summary

22 Jun 2009 by Kuldip Rindani

This script calculates size of every user database with summary

How to Integrate an OLE Object with SQL Server

15 Jun 2009 by Md. Marufuzzaman

This article will demonstrate how we can integrate T-SQL with an external application.

Building a Hybrid Active Directory and SQL Table DataSource View

8 Jun 2009 by noahhath

Building a hybrid Active Directory and SQL table DataSource view.

TwittiBot: Adventures in Developing a WPF Hybrid Smart Client for Twitter

1 Jun 2009 by Dwayne Macadangdang

An article on creating a Hybrid Smart Client for Twitter using the Windows Presentation Foundation and the TwitterLib class library

A SQLProcedure For MSSQL 2005 Of CustomPaging With RowNum And CustomPaging Without RowNum Both For MSSQL 2000 And MSSQL 2005

29 May 2009 by qubing

WITH Clause AND EXEC sp_executesql Clause Used In MSSQL 2005

How To Store Any File into SQL Database

22 May 2009 by Md. Marufuzzaman

An easy technique to store any file into SQL database

Passing an Array as Parameter to SQL Server Procedure

13 May 2009 by Mohammad Al Hoss

Passing an array as parameter to SQL server Procedure

Minimalistic Driver-less Native MySql Client

11 May 2009 by Ladislav Nevery

Native MySql Client not requiring any special driver or library

Generate Classes and CRUD Procedures

5 May 2009 by ColinBashBash

Generate classes / CRUD procedures.

4 steps to create free SSL certificate for development

4 May 2009 by Shivprasad koirala

4 steps to create free SSL certificate for development

CrystalReports Push Model with .NET

29 Apr 2009 by Raspberry Man

How to make custom datasource for CrystalReports engine using push model and .NET

How to Config Linked Servers in a Minute

29 Apr 2009 by Kamran Hazari

How to create Linked servers in a minute in an easy way

Implementing Audit Trail using Trigger

26 Apr 2009 by Shivprasad koirala

Implementing Audit trail using trigger

How to Non-alphabetically Sort GridView Columns with Text Data

22 Apr 2009 by Christopher Geyer

Creating a sortable GridView is easy. But, what if you want to perform a nonalphabetic sort on a column that is alphabetical? Answer below...

Coding an N-Tier Application in C# without any Wizard - Part I

6 Apr 2009 by Vimalsoft(Pty) Ltd

Beginner to intermediate in N-Tier

How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File

26 Mar 2009 by Vimalsoft(Pty) Ltd

How to Store and Retrieve a ConnectionString from a Web.Config or App.Settings File

4 steps to use readymade DAL component (Data application blocks)

24 Mar 2009 by Shivprasad koirala

4 steps to use readymade DAL component (Data application blocks)