Art

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

Blog Post

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

19 reads

Blog Post

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...

2017-04-12

232 reads

Blog Post

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

11 reads

Blogs

How to Find Expensive Queries in Amazon Redshift

By

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

By

If you've been here before, you know this blog is usually about SQL Server,...

Designing a Storage Load Test for SQL Server

By

I’ve been doing storage load tests for SQL Server for a long time, both...

Read the latest Blogs

Forums

How Long is a Long I/O?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Long is a Long...

T-SQL Trigonometric Functions in SQL Server

By Imran2629

Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...

Half of All Engineers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Half of All Engineers

Visit the forum

Question of the Day

How Long is a Long I/O?

In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?

See possible answers