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,521 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,047 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

899 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,023 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,673 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,368 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,387 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,013 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,851 reads

Blogs

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

By Eduardo Pivaral

Every PostgreSQL migration eventually hits the same fork in the road. The database is...

A Spread of Vacation

I’m off on vacation today. Which is a little weird as I just got...

How AgentDBA Identifies Backup Failures

Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...

Read the latest Blogs

Forums

Have you done a Mid year check in?

Comments posted to this topic are about the item Have you done a Mid...

From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline

By Cláudio Tereso

Comments posted to this topic are about the item From SQL Server On-Premises to...

Independence Day 2026

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2026

Visit the forum

Question of the Day

Independence Day 2026

In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.

See possible answers