Azure-Sql-Db

This is part 4 of a series on working with change data capture (CDC) in Azure SQL Database. This part discusses how to enable it and how to use it. When I was reading the documentation for CDC in Azure SQL Database, I kept coming across a mention that it required at least an S3 service level objective (SLO), if you were using a DTU-based database. I really hoped that wasn’t the case.

2023-09-23

I had an email from a friend today where he asked what was wrong with SQL Server, and wondered if ROUND() didn’t go to the same school that he did. The example was: SELECT '0.5' [SOURCE VALUE], '1' [SHOULD ROUND TO], ROUND('0.5',0) [SQL SAYS] UNION SELECT '1.55', '1.6', ROUND('1.55',1) UNION SELECT '94.55', '94.6', ROUND('94.55',1); The output was: What was puzzling him is why SQL Server’s ROUND was converting 94.55 to 94.

2023-07-11

This is part 3 of a series on working with change data capture (CDC) in Azure SQL Database. This part discusses how to enable it and how to use it. To show how this works, I have created an Azure SQL Database called CDCTest. I created it as a DTU-based database with a service level objective (SLO) of S3. I’ll discuss more about the licensing implications of CDC in part 4.

2023-06-02

In the part 1 of this series, I discussed the positioning of Change Data Capture. In part 2, I want to cover how it works. Log Reading There are many ways that you can output details of changes that occur in data within SQL Server. Many of those methods require actions to occur at the time the data change is made. This can be problematic. The first problem with this, is the performance impact on the application that’s making the change.

2023-03-06

I often need to capture the changes from one database into another. The most common reason is that I’m wanting to bring changes from a transactional system across into a data warehouse that’s part of a BI setup. So which technology is best to use for this? That’s not a trivial question to answer but here are some thoughts: Replication? Unfortunately, this one’s not available for Azure SQL DB as yet.

2023-02-26