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

How to Set Default Value or Binding for BLOB DataTypes on SQL Server

15 Jan 2013 by Wonde Tadesse

This tip/trick helps to set a default value for blob data type such as Image, VarBinary.

SQL-Server-2005

SQL-Server

SQL-Server-2008

SQL-server-2000

Read a file using transact-sql.

8 Jul 2010 by Md. Marufuzzaman

How easy to read a file without using of the seven extended stored procedures.

How to Split Microsoft SQL Server Table Row Data

18 Dec 2015 by Md. Marufuzzaman

This tip shows you an easy way to split Microsoft SQL Server table row data.

How to update a row with another row if column values are null in SQL

17 Aug 2012 by ManojKumar19

Update row column with another row column in same table SQL only if it is null.

Creating SQL Joins in Simple Steps

20 Sep 2012 by Sreedhar Puligundla

Simple steps to create SQL joins by using SQL Server 2008 Management Studio

SMO 101 - Getting all DB's

17 Aug 2011 by bmckuhen

How to get a quick list of all DBs using SMO

Pivoting on SQL Server Varchar Data Types

22 Feb 2016 by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Find Missing Date Ranges in SQL Server

10 Feb 2012 by Ramanujam Shankar

Find missing date periods from a table.

Concatenate many rows into a single text string using SQL Server 2008

25 Feb 2012 by e-Lopes

How to concatenate many rows into a single text string using SQL Server 2008.

Concatenate many rows into a single text string using SQL Server 2008

23 Feb 2012 by PIEBALDconsult

See also Stupid CTE tricks -- string concatenation[^]

Generating and Splitting a Delimited String Column

17 Jan 2013 by Tharaka MTR

This article describes the easiest way to create and process delimited row using SQL XQuery.

SQL Server StringPadding (String function)

24 Apr 2013 by Surender Singh (CodeToastDev)

Custom StringPadding functions for SQL Server

Auditing Failed Logins in SQL Server: Looking Beyond Post-event Analysis

23 Sep 2014 by SatyLepide

By analyzing log-in attempts on SQL server, admins can build the complete picture out of the sequence of events that led to compliance failure or unauthorized access.

Concatenate many rows into a single text string using SQL Server 2008

25 Feb 2012 by Sanjay K. Gupta

How to concatenate many rows into a single text string using SQL Server 2008

Locate SQL Server Instances on the Local Network

30 Apr 2012 by Constantin Chumak

This is an alternative for "Locate SQL Server instances on the local network"

Translating ANSI Column into Unicode (Arabic Code Page)

7 Mar 2013 by Emad Sammour

Mapping table is used in the translation - output in Unicode (nvarchar)

How to Use Office365 Email with SQL Server 2000

17 Sep 2013 by MAW74656

This is a drop-in solution that mimicks the functionality of xp_sendmail (including query results), without installing Outlook on the server.

Drop all Triggers belonging to any schema in MS SQL Server

9 Oct 2013 by Matthew Taylor

How to remove Microsoft SQL Server triggers associated with a custom schema.

Concatenate many rows into a single text string using SQL Server 2008

8 Mar 2012 by Ramanujam Shankar

Using COALESCE function - concatenate many rows into a single text string output in SQL Server.

Import CSV or txt File Into SQL Server Using Bulk Insert.

21 May 2014 by Arvind Singh Baghel

Import CSV or txt File Into SQL Server Using Bulk Insert.

Convert RTF to Plain Text (Revised Again)

9 Apr 2016 by NightWizzard

Handling for hex expressions and the trailing '}'

Random Date/Time Test Data Generation

25 Aug 2016 by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Create a Sample SQL Database in Less Than 2 Minutes

18 Feb 2013 by Pascal Ganaye

This SQL stored procedure creates a database from scratch with some meaningful content.

SQL-Server

SQL-server-2000

Get accurate age by date

20 Feb 2010 by Md. Marufuzzaman

Get accurate age by date using MS SQL Server

A Simple and Another Way to Find Rows on n’th Maximum Number from a Table

23 Dec 2015 by Md. Marufuzzaman

A simple tip/trick to get rows on n’th maximum number from a table

SQL Server Database Backup Status Report

5 Jun 2015 by Dathuraj Pasarge

Know whether your databases are backed up successfully in the last 24 hours or not !!!

Number of different ways to get total number of rows from tables

21 Jun 2010 by Pranay Rana

Getting a SQL Server RowCount Without doing a Table Scan

A Unique Feature of SQL SERVER Loop with Go Statement

10 Nov 2013 by Rajat-Indiandotnet

A unique feature of SQL SERVER Loop with Go statement

A Simple Example of Microsoft SQL Server Pad String

18 Dec 2015 by Md. Marufuzzaman

A simple example of Microsoft SQL Server Pad String

How to setup database versioning tool RoundhousE

2 Sep 2014 by Rohan Kishor Garud

RoundhousE (RH) is a database migrations engine that uses plain old SQL Scripts to transition a database from one version to another.

The Best Table Finder (The BestCube Problem)

20 Dec 2016 by BharatRamV

Finds the Best Table for a given set of columns

Split function in SQL

30 Jul 2013 by Gauri Chodanker

SQL function in SQL

SQL Group by With Joins

15 Feb 2010 by Pranay Rana

How to use Group By clause when joining to table Let's consider one scenario where I have two table employees (contains employee detail) and sales (contains infomation about sales done by employee).Structure of...

Dynamic ORDER BY with multiple criteria in T-SQL

28 May 2013 by Bob Crowley

How to use a CASE statement in ORDER BY to avoid dynamic SQL

Find Sp from database which is related to(using) table XXX

27 Feb 2010 by Pranay Rana

Problem : - During project development I got the requirement that I have to modified the column name of the table which is used in the no of procedure i.e i have to found all procedure related to that table and modify it For the above problem following are the solution that i used First ...

Write error log in a text file for Custom Assembly being used in Reporting Services

19 Sep 2013 by alifaraze

writing error in a text file is very easy but writing error from a custom assembly in reporting services requires permissions