Derek Colley

Dr. Derek Colley is the lead technical consultant for Optimal Computing, a boutique data consultancy based in the UK NW helping clients troubleshoot, configure, plan and deploy their data platforms. He specializes in data integration and database performance optimization, and is a PhD candidate with Staffordshire University, looking into methods of integrating AL query selection algorithms with the cost-based query optimizer. In his spare time, he enjoys building robots, going outdoors, and spending time with his four children.
  • MSSQLTips Awards: Trendsetter (25+ tips)
Title Category Date
SQL Server Functions – VARP, SOUNDEX and NTILE Functions System2026-06-09
Create Custom Audit Specifications using SQL Server Audit Auditing and Compliance2024-06-11
Run Python Scripts in SQL Server Agent SQL Server Agent2019-01-30
Automatically Create and Anonymize Downstream Databases from Azure DB Azure2018-11-05
Importing Data from AWS DynamoDB into SQL Server 2017 Amazon AWS2018-07-30
Choosing Resource Model and Service Tier for Azure DB Azure2018-07-11
SQL Server Data Access Using R – Part 3 SQL Server 20162017-06-28
SQL Server Data Access Using R – Part 2 SQL Server 20162017-05-30
SQL Server Data Access Using R – Part 1 SQL Server 20162017-05-22
Configuring SQL Server Endpoint and ACL Access in Windows Azure Azure2016-06-14
Remodel Poorly Designed SQL Server Database Tables Database Design2016-05-11
Storing passwords in SQL Server – things to know to keep the data secure Security2016-04-25
Building Quick SQL Server Data Input Forms with InfoPath Application Development2016-04-11
Implementing Luhn’s Algorithm in T-SQL to validate credit card numbers Functions User Defined UDF2014-08-27
Accessing OLE and COM Objects from SQL Server using OLE Automation Stored Procedures Scripts2014-08-21
Demonstrating the Effects of Using Data Compression in SQL Server Compression2014-03-12
Different ways to get random data for SQL Server data sampling Functions System2014-01-29
Explanation of SQL Server IO and Latches Locking and Blocking2013-10-30
Compare Big Data Platforms vs SQL Server Big Data2013-08-29
Techniques For Improving SQL Query Performance – Indexing, Parameterization and Partitioning Performance Tuning2013-08-22
Creating Dynamic T-SQL to Move a SQL Server Database Dynamic SQL2013-07-31
Troubleshooting Excess Compilations in SQL Server Using the Plan Cache and PowerShell Performance Tuning2013-07-18
Demonstrations of Transaction Isolation Levels in SQL Server Locking and Blocking2013-06-18
Configuring Alerts for SQL Server AlwaysOn Availability Groups Availability Groups2013-06-11
Encrypt and Decrypt SQL Server Stored Procedures, Views and Functions Encryption2013-05-30
Microsoft SQL Server 2012 Service Pack 1 Summary Install and Uninstall2013-05-20
Understanding the SQL Server 2012 Licensing Model Licensing2013-04-24
SQL Server JOIN Hints JOIN Tables2013-04-02
Troubleshooting and Fixing SQL Server Page Level Corruption Disaster Recovery2013-02-07
Troubleshooting SQL Server Replication Replication2013-01-22
Standardizing SQL Server CRUD Templates with Rollback Plans Testing2013-01-03