SQL Database Administrator/Developer. Background in developing OLTP/document based databases, SQLXML and performance tuning with an unhealthy fascination for the SQL query optimiser!

About me

I have been developing software from my early teens and stayed with technology after leaving school. Initially focussing on software development, networking and IT support type roles, I found...

2017-05-03

1 reads

Moved blog to Ghost

Another year, another blog update lol!… Last year I remember doing a significant version upgrade for my self-hosted Orchard CMS software on the DiscountASP hosting platform and it all...

2017-04-12

1 reads

Blogs

The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It

By

Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!

The Post Pandemic Office Experience

By

I traveled to Pasadena, CA this week to work with a few other Redgaters...

Connecting to Azure Blobs in Power BI

By

The step-by-step process below walks through connecting to data housed in Azure Blob Storage...

Read the latest Blogs

Forums

Get the last day of the year based on a date range

By dqurve

I am trying to get the last day of the year from a date...

Put two queries together

By stephen.aa

Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...

Excel Formula to create SQL Script for a Values Table

By allinadazework

Comments posted to this topic are about the item Excel Formula to create SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers