21st Sep 2020 How to read a Parallel Execution Plan in Oracle The volume of data being stored in databases has grown exponentially in recent years. So too has the need to rapidly generate value or business insights from that data. sqlmaria.com
21st Sep 2020 Best practices for using Docker Hub for CI/CD According to the 2020 Jetbrains developer survey 44% of developers are now using some form of continuous integration and deployment with Docker Containers. docker.com
21st Sep 2020 MongoDB 101: 5 Configuration Options That Impact Security (And How to Set Them) As with any database platform, MongoDB security is of paramount importance to keeping your data safe. MongoDB and other data platforms like Redis and Elasticsearch are often in the news for data breaches because of misconfigured settings in the database. percona.com
21st Sep 2020 How we use the Grafana GitHub plugin to track outstanding pull requests First of all, we’re pleased to announce the first release of the GitHub data source. The source code is available at github.com/grafana/github-datasource. Contributions, feature requests, and bug reports are welcome. grafana.com
21st Sep 2020 Why should businesses upgrade their PostgreSQL Database? It all comes down to determining the cost of not upgrading your PostgreSQL Database. enterprisedb.com
21st Sep 2020 Connection Handling & Throttling with ProxySQL The ability to shape the traffic that goes to the database is one of the most important ones. In the past days you had not that much control over it - applications sent the traffic to the database and that’s about it. severalnines.com
21st Sep 2020 Refresh SQL Server Always On Availability Group databases using DBATools PowerShell In the 20th article of the SQL Server Always On Availability Group series, we will explore the process to refresh an availability group database using SQL scripts. In this article, we will use the DBATools commands for this purpose. sqlshack.com
21st Sep 2020 How to Decide Between JOIN and JOIN FETCH Deciding between JOIN and JOIN FETCH is a matter of performance! Typically, JOIN and JOIN FETCH come into play when the application has lazy associations but some data must be fetched eagerly. Relying on FetchType.EAGER at the entities-level is a code smell. dzone.com
21st Sep 2020 Renaming the default branch in Azure Data Factory Git repositories from “master” to “main” In Azure Data Factory, you can connect to a Git repository using either GitHub or Azure DevOps. When connecting, you have to specify which collaboration branch to use. In most cases, the default branch is used. Historically, the default branch name in git repositories has been “master“. cathrinewilhelmsen.net
21st Sep 2020 5 Steps to Greater Cyber Resiliency Work from home isn't going away anytime soon, and the increased vulnerability means cyber resiliency will continue to be critical to business resiliency. Recent events have rapidly shifted the way that we live and work. darkreading.com
21st Sep 2020 Starting SQL: What Are Parameters Made Of? There are many good reasons to parameterize a query, but there are also trade-offs. There’s no such thing as a free parameter, as they say. In this post, we’re going to discuss what is and isn’t a parameter, and some of the pros and cons. erikdarlingdata.com
21st Sep 2020 Server Fest Conclusions The MariaDB Server Fest 2020 is now over! Time for some spontaneous, initial reflections. Those advantages were not enough for us. We wanted to take it a step further. mariadb.org
21st Sep 2020 Open Mainframe Project Launches a COBOL Working Group The Open Mainframe Project (OMP), an open source initiative that enables collaboration across the mainframe community to develop shared tool sets and resources, has launched a COBOL Working Group, four new projects, and added Micro Focus as a new member. dbta.com
21st Sep 2020 Please don't use sys.sp_columns! I was investigating the table for other reasons. And because I'm lazy, I scanned the output of the system procedure sys.sp_columns (instead of writing a proper query against more modern metadata). I spotted the legacy type in the output, and dropped everything. sqlblog.org
21st Sep 2020 Understanding SQL Server Recovery Models The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database. red-gate.com
21st Sep 2020 DB2Night Show #Z109: Db2 for z/OS Utilities Hints and Tips 100% of our studio audience learned something!Kai described the purpose and use of Db2's log information. Watch the replay... I can see why Kai Stroh is a popular Db2 speaker. There is a lot of information in this well delivered presentation. Search #DB2Night to learn more. dbisoftware.com
21st Sep 2020 Restore TDE Enabled Azure SQL DB to On-Premises Server For on-premises SQL Server databases that have TDE enabled, we need certificates to perform a restore to another SQL Server. mssqltips.com
21st Sep 2020 Video : Multitenant : Dynamic CPU Scaling – Resource Manager Control of CPU using CPU_COUNT and CPU_MIN_COUNT In today’s video we’ll discuss how Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling. This can be useful to stop a small number of PDBs using all CPU resources assigned to the instance. oracle-base.com
20th Sep 2020 Beginner's guide to Elasticsearch In life, we are always in search of something. Whether we are in search for the meaning of life or in search for the most delicious tacos in town, we heavily rely on search engines to get the answers. dev.to
19th Sep 2020 Introduction to DAX Financial Functions – Part 1 Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. red-gate.com
19th Sep 2020 How Does a Database Load Balancer Work? A database Load Balancer is a middleware service that stands between applications and databases. It distributes the workload across multiple database servers running behind it. severalnines.com
19th Sep 2020 Jenkins at DevOps World 2020 The annual DevOps World, formerly known as DevOps World | Jenkins World is next week - Sept 22-24, with workshops on Sept 25. Just like other events this year, DevOps World pivoted to a virtual event but that doesn’t mean there is a shortage of sessions or networking opportunities. jenkins.io
19th Sep 2020 Diary of an Engineer: Delivering 45x faster percentiles using Postgres, Citus, & t-digest This diary-of-an-engineer post from our Citus open source engineering team was originally published on the Azure Postgres Blog. citusdata.com
19th Sep 2020 Learn MySQL: Delete and Update Statements In this article, we are going to learn how we can update and delete data using Delete and Update statements. In my previous articles, we have learned how we can insert data using INSERT statement, and sort and filter data using WHERE and ORDER BY statements. sqlshack.com
19th Sep 2020 MongoDB SSL with self-signed certificates in C# When deploying MongoDB in production, it is strongly recommended that you use an SSL-enabled geo-distributed replica-set configuration for maximum security and availability. ScaleGrid provides you two options for setting up SSL. scalegrid.io
19th Sep 2020 IBM POWER and SAP HANA: A Powerful and Effective Combination As organizations looks for differentiators to improve efficiency and improve cost effectiveness, the combination of IBM Power Systems and SAP HANA can provide a potent platform with a significant return on investment. Why IBM Power Systems? datatechnologytoday.wordpress.com
19th Sep 2020 The Answer Is… One of the big changes in security I have seen over the years is a significant increase in the use of security questionnaires. blogs.oracle.com
19th Sep 2020 Do you know where your installation media is? This was inspired by a Twitter comment and subsequent DMs, but I’m not going to name names. You know who you are… 🙂 Let me ask you some questions. oracle-base.com