7th Apr 2021 MySQL 101: Basic MySQL Server Triage So your MySQL server has crashed. What do you do now? When a server is down, in my opinion, there are two steps that a... percona.com ⏰ 3 mins
7th Apr 2021 MySQL & macOS Silicon It’s a problem for my students who purchased the new Apple hardware that uses Apple Silicon because they can’t install a... blog.mclaughlinsoftware.com
7th Apr 2021 Design Pattern for Highly Parallel Compute: Recursive Scaling with Amazon SQS Scaling based on Amazon Simple Queue Service (SQS) is a commonly used design pattern. At AWS Professional Services, we h... aws.amazon.com ⏰ 6 mins
7th Apr 2021 Can a monitoring tool save money? When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to help me do my jo... red-gate.com
7th Apr 2021 Stairway to SQL essentials SQL Essentials stairway series helps readers understand the most common database language SQL uses for data munging and ... sqlshack.com ⏰ 5 mins
7th Apr 2021 PostgreSQL with Go in 2021 If you’re a modern web developer, it is inevitable to ignore a database for long as it plays an important part in the ap... dev.to ⏰ 3 mins
7th Apr 2021 Getting started with Amazon Athena and S3 In this article, I am going to discuss Amazon Athena and how we can analyze data stored in S3 using Athena.... sqlshack.com ⏰ 6 mins
7th Apr 2021 MySQL NDB Cluster Installation Through Docker host > docker pull mysql/mysql-cluster host> docker pull mysql/mysql-cluster:7.5 Let's wait for the download to finish. ... clustertesting.blogspot.com
7th Apr 2021 Ten Best Intel Ice Lake-SP Processors for SQL Server On April 6th, 2021 Intel held their “How Wonderful Gets Done“ launch event for the new 3rd Generation Intel Xeon Scalabl... glennsqlperformance.com ⏰ 5 mins
6th Apr 2021 CIS Benchmarks April 2021 Update CIS is excited to announce the release of the following CIS Benchmarks for March 2021. These CIS Benchmark releases woul... cisecurity.org ⏰ 3 mins
6th Apr 2021 Never, Ever, Ever Start T-SQL Comments with Two Dashes Never, ever use two dashes. Never. The problem is that monitoring tools and diagnostic management views often dump out t... brentozar.com
6th Apr 2021 Export indexes and constraints from SQL Server graph databases to Neo4j In our previously published article in this series, we explained how to migrate SQL Server graph tables into Neo4j and w... sqlshack.com ⏰ 7 mins
6th Apr 2021 Default Maintenance Plan Shrink Database – Video Tip The problem with using the default maintenance plans is that SQL Server Management Studio makes it easy to turn on some ... stevestedman.com ⏰ 4 mins
6th Apr 2021 Spatial database management systems A Spatial DBMS is a database management system that is able to efficiently store, manipulate and query spatial data. Spa... db-engines.com
6th Apr 2021 Pluralsight is Offering a Free Month #FreeApril This month Pluralsight is offering a free subscription to its entire course catalog. If you want to build your DevOps, p... devopscube.com
6th Apr 2021 Monitor Azure Service Health events with Datadog Azure Service Health continuously notifies you of issues that may affect the availability of your environment, such as s... datadoghq.com ⏰ 4 mins
6th Apr 2021 IT Resilience Within AWS Cloud, Part II: Architecture and Patterns In Part I of this two-part blog, we outlined best practices to consider when building resilient applications in hybrid o... aws.amazon.com ⏰ 6 mins
6th Apr 2021 Scylla’s New IO Scheduler As any other computational resource, disks are limited in the speed they can provide. This speed is typically measured a... scylladb.com ⏰ 9 mins
6th Apr 2021 How to Setup Prometheus Node Exporter on Kubernetes If you want to know how the Kubernetes nodes perform or monitor system-level insights of kubernetes nodes, you need to s... devopscube.com ⏰ 4 mins
6th Apr 2021 Learn MySQL: Install MySQL server 8.0.19 using a noinstall Zip archive In this article, I am going to explain the step-by-step installation process of MySQL server 8.0.19 using a noinstall Zi... sqlshack.com ⏰ 6 mins
6th Apr 2021 Case Study A recent question on the Oracle Developer forum posed an interesting question on “finding the closest match” to a numeri... jonathanlewis.wordpress.com ⏰ 15 mins
6th Apr 2021 Five Facts about the SQL Server Resource Database For many people familiar with SQL Server, system databases are associated only with four databases - master, model, msdb... mssqltips.com ⏰ 5 mins
6th Apr 2021 How Database Automation Lowers The Total Cost of Ownership of Infrastructure Services Krzysztof Książek, Director of Support at Severalnines. For nearly 15 years Krzysztof has held positions as a SysAdmin &... severalnines.com
6th Apr 2021 Three Steps To Get Started With Database DevOps Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve alrea... red-gate.com ⏰ 10 mins
6th Apr 2021 PostgreSQL: Get member roles and permissions PostgreSQL provides a highly sophisticated and powerful security and permission system. It allows you to define users (=... cybertec-postgresql.com ⏰ 3 mins
6th Apr 2021 MySQL and UUIDs In ALTER TABLE for UUID we discuss currently proper way to store and handle UUID in MySQL. Currently it works, even in a... blog.koehntopp.info ⏰ 5 mins
6th Apr 2021 Where I See Databases Going in the Next 10 Years This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than ... brentozar.com ⏰ 9 mins
6th Apr 2021 Powering Messaging Enabledness with Yelp's Data Infrastructure In addition to helping people find great places to eat, Yelp connects people with great local professionals to help them... engineeringblog.yelp.com ⏰ 6 mins
6th Apr 2021 Postgres Blog Databases are often a critical part of enterprise infrastructure, so when and how to upgrade them is a common discussion... momjian.us
6th Apr 2021 Query Optimization in SQL Server for beginners This article intends to give some details about the query optimization process in SQL Server. The query optimization is ... sqlshack.com ⏰ 6 mins
5th Apr 2021 Free Columnstore Training Class on Tuesday Your report queries are too slow. You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores... brentozar.com
5th Apr 2021 Common Query Plan Patterns For Windowing Functions: Partition By Parallelism Prior to SQL Server 2012, this blog post would be wrong. If you’re still on a version prior to 2012, ignore this blog po... erikdarlingdata.com
5th Apr 2021 SQL Server – Contained Database You may have encounter already case when an application offers the possibility to create and maintain SQL database users... blog.dbi-services.com ⏰ 3 mins
5th Apr 2021 SSMA Db2toSQL Migration Fails without Error The SQL Server Migration Assistant (SSMA) is a tool for transitioning from other platforms like Db2 to Microsoft SQL Ser... virtual-dba.com
5th Apr 2021 SQL1022C There is not enough memory available to process the command. Last week, I was trying to check the version of my Db2 client on my laptop and I got an unexpected error message. This w... blog.dbplatz.com
5th Apr 2021 Rename your DB clone completely Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicat... blog.dbi-services.com ⏰ 7 mins
5th Apr 2021 Simplify Log Management For Backup Currently, there is a cronjob to delete backup logs older than 7 days. Typically, it not’s a big deal; however, having t... mdinh.wordpress.com ⏰ 3 mins
5th Apr 2021 How to Encrypt MySQL Data Using AES Techniques Sometimes clients want that the information they collected from the user should be encrypted and stored in a database. D... thinkdiff.net
5th Apr 2021 Getting Started with OpenTelemetry Python v1.0.0 Since the OpenTelemetry Tracing Specification reached 1.0.0 — guaranteeing long-term stability for the tracing portion o... splunk.com ⏰ 7 mins
5th Apr 2021 Understanding *args and *kwargs arguments in Python In this article, I am going to talk in detail about the functions and arguments in Python. Python is one of the most pop... sqlshack.com ⏰ 6 mins
5th Apr 2021 New CIS AWS Benchmarks Help Secure Cloud Products and Services Amazon Web Services (AWS) continues to expand with new cloud products and services. The Center for Internet Security (CI... cisecurity.org ⏰ 4 mins
5th Apr 2021 Convert the NUMBER data type from Oracle to PostgreSQL – Part 2 An Oracle to PostgreSQL migration in the AWS Cloud can be a multistage process with different technologies and skills in... aws.amazon.com ⏰ 8 mins
5th Apr 2021 How to Benchmark and Tune Google Cloud Engineers on cloud performance teams can spend their entire workday tuning and optimizing cloud configurations.... cockroachlabs.com ⏰ 3 mins
5th Apr 2021 AWS S3 as Docker volumes We can attach an S3 bucket as a mounted Volume in docker. We need to use a Plugin to achieve this.... dev.to
5th Apr 2021 SQL Server Diagnostic Information Queries for April 2021 These are my SQL Server Diagnostic Information Queries for April 2021, aka my DMV Diagnostic Queries. They allow you to ... glennsqlperformance.com ⏰ 4 mins
5th Apr 2021 Real-Time Big Data Analytics: How to Replicate from MySQL to Hadoop First off: Happy 15th birthday, Hadoop! As most of you will know, Apaches Hadoop is a powerful and popular tool, which h... continuent.com ⏰ 6 mins
5th Apr 2021 How to Assess Your SQL Server Environment Give me six hours to chop down a tree and I will spend the first four sharpening the axe. Welcome back to the Two Weeks ... straightpathsql.com ⏰ 3 mins
5th Apr 2021 Considerations for Running SQL Server on Kubernetes Kubernetes is an open-source orchestration and management system for containers. It is an exciting technology to learn o... mssqltips.com ⏰ 5 mins