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 […]
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)