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, […]
Popular Posts
Trending Posts
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
Recent Posts
Editors Choice
Converting times across time zones
SQL 2025 Optimized locking in SQL2025
You Can’t Be King till You’ve Killed Someone
Fuzzy String matches in TSQL
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 […]
Azure AI Video Indexer
Azure AI Video Index as its name suggests can help create metadata about a video based on its content. The idea being you can upload a video and […]
Azure Always On Replicas and other options that could save you money.
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 […]