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.

Blogs

Removing the REST Endpoint in the Data API Builder

By

The more I work with the Data API Builder (DAB), the more I lean...

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

SQL Saturday Oregon & SW Washington 2024

By

Wow I am so late in posting these notes! But this conference was amazing,...

Read the latest Blogs

Forums

TDE for multiple databases and severs

By sqlfriend

We are self hosting sql servers, we are not using Azure for sql servers....

Help with parent/child query please

By Mr. Holio

Hi everyone, Trying to get this data to the following format but I can't...

The user data source credentials do not meet the requirements to run this report

By mceventphoto

I am trying to implement a SSRS reporting dashboard similar to the SQL-performance-dashboard-reports that...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers