Discovering SQL Server 2005 Instances by Querying System Center Configuration Manager (SCCM)

SQL Server 2005 extended support will end on April 12, 2016. After this date, Microsoft will no longer be releasing security updates for this product. In the article, we will query the System Center Configuration Manager (SCCM) 2012 database to obtain the number and editions of SQL Server 2005 instances that are installed, along with…

0

Creating Complex Test Databases – Generating One Table for each of the 2,397 supported Collations

As a follow up to my series on complex test databases, this article will cover one of the more interesting test databases that I recently created.    Goal:  Create a database that includes one table for each supported collation.  Each table contains a single column with the various column level collations supported by SQL Server 2012 (nearly…

0

TSQL – Solve it YOUR Way – Finding a Person’s Current Age Based on Birth Date

Introduction: As part of the blog series TSQL – Solve it YOUR Way, today’s topic will cover a question asked recently in the T-SQL MSDN forums where the solution, at first, seems extremely obvious.  However, as solutions were proposed and flaws were discovered with the proposals, the interesting nature of the problem was revealed.  As is the theme…

12

TSQL – Solve it YOUR Way – Finding the Longest Repeated Substring

  Introduction: As part of the blog series TSQL – Solve it YOUR Way, today’s topic will cover a common programming interview question where we are asked to find the longest repeated substring in a given string, followed by different solutions and explanations from three of the more helpful and creative contributors in the TSQL…

5

TSQL – Solve it YOUR Way – Finding the percentage of NULL values for each column in a table

Introduction: As part of the blog series TSQL – Solve it YOUR Way, today’s topic will cover a question asked in the Transact-SQL MSDN Forums here, followed by three different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums, Jens Suessmeyer, Naomi Nosonovsky, and Jingyang Li. Topic:  How can…

7

TSQL – Solve it YOUR Way – Finding the MAX Value from Multiple Columns

Introduction: As part of the blog series TSQL – Solve it YOUR Way, today’s topic will cover a question recently asked in the Transact-SQL MSDN Forums here, followed by four different solutions from three of the more helpful and creative contributors in the TSQL MSDN forums, Jingyang Li, Steven Wang, and Kent Waldrop. Topic:  I…

9

Finding the Correct Version of the AdventureWorks SQL Server Sample Database

The AdventureWorks database is a fictitious company database that has existed since SQL Server 2005 as a means to show new functionality in each new version released.  Because the Books Online TSQL samples leverage this sample database, AdventureWorks has become a vital aspect of learning new features/constructs within SQL Server.  What started as a big…

11