So long AdventureWorks, we’ll miss you! (And hello Wide World Importers!)

So long AdventureWorks, we’ll miss you! It’s the end of an era for the SQL Server sample database AdventureWorks as development has been suspended for the popular sample database following the release of SQL Server 2016. Many of us have used this sample database to learn constructs and features of the product since its introduction…

3

Querying SCCM – Finding Manufacturer Counts and Percentages

Lately I’ve been doing a lot of work with System Center Configuration Manager¬†(SCCM) 2012 in terms of reporting and custom collections. As part of this, I’ve had the need to write this particular short query to retrieve manufacturer details several times, which seemed to make for a good target to share. Goal: Find the number…

0

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

Connecting SQL Server Profiler to Power BI Desktop

Connecting SQL Server Profiler to your Power BI Desktop Analysis Services Instance One of my favorite methods of better understanding any database structure or application is to connect SQL Profiler and inspect the events being executed. Now that I’ve been using Power BI Desktop extensively over the past couple months, I have started to run…

1

Windows Server 2012 / 2012 R2 – Logon restricted to members of Local Administrators group

Within one of the SQL Server environments that I support, we recently experienced a Windows Server 2012 operating system crash followed by a situation where the SQL Server 2012 service was unable to start with the following error message: Error message 7038 – The MSSQLSERVER service was unable to log on as NTSERVICE\MSSQLSERVER with the currently configured password…

0

TechNet Guru Competition – Show off your SQL Server skills!

  Over the past few months, I’ve had the opportunity to help judge a great new online competition on TechNet Wiki spanning many Microsoft technologies and including several SQL Server categories.  The contest requirements are very basic and contribute to the overall SQL Server community by increasing the amount of user contributed content on TechNet…

1

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