Joey on SQL Server


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.

A Deep Dive Inside Azure SQL Database, Part 2

In the second part of this series, Joey describes the methods that Microsoft uses to manage code rollouts, and how it detects hardware and software problems on Azure SQL.

Industrial Rigging Graphic

A Deep Dive Inside Azure SQL Database, Part 1

Microsoft promises 99.995 percent uptime for the Azure SQL platform, which is incredible. In the first of a two-part series, Joey takes an close look at the infrastructure that supports high availability in Azure database services.

Understanding Columnstore Indexes in SQL Server

First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data work best with them.

IT Security Isn't Supposed To Be Easy

Joey explains why it's worth it to endure a little inconvenience for the long-term benefits of a password manager and multifactor authentication.

Gears

Getting Started with Dbatools for SQL Server

An open source project gives DBAs the ability to channel PowerShell for automating and scaling complex SQL Server tasks, starting with the most basic: database backups.

How To Be a Better DBA: 4 Strategies To Improve SQL Server Performance

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ways to make life easier.

Ransomware: What It Means for Your Database Servers

Ransomware affects databases in very specific ways. Joey describes the mechanics of a SQL Server ransomware attack, what DBAs can do to protect their systems, and what security measures they should be advocating for.

SQL Server 2019 Licensing: How Much Does It Cost and What's Included?

Microsoft has clarified the more confusing elements of SQL Server licensing and extended major benefits to customers. The catch is that Software Assurance is required to take advantage of them.