Derek Wilson

Derek Wilson delivers tactical and strategic Business Intelligence and Enterprise Architecture solutions. His primary focus in on Microsoft SQL Server technologies and aligning business problems to technology solutions. He architects BI solutions leveraging SQL Server, SharePoint and any other technologies that help his clients achieve better data driven decisions. By leveraging the information learned while collecting requirements for BI projects, he helps align business processes to technology helping further organizations Enterprise Architecture. He is an author, trainer, blogger and has been using SQL Server since version 6.5.

T-SQL HOST_ID and HOST_NAME

by Derek Wilson

Business Intelligence and Enterprise Architecture

HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...

2015-04-20

3,519 reads

SQL Server 2014 Deprecated Features

by Derek Wilson

Business Intelligence and Enterprise Architecture

SQL Server 2014 Deprecated Features – Database Engine
Everyone looks at the new features when trying to determine when to upgrade from...

2015-03-19

2,042 reads

SQL Saturday #408 Houston – June 13th 2015

by Derek Wilson

Business Intelligence and Enterprise Architecture

Call for speakers is now open for SQL Saturday #408 in Houston, TX. If you are interested in presenting please...

2015-03-13

898 reads

Azure Data Factory

by Derek Wilson

Business Intelligence and Enterprise Architecture

What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing. It allows...

2015-03-10

1,397 reads

T-SQL EXCEPT and INTERSECT

by Derek Wilson

Business Intelligence and Enterprise Architecture

T-SQL EXCEPT and INTERSECT
Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same...

2015-03-03 (first published: 2015-02-23)

9,018 reads

T-SQL UNION Set Operator

by Derek Wilson

Business Intelligence and Enterprise Architecture

T-SQL UNION
Set operators allow you to combine data from two or more queries and return the results in a single...

2015-02-13 (first published: 2015-02-04)

8,667 reads

SSRS Farm to Scale-Out Performance

by Derek Wilson

Business Intelligence and Enterprise Architecture

SSRS Farm Overview
Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and...

2015-01-26

1,366 reads

T-SQL Random Numbers using RAND() for Test Data

by Derek Wilson

Business Intelligence and Enterprise Architecture

T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...

2015-01-12

1,386 reads

T-SQL COALESCE Example

by Derek Wilson

Business Intelligence and Enterprise Architecture

T-SQL COALESCE
SQL Server T-SQL coalesce simplifies the use of a case statement to find the first non-null value of your...

2014-12-30 (first published: 2014-12-26)

9,010 reads

ROW_NUMBER SQL Server

by Derek Wilson

Business Intelligence and Enterprise Architecture

Row_Number SQL Server
SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number()...

2014-12-22 (first published: 2014-12-16)

8,850 reads

Blogs

SWAG Saves the Day

PASS Summit East is in one week. I was on the road last week...

Upgrading SQL Server Containers on the Laptop

I don’t have SQL Server installed on my laptop. In an effort to keep...

How to Find Expensive Queries in Amazon Redshift

By Eduardo Pivaral

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

Read the latest Blogs

Forums

Having Issue deploying a report to an on prem server from PowerBI desktop

By daniel.manke

Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

Hi all Can I get some perspective from the community please on performing in-place...

How Long is a Long I/O?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Long is a Long...

Visit the forum

Question of the Day

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

See possible answers