Remove Best Practices Remove Document Remove Servers Remove Tuning
article thumbnail

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Percona

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. Spoiler alert: This post focuses on MongoDB 3.6.X

article thumbnail

From Proprietary to Open Source: The Complete Guide to Database Migration

Percona

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Performance tuning The first critical move in performance tuning is query optimization.

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

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. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49
article thumbnail

Best Web Performance Books to Learn Site Speed Optimization

MachMetrics

Author Steve Souders writes about the best practices that he gained as the Chief Performance Yahoo!, Even Faster Web Sites: Performance Best Practices For Web Developers. High Performance Web Sites: Essential Knowledge For Front-End Engineers. and the Head Performance Engineer at Google. – Aurel V.

Speed 85
article thumbnail

Exploring PostgreSQL Backup Strategies for Enterprise-Grade Environments

Percona

Database Performance Tuning : By optimizing backup schedules, monitoring for errors, or looking for ways to reduce backup storage needs, DBAs are always working to improve the efficiency of backups and restores. Continuous archiving of WALs to a remote backup server that is redundant and avoids a single point of failure.

article thumbnail

The Ultimate Guide to MySQL Partitions

Percona

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. This helps identify potential issues and fine-tune the partitioning strategy. Documentation : Always be documenting!

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40