It’s Time for a Disaster Recovery Back-Up Plan

No one really likes to plan for the worst, but the hard reality is that disasters can strike businesses at any time. Data loss and downtime can impact a company financially and cause other serious consequences.

29th Jan 2020

YugabyteDB Engineering Update – Jan 29, 2020

We are pleased to announce that YugabyteDB 2.0.11 is now live! You can read the official release notes of this and previous versions here. These two releases shipped with a combined 30+ new enhancements and fixes.

29th Jan 2020

Move a SQL database using the detach and attach method

This article explores the process of moving a SQL database using the detach and attach method. Sometimes we require moving data files (primary, secondary) and log files to different drives and servers. Some of the cases where you might require moving database files are as follows:

29th Jan 2020

Data Summit 2020 Call for Speakers Extended to Nov. 25

The call for speakers is open for the seventh annual Data Summit conference, to be held at the Hyatt Regency in Boston, May 19-20, 2020, with pre-conference workshops on May 18.

29th Jan 2020

AWS RDS SQL Server Announcements - 2019

The latest blog posts on SQLServerCentral.

29th Jan 2020

The Curious Case of… a sudden latency and memory usage increase

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent.

29th Jan 2020

How do I Install SQL?

I have seen the question several times on various groups or forums – “How do I install SQL?”. From a DBA standpoint, this isn’t even a properly formed question. From a developer learning standpoint the question makes sense. I needed Python, I went and downloaded Anaconda.

29th Jan 2020

Preserving commit order on replicas with binary log disabled

MySQL 8.0.19 introduces Binlogless replicas with commit ordering which means you can deploy asynchronous replicas without binary logs enabled, and commit transactions in the same order they are replicated in.

29th Jan 2020

The ultimate performance for your big data with SQL Server 2019 Big Data Clusters

Microsoft SQL Server 2019 Big Data Cluster enables intelligence over all your data and helps remove data silos by combining both structured and unstructured data across the entire data estate. Big Data Clusters integrates Microsoft SQL Server and the best of big data open-source solutions.

29th Jan 2020

Chaos Engineering and SQL Server

Recently I’ve been delving into Chaos Engineering, reading books, watching videos, listening to podcasts etc. and I find it really intriguing….I mean, it just sounds exciting, right? CHAOS Engineering! N.B.

29th Jan 2020

My Experiences as a Senior Solutions Architect and a Mother on Parental Leave: Meet Veronica Tudor

In this interview, you will meet Veronica Tudor, Senior Solutions Architect in Dublin. Veronica speaks about how this role compares to her previous ones, and she also opens up about her maternity leave, and how she’s grown both personally and professionally at MongoDB.

29th Jan 2020

How to Remove Times from Dates in SQL Server

And let’s say you wanna find the users who last accessed the site on September 9, 2018 – regardless of the time. Here are a few ways to do it: Here are their actual execution plans. I’m using SQL Server 2019, with 2019 compatibility level, and the 50GB StackOverflow2013 database.

29th Jan 2020

End of Life Notification for Percona Server for MongoDB 3.4

As noted on our Software and Platform Lifecycle page, Percona Server for MongoDB 3.4 reached end of life on January 31, 2020.

29th Jan 2020

Why no GUI installations anymore?

I believe the person in question didn’t like that I no longer do those massive articles showing how to install RAC using the GUI. Instead I do automatic silent builds using Vagrant and shell scripts. My recent RAC articles just describe the Vagrant builds.

29th Jan 2020

What to Monitor in MySQL 8.0

Monitoring is a must in all environments, and databases aren’t the exception. Once you have your database infrastructure up-and-running, you’ll need to keep tabs on what’s happening.

29th Jan 2020

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

Last Friday I spent my lunch break going through some links I had marked for future reading. One of them was a post earlier this month by Erik Darling about a new troubleshooting tool he made called “sp_pressure_detector,” including a video showing how to use it.

29th Jan 2020

Migrating from Oracle to PostgreSQL: Tips and Tricks

Migrating to PostgreSQL from Oracle is a topic that often comes up in discussions around PostgreSQL. At Crunchy Data, we are of course not surprised that there is broad interest in moving to the world's most advanced database.

28th Jan 2020

Creating ACID Transactions in Azure Cosmos DB with SDK

Creating transactional batch of operations by using Cosmos DB SDK

28th Jan 2020

How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error

I’ve come across another error message in my seemingly never-ending battle with Azure Key Vault. A while back I couldn’t delete a resource group because of Key Vault soft-delete. Then I couldn’t recreate a Key Vault with the same name again because of soft-delete.

28th Jan 2020

Learn SQL: Aggregate Functions

SQL has many cool features and aggregate functions are definitely one of these features, actually functions. While they are not specific to SQL, they are used often.

28th Jan 2020

Distributed SQL vs. NewSQL

Our previous post in this series “What is Distributed SQL?” highlights the common architectural principles as well as the business benefits of distributed SQL databases.

28th Jan 2020

Index Planner for Couchbase Global Secondary Indexes

In this article, learn more about Index Planner for Couchbase Global Secondary Indexes. An integral aspect of any distributed system is to seamlessly provide high availability (HA) and load balancing capabilities to its user.

28th Jan 2020

Understanding the ProxySQL Audit Log

ProxySQL became a very important bit of infrastructure in the database environments. It works as a load balancer, it helps to shape the flow of the traffic and reduce the downtime. With great power comes great responsibility.

28th Jan 2020

Performance Best Practices: MongoDB Data Modeling and Memory Sizing

Welcome to the first in a series of blog posts covering performance best practices for MongoDB. In this series, we will cover key considerations for achieving performance at scale across a number of important dimensions, including:

28th Jan 2020

Scheduled PostgreSQL Backups and Retention Policies with Kubernetes

It is important (understatement) that you take regularly scheduled backups of your PostgreSQL system as well as manage how many backups you have, which is known as "backup retention.

28th Jan 2020

pg_timetable: Advanced PostgreSQL scheduling

pg_timetable is a brand-new job scheduler for PostgreSQL implemented completely from scratch (in Go). Traditional job scheduling is quite limited and does not cover all we needed in real life.

28th Jan 2020

SQL EXISTS and NOT EXISTS

In this article, we are going to see how the SQL EXISTS operator works and when you should use it.

27th Jan 2020

Migrating from SQL Server to MariaDB on the MariaDB Knowledge Base

Federico is a freelance database consultant, organizer of the London Open Source Database Meetup, author of the book Mastering MariaDB, and well-known member of the MariaDB community..

First 161 162 163 164 Last