Lukas Vileikis in Blogs Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest on September 17, 2024.… 13 September 2024 4 min read
Ben Johnston in Blogs Auditing SQL Server – Part 4 – Database Configuration Audit This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level hardware audits and SQL Server engine level audits.... 20 August 2024 15 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 7: MySQL Enterprise Backup In this blog, we walk you through the primary way to take enterprise-level backups in MySQL: MySQL Enterprise Backup. Have a read!… 03 December 2022 7 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 6: Physical vs. Logical Backups In this blog, we compare two of the most popular types of backups in MySQL - backups of a physical and logical nature. Curious what... 01 December 2022 9 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 5: Backing Up Big Data This blog will guide you through backing up big data sets in MySQL with ease. Have a read!… 26 November 2022 14 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 4: mydumper In this blog, we walk you through one of the most prominent MySQL logical backup solutions - a CLI-based tool called mydumper.… 22 November 2022 4 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 3: mysqlpump In this blog, we walk you through the brother of mysqldump - mysqlpump - and tell you everything about it. Have a read!… 19 November 2022 6 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 2: Percona XtraBackup In this blog, we walk you through one of the flagship backup offerings by Percona - XtraBackup.… 16 November 2022 7 min read
Lukas Vileikis Optimizing MySQL: The Basics of Query Optimization In this blog, we will walk you through the basics of query optimization in MySQL. Have a read!… 10 November 2022 4 min read
Database DevOps Grant Fritchey in Database DevOps What is database continuous integration? Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would... 07 October 2020 9 min read
Roy Ernest Introduction to SQL Server Spatial Data Many applications require the handling of geospatial data. Roy and Surenda take you through the basics of SQL Server spatial data types. … 18 March 2020 22 min read
Blogs Dennes Torres in Blogs New Technologies to Study One great result from PASS Summit, especially when we are close to a new SQL Server release, is to identify important technologies to study on... 28 November 2018 7 min read
Kalen Delaney SQL Server Internals: In-Memory OLTP In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help... 07 December 2017 2 min read
Hugh Bin-Haad Relational Algebra and its implications for NoSQL databases With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the... 01 April 2016 4 min read
Robert Sheldon SQL Server System Functions: The Basics Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the... 31 March 2016 22 min read
Elizabeth Ayer The Comeback of Migrations-Based Deployments With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which are normally called 'migrations-based approaches',... 17 March 2016 11 min read
Matthew Skelton Database Lifecycle Management for ETL Systems Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL processes tend to grow in... 16 March 2016 32 min read
Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery... 15 March 2016 23 min read
Matthew Skelton Database Migrations: Modifying Existing Databases It should be simple to upgrade a database to a new version. It certainly can be, but if you need to preserve the existing data... 09 March 2016 34 min read
Robert Sheldon SQL Server Metadata Functions: The Basics To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the... 09 March 2016 21 min read
