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.
- By Joey D'Antoni
- 09/08/2020
With cloud suites like Microsoft 365 scattering user data across multiple apps and services, application-aware backups and restorations are due for a surge in renewed interest.
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.
- By Joey D'Antoni
- 07/22/2020
There's another threat to consider when it comes to developing a backup strategy for static data on an active volume: bit rot.
Microsoft announced on Thursday that it bought ADRM Software Inc., a maker of data models for various industries.
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.
- By Joey D'Antoni
- 05/13/2020
Beyond just crunching budgets, Microsoft's recent Excel overhaul will give it the intelligence to recognize over 100 new data categories and process information in ways that were previously unimagined.
Microsoft and Red Hat this week announced an expansion of their integration work as part of this week's Red Hat Summit 2020 event, which went virtual.
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.
- By Joey D'Antoni
- 02/10/2020
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.
- By Joey D'Antoni
- 01/21/2020
IDC's latest guide on full-time employment for the information and communications technology (ICT) sector has its sights set on IT organizational transformation.
A comparison of SQL Server's throughput performance on Microsoft Azure and Amazon Web Services (AWS) gives the edge to Microsoft's cloud.
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.
- By Joey D'Antoni
- 11/08/2019
From Big Data clusters to faster database recovery, here are the biggest changes Microsoft has made to its new flagship database server.
- By Joey D'Antoni
- 11/04/2019
Microsoft CEO Satya Nadella described the new boundaries Microsoft is breaking in its Azure cloud.
- By Joey D'Antoni
- 11/04/2019