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,044 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,020 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,672 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,367 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,012 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

SQL Server instance metadata inventory with PowerShell and SMO

SQL Server instance metadata inventory with PowerShell and SMO The purpose...

5 SQL Tricks Worth Remembering Before You Close the Laptop

By Eduardo Pivaral

Disclosure: this post may contain links to books as an affiliate link. If you...

Claude Context Window

Every Claude conversation has a context window. It is the total amount of text...

Read the latest Blogs

Forums

Celebrating 30 years of PostgreSQL, A Thank you message

Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...

provisioning sql server via VMware Cloud Foundation

By andreas.kreuzberg

Hello, has anyone here ever provisioned and actually used an MS SQL Server with...

No More Deadlocks

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No More Deadlocks

Visit the forum

Question of the Day

No More Deadlocks

After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?

See possible answers