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 […]
KQL cheatsheet
The good thing about KQL is that the syntax is familiar to those who use TSQL, and any other RDBMS query language. This makes sense because the purpose […]
KQL – Tutorial – What is KQL?
What is KQL? KQL (Kusto Query Language) is a query language developed by Microsoft for searching and analyzing data. It is used in various Microsoft products, such as […]
Updating Stats in Azure SQL Database
Recently we were having some issues with DTU utilization in Microsoft SQL Azure. One of the troubleshooting steps that was suggested was the update statistics and rebuild indexes. […]
Profile columns for indexes
Every once in a while, as part of a consulting project I need to investigate all the different columns and datatypes used within the tables. Often in order […]
Monty Hall Simulation using T-SQL
The first time I heard about the Monty Hall problem was while watching TV. The host of the TV show had presented the problem as you typically see. […]