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

Viewing errors with extended events

By

A little while back I came across this post: Identifying failed queries with extended...

My Toolbox - Everything

By

Foreword Not everything in the general sense, but a tool called Everything by voidtools (Download...

Understanding Microsoft Purview Pricing

By

Ever since its official launch around October 2021, Microsoft Purview has been one of...

Read the latest Blogs

Forums

How to get record based on nearest date in SQL

By pelusch

Guys! For the three customers  in Table A I want to get the amount...

delete my own login

By snomadj

So I have my own individual windows login to SQL & access via a...

cursor to do update for multiple tables of a specific field

By sqlfriend

I am trying to scramble ID field in multiple tables in database. I created...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Using R apply

See possible answers