Filter

The Filter operator is used to remove rows from a result set that do not satisfy a specified condition. Its most common usage is to implement a WHERE clause, although many elements of a WHERE clause get implemented in other ways (e.g.

sqlserverfast.com

19th Nov 2020

Replay your Workload in the Cloud

Join Kevin Kline and me on Monday, November 23rd to learn how we do load testing in the cloud.Want to save money, validate performance, and make sure you do not have errors while migrating to the cloud? You need to learn about the DEA today.

johnsterrett.com

19th Nov 2020

How to collect VMware vSphere metrics

In Part 1 of this series, we discussed key VMware vSphere metrics you can monitor to help ensure the health and performance of your virtual environment. In this post, we’ll cover how you can access these key vSphere metrics using a few of VMware’s internal monitoring tools.

datadoghq.com

19th Nov 2020

Announcing the MySQL Database Service support for E3 shapes

The MySQL team is excited to announce that MySQL Database Service now supports the Oracle Cloud Infrastructure Compute E3 shapes. These shapes are built on the 2nd Gen AMD EPYC 7742 processor, with a base clock frequency of 2.25 GHz and max boost of up to 3.

blogs.oracle.com

19th Nov 2020

An Overview of Percona Backup for MongoDB

The known and popular backup method for MongoDB is mongodump. It is a logical backup method, similar to mysqldump in MySQL or pg_dump in PostgreSQL database. There is another backup tool called Percona Backup for MongoDB.

severalnines.com

19th Nov 2020

SQL Developer – A great tool and better ways to use it

SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can make you more productive. SQL Developer is a free tool provided by Oracle.

red-gate.com

19th Nov 2020

Faster logical backup of a single table in MySQL.

Logical backup’s are of great use in data migration across cloud environments and table level recoveries. The new Mysql shell 8.0.22 ,has introduced a couple of new utilities named util.dumpTable() and util.exportTable() to export individual tables from a MySQL. Prior to 8.0.

mydbops.wordpress.com

19th Nov 2020

Microsoft Azure at Data Platform Virtual Summit 2020

Data Platform Virtual Summit 2020 (DPS 2020) is just a couple of weeks away.

cloudblogs.microsoft.com

19th Nov 2020

SQL Join vs Subquery: The Game Changer

When building an SQL query that involves multiple tables, there is always a constant debate about joining the tables or using subqueries. There are pros and cons to every method. My natural choice is to join the tables. I find it easier to maintain and read.

daily.dev

19th Nov 2020

Best practices for migrating Oracle database MERGE statements to Amazon Aurora PostgreSQL and Amazon RDS PostgreSQL

To migrate an Oracle database to Amazon Aurora with PostgreSQL compatibility, you usually need to perform both automated and manual tasks. The automated tasks involve schema conversion using AWS Schema Conversion Tool (AWS SCT) and data migration using AWS Database Migration Service (AWS DMS).

aws.amazon.com

19th Nov 2020

Field Notes: Automating Migration Requests for Reserved Instances and Savings Plans in Closed Accounts

Enterprise AWS customers are often managing many accounts under a payer account, and sometimes accounts are closed before Reserved Instances (RI) or Savings Plans (SP) are fully used.

aws.amazon.com

19th Nov 2020

Now Available: Red Hat Ansible Automation Platform 1.2

Red Hat Ansible Automation Platform 1.2 is now generally available with increased focus on improving efficiency, increasing productivity and controlling risk and expenses.

ansible.com

19th Nov 2020

Overview of Real-Time Monitoring Options For Db2

I thought I’d share an overview of the real-time monitoring options for Db2 (LUW). This article focuses on comparing the options, with links to deeper information on each tool. First a quick overview of the types of monitoring that every DBA should be doing.

datageek.blog

19th Nov 2020

DB2 v11.5.4 REST API – Part Two

Enabling clients to interact via HTTP GET/POST requests the REST API functionality provides clients a lightweight, modern interface to data stored in DB2 databases.

triton.co.uk

19th Nov 2020

Database DevOps Considerations for SQL Server Availability Groups

One question which comes up periodically from our Microsoft Data Platform customers is whether there is anything special that they need to do when implementing version control, continuous integration, and automated deployments for a production database which is a member of a SQL Server Availability

red-gate.com

19th Nov 2020

DB2 v11.5.4 REST API – Part One Setup and Configuration

Enabling clients to interact via HTTP GET/POST requests the REST API functionality provides clients a lightweight, modern interface to data stored in DB2 databases.

worldofdb2.com

19th Nov 2020

Waiting for PostgreSQL 14 – Provide the OR REPLACE option for CREATE TRIGGER. – select * from depesz;

committed patch: Provide the OR REPLACE option for CREATE TRIGGER. This is mostly straightforward. However, we disallow replacing constraint triggers or changing the is-constraint property; perhaps that can be added later, but the complexity versus benefit tradeoff doesn't look very good.

depesz.com

19th Nov 2020

Unattended Upgrades, Ubuntu 18.04, and PostgreSQL 10: The Perfect Storm

We recently enabled unattended-upgrades on our Ubuntu 18.04 LTS (Bionic) servers, including our PostgreSQL hosts.

seiler.us

19th Nov 2020

Deploy Database Objects to Multiple SQL Server Instances Using PowerShell

When working with dozens or hundreds of SQL Server instances, there’s a good chance that you might need to deploy a new object to each instance. For example, you might need to create a new login for a specific application that will connect to each of the instances.

mssqltips.com

19th Nov 2020

What’s So Special About Spatial Data?

How is Lyft able to tell you how far away your driver is? How does DoorDash give accurate estimates for the food you just ordered? Both of these satisfying user experiences are possible because of spatial data.

cockroachlabs.com

19th Nov 2020

Understanding Graphs and Graph Data Science

Graph approaches to data are exploding. In the commercial world, graph-based analysis is used to explore deeper meaning in data you already have, improve forecasts and make better predictions.

neo4j.com

18th Nov 2020

The Virtual Experience

I just completed the 2020 DevOps Enterprise Summit a few weeks ago, and it was enlightening to me to see that so many people liked this experience. They appreciated not traveling, being able to drop in and out of sessions while near their home and family.

voiceofthedba.com

18th Nov 2020

Complimentary IDUG EMEA 2020 Expo Pass for World of Db2 Members

We are offering a complimentary IDUG EMEA 2020 Expo Pass for Db2 users to visit the IBM Expo at the IDUG EMEA 2020 Conference. Basically this means that IDUG have opened the IBM Expo for non IDUG registered attendees. Meet IBM Experts on Thursday 19th November 11:50 - 13:00 CET and ...

worldofdb2.com

18th Nov 2020

Setting MySQL Configuration Variables - MySQL 5.7 vs MySQL 8.0

In this article, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0. MySQL configuration variables are a set of server system variables used to configure the operation and behavior of the server.

dzone.com

18th Nov 2020

EightKB is back!

We’re back! The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1000 attendees!

dbafromthecold.com

18th Nov 2020

DB2 v11.5.4 REST API – Part One

Enabling clients to interact via HTTP GET/POST requests the REST API functionality provides clients a lightweight, modern interface to data stored in DB2 databases.

triton.co.uk

18th Nov 2020

Collecting Toxic Waste

I was listening to someone talk about software development recently and they used this phrase: “are you collecting toxic waste?”. In this case, they were discussing technical debt, but I found the analogy to be good.

voiceofthedba.com

18th Nov 2020

Engineering for Engineers: How MongoDB’s Culture Enables Engineers to Be Their Very Best

As a leading technology company disrupting the fast-growing database market, MongoDB offers a unique opportunity for ambitious engineers.

mongodb.com