SQL Server DBA specializing in performance tuning and disaster recovery. Bad code rarely begins the cascade of most SQL Server performance problems. Typically, it begins with something that is much ...

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 ...

# This script checks some SQL Server best practices, running it and understanding the results is for those who have been working with the product for some time. # It can be run locally or remotely ...

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 ...

Ds_Email_Information_1_ENG VARCHAR(200), Ds_Email_Information_2_ENG VARCHAR(200), Ds_Email_Information_1_PTB VARCHAR(200), Ds_Email_Information_2_PTB VARCHAR(200 ...

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 ...