When it comes to using Always On in Microsoft SQL Server it is a technology that has been around for a long time. The feature was introduced in […]
ADR new features in SQL 2022 – multithreaded version store
Accelerated database recovery is one of those features that was introduced in SQL 2019 and you have probably been enjoying its benefits without ever knowing how much it […]
NULLs in MS SQL Server
NULLs are a frequently misunderstood concept within databases. This confusion often arises because NULL is mistakenly considered equivalent to empty or mathematically equal to zero, which is not […]
The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)
The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)
Should you use GitHub Co-pilot in Azure Data Studio
The simple answer is no. By now you have already tried ChatGPT and have a decent idea about its limitations. The same hold true for GitHub Co-pilot. The […]
Does DB_ID use identity column or Sequence?
An interesting use case came up recently about misusing databases keys by piggy backing off the DBID of another database that already exists. This is a theoretical exercise […]
administration / Azure / Database / MSSQL
How to modify a bacpac file – Moving databases from Azure SQL to SQL VM
When working with Azure SQL databases one of the challenges is how difficult it is to move data across environments. Say for example we have a production database […]
Low volume on Speaker when playing songs on Amazon Prime
This issue bugged me personally for a long time and it was mainly because the advice on the internet doesn’t seem to explain that actual issue and states […]
Modifying a bacpac file
When working with Azure SQL databases one of the biggest irritants is the lack of access to backup files. A lot of the time we need to refresh […]