I was asked this question recently when I conducted a SQL Session and it felt like a very simple and easy question to answer and something I am […]
How to Setup and Configure Query Store in MS SQL Server
Query Store is a powerful feature in Microsoft SQL Server that serves as a performance monitoring and troubleshooting tool. It essentially acts as a database-wide flight data recorder, […]
How to use Query Store DMVs to troubleshoot performance issues
Troubleshooting MS SQL Server is something that comes from years of experience and there is a certain amount of pride that comes with mastering the level of knowledge […]
Is Using Top operator good for your query?
Using the TOP operator in T-SQL procedures is a common practice among developers. It’s often employed to limit the number of records, either to fetch the first value […]
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 […]
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 […]