DBplatz

image
17th Apr 2021

Automatic cleanup of SQL Server Agent scheduled jobs

One problem that people often have is a large number of SQL Agent jobs on their servers and they don't want to remove th...

mssqltips.com
image
17th Apr 2021

How to optimize slow INSERT queries in MySQL

Remove existing indexes - Inserting data to a MySQL table will slow down once you add more and more indexes. Therefore, ...

eversql.com
image
17th Apr 2021

How difficult is to create a database software like PostgreSQL ?

Recently on twitter, i have seen a poll by Qovery asking how hard is it to create a database like PostgreSQL. With no su...

migops.com ⏰ 7 mins
17th Apr 2021

How to use Encryption to Protect MongoDB data

With many kinds of data stored in the database, sometimes we may be dealing with confidential data, which might include ...

severalnines.com ⏰ 3 mins
image
17th Apr 2021

Understanding Execution Plans of the SQL Server Insert statement

In this article, we will learn how to interpret an execution plan of a SQL Server insert statement. When we execute an i...

sqlshack.com ⏰ 6 mins
image
16th Apr 2021

InnoDB Data Locking – Part 4 “Scheduling”

In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that...

mysqlserverteam.com ⏰ 9 mins
image
16th Apr 2021

Introduction to Containers with AWS

Containerization—a virtualization method used to deploy and run distributed applications without the need to launch an e...

dev.to ⏰ 6 mins
image
16th Apr 2021

How Do You Design a Shopping Cart Database for E-Commerce?

An e-commerce shopping cart serves as a virtual cart that allows customers to add and hold items until they complete the...

dev.to ⏰ 8 mins
image
16th Apr 2021

April 15 | WAL in PostgreSQL: 2. Write-Ahead Log

Last time we got acquainted with the structure of an important component of the shared memory — the buffer cache. A risk...

postgrespro.com ⏰ 10 mins
image
15th Apr 2021

Always Retry

When multiple people connect to a SQL Server database and attempt to query or update rows, blocking occurs. This is norm...

voiceofthedba.com
image
15th Apr 2021

Using MySQL with Unity

Even games must store data like top scores. In this article, Lance Talbert explains how to save data using MySQL with Un...

red-gate.com ⏰ 12 mins
image
15th Apr 2021

What is SQL - Part 3

Viewing, updating and deleting data in tables This is part 3 of a four-part article which explains SQL Part 1 Part 2 Par...

dev.to ⏰ 6 mins
image
15th Apr 2021

Common Query Plan Patterns For Joins: Index Union

Index union is a little bit different from index intersection. Rather than joining two indexes together, their result se...

erikdarlingdata.com
image
15th Apr 2021

Connecting a SQL Server client on Linux using Active Directory authentication

I’m a complete beginner at Linux, so I should preface this post with the fact that these are my humble notes after hours...

sqlsunday.com ⏰ 3 mins
image
15th Apr 2021

Inserted Scan

The Inserted Scan operator is only found in execution plans for code in triggers. It is used for queries that read data ...

sqlserverfast.com ⏰ 3 mins
15th Apr 2021

DynamoDB / Aurora: sparse and partial indexes

. In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, b...

blog.dbi-services.com ⏰ 7 mins
15th Apr 2021

15 Apr 101 SERIES OF ORACLE IN GOOGLE CLOUD – PART III : Using GCP Snapshots to Clone a DB in a VM

Continuing on the GCP 101 series. I will explain how is it that you use GCP Disk Snapshots to clone a DB in a GCP VM. On...

rene-ace.com ⏰ 4 mins
image
15th Apr 2021

Automating Azure DevOps with Logic Apps

Azure Logic Apps can be used to automate steps like sending approval emails. Elie Bou Issa explains automating Azure Dev...

red-gate.com ⏰ 10 mins
image
15th Apr 2021

Platform End of Support Announcement for Ubuntu 16.04 LTS

The End Of Support date for Ubuntu 16.04 LTS is coming soon. According to the Ubuntu Release Life Cycle, it will be at t...

percona.com
image
15th Apr 2021

Introducing cross-Region event routing with Amazon EventBridge

Using Amazon EventBridge, you can now route events from any commercial AWS Region to other supported Regions. The initia...

aws.amazon.com ⏰ 6 mins
image
15th Apr 2021

Learn how to monitor your energy use at home with a Raspberry Pi, Grafana and Prometheus

About six months ago, I decided to start a little project at home that combined my interest in IoT with my experience as...

grafana.com ⏰ 4 mins
image
15th Apr 2021

Online DDL with Group Replication In Percona Server for MySQL 8.0.22 (and MySQL 8.0.23)

While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how ...

percona.com ⏰ 4 mins
image
15th Apr 2021

Automate SQL database backups using Windows Task Scheduler

In this article, we will learn how we can automate the backup of SQL database created in SQL Server Express edition. SQL...

sqlshack.com ⏰ 4 mins
image
15th Apr 2021

SQL Server : Fix Msg 8630, Level 16, State 1, Line 1 – Internal Query Processor Error : The query processor encountered an unexpected error during execution (HRESULT = 0x80040e19).

This is going to be a quick reference for people encountering this error and to do the fix more than a blog post but I d...

sqljana.wordpress.com
15th Apr 2021

How to Replicate Securely and in Real-Time From MySQL to Amazon Redshift

Currently ranked 33rd on DB-Engines’ popularity ranking of database management systems (with a downwards trend), Amazon ...

continuent.com ⏰ 5 mins
image
14th Apr 2021

Common Query Plan Patterns For Joins: Index Intersection

Lookups are between a nonclustered index and either the clustered index or heap, and index intersection and union are be...

erikdarlingdata.com
image
14th Apr 2021

The PowerShell Basics If Statement–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBlogge...

voiceofthedba.com
image
14th Apr 2021

No Data Loss and No Service Interruption – HDF to CFM Rolling Migration

The blog “Migrating Apache NiFi Flows from HDF to CFM with Zero Downtime” detailed how many common NiFi dataflows can be...

blog.cloudera.com ⏰ 5 mins
image
14th Apr 2021

Communications in a Cluster: Heartbeat Mechanism

This article introduces the heartbeat mechanism through which the servers in a Nebula Graph cluster communicate with eac...

dzone.com ⏰ 5 mins
14th Apr 2021

Postgres Blog

Postgres has a lot of settings — 329 in Postgres 13. Most of these settings control one specific thing, and the defaults...

momjian.us
14th Apr 2021

SQL and SQL Developer Data Modeler 21.1 are now available

We released updates for your favorite command line interface and design tools for the Oracle Database yesterday! Primari...

thatjeffsmith.com
image
14th Apr 2021

Jenkins vs Spinnaker – A Comparison

Many organizations are using a combination of Jenkins and a tool like Ansible, Puppet, Chef, or Salt to automate their C...

opsmx.com ⏰ 4 mins
image
14th Apr 2021

Detect anomalous activity in your environment with new term–based Detection Rules

When it comes to securing your production environment, it’s essential that your security teams are able to detect any su...

datadoghq.com ⏰ 3 mins
image
14th Apr 2021

What You Can Do With Auto-Failover and Percona Distribution for MySQL (8.0.x)

There are few things your data does not like. One is water and another is fire. Well, guess what: Given my ISP had part ...

percona.com ⏰ 7 mins
image
14th Apr 2021

Percona Distribution for MySQL: High Availability with Group Replication Solution

This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations...

percona.com ⏰ 13 mins
14th Apr 2021

A quick sanity testing of PostgreSQL parallel query on Arm64

Parallel Aggregate An aggregate expression in a query typically has drastically less number of rows returned, compared t...

amitdkhan-pg.blogspot.com ⏰ 6 mins
image
14th Apr 2021

Number series generator challenge solutions – Part 4

This is the fourth part in a series about solutions to the number series generator challenge....

sqlperformance.com ⏰ 22 mins
14th Apr 2021

Configuring Mutual SSL Authentication in ClusterControl

Establishing trusted communications between systems is essential in enhancing system’s security. The use of Public Key I...

severalnines.com ⏰ 4 mins
image
14th Apr 2021

Top 10 Developer Guide Pages for Amazon DocumentDB (with MongoDB compatibility)

AWS customers use Amazon DocumentDB (with MongoDB compatibility) to save on infrastructure and license costs, decrease m...

aws.amazon.com ⏰ 3 mins
image
13th Apr 2021

MySQL JOINs Tutorial with Examples

The article presents a detailed tutorial on MySQL JOINs. In it, you will learn about different types of JOINS that are s...

blog.devart.com ⏰ 5 mins
image
13th Apr 2021

How to send traces to Grafana Cloud with OpenTelemetry Collector

As an open source company, we understand the value of open standards and interoperability. This holds true for Grafana C...

grafana.com ⏰ 3 mins
image
13th Apr 2021

Mapping Your Way To Compliance With Cybersecurity Frameworks

Organizations today need to comply with multiple policy, regulatory, and legal security frameworks. Complying with all o...

cisecurity.org
image
13th Apr 2021

How to choose between SQL and NoSQL databases

Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose betwe...

red-gate.com ⏰ 8 mins
image
13th Apr 2021

SQL Diagnostic Manager for SQL Server

Reduced availability and performance of Microsoft SQL Server can severely impact the critical applications that it suppo...

mssqltips.com
image
13th Apr 2021

Ansible Basics Workshop day @dbi services

Today, I follow our Workshop Ansible Basics with Jérôme Witt. Why I follow this workshop? First, it’s to have the basics...

blog.dbi-services.com
image
13th Apr 2021

JENKINS : Update manually your Jenkins master

Hi there, What about keeping up to date your Jenkins 🙂 Such easy to perform that!Today we will check the manual update ...

blog.dbi-services.com
image
13th Apr 2021

Load Balancing in Scylla Alternator

In a previous post, Comparing CQL and the DynamoDB API, I introduced Scylla — an open-source distributed database which ...

scylladb.com ⏰ 12 mins
image
13th Apr 2021

Twenty Years

My life changed twenty years ago, this very month. I was a developer, working for a small software company outside of Bo...

thomaslarock.com ⏰ 10 mins
    • First
    • 1
    • 2
    • 3
    • Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2021 © DBplatz