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,393 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

1,967 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

892 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,385 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)

8,983 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,654 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,348 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,345 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)

8,982 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,836 reads

Blogs

Redgate Clone Graduating Images

I wanted my own custom image in our internal Redgate Clone cluster, so I...

SQL Saturday Syracuse 2024 Recap

First Things First Thanks to every who came to my session, Asnwering the Auditor’s...

A New Word: Incidental Contact High

incidental contact high – n. an innocuous touch by someone just doing their job...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

Comments posted to this topic are about the item How to Add a New...

Azure Purview Scanner Requires Database Master Key to produce Lineage, but why?

By Orlando Colamatteo

I am studying for the Azure Data Engineer certification and the material covers Purview...

Visit the forum

Question of the Day

Adding Features During a SQL Server 2022 Upgrade

I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?

See possible answers