Joey on SQL Server


Gears

Microsoft Finally Releases SQL Server 2022

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.

Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization

Reduce workload times with this handy feature that can benefit every database pro.

Industrial Rigging Graphic

A Deep Dive into SQL Server 2022's Query Performance Features, Part 1

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception.

Frozen Glass

Everything You Need To Know About Azure SQL Database Emulator

Microsoft's Asad Khan breaks down some details on the recently announced feature.

DBAs: You Need To Learn PowerShell

It's time. Make your life a lot easier by automating those time-intensive tasks.

Matrix

Microsoft Build: A Deeper Dive into SQL Server 2022

Build 2022 marks the long-awaited public preview of Microsoft's next-generation database engine. Here are the top seven new SQL Server 2022 features to look out for.

Tracking Performance Impacts of SQL Server Changes

Getting a bird's eye view can help to quickly spot trouble areas.

Introducing SQL Server 2022: Top 3 New Features Announced at Microsoft Ignite

The next major version of Microsoft's flagship database engine is now in private preview. Here's what you need to know about it.

What Is TempDB and Why Does It Matter?

Time to hit the basics and dive into how theSQL Server database engine works.

That One Easy Trick for SQL Server Performance

Here's how to fix that performance database query to speed up response time.

Why Activity Monitor May Be Hurting Your SQL Server's Performance

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives.

Chalk Arrow

So You Need To Move Off SQL Server 2016

As of July 13, SQL Server 2016 no longer has mainstream support. Your next steps as a DBA include understanding Microsoft's support model, knowing the risks of upgrading and then biting the upgrade bullet.

Subscribe on YouTube