23rd Jun 2020 Expanding SQL Server Big Data Clusters capabilities, now on Red Hat OpenShift SQL Server Big Data Clusters (BDC) is a new capability brought to market as part of the SQL Server 2019 release. cloudblogs.microsoft.com
23rd Jun 2020 What ‘Security’ Means for Open Source Software It’s unlikely that any modern enterprise has a tech stack completely free of open source software. Open source is a big part of what helps companies innovate quickly, and use software to create a competitive advantage. thenewstack.io
23rd Jun 2020 How to visualize Prometheus histograms in Grafana Do you have a Prometheus histogram and have you asked yourself how to visualize that histogram in Grafana? You’re not alone. Here, we will show you how it’s done. grafana.com
23rd Jun 2020 Kubernetes observability tutorial: Log monitoring and analysis Kubernetes has emerged the de facto container orchestration technology, and an integral technology in the cloud native movement. elastic.co
23rd Jun 2020 Execute a SQL Server procedure inside the function In this article, we will ensure that the execution of the SQL Server procedure inside the function is possible. sqlshack.com
23rd Jun 2020 Introducing Percona Distribution for MySQL Percona is pleased to announce the release of . Following our recent releases of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL, designed and tested to work together. percona.com
23rd Jun 2020 Bad Idea Jeans Add those two things together, and Richie found himself working on a new feature for SQL ConstantCare® that would automatically break up advice into multiple emails if we needed to attach several big query plans. brentozar.com
23rd Jun 2020 Security Tasks: Only 0.13% of passwords pass the validate_password plugin MEDIUM policy score. Passwords lists abound on the net. They exist to: From MySQL 5.6 the validate_password plugin has been available. It enables password strength to be checked against known security best practice for passwords. dbadojo.com
23rd Jun 2020 How to Introduce Yourself to Machine Learning Most IT and business leaders know that despite the economic and human disruption of the COVID-19 pandemic, digital transformation will ultimately speed up, not slow down. splunk.com
23rd Jun 2020 Data Protection for Today’s Highly Complex Cloud Native World Dell Technologies sponsored this podcast. In this The New Stack Makers podcast, technology thought leaders from Dell EMC and VMware discuss the dynamics of data protection and other DevOps-related themes for today’s highly complex cloud native environments. thenewstack.io
22nd Jun 2020 CIS Controls Self Assessment Tool (CSAT) Update v1.3.0 At CIS, we believe in cultivating a trusted and collaborative environment for information sharing. Through our Community, we develop industry-leading tools and resources to enhance the cyber defense programs of organizations in every industry. cisecurity.org
22nd Jun 2020 Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with. scalegrid.io
22nd Jun 2020 Best practices for managing your SLOs with Datadog Collaboration and communication are critical to the successful implementation of service level objectives. Development and operational teams need to evaluate the impact of their work against established service reliability targets in order to improve their end user experience. datadoghq.com
22nd Jun 2020 Heaps in SQL Server: Part 2 Optimizing Reads In the second article of this series, Uwe Ricken discusses ways to affect the performance of queries involving heaps, including the TOP operator, compression, and partitioning. red-gate.com
22nd Jun 2020 Getting Started with Knowledge Graphs in RedisGraph Knowledge graphs are an essential information resource for machine learning in search and inferencing. Learn how to load and process ontologies in RedisGraph as a first step in building knowledge graphs in Redis. redislabs.com
22nd Jun 2020 Storage 101: Cloud Storage Throughout this series, I’ve discussed a range of storage-related topics, some of which I mentioned only briefly. One of those is cloud storage, which now plays a vital role in today’s data management strategies. red-gate.com
22nd Jun 2020 State of Database Monitoring Redgate published a report that many of you helped with by providing information. First, thanks! Your info really helped. Second, do you want to see it? You can. Go here and get a copy. scarydba.com
22nd Jun 2020 Apache Spark Connector for SQL Server and Azure SQL is now open source We’re happy to announce that we have open–sourced the Apache Spark Connector for SQL Server and Azure SQL on GitHub. cloudblogs.microsoft.com
22nd Jun 2020 Connecting to a SQL Server Docker Container Running in macOS Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting or running a virtual machine. In this article of the series, Carlos Robles demonstrates how to connect to the SQL Server once it’s running. red-gate.com
22nd Jun 2020 Online Migration from MySQL 5.6 Non-GTID to MySQL 5.7 with GTID The plan is to set up a replication link from the new cluster running on MySQL 5.7 to the master running on MySQL 5.6 (outside of ClusterControl provision), which uses no GTID. MySQL does not support mixing GTID and non-GTID in one replication chain. severalnines.com
22nd Jun 2020 What’s The Point Of Estimated Plans, Anyway? Estimated plans can be a bit confounding, huh? Whether you see one by hitting CTRL+L, looking in the plan cache, or looking in Query Store, the song remains the same. erikdarlingdata.com
22nd Jun 2020 Machine learning in cybersecurity: Training supervised models to detect DGA activity How annoying is it when you get a telemarketing call from a random phone number? Even if you block it, it won’t make a difference because the next one will be from a brand new number. Cyber attackers employ the same dirty tricks. elastic.co
22nd Jun 2020 Python: How to... Programming language is considered very powerful if it can solve a given set of problems succinctly and efficiently. In this article, let’s see how Python can solve a series of problems concisely using a set How to questions. dev.to
22nd Jun 2020 Database Fundamentals #26: The Primary Key War There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful information. For example, there is an ISO standard for the abbreviation of state names in the United States. scarydba.com
22nd Jun 2020 Learn SQL: SQL Server Cursors SQL Server cursors are one common topic on the Internet. You’ll find different opinions when to use them and when not to do it. Today, we’ll also talk about them and answer the question when (not) to use them. sqlshack.com
22nd Jun 2020 Percona XtraBackup For All Versions of MySQL, Updated Percona Distribution of PostgreSQL, Percona XtraDB Cluster Improvements : Release Roundup June 22, 2020 : Percona Database Performance Blog Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service itself. percona.com
22nd Jun 2020 Oracle's MySQL InnoDB Cluster versus Tungsten Clustering for MySQL We’ve been receiving requests recently from MySQL users wanting to understand how InnoDB Cluster compares to Tungsten Clustering, our MySQL HA, disaster recovery, and geo-clustering solution. In response we have come up with this comparative outline, looking at some of the key features of each. continuent.com
22nd Jun 2020 Dirty Reads and the Read Uncommitted Isolation Level In this article, we will discuss the Dirty Read concurrency issue and also learn the details of the Read Uncommitted Isolation Level. A transaction is the smallest working unit that performs the CRUD (Create, Read, Update, and Delete) actions in the relational database systems. sqlshack.com