Why Cloud and DevOps are better together

To maximise the benefits of cloud computing while optimising costs, a DevOps approach is the best way forward. In this blog post we explain why. According to a report from IT analyst firm Freeform Dynamics, using cloud or DevOps in isolation accelerates software delivery by just over 50 percent.

devopsgroup.com

20th Jan 2021

Log and Error Redaction in CockroachDB v20.2

CockroachDB users trust us with their most sensitive data (see: healthcare, finance). And the best way for us to maintain that trust is for Cockroach Labs to never see this data at all. In CockroachDB v20.

cockroachlabs.com

20th Jan 2021

Study Guide for DP-201 Microsoft Certification Exam: Designing an Azure Data Solution

Hello Readers, welcome back. If you are inclined towards gaining data engineering skills on the Azure platform, Microsoft Azure data solutions certification DP-201 is the perfect step for you to take. The DP-201 certification exam introduced by Microsoft for designing an Azure Data solution.

blog.cloudthat.com

20th Jan 2021

But When Did We Capture That Changed Data?

There are to common questions people ask about changed data that CDC doesn’t support very naturally: When did it change? Who changed it? While it is possible to join to cdc.lsn_time_mapping to get that information, you may be dealing with a box product that doesn’t support that functionality.

erikdarlingdata.com

20th Jan 2021

DBA Automation

Just a quick blog post today to point you at a couple of other resources that I have created on the topic of automating database administration.

datatechnologytoday.wordpress.com

20th Jan 2021

Oracle SQL Developer Web 20.4 and JSON

In yesterday’s post I said there were a couple of major improvements for ORDS and SQL Developer Web 20.4. I took you through the enhanced REST workshop and let you know that your sessions won’t automatically expire one hour from login time.

thatjeffsmith.com

20th Jan 2021

Oracle 21C, new feature blockchain tables.

First draft, more to come. I’ve spoken in the past about the utility of blockchain, to create a table that can not be altered. Oracle 21C is not available in OCI.

oraclewizard.com

20th Jan 2021

Around the clock with Azure SQL and Azure Data Factory

On February 3-4, the Azure SQL and Azure Data Factory teams are partnering on a learning event for the community to come together to learn about Azure SQL and Azure Data Factory, meet the engineering teams behind these services, and learn how you can get started with using Azure Data Factory and Azu

cloudblogs.microsoft.com

20th Jan 2021

MySQL 8.0.23 Is Available: Highlighting Some Important Points

As many of you have seen already, MySQL 8.0.23 is available for download (release notes). Today our dear LeFred thanked all the numerous contributors to bug fixes. About this: let me mention our two people involved in bug fixing, Venkatesh Prasad Venugopal and Kamil Hołubicki.

percona.com

20th Jan 2021

MySQL Invisible Column – part I

With the new MySQL 8.0.23, something very interesting has been released: Invisible Column. This is the first post dedicated to this new feature, I expect to write a series of 3. This one is the introduction.

lefred.be

20th Jan 2021

Monitoring ORDS Connection Pools

ORDS can have many connection pools going at any point in time. Typically to see what the state of the connection pool was someone would have to go into the database and do things like select from v$session such as:

krisrice.io

20th Jan 2021

2021-01-20: Reaching the IAC Team

To improve collaboration and avoid issues falling through the cracks, we have collected information on all the ways to get in contact with us. Whether this be to review a PR, highlight a nasty bug or really for any other reason, let us know what we did well, and what we need to do better.

puppetlabs.github.io

20th Jan 2021

Azure Data Factory Pipeline Logging Error Details

In my previous article, Logging Azure Data Factory Pipeline Audit Data, I discussed a variety of methods for capturing Azure Data Factory pipeline logs and persisting the data to either a SQL Server table or within Azure Data Lake Storage Gen2.

mssqltips.com

20th Jan 2021

Vagrant and Docker Builds: ORDS 20.4, SQLcl 20.4 and Database Patches

The January Oracle quarterly patches were released yesterday, which prompted me to do some new builds. We got Oracle REST Data Services (ORDS) 20.4 and SQLcl 20.4, which I use in a number of my Vagrant and Docker builds, so I updated them and ran some builds.

oracle-base.com

20th Jan 2021

Logz.io™ Infrastructure Monitoring

Monitor with open source Prometheus and Grafana - the best cloud-native tools for metrics storage and analytics. Provided on an easy-to-use cloud service, integrated with logs and metrics.

logz.io

20th Jan 2021

CBO Example

A little case study based on an example just in on the Oracle-L list server. This was supplied with a complete, working, test case that was small enough to understand and explain very quickly. The user created a table, and used calls to dbms_stats to fake some statistics into place.

jonathanlewis.wordpress.com

20th Jan 2021

Announcing the TiDB Incubator Program

Today, we are excited to introduce the TiDB Incubator Program, a program designed to ensure that new projects in the TiDB ecosystem can obtain resources and help from the community towards their desired maturity level.

pingcap.com

20th Jan 2021

How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server. Azure Data Sync —a synchronization service set up on an Azure SQL Database.

sqlshack.com

20th Jan 2021

Oracle Quarterly Critical Patches Issued January 19, 2021

Multiple vulnerabilities have been discovered in Oracle products, which could allow for remote code execution.

cisecurity.org

20th Jan 2021

How to Backup Your Moodle MySQL Database

Data is an essential part of running a Moodle environment. Should the IT operations team lose data accidentally, then it could lead to a huge loss. So, to protect valuable information, sysadmins need to back up their Moodle database.

severalnines.com

20th Jan 2021

Change Management Is Broken: Here’s How to fix It

We go over the top reasons why change management has long been technology’s least favorite process and some successful ways to implement technical change management.

dzone.com

20th Jan 2021

Introducing GitLab integration for DigitalOcean App Platform

DigitalOcean App Platform is a modern PaaS (Platform as a Service) solution that makes it super simple to build, deploy, manage, and scale apps.

digitalocean.com

20th Jan 2021

Installing Rclone to the Raspberry Pi

This project will show you how you can install the Rclone software to your Raspberry Pi. Rclone is an open-source software designed to let you manage content on cloud services such as Google Drive and Amazon S3.

pimylifeup.com

20th Jan 2021

Business Rules With Dgraph

In this blog, we discuss how to use Dgraph database as part of a solution for implementing an application based on business rules. In particular, you will model and implement a Decision Table, a popular technique used to model and implement business rules.

dgraph.io

19th Jan 2021

Automating SSL Certificate Expiration Monitoring

In my previous work experience, monitoring certificate validation was critical to our team. These certificates were used to sign commercial transactions between the payment gateway (us) and other providers. That check was manual and depended on the calendar of one person.

influxdata.com

19th Jan 2021

Search SQL Server error log files

The SQL Server error log is helpful for troubleshooting issues. Greg Larsen demonstrates several ways to search SQL Server error log files. Each instance of SQL Server logs information about its processing to a file known as the error log.

red-gate.com

19th Jan 2021

Oracle SQL Developer Web 20.4 and AutoREST

Versions 20.4 of SQLcl, ORDS, and Data Modeler are now available! SQL Developer v20.4 (desktop) will be available SHORTLY. SQL Developer Web is provided as a feature of ORDS, so go here to download and get started if you want to use the features discussed in this post.

thatjeffsmith.com

19th Jan 2021

Announcing Feb Webcast – Introduction to Database Corruption

On February 17, 2021 at 6:00pm Pacific time Derrick Bovenkamp and I will be presenting a webcast training on SQL Server Database Corruption. After repairing dozens of corrupt database over the last 6 years we are going to share our experiences.

stevestedman.com

First 1 2 3 4 Last