DBplatz
3rd Mar 2021

Running CockroachDB on Kubernetes

At Cockroach Labs, we’re working hard to make it easier to keep your data safe and available even in the face of catastrophic failures.

cockroachlabs.com
3rd Mar 2021

Backup MySQL Databases in Kubernetes

In this post, we will show you how to create a MySQL server backup using Kubernetes CronJobs. In our case, we do not have a managed MySQL server. But we want to backup it to our NAS, so that we have a backup in case of emergency.

dev.to
3rd Mar 2021

MongoDB setup for creating REST API

Here I am going to explain how to set up your database MongoDB for creating REST API using node.js,express which you can later fetch using any frontend like React.I am not covering the basics of mongoDB here. 2.Create a cluster. Choose Shared Clusters which is free.

dev.to
3rd Mar 2021

Open Infrastructure Foundation Silver Member Establishes a New Foothold in Private Cloud

Last week, InMotion Hosting, an Open Infrastructure Foundation Silver Member, announced the general availability of their new Flex Metal Cloud IaaS product. With this announcement, InMotion Hosting established a new foothold in the Infrastructure as a Service (IaaS) and Private Cloud markets.

superuser.openstack.org
3rd Mar 2021

Database Fundamentals

I would guess that most of the readers of this blog understand the basic concepts and fundamentals of database technology. However, many folks who think they understand the basics often do not have the knowledge and understanding they believe they have.

datatechnologytoday.wordpress.com
3rd Mar 2021

How to Encrypt Hybrid Cloud Database Traffic

Pon Suresh Pandian is an Oracle-Certified, MySQL Support Engineer at Severalnines. He is interested in MySQL & PostgreSQL related technologies and strives to always ensure database performance and high availability for his customers.

severalnines.com
3rd Mar 2021

Learn SQL: Dynamic SQL

Dynamic SQL is a programming technique you can use to build SQL statements as textual strings and execute them later. This technique could prove to be useful in some cases and therefore it’s good to know we have it as an option.

sqlshack.com
3rd Mar 2021

Oracle Cloud Breakdown – Database Hosting Costs on OCI

When considering a new cloud provider, the big names come to mind -  AWS, Azure, and Google Cloud. If you’re a developer, you might even be considering a dev-friendly cloud like DigitalOcean or Linode.

scalegrid.io
3rd Mar 2021

Oracle Database Upgrades : One Size Does Not Fit All

If you follow me on Twitter, you’ll know I’ve been doing a lot of upgrades recently. Whenever I mention upgrades, someone comes back with a comment asking me to describe in detail what I’ve done. This always makes me nervous, as every upgrade is potentially unique.

oracle-base.com
3rd Mar 2021

How many engineers does it take to make subscripting work? · Erthalion's blog

Are you tired of this syntax in PostgreSQL? The select part is actually fine. But for updates, especially for complex updates, it could be pretty verbose and far from being ergonomic. What would you say to this syntax instead?

erthalion.info
3rd Mar 2021

Running Raspberry Pi Desktop within VirtualBox

In this guide, we will be showing you how to run Raspberry Pi Desktop using VirtualBox. VirtualBox is a nifty piece of software that allows you to run an operating system on top of another operating system.

pimylifeup.com
3rd Mar 2021

How does the buffer pool handle low memory conditions?

One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you always give SQL Server as much RAM as you can afford, because it’s going to use it. But what happens when SQL Server runs out of memory?

bornsql.ca
2nd Mar 2021

Disabling Non-Clustered Indexes For Fun and Profit

One of the frequently quoted ETL best practices is to disable your non-clustered indexes during a data load.

nebraskasql.blogspot.com
2nd Mar 2021

PostgreSQL - default superuser privileges were removed.

Last week a colleague contacted me about a PostgreSQL installation where the privileges of the postgres user suddenly "disappeared". However, his server was Windows, so I tried and replicated this issue on a Windows 2019 server.

blog.dbplatz.com
2nd Mar 2021

Using SQL to democratize streaming data

Streaming analytics is crucial to modern business – it opens up new product opportunities and creates massive operational efficiencies. In many cases, it’s the difference between creating an outstanding customer experience versus a poor one – or losing the customer altogether.

blog.cloudera.com
2nd Mar 2021

How WiredTiger Revolutionized MongoDB

Unlike many other “next-generation” databases, MongoDB was not created by refugees from one of the existing database companies or architects of large-scale cloud infrastructures.

dbta.com
2nd Mar 2021

Using Dynamic SQL

There are many ways that you can structure your T-SQL code to solve complex problems. Throughout my career, I’ve learned different ways, and also some patterns to avoid. However, those change over time. For example, there was a time when heavily loading tempdb caused issues in the v6 era.

voiceofthedba.com
2nd Mar 2021

Alerting and Notifications from SkySQL

MariaDB SkySQL is a database-as-a-service (DBaaS) that delivers unmatched flexibility and massive scalability in the cloud. SkySQL offers a dedicated observability portal, SkySQL Monitoring, which serves as a single pane of glass for the customer’s performance metrics across all clouds.

mariadb.com
2nd Mar 2021

Invisible MySQL?

Is MySQL going invisible? Invisible Indexes were included in MySQL 8.0 and now with version 8.0.23 we have Invisible Columns. The value of the invisible index is that it allows you to make an index disappear from the view of the optimizer. In the distant days before 8.

elephantdolphin.blogspot.com
2nd Mar 2021

Using Docker inside Kubernetes

In a previous post I talked about the problem of granting privileges to a container and the risks that this entails. Today I want to present a specific case in which privileges are granted to a container and give some alternatives. One of the most popular Continuous Integration tools is Jenkins.

blog.arima.eu
2nd Mar 2021

Flux Training is Back — Grabbed Your Spot Yet?

Hands-On Flux Training is back by popular demand! As part of InfluxDays EMEA 2021 Virtual Experience, it will take place on May 10-11, 2021, the week prior to the conference — with only 50 spots available to ensure an ideal student-to-teacher ratio.

influxdays.com
2nd Mar 2021

Learn MySQL: An overview of the mysqlbinlog utility

The mysqlbinlog utility is used to process the binary logs of the MySQL server. Using mysqlbinlog utility, we can perform the following tasks: In my previous article, I have explained about the binary logs.

sqlshack.com
2nd Mar 2021

Disaster Recovery Options for PostgreSQL Deployed to a Hybrid Cloud

In our previous Hybrid Cloud blogs, we often mention that one of the primary options of availing the Hybrid Cloud topology setup is to use this as your disaster recovery target.

severalnines.com
2nd Mar 2021

​A Powerful New Approach to Phishing – the Biggest Issue for Cybersecurity

Originally published on Ericom's blog. Phishing attacks – which start with emails that appear to come from a legitimate company but are really devised by cybercriminals – are the top delivery mechanism for ransomware.

cloudsecurityalliance.org
2nd Mar 2021

Security and Containers in Cloud Native PostgreSQL

In this blog post, we’ll analyze in more depth some relevant security aspects that EDB’s Cloud Native PostgreSQL implements at the “Container” level, the third layer of the 4C’s security model in Kubernetes—which I covered in my last blog.

enterprisedb.com
2nd Mar 2021

Restore dedicated SQL pools in Azure Synapse Analytics

This article will walk you through the process of restoring dedicated SQL pools in Azure Synapse Analytics. Database or Data Warehouse administrators need to back-up and restore database and database on a frequent basis.

sqlshack.com
2nd Mar 2021

Field Notes: Accelerate Research with Managed Jupyter on Amazon SageMaker

Research organizations across industry verticals have unique needs. These include facilitating stakeholder collaboration, setting up compute environments for experimentation, handling large datasets, and more.

aws.amazon.com
2nd Mar 2021

Percona Monitoring and Management 2.15 Brings Even MORE Reasons to Upgrade to PMM v2!

In November of 2020, we announced that in early 2021 Percona was slated to release a version of Percona Monitoring and Management (PMM) v2 that would include all of the critical functionality users of PMM v1 have come to know and love over the years.

percona.com
First 1 2 3 Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2020 © DBplatz