Using Amazon FSx for SQL Server Failover Cluster Instances

In this article, see what you need to know about using Amazon FSx for SQL Server failover cluster instances. Intro If you are considering deploying your own Microsoft SQL Server instances in AWS EC2, you have some decisions to make regarding the resiliency of the solution.

dzone.com

12th Jan 2021

Azure SQL Database named among the top 3 databases of 2020

We are excited to share that Azure SQL Database is among the most popular databases of 2020 according to DB-Engines, who recently announced their DBMS of the Year award.

azure.microsoft.com

12th Jan 2021

Study Guide for Passing AZ-500 Microsoft Certified Azure Security Engineer Associate

Microsoft launched the role-based certifications for Microsoft 365 and Azure. Based on your job role and experience, you can choose the certification that suits your profile. If your job is to manage security for Azure, then you can take the exam AZ-500.

blog.cloudthat.com

12th Jan 2021

SQL Server Move Database Files Step By Step

SQL Server Database Administrators often face the task of moving user database files to a new location.

mssqltips.com

12th Jan 2021

Announcing New Introduction to Neo4j 4.x Online Training Courses!

We have reorganized our Introduction to Neo4j course into multiple courses and we just published them on our GraphAcademy site. We have found that some users simply want an overview of Neo4j without needing to learn how to write Cypher statements.

neo4j.com

12th Jan 2021

Get Rid of Read Repair Chance

Apache Cassandra has a feature called Read Repair Chance that we always recommend our clients to disable. It is often an additional ~20% internal read load cost on your cluster that serves little purpose and provides no guarantees.

thelastpickle.com

12th Jan 2021

Considerations For Implementing Soft Deletes

Implementing soft deletes for an app that’s been around for a while can be tough.

erikdarlingdata.com

12th Jan 2021

Oracle 21c: Blockchain Tables

With Oracle Database 20c/21c the new feature Oracle Blockchain Tables has been introduced. Blockchain Tables enable Oracle Database users to create tamper-resistant data management without distributing a ledger across multiple parties.

blog.dbi-services.com

12th Jan 2021

The Preview of Database as a Service (DBaaS) in Percona Monitoring and Management is Now Live!

This week we officially kick-off the Preview of Database as a Service (DBaaS) in Percona Monitoring and Management. We are still looking for users to test and provide feedback during this year-long program, and we would love you to participate!

percona.com

12th Jan 2021

Configuring and using Oracle Connection Manager on Amazon EC2 for Amazon RDS for Oracle

This post describes how to configure Oracle Connection Manager on Amazon Elastic Compute Cloud (Amazon EC2) in an Amazon RDS for Oracle environment, and introduces some best practice use cases when using Oracle Connection Manager on Amazon EC2.

aws.amazon.com

12th Jan 2021

MySQL macOS Docker

While you can download MySQL as a DMG package, a number of users would prefer to install it as a Docker instance. You won’t find the macOS downloads on the same web site as other downloads. You can use the following macOS download site.

blog.mclaughlinsoftware.com

12th Jan 2021

Private vs. Public vs. Hybrid Cloud: Which One to Choose?

We outline some basic considerations and cloud comparisons, as well as best practices for how to integrate and manage these complex deployments. Most enterprise IT departments now manage applications across multiple environments in a dizzyingly complex overall IT architecture.

dzone.com

12th Jan 2021

AWS Lambda Error Handling

In this article, we’ll be discussing everything you need to know about the basics of AWS Lambda error handling and some popular methods using StepFunctions and X-Ray. Regardless if you’re an AWS Lambda expert or if you’re a new Lambda user, there’s always something new to learn.

dashbird.io

12th Jan 2021

How to do Document-level Locking on MongoDB and .NET Core

Hi All! Today we’re going to see how MongoDB handles locks and how we can achieve Document-level locking. The default MongoDB storage engine, WiredTiger, uses optimistic concurrency control, or OCC. In a nutshell, it assumes that

dzone.com

12th Jan 2021

Dynamic SQL Injection With Oracle ERP Cloud

This article covers the steps to create a Dynamic BI Report so SQL can be injected at a run time to the report, which can be useful in building integrations. In this previous article, we learned how to design and Develop an Oracle Cloud BI Report.

dzone.com

12th Jan 2021

A Snippet of Features: Reviewing PostgreSQL Version 13

This latest and greatest version of PostgreSQL, version 13, has been here since last summer and continues the tradition of gains in performance, administration, application development, and security enhancements. TIP: More detailed information can be found in the Release Notes here.

percona.com

12th Jan 2021

Oracle archived redo size – the research

Oracle archived redo size may be smaller than that of online redo log files. In this article, Jonathan Lewis takes a deeper look.

red-gate.com

12th Jan 2021

MySQL Group Replication – How to Elect the New Primary Node

In this blog, I am going to explain the different ways of electing the PRIMARY node in MySQL group replication. Before MySQL 8.0.2, primary election was based on the member’s UUID, with the lowest UUID elected as the new primary in the event of a failover. From MySQL 8.0.

percona.com

12th Jan 2021

Understanding Docker: part 26 – Docker components

Understanding Docker can be difficult or time-consuming. In order to spread knowledge about Cloud technologies I started to create sketchnotes about Docker. I think it could be a good way, more visual, to explain Docker (and other technologies like Kubernetes and Istio).

dev.to

11th Jan 2021

Database Cloning in Amazon Aurora

Amazon Aurora provides a MySQL and PostgreSQL compatible relation database with performance and feature enhancements over the existing databases. In the previous articles, we discussed the following features. You can refer to ToC at the bottom.

sqlshack.com

11th Jan 2021

Which Moodle Database Should You Use?

The open source, eLearning LMS Moodle has recently been getting a lot of attention due to the COVID-19 Pandemic.

severalnines.com

11th Jan 2021

AzureFunBytes – A Guide to Skills Measured for the Azure Fundamentals Exam (AZ-900)

Taking the AZ-900: Microsoft Azure Fundamentals Certification Exam is one of the great first steps in becoming proficient in the Azure Cloud. Those who take this exam will need a foundational understanding of the cloud in order to pass it.

devblogs.microsoft.com

11th Jan 2021

A Practical Multi-Cloud Distributed SQL Strategy for 2021

In order to meet the needs of the growing demand of businesses, many global enterprises are choosing cloud infrastructure from multiple providers like AWS, Azure, Google, or private data centers.

blog.yugabyte.com

11th Jan 2021

A use case for sp_prepare / sp_prepexec

There are features many of us shy away from, like cursors, triggers, and dynamic SQL. There is no question they each have their use cases, but when we see a trigger with a cursor inside dynamic SQL, it can make us cringe (triple whammy).

sqlperformance.com

11th Jan 2021

Auditing and Monitoring PostgreSQL/EPAS - APJ

The most common problems a database administrator or user encounters while working on a database is to audit and monitor the health of their databases which includes observing the database activity so as to be aware of the actions of the users, finding the slow running statements, finding why database systems performance is low during certain inter

enterprisedb.com

11th Jan 2021

Full Read Consistency Within Percona Kubernetes Operator for Percona XtraDB Cluster

The aim of Percona Kubernetes Operator for Percona XtraDB Cluster is to be . The Operator solution is using Percona XtraDB Cluster (PXC) behind the hood to provide a highly available, resilient, and scalable MySQL service in the Kubernetes space.

percona.com

11th Jan 2021

Cross-account replication with Amazon DynamoDB

Hundreds of thousands of customers use Amazon DynamoDB for mission-critical workloads. In some situations, you may want to migrate your DynamoDB tables into a different AWS account, for example, in the eventuality of a company being acquired by another company.

aws.amazon.com

11th Jan 2021

Raspberry Pi 400 for working and learning at home

Did you get Raspberry Pi 400 as a home learning or working device? We hope you’ve been getting on well with our affordable all-in-one computing solution. If you’re a new user, here are some tips for you to get the most out of your brand-new Raspberry Pi 400.

raspberrypi.org

First 5 6 7 8 Last