18th Jan 2021 Video : JSON Data Type in Oracle Database 21c In today’s video we demonstrate the JSON data type, introduced in Oracle database 21c. The video is based on this article. oracle-base.com
18th Jan 2021 Checking job history log size with TSQL One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you may not be able to track down job failure issues. stevestedman.com
17th Jan 2021 Getting Started With AWS Monitoring Take your monitoring to the cloud. Amazon Web Services (AWS) is the most popular public cloud, with 175 services and counting. A key element of a successful cloud operation is gaining visibility into what is running where, what issues are occurring, and dealing with them, preferably automatically. dzone.com
17th Jan 2021 Oracle Database 21c : It’s New to Everyone A few days ago Oracle made the official announcement about the release of Oracle database 21c (here). This was a rather late announcement, as the product has been available on Oracle Cloud for over a month, but that’s not the subject of this post. oracle-base.com
16th Jan 2021 Working With MyISAM in MySQL MyISAM is one of the most popular storage engines in MySQL. MyISAM frequently is the second choice after InnoDB - in this blog post we will try to find out how best to work with this engine. MyISAM is one of MySQL’s storage engines. severalnines.com
16th Jan 2021 Data-Driven Enterprise – Dataedo Data Cartoon We love when you use our cartoons! You can use them for free for private, educational, and commercial purposes as long as you give us proper credit. You can publish them in your website, article, email, presentation, video, book, or any other media. How to do that? dataedo.com
16th Jan 2021 The DB2Night Show #231: Db2 V11.5 Overview & Latest From the Lab 100% of our studio audience learned something!Keri presented a Db2 V11.5 Overview. Watch the replay... Keri did her usual thorough job including information on Db2 11.5.5 and beyond. Be sure to download or watch youtube and catch this session. Search #DB2Night to learn more. dbisoftware.com
16th Jan 2021 pspg 4.0.0 released I finished and released new version of pspg pager. New release has possibility to export content in CSV, TCVS, formatted text or INSERT format to file or clipboard. okbob.blogspot.com
16th Jan 2021 Unit Testing Helidon Like A Pro using Mockito Writing JUnit5 unit tests in Helidon is easy with the usage of helidon-microprofile-tests-junit5 dependency. It starts a separate Helidon microprofile server for you to run your tests using @HelidonTest annotation. blogs.oracle.com
15th Jan 2021 How to monitor Azure Data Factory In the previous articles of this series, we discussed how to perform different types of activities using Azure Data Factory. These tasks include copying data between different data stores, running SSIS packages and transforming data before writing it to a new data store. sqlshack.com
15th Jan 2021 MySQL 8.0.22: SHOW PROCESSLIST Version 2 – Now Available From PERFORMANCE_SCHEMA The “SHOW PROCESSLIST” command is very famous and very useful for MySQL DBAs. It will help you to understand the ongoing thread activities and their current states. By default, the “show processlist” output details will be collected from the thread manager, and it needs the global mutex. percona.com
15th Jan 2021 Performance Measures And Factors When I’m working with clients, we look at a lot of stuff together to make sure things are in good working order. If we’re tuning a single query, the goal is pretty easy to define. We want it to finish as fast as possible. erikdarlingdata.com
15th Jan 2021 How to Audit a PostgreSQL Database Auditing is a good way to keep your data as safe as possible, and to know what is happening in your databases. It is also required for many security regulations or standards, like PCI - Payment Card Industry. This is not an exception for your PostgreSQL database. severalnines.com
15th Jan 2021 Synchronizing Files on your Raspberry Pi with Syncthing In this tutorial, we will show you how you can use the Syncthing software on your Raspberry Pi. Syncthing is a software designed to synchronize files between multiple devices such as the Raspberry Pi in real-time. pimylifeup.com
15th Jan 2021 What's the Quarantine state in Windows Failover Clusters Due to the Coronavirus pandemic, Quarantine and Lockdown are two prominent words from the year 2020. The word Quarantine means isolating things such as a COVID-19 positive patient to prevent the spread of the disease. mssqltips.com
15th Jan 2021 2021 Cybersecurity Trends to Prepare For While few people foresaw the dramatic developments of the past year, CIS experts interviewed in 2020 identified several cybersecurity trends that persisted or even accelerated in the midst of the COVID-19 pandemic. cisecurity.org
15th Jan 2021 Auditing PostgreSQL Using pgAudit Auditing in information technology (IT) is a process of examining an organization’s IT infrastructure to ensure compliance with the requirements imposed by recognized standards or established policies. scalegrid.io
15th Jan 2021 The modern Droplet: How to choose the “right” VM for business and personal use DigitalOcean Droplets are on-demand, Linux virtual machines suitable for production business applications and personal passion projects. We’ve recently introduced Storage-Optimized Droplets with NVMe SSD, and have also made other adjustments to our Droplet portfolio. digitalocean.com
15th Jan 2021 Trigger Warning! Guide to SQL Triggers - Setting up Database Tracking and Auditing in PostgreSQL I was 12 years old when I first heard about SQL triggers. My brother, Jonathan, had just begun his software career at a startup. Jonathan came home one day frustrated by a database full of convoluted SQL triggers. blog.arctype.com
14th Jan 2021 Installing Grafana on Raspberry OS. In a previous post we’ve installed Prometheus on Raspberry, and this time we are installing Grafana on a Raspberry Pi as part of our homelab monitoring server. The Raspberry Pi we’ve chosen is this one.Model 3B -1GB. blog.dbplatz.com
14th Jan 2021 Tips for Monitoring MySQL for Moodle Database monitoring is a critical part of any application’s maintenance. Finding database issues on time can help the application remain healthy and accessible. Without monitoring in place, database outages can be prolonged, resulting in increased downtime for users. severalnines.com
14th Jan 2021 Preparing on-premises and AWS environments for external Kerberos authentication for Amazon RDS As database security becomes more and more essential to the success of a business, managing user access to databases effectively has always been a challenge to database administrators (DBAs) and security officers. Traditional database authentication is based on a username-password mechanism. aws.amazon.com
14th Jan 2021 How to Scale Your Services With Docker During Development In this article, we're going to see how we can leverage Docker to scale and spin up multiple instances of a service on our machine. Hi all! Today we’re going to see how we can leverage Docker to scale and spin up multiple instances of a service on our machine. dzone.com
14th Jan 2021 Vulnerability Management Has a Data Problem Security teams have an abundance of data, but most of it lacks the context necessary to improve remediation outcomes. Today, vulnerability management teams have so much data on hand that processing and analyzing it takes as much time as remediation efforts. darkreading.com
14th Jan 2021 Benchmarking AWS, Azure, & GCP in the 2021 Cloud Report. Who came out on top? The 2021 Cloud Report stands on benchmarks. cockroachlabs.com
14th Jan 2021 Webinar January 28: Tuning PostgreSQL for High Performance and Optimization PostgreSQL is one of the leading open-source databases, but, out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. percona.com
14th Jan 2021 Between Reading Richard Foote’s latest blog note about automatic indexing and “non-equality” predicates I was struck by a whimsical thought about how the optimizer handles “between” predicates. jonathanlewis.wordpress.com
14th Jan 2021 How to perform Azure SQL database Import/Export operations using PowerShell In Azure, the Import/Export operation of the Azure SQL database is a vital part of the database migration methods. It is important to choose the most viable option as per the database migration strategy and business requirements. sqlshack.com