sqlrider

Alex Stuart is a DBA from Manchester, UK, who levelled up from bartender to application support to accidental DBA to full-time Default Blame Accepter.
Primarily a production DBA fond of performance tuning and upgrades, but known to get hands dirty with whatever tool fits the job - Powershell, C#, ASP.NET, breaker bars.
In summer he rides fast bikes on as many racetracks as he can fit in.
In winter he reads and plays guitar and videogames. Ok, sometimes in summer he also does all of those things.

Interests: Technology, philosophy, motorbikes, videogames
Skills: Performance tuning, Azure, automation

Twitter: @https://twitter.com/sqlrider
Website: https://sqlrider.net
LinkedIn: https://www.linkedin.com/in/alex-stuart-sqldba/

All authors

A Very Simple Blocking Alert

by sqlrider

Sqlrider - Speed enthusiast

Blocking in SQL Server can be good – after all, it’s one of the ways consistency is guaranteed – we usually don’t want data written to by two processes...

2021-05-13

4 reads

T-SQL Tuesday #138

by sqlrider

Sqlrider - Speed enthusiast

This month’s T-SQL Tuesday is hosted by Andy Leonard who has poised the question ‘What do you do when technology changes underneath you?’ I was going to begin by...

2021-05-11

13 reads

What do you do when technology changes underneath you? (T-SQL Tuesday #138)

by sqlrider

Sqlrider - Speed enthusiast

This month’s T-SQL Tuesday is hosted by Andy Leonard who has poised the question ‘What do you do when technology changes underneath you?’ I was going to begin by...

2021-05-11

1 reads

SSIS – Arithmetic overflow error converting IDENTITY to datatype int

by sqlrider

Sqlrider - Speed enthusiast

I recently encountered a SSIS package that was failing due to an ‘arithmetic overflow error converting IDENTITY to datatype int’; Conversion/overflow errors aren’t that unusual – normally a data...

2021-04-06

42 reads

Serverless Azure SQL DB can show incorrect data space usage in the Portal

by sqlrider

Sqlrider - Speed enthusiast

A quick PSA on the behaviour of Serverless Azure SQL DB space reporting in the Azure Portal. I recently had to shrink a large Azure SQL DB for cost...

2021-03-31

24 reads

Getting SQL Services Information with Powershell

by sqlrider

Sqlrider - Speed enthusiast

Hopefully you already know everything about your SQL estate, including what services are installed and what’s running them, either because it’s so small you just know, or, preferably, you...

2021-03-15

14 reads

All authors

sqlrider

A Very Simple Blocking Alert

T-SQL Tuesday #138

What do you do when technology changes underneath you? (T-SQL Tuesday #138)

SSIS – Arithmetic overflow error converting IDENTITY to datatype int

Serverless Azure SQL DB can show incorrect data space usage in the Portal

Getting SQL Services Information with Powershell

Blogs

How to find free space in Azure PosgreSQL

T-SQL Tuesday #180: Good enough is perfect Roundup

Using SQL Compare with Read-only Access

Forums

Compare rows within the same table

Microsoft Recommendations for Update Stats?

how can i tell if our db2 driver is ms or ibm or other?

Question of the Day

A Strange Result