Enforce SQL database best practices using SQL Server Policy-Based Management

In this article, I am going to explain how we can enforce the SQL database best practices using Policy-Based Management. The policy-based management feature of SQL Server was introduced in SQL Server 2005.

sqlshack.com

24th Jul 2020

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – July 24, 2020

Welcome to this week’s tips and tricks blog where we explore both beginner and advanced YugabyteDB topics for PostgreSQL and Oracle DBAs. First things first, for those of you who might be new to either distributed SQL or YugabyteDB.

blog.yugabyte.com

24th Jul 2020

The Ever-Increasing Adoption of OpenTelemetry

Having just wrapped up Splunk’s DevOps virtual event, it was inspiring to see the power and enthusiasm of the open-source community.

splunk.com

24th Jul 2020

Setting up Azure Active Directory Domain Services (Azure AD DS)

Microsoft’s Azure Active Directory Domain Services (Azure AD DS) provides managed domain services such as domain join, group policy, lightweight directory access protocol (LDAP), and Kerberos/NTLM authentication that’s fully compatible with Windows Server Active Directory.

virtual-dba.com

24th Jul 2020

Changes that I like in the new MySQL 8.0.21

A new release of MySQL was out on July 13 (8.0.21). Among all the changes, there are some that I have already tested and that I really appreciate. In previous releases, I can already see in the error log file who stopped the MySQL server if this was done through the shutdown statement.

blog.dbi-services.com

24th Jul 2020

Example Architectures for Data-Intensive Applications

Taking architectural examples from the book Designing Data-Intensive Applications, this article looks at how adding Couchbase simplifies architecture. ...a drawing should have no unnecessary lines and a machine no unnecessary parts. - William Strunk Jr.

dzone.com

24th Jul 2020

Solved: SQL Server Error 823

When you receive error 823, there could be data loss, inconsistencies in the file system, or the database file could be damaged. Let's see how to fix it. You would have faced error 823 and might have stuck from performing any Input/Output operation in your database.

dzone.com

24th Jul 2020

Top 3 Snowflake Performance Tuning Tactics

The Snowflake Database has no indexes to build, no statistics to capture or partitions to manage. How do you tune Snowflake for maximum performance?The Snowflake Data Warehouse has an excellent reputation as an analytics platform for blisteringly fast query performance but without indexes.

dzone.com

24th Jul 2020

MongoDB: Utilization of an Index on Subdocuments

MongoDB has a lot of possibilities for creating indexes. We have seen in previous articles some of the available index types and discussed explain() usage: You can have a look at those if you need to review more details on the indexes and explain() investigation.

percona.com

24th Jul 2020

Release Announcement: InfluxDB 2.0.0 Beta 15

A new release of InfluxDB 2.0 Beta is available now. We will be shipping regular updates as we add new features and fix issues. Please keep in mind that these beta builds are not meant for testing performance or production usage.

influxdata.com

24th Jul 2020

InfluxDB Cloud Now on All Major Cloud Platforms: Azure, AWS and Google

Today, InfluxDB Cloud is generally available on Microsoft Azure. Now you have the freedom to run the leading time series database on whichever you prefer: Microsoft Azure, Google Cloud or AWS. InfluxDB Cloud now runs in five regions across three vendors and two continents.

influxdata.com

24th Jul 2020

MySQL: who’s filling my error log?

This morning, a user asked in the MySQL Community Slack if somebody had an idea why the error log was filled up continuously with a warning messages like this one: 2020-07-24T06:54:00.

lefred.be

24th Jul 2020

Using Simple Linear Regression to Make Predictions

Regression analysis may be one of the most widely used statistical techniques for studying relationships between variables [1]. We use simple linear regression to analyze the impact of a numeric variable (i.e., the predictor) on another numeric variable (i.e., the response variable) [2].

feedproxy.google.com

24th Jul 2020

What is fillfactor and how does it affect PostgreSQL performance?

Recently I was asked if there’s a rule of thumb / best practice for setting the fillfactor in Postgres – and the only answer I could give was to decrease it “a bit” if you’re doing lots and lots of updates on some table.

postgr.es

23rd Jul 2020

Using Change Data Capture (CDC) in Scylla

Change Data Capture (CDC) allows users to track data updates in their Scylla database. While it is similar to the feature with the same name in Apache Cassandra and other databases, how it is implemented in Scylla is unique, more accessible, and more powerful.

scylladb.com

23rd Jul 2020

Comparing MariaDB Server to MariaDB Cluster

MariaDB Server and MariaDB Cluster are open source products powered by the MariaDB Corporation. MariaDB Server is one of the most popular relational databases, it was originally forked from MySQL server.

severalnines.com

23rd Jul 2020

N/A - CVE-2020-15886

A SQL injection vulnerability in reportdata_controller.php in the reportdata module before 3.5 for MunkiReport allows attackers to execute arbitrary SQL commands via the req parameter of the /module/reportdata/ip endpoint.

feeds.security-database.com

23rd Jul 2020

Improved Backup & Restore Capabilities in CockroachDB 20.1

CockroachDB is designed to deliver bulletproof resilience. But even the world’s safest boat needs to carry life jackets. The same principle applies to your data, which is why we’ve baked a breadth of Backup and Restore capabilities into CockroachDB.

cockroachlabs.com

23rd Jul 2020

PostgreSQL 13 is Coming - Find Out What's New! - India & Singapore Time

PostgreSQL 13 is coming. Find out how to harness the power of new & improved features in PostgreSQL 13. This webinar will explore the following:

enterprisedb.com

23rd Jul 2020

Distributed SQL: a Cloud-Native, Scalable Postgres Alternative

Gartner predicts that by 2022, 75% of all databases will be deployed in the cloud. The findings shouldn’t come as a surprise: on-premise data centers are slowly being phased out as companies realize the many benefits to running a database in the cloud.

cockroachlabs.com

23rd Jul 2020

Using Percona Kubernetes Operators with Percona Monitoring and Management

Percona Monitoring and Management (PMM) provides an excellent solution to monitor both Percona XtraDB Cluster and Percona Server for MongoDB. Currently, there is no Percona-supported deployment model to deploy PMM by Percona Kubernetes Operators.

percona.com

23rd Jul 2020

Build a REST API with Node.js and HarperDB

If you are building an application using Node.js, it can get a little overwhelming since there are a variety of databases to choose from and different ways to build APIs.

dev.to

23rd Jul 2020

Predict Database Problems Using MariaDB SkySQL Workload Analysis Tool

Database monitoring is an invaluable tool when you need to react to a problem. And root cause analysis helped by monitoring can avoid repeat issues. That’s great, but we’d all rather prevent problems than react to them.

mariadb.com

23rd Jul 2020

Managing and maintaining SQL Server identity values

Problem One nice feature that SQL Server offers is the ability to have an automatic counter or identity value column in your table.

2ndquadrant.com

23rd Jul 2020

Unicode normalization in PostgreSQL 13

Unicode is a complicated beast. One of its numerous peculiar features is that different sequences of codepoints can be equal. This is not the case in legacy encodings.

2ndquadrant.com

23rd Jul 2020

Add a new node into existing SQL Server Always On Availability Groups

This is the 5th article in the series of a comprehensive guide to SQL Server Always On Availability Groups. In the previous articles (see TOC at the bottom), we configured a two-node SQL Server Always On Availability Group. We performed the following steps at a high level.

sqlshack.com

23rd Jul 2020

Monitor the growth of SQL databases using the Default Trace

Monitoring the growth of the SQL Database is one of the essential tasks of the SQL Server DBA. In this article, I am going to explain how we can monitor the growth of the SQL database using the default trace. First, let me explain the default trace in SQL Server.

sqlshack.com

23rd Jul 2020

The Complete Guide To Invoking Serverless Oracle Functions

I have blogged quite a bit about serverless Oracle Functions here on this blog, including several various examples about function invocation. But, I've never put together a comprehensive guide that includes examples of the various ways to invoke your serverless functions in the Oracle Cloud.

blogs.oracle.com