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

12 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

19 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

5 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

67 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

35 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

50 reads

Sqlrider - Speed enthusiast

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

Audit – Security Compliance Frameworks (Part 1)

Restore SQL Server Database to an OrbStack Container

Day of Data Baton Rouge Slides and Code

Forums

ALAMAT BCA KCU KUNINGAN Telp 08218200174

ALAMAT BCA KCU PURI INDAH Telp 08218200174

SQL 2025 SSMS Nonsense

Question of the Day

SQL Server Certificates