Joey on SQL Server


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.

How To Use Query Store Hints in Azure SQL

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

The Right Approach to Database Backups

Elaborate backups might seem like a good idea at first, but they add unnecessary complexity to your recovery process. Here are some things to keep in mind to make backup and recovery as smooth as possible.

Speed Logo

Top Tips To Make SQL Server Run Faster on Azure VMs

Storage and performance can be quite different in the cloud. It's important to choose the right VM size and configure your storage properly to keep SQL Server workloads running smoothly.

Bridgt Tunnel

Working with Secure Enclaves in Azure SQL Database

Microsoft announced a lot of Azure SQL news at Ignite this month, but few as critical to application development security than the public preview of Always Encrypted with secure enclaves. Here's how to get started with this new feature.

How To Automate Tasks in Azure SQL Database

Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in Azure.

Dark City Illustration

The Night the Lights Went Out in the Cloud: Lessons from the AWS Outage

Last week's AWS outage that broke the Internet showed how critical it is to build applications that can withstand transient failure. Here's what you need to know to design a resilient cloud app (and it doesn't involve multicloud).

Steel Grid Graphic

Backups and Consistency Checks: The DBA's Top Priorities

Database protection goes far beyond backups; ensuring the quality and consistency of those backups is equally important. Here are the maintenance tasks that will make sure your databases stay in top shape.

Jumbled Word Cloud Graphic

Q&A: How Microsoft Is Raising Azure Arc's Data Services Game

Ignite 2020 saw the public preview of Azure Arc enabled data services, the latest step in Microsoft's bid to demystify multicloud. Principal program manager Travis Wright explains how it works.

Subscribe on YouTube