What to Check if PostgreSQL Memory Utilization is High

Reading from memory will always be more performant than going to disk, so for all database technologies you would want to use as much memory as possible. If you are not sure about the configuration, or you have an error, this could generate high memory utilization or even an out-of-memory issue.

18th Feb 2020

How to Deploy and using MySQL InnoDB Replica Set in Production ?

MySQL InnoDB ReplicaSet a quick and easy way to get MySQL replication(Master-Slave), making it well suited to scaling out reads, and provides manual failover capabilities in use cases that do not require the high availability offered by MySQL InnoDB cluster.

18th Feb 2020

Top 4 Database Design Tools

In this article, explore a comparison of four of the best database design tools. Good database design will significantly decrease maintenance work and minimize the chances of errors in a project. As every project has different requirements, finding the right tool for it can be a difficult task.

18th Feb 2020

Performance Best Practices: Sharding

Welcome to the fourth in a series of blog posts covering performance best practices for MongoDB. Through sharding, you can automatically scale your MongoDB database out across multiple nodes and regions to handle write-intensive workloads and growing data sizes, and for data residency.

18th Feb 2020

Five security principles developers must follow

Developers and their applications are the backbone of organisations across the world. But in recent years, large scale security breaches have put data protection at the forefront for product development teams. With the likes of the GDPR now in place, security must be a priority.

18th Feb 2020

Choosing a Processor for SQL Server

Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same. I have request SQL Server Expert Glenn Berry (b|t) to help us in selecting the right CPU.

18th Feb 2020

Celebrating record responses for the 2020 State of Database DevOps Report

I’m excited to announce that Redgate has published the fourth annual State of Database DevOps Report. This year we had more than 2,000 respondents to our survey on development and deployment practices for database changes.

18th Feb 2020

Database Normalization in SQL with Examples – SQLServerCentral

As a database developer, we might often come across terms like normalization and denormalization of a database. Database normalization is a technique that helps to efficiently organize data in a given database.

17th Feb 2020

Migrating PostgreSQL to the Cloud - Comparing Solutions from Amazon, Google & Microsoft

From a bird’s eye view, it would appear that when it comes to migrating the PostgreSQL workloads into the cloud, the choice of cloud provider should make no difference.

17th Feb 2020

SQL Undercover TV – Instant File Initialisation

Adrian has a look at the performance benefits of instant file initialisation Below is Ade’s auto growth script… DECLARE @trcfilename VARCHAR(1000) ; SELECT @trcfilename = path FROM sys.

17th Feb 2020

Join Elimination bug

It is possible to take subquery factoring (common table expressions / CTEs) too far.

17th Feb 2020

Every Db2 Article I've Written

Craig S. Mullins Sugar Land, TX, United States Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

17th Feb 2020

Important Health Checks for your MySQL Master-Slave Servers

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions.

17th Feb 2020

How to Run Orchestrator on FreeBSD

In this post, I am going to show you how to run Orchestrator on FreeBSD. The instructions have been tested in FreeBSD 11.3 but the general steps should apply to other versions as well. At the time of this writing, Orchestrator doesn’t provide FreeBSD binaries, so we will need to compile it.

17th Feb 2020

Significant SQL Server 2019 licensing changes

I thought I would cover significant SQL Server 2019 licensing changes for High Availability and Disaster Recovery. Because it was a big topic of conversation when I spoke at SQL Saturday Edinburgh recently. Which surprised me a bit because these licensing changes have been in-place for a while now.

17th Feb 2020

Recommended SQL Server Books, 2020 Edition

If you’re the kind of person who likes to read books, here are some that I think would expand your horizons. These links are Amazon affiliate links, so I make a few cents when you buy through ’em. It’s your way of tipping me for the book recommendations, so thank you!

17th Feb 2020

Why I Support Code Automation Tools Like ORMs

I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in point, ORM tools. Whether we’re talking nHibernate, Linq, or Entity Framework, the degree of loathing for these tools by most DBAs is really hard to measure.

17th Feb 2020

Getting started with MySQL Cluster using MySQL Cluster Manager

In this blog post we will look at how to install and configure MCM and then create a new cluster using MCM commands. Steps to install and and setup MCM as a service is explained here.

17th Feb 2020

SQL Server Checkpoint Monitoring with Extended Events

I was recently troubleshooting a SQL Server 2016 instance with long checkpoints, which surfaced as FlushCache entries in the error log. Basically, this tells you that checkpoint operations were taking longer than the target recovery time, which can happen for a variety of reasons.

16th Feb 2020

Distributed SQL Tips and Tricks – Feb 14, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation and blogs that have been published since the last post.

16th Feb 2020

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

I am very passionate about having a disaster recovery architecture, plan and strategy. This is very important for business continuity. I will be walking you through a journey on implementing High Availability (HA) (AlwaysOn Availability group) on MSSQL Server.

16th Feb 2020

MariaDB 10.5.1 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.5.1, the first beta release in the MariaDB 10.5 development series. See the release notes and changelogs for details.

16th Feb 2020

What Do You Find Difficult about SQL and Databases?

An interesting blog post came out today from Formidable Labs. As the blog title s...

16th Feb 2020

MySQL Adventures: CPU Cores and IOPS on GCE

TL;DR — If you are hosting your database server in GCE, then you have to be very cautious with capacity planning. The number of CPU cores has an impact on IOPS you get.

16th Feb 2020

MySQL – Download Sample Database – Sakila, World, Employee

Just like SQL Server, I do consult with MySQL, PostgreSQL, and MariaDB. One of the most popular questions, I often receive during my consulting engagement is that where can one download the sample database for various databases.

16th Feb 2020

Char problems

The semantics of comparing character columns of different types can lead to some confusion, so before I get into the main body of this note here’s a little test based on a table with one row: create table t1(c2 char(2), c3 char(3), vc2 varchar2(2), vc3 varchar2(3)); insert into t1 values ('XX','X

16th Feb 2020

Automating MySQL schema migrations with GitHub Actions and more

In the past year, GitHub engineers shipped GitHub Packages, Actions, Sponsors, Mobile, security advisories and updates, notifications, code navigation, and more. Needless to say, the development pace at GitHub is accelerated.

16th Feb 2020

A Tool to Compare PostgreSQL Database Schema Versions

The End Point development team has completed a major application migration from one stack to another. Many years ago, the vendor maintaining the old stack abandoned support and development. This led to a stack evolution riddled with independent custom changes and new features in the following years.

First 155 156 157 158 Last