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

8 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

219 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

4 reads

Blogs

Bicep Your Elastic Jobs

By

I posted on Terraform and Azure SQL last year but wanted to see what...

3rd Party Applications Have Issues

By

As a SQL DBA, what do you do when a vendor application has performance...

Check Azure SQL DB Space Used

By

A couple of days ago I was doing some cleaning on some Azure SQL...

Read the latest Blogs

Forums

The On-Call Load

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The On-Call Load

Two Table Hints

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Two Table Hints

Database Dashboards in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Dashboards in Azure Data...

Visit the forum

Question of the Day

Two Table Hints

What happens when I run this code:

SELECT
  p.ProductName
, p.ProductCategory
FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);

See possible answers