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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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