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

9 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

32 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

22 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

7 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

Use a slicer to filter a visual based upon a measure in Power BI

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

Microsoft Fabric shortcuts

Forums

Data visualization agencies in India

Database Management Company

SQL Server software and windows version compatibility level

Question of the Day

Post Restore Tasks for the Resource Database