article thumbnail

Common SQL Server Mishaps

SQL Performance

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. I always check backups first when looking at a new system. Statistics.

Servers 49
article thumbnail

PREVIEW : SentryOne Plan Explorer Extension for Azure Data Studio

SQL Performance

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query.

Azure 90
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Back-to-Basics Weekend Reading - Staged Event-Driven Architecture

All Things Distributed

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 17 August 2012 07:00 PM. I am in São Paolo, Brazil for the 2012 AWS Latin America Summit and for The Next Web Latin America conference. Back-to-Basics Weekend Reading - Staged Event-Driven Architecture. Comments ().

article thumbnail

Expanding the Cloud for Windows Developers - All Things Distributed

All Things Distributed

Werner Vogels weblog on building scalable and robust distributed systems. By Werner Vogels on 08 May 2012 02:00 PM. Amazon RDS for SQL Server. We introduced Amazon RDS for Oracle last year , and based on the demand from our Windows customers, are introducing Amazon RDS for SQL Server today. Comments ().

Cloud 115
article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MySQL?

article thumbnail

PREVIEW : SentryOne Plan Explorer Extension for Azure Data Studio

SQL Performance

Connecting to SQL Server 2012 or better, or Azure SQL Database. And recommended system configuration: Two or more cores 8GB or more of memory Operating Systems: Windows (8.1 / Server 2012 R2 or better) macOS (10.13 In a new query window, establish a connection to a server, and write or paste a query.

Azure 50
article thumbnail

Full vs. Incremental vs. Differential Backups: Comparing Backup Types

Percona

This blog was originally published in January 2012 and was updated in June 2023. Advantages of full backups Full backups provide several benefits in terms of safeguarding data and facilitating recovery processes, as they encompass thorough data replication and enable complete system restoration during critical situations.

Storage 66