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

DECLARE @db_name SYSNAME = 'StackOverflow2013' -- Replace with your database name DECLARE @db_size_GB FLOAT = 100.0 -- Actual DB size used for test (in GB) DECLARE @target_db_size_GB FLOAT = 1024.0 -- ...

Welcome to this Microsoft solutions workshop on SQL Server 2019 Workshop. In this course you will learn how to solve modern data challenges with SQL Server 2019 using a hands-on lab approach. This ...

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

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...