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.

Azure SQL Server Database

by Derek Wilson

Business Intelligence and Enterprise Architecture

SQL Server in Azure
You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have...

2014-12-04 (first published: 2014-12-01)

6,764 reads

SQL Server Management Studio Reports

by Derek Wilson

Business Intelligence and Enterprise Architecture

SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within...

2014-11-21 (first published: 2014-11-17)

7,586 reads

SQL Server Table Partition Example

by Derek Wilson

Business Intelligence and Enterprise Architecture

Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...

2014-11-03

5,100 reads

SQL Pass Summit 2014

by Derek Wilson

Business Intelligence and Enterprise Architecture

Next week I will be in Seattle for the 2014 SQL Pass Summit event. If you are involved in projects...

2014-10-30

1,153 reads

SQL Server TABLESAMPLE

by Derek Wilson

Business Intelligence and Enterprise Architecture

Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a...

2014-10-28 (first published: 2014-10-20)

7,353 reads

SQL Server Checksum

by Derek Wilson

Business Intelligence and Enterprise Architecture

Use SQL Server Checksum in Data Warehousing
When building data warehouses you often need a fast way to know if the...

2014-10-14

2,298 reads

Common Table Expressions (CTE)

by Derek Wilson

Business Intelligence and Enterprise Architecture

Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...

2014-10-08 (first published: 2014-10-03)

9,008 reads

SQL Server 2014 Cardinality Estimator

by Derek Wilson

Business Intelligence and Enterprise Architecture

SQL Server 2014 Cardinality Estimator
The SQL Server 2014 cardinality estimator has been improved to increase the quality of SQL Server query...

2014-09-25

982 reads

Schema on Read vs Schema on Write

by Derek Wilson

Business Intelligence and Enterprise Architecture

Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...

2014-09-12

1,190 reads

Business Intelligence Strategy – Beginning Steps

by Derek Wilson

Business Intelligence and Enterprise Architecture

Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...

2014-09-01

731 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