Microsoft is integrating AI features directly into SQL Server for the first time. The new version also brings JSON support and changes the licensing model. Microsoft announced the general availability ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Your browser does not support the audio element. In SQL Server, the tempdb database is the unsung hero behind countless operations—storing temporary tables ...

Solutions Architect, Azure cloud expert, blogger, trainer, professional racing driver. I recently migrated a full-fledged SQL Server from a virtual machine to Azure SQL. The journey was full of ...

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...

One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of how ...

This script detects when there are sleeping sessions with open transactions older than 10 minutes by default. Such sessions can cause blocking and can prevent the transaction log from clearing, ...

The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...