Sqlrider - Speed enthusiast

Automating AlwaysOn Availability Group Failover for SSISDB 2012/2014

• by sqlrider

• Sqlrider - Speed enthusiast

Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...

2021-05-28

17 reads

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-24 (first published: 2021-05-13)

556 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

4 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

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

4 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

1 reads