8th Dec 2021 Setting up two-node Db2 HADR Pacemaker cluster with fencing on Microsoft Azure This document provides an alternate Db2 HADR configuration with Pacemaker without using a third lightweight host as a quorum device (Qdevice) arbitrator. ibm.com
8th Dec 2021 Four Questions You Need To Ask When Choosing a Database Are you overwhelmed by the sheer amount of databases on the market today, and not sure where to start? Let’s say that you are a Software Developer, and you need to select a database for a brand new application or maybe you need to figure out a database to replace and upgrade your legacy database. singlestore.com
8th Dec 2021 The State of Database Monitoring Survey, Insights Report Redgate estimate that the savings realized with a monitoring tool could be well over $85,000 / year*. red-gate.com
8th Dec 2021 SQL Server: how to have the number of core-based licenses used on my environment? This week, a customer asks me to find out how many SQL Server Standard licenses are used in their environment. The licensing is core based and to not be used for Sserver + Cals licenses. To have an idea, I create a script following the Microsoft document about the licensing here. blog.dbi-services.com
8th Dec 2021 Matching Supply With Demand Challenge My friend Peter Larsson sent me a T-SQL challenge involving matching supply with demand. As far as challenges go, it's a formidable one. It's a pretty common need in real life; it's simple to describe, and it's quite easy to solve with reasonable performance using a cursor-based solution. sqlperformance.com
8th Dec 2021 Quick 📸 on 🐘 active SQL from pg_stat_statements This is a quick query on pg_stat_statements to get a real-time overview of queries within a 30 second snapshot. Note that it relies on the execution plan running the two CTEs one after the other, and joining pg_sleep() after the left table. I've used it on YugabyteDB 2.9 which is PostgreSQL 11. dev.to
8th Dec 2021 Optimize your IoT Services for Scale with IoT Device Simulator The IoT (Internet of Things) has accelerated digital transformation for many industries. Companies can now offer smarter home devices, remote patient monitoring, connected and autonomous vehicles, smart consumer devices, and many more products. aws.amazon.com
7th Dec 2021 Monitoring – first steps with Prometheus Monitoring is a crucial element of DevOps automation that has to be proactive, meaning it must find ways to improve applications quality before bugs appear. blog.dbi-services.com
7th Dec 2021 test=# SHOW shared_preload_libraries; shared_preload_libraries -------------------------- pg_rewrite (1 row) Finally, you have to enable the pg_rewrite extension to ensure that the partition_table function is available: test=# CREATE EXTENSION pg_rewrite; CREATE EXTENSION test=# \x Expanded display is on. cybertec-postgresql.com
6th Dec 2021 InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines If you are looking to improve the performance of MySQL databases in your software, you may need to know all the differences between InnoDB and MyISAM, two well-known types of MySQL storage engines. blog.devart.com
6th Dec 2021 Performance Testing Tools: 8 to Help Find Your Bottlenecks Performance is a vital component of user experience. Users will leave—and likely not come back—if your site is slow. If they stay, they’ll be less likely to buy from you if their experience is subpar. splunk.com
6th Dec 2021 Azure SQL The policy from the previous blog post can only to check if the is using Azure Authentication only or if it is accepting Azure SQL Authentication as well. This time, let’s analyse a policy not only to check, but to change this configuration. red-gate.com
6th Dec 2021 A Systematic Approach to View Creation Historically, one of the most fertile grounds for disagreement between database professionals was the appropriate usage of views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach. db2portal.blogspot.com
6th Dec 2021 Configure a Linked Server between SQL Server and PostgreSQL using ODBC drivers This article explains configuring a linked server between SQL Server 2019 and PostgreSQL. In my previous article named Configure ODBC drivers for PostgreSQL, we got introduced to the ODBC driver of PostgreSQL. We also learned how we could download, install, and configure it. sqlshack.com
3rd Dec 2021 Apache CloudStack on RaspberryPi4 with KVM IoTs have gained interest over recent times. shapeblue.com
3rd Dec 2021 Deploying Azure Container Instances for SQL Server 2019 This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal. The Containers are a popular way of packaging, deploying, and managing cloud applications. sqlshack.com
3rd Dec 2021 Advent of Code 2021 in Db2 LUW SQL – Day 01! Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 1. AOC Day 1 My day 1 solutions are available in my GitHub repo. datageek.blog
3rd Dec 2021 Configure SQL Server on Linux for Active Directory Authentication In this post, we’re going to walk through configuring Active Directory authentication for SQL Server on Linux. nocentino.com
3rd Dec 2021 Making sure symlinks work on CIFS/SMB mounted shares Now git can happily clone repos with symlinks, and my backups are just a little more complete! jeffgeerling.com
2nd Dec 2021 Installing SQL Server 2019 on RedHat Linux In a previous article, SQL Server On Linux Installation and Configuration, we walked through how to install SQL Server Linux on Ubuntu 20.04. SQL Server Linux 2017 and 2019 support Red Hat Enterprise Linux versions 7.7-7.9 and 8.0-8.3 as well. severalnines.com
2nd Dec 2021 SQL Server Trace Flags and how they impact the SQL Server Query Optimizer behavior In this article, we will learn some query hints and trace flags that impact the query performance and also influence the SQL Server query optimizer’s default execution plan generation algorithm. sqlshack.com
2nd Dec 2021 Centralizing data validation with domains in Azure Database for PostgreSQL In this article, we will learn how to work with domains in Azure Database for PostgreSQL and learn how to use it with tables to centralize the constraints logic that would be applied across tables. Database systems use tables as the primary database object to host a variety of data. sqlshack.com
2nd Dec 2021 Data Visualization Made Easy with ReactJS, Nivo and InfluxDB If a picture is worth a thousand words, then a well-done data visualization is worth a million. The quality of a dashboard can make or break an application. In this tutorial, you will learn how to make high-quality data visualizations easily by using the Nivo charting library with ReactJS. influxdata.com
2nd Dec 2021 How to Enable and Configure SQL Server Agent for SQL Server 2019 on RHEL 8.1 SQL Server Agent is an important feature of SQL Server to schedule and automate activities. To get SQL Agent to work on Linux, there are a few steps you need to take to get it to work. mssqltips.com
2nd Dec 2021 What is Data Mining? As IT departments and businesses across all sectors handle larger quantities of raw data, processes have been created to turn this data into useful information. Data mining is the umbrella term for this process. eweek.com
1st Dec 2021 SQL Server Diagnostic Information Queries for December 2021 These are my SQL Server Diagnostic Information Queries for November 2021, aka my DMV Diagnostic Queries. They allow you to get a very comprehensive view of the configuration and performance of your SQL Server instance in a short amount of time. glennsqlperformance.com
1st Dec 2021 Best Practice This showed up recently on the Oracle Developer Forum. For a while I’m questioning myself about a best practice query for performance. jonathanlewis.wordpress.com
30th Nov 2021 Why Now is the Time for Chaos (Engineering) Written by Morey J. Haber, BeyondTrust. If you are old enough to remember the television show Get Smart, you may be familiar with the concept of applying chaos to provide order. cloudsecurityalliance.org
30th Nov 2021 How to restore an Azure SQL Database I will explain how to restore an Azure SQL database in case you need to recover some data, or somebody has deleted your database in this article. Databases restore is the common activity a DBA performs in his day-to-day activities to meet various business requirements. sqlshack.com
30th Nov 2021 Table Inheritance in Azure Database for PostgreSQL In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL. A database ecosystem is formed of various types of database objects like tables, views, procedures, schemas, etc. sqlshack.com
30th Nov 2021 Why the Optimizer Doesn't Use Buffer Pool Knowledge SQL Server has a cost-based optimizer that uses knowledge about the various tables involved in a query to produce what it decides is the most optimal plan in the time available to it during compilation. sqlperformance.com
30th Nov 2021 SQL Identity Columns in SQL Server, Oracle and PostgreSQL - Part 1 Identity columns are a widely used technique to provide a table with an automatically generated (AKA auto-increment surrogate key), but this technique has its caveats in terms of performance and there are some interesting differences between Microsoft SQL Server, Oracle and PostgreSQL. mssqltips.com
30th Nov 2021 Your guide to Amazon Managed Blockchain and Amazon QLDB breakouts, workshops, and chalk talks at AWS re:Invent 2021 AWS re:Invent 2021 is here! This post includes a complete list of Amazon Managed Blockchain and Amazon Quantum Ledger Database (Amazon QLDB) sessions taking place at re:Invent 2021. aws.amazon.com
29th Nov 2021 Migrate encrypted columns data from on-premises to Azure SQL Database Azure SQL Database is a cloud database hosted on Microsoft’s Azure platform. It is an enterprise-grade database service that supports a wide range of advanced features, and it can be used to store and process data. sqlshack.com
29th Nov 2021 Planned Maintenance on Wednesday, December 1 We are updating the operating system on our servers on Wednesday, December 1st, beginning at 15:30 UTC. We will be applying an important operating system update to our servers on Wednesday, December 1st, beginning at 15:30 UTC. We anticipate that the work will take approximately two hours. worldcommunitygrid.org
29th Nov 2021 Tips for a Successful OpenTelemetry Deployment OpenTelemetry offers vendor-agnostic APIs, software development kits (SDKs), agents, and other tools for collecting telemetry data from cloud-native applications and their supporting infrastructure to understand their performance and health. splunk.com
29th Nov 2021 How to Install MySQL Database on Ubuntu 20.04 MySQL is an open-source relational database management system (RDBMS), it’s widely used and part of the popular LAMP/LEMP stacks. The data is organized in one or more tables in which the data types may be related to each other and MySQL uses SQL Structured Query Language to manage its data. rosehosting.com
29th Nov 2021 Query Store and hints: More Powerful than ever I need to confess: I’m proud of the article Query Store and Parameterization Problems I wrote. red-gate.com
29th Nov 2021 Collation Stability When PostgreSQL needs to sort strings, it relies on either the operating system (by default) or the ICU collation library (if your PostgreSQL has been built with support for ICU and you have chosen to use an ICU-based collation) to tell it in what order the strings ought to be sorted. rhaas.blogspot.com
29th Nov 2021 PostgreSQL 14 Database Monitoring and Logging Enhancements PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a monitoring perspective. percona.com
29th Nov 2021 Transfer error messages between SQL Server instances using SSDT 2017 This is the fourth article in the series of Migrating SQL Server Objects using SSDT 2017. In the third article, we learned how we could transfer SQL logins between the servers. sqlshack.com
28th Nov 2021 Hidden Improvements in SQL Server 2019 Microsoft launched SQL Server 2019 on November 4th 2019, so it has been GA for a little over two years now. The latest Cumulative Update (CU) right now is SQL Server 2019 CU14. glennsqlperformance.com
27th Nov 2021 Install SQL Server on Linux using ClusterControl Microsoft has taken a big step in releasing SQL Server Linux for users to build their applications. That’s great news for organizations where the only requirement is that you should be using SQL Server 2017 or 2019. severalnines.com
27th Nov 2021 ODA 19.12: How can you manage DB Systems with odacli? As virtualization is available for all ODAs now, you could ask yourself if it’s a good idea to use this virtualization or not. Databases can be created as bare metal, but also within a DB System for better isolation. And both can be used on the same ODA. blog.dbi-services.com
27th Nov 2021 SQL Server 2019 Cumulative Update 14 On November 22nd, 2021, Microsoft released SQL Server 2019 Cumulative Update 14. This is Build 15.0.4188.2. By my count, there are 19 public fixes and improvements in this CU, so it has a smaller than average number of fixes. glennsqlperformance.com
27th Nov 2021 Monitoring Schema Changes via Last Commit Timestamp First of all in order to get information about the committed transaction timestamps, there must be the option track_commit_timestamp configured. fluca1978.github.io
27th Nov 2021 How to run a specific regression test I have been working on an internal project based on PostgreSQL for a while, and from time to time, I need to run some specific test cases to verify my changes. highgo.ca
26th Nov 2021 Using tables as templates in Azure Database for PostgreSQL In this article, we will learn how to create a new instance of Azure Database for PostgreSQL as well as understand how to use existing tables as templates while creating new tables. sqlshack.com
