DBplatz
22nd Oct 2020

Which database is right for you?

PostgreSQL, EDB Postgres, Oracle, Cassandra, Mongodb, Redis, MySQL, SQL Server Selecting a database can be compared to your next automobile purchase. If you have a family of eight, you probably would not purchase a car with only two seats.

enterprisedb.com
22nd Oct 2020

MariaDB SkySQL Expanded Monitoring

The newest release of MariaDB SkySQL includes major new capabilities, such as new topologies for distributed SQL and clustering, and cloud data warehousing with massively parallel processing and HA.

mariadb.com
22nd Oct 2020

Securing Secrets in Azure DevOps

In my previous article, Azure DevOps CI/CD using GitHub Repo and Visual Studio Azure SQL Database Project, I demonstrated how to deploy an Azure SQL Database from Visual Studio using Azure DevOps using the Azure SQL Database deployment release task.

mssqltips.com
22nd Oct 2020

Make SQL Server Agent Jobs HADR Aware – SQLServerCentral

Always On Availability Groups (AGs/AG) provides a fairly convenient and reliable High-Availability Disaster Recovery ("HADR") solution. Each database is configured to provide a fail-over solution using multiple servers running Windows Clustering replicas.

sqlservercentral.com
22nd Oct 2020

Smashing Security podcast #201: Robin Hood, Flippy, and the web ad bubble

The Darkside ransomware gang thinks it’s a modern-day Robin Hood when it donates extorted Bitcoins to charity, the micro-targeted ad industry could pop like a bubble, and would you trust a burger-flipping robot?

grahamcluley.com
22nd Oct 2020

Understanding Inner Loop Development and Pull Rates

We have heard feedback that given the changes Docker introduced relating to network egress and the number of pulls for free users, that there are questions around the best way to use Docker as part of your development workflow without hitting these limits.

docker.com
22nd Oct 2020

Addressing cybersecurity risk in industrial IoT and OT

As the industrial Internet of Things (IIoT) and operational technology (OT) continue to evolve and grow, so too, do the responsibilities of the Chief Information Security Officer (CISO).

microsoft.com
22nd Oct 2020

Most Costly Statement in a Stored Procedure

In this article, see the most costly statement in a stored procedure. A lot of stored procedures have multiple statements and determining the most costly statement in a given proc is a very common task.

dzone.com
22nd Oct 2020

Automating Database Migrations With Containers and Git

Script manifest files are used to deliver custom database migrations. Managing database migrations for multiple environments and teams can be challenging.

dzone.com
22nd Oct 2020

Welcome to Redgate Deploy and cross-platform database DevOps

As organizations realize the advantages they can gain by integrating database development into their DevOps pipelines, the conversation about database DevOps has moved from ‘why’ to ‘how’.

red-gate.com
22nd Oct 2020

Graph Visualization Just Got Easier: Introducing Neo4j Bloom 1.4!

A few weeks ago, we released Neo4j Bloom version 1.4 with new features to help you get started investigating graphs visually and providing new ways of viewing different types of graphs.

neo4j.com
21st Oct 2020

Automation and the Future of Modern Db2 Data Management

Recently I was invited by BMC Software to participate in their AMI Z Talk podcast series to talk about modern data management for Db2... and I was happy to accept.

db2portal.blogspot.com
21st Oct 2020

Drilling Down on Database Licensing Best Practices and Pitfalls at Data Summit Connect Fall 2020

As software infrastructure is stretched between on-premise deployments, public clouds, and hybrid clouds, keeping software usage in compliance can be a significant challenge.

dbta.com
21st Oct 2020

Migrating from Maxscale to the ProxySQL Load Balancer

A database load balancer, or proxy, is a middleware service between application layer and database layer. Application connects to the database proxy, and the proxy forwards the connection to the database.

severalnines.com
21st Oct 2020

How to Import Perfmon Data into a SQL Server for Analysis

If you followed the last video, I showed you how to set up windows perfmon for ongoing performance metric collection on all of your critical SQL Server machines. However, having this raw data in a portable format doesn’t mean you have an easy means to access that data.

sqlservercentral.com
21st Oct 2020

Tips for Designing a Data Warehouse for Agility and Scale at Data Summit Connect Fall 2020

At Data Summit Connect Fall 2020, John O'Brien, principal advisor and CEO, Radiant Advisors, provided guidance about the agile methodology and templates that project delivery teams can follow to build modern data infrastructures (on-prem, hybrid, and multi-cloud).

dbta.com
21st Oct 2020

AWS Distro for OpenTelemetry will send metrics and traces to Datadog

Datadog has a long-standing commitment to open standards. Our integrations with OpenMetrics, JMX, and WMI, as well as our implementation of the tried-and-true StatsD protocol, enable you to collect data with the tools and libraries that fit best into your workflows.

datadoghq.com
21st Oct 2020

You Don’t Need a Blockchain, You Need a Time-Series Database

Nicolas Hourcard Nicolas is a lifelong technology enthusiast and co-founder of QuestDB. He previously leveraged time-series data for companies like Rothschild and Nasdaq. He splits his time between London and San Francisco and enjoys tennis, skiing and climbing new mountain peaks each year.

thenewstack.io
21st Oct 2020

Faster SQL: Adaptive Query Execution in Databricks

Earlier this year, Databricks wrote a blog on the whole new Adaptive Query Execution framework in Spark 3.0 and Databricks Runtime 7.0. The blog has sparked a great amount of interest and discussions from tech enthusiasts.

databricks.com
21st Oct 2020

VMware Patches Critical Code Execution Vulnerability in ESXi

VMware this week informed customers that it has patched several vulnerabilities in its ESXi, Workstation, Fusion and NSX-T products, including a critical flaw that allows arbitrary code execution.

securityweek.com
21st Oct 2020

PostgreSQL to Accelerate Innovation - UTC

PostgreSQL is versatile and used for a wide range of applications and use cases in the enterprise. It is more than just database technology, it is an accelerator for innovation. Much innovation today is happening in new application development, application modernization, and re-platforming to the cloud across the information architecture landscape.

enterprisedb.com
21st Oct 2020

Monitoring and Visualization of Couchbase Sync Gateway with Prometheus and Grafana

In order to improve the accessibility of our stats, the Sync Gateway 2.8 release integrates the  Prometheus exporter functionality directly into Sync Gateway, reducing the steps required to setup a monitoring stack.

blog.couchbase.com
21st Oct 2020

Postgres Weekly Issue 378 : October 21, 2020

While releases aren't at a Chrome or Node-esque pace, Postgres nonetheless has numerous versions that are still in production and their featuresets overlap in various interesting ways.

postgresweekly.com
21st Oct 2020

Designing the Raspberry Pi Compute Module 4

Raspberry Pi Compute Module 4 designer Dominic Plunkett was kind enough to let us sit him down for a talk with Eben, before writing up his experience of bringing our latest board to life for today’s blog post. Enjoy.

raspberrypi.org
21st Oct 2020

MySQL JSON_TABLE – Map a JSON object to a relational database table

In this article, I’m going to explain how the MySQL JSON_TABLE function works, and how you can use it to transform a JSON object into a relational database table. When using a relational database system, it’s best to design the database schema according to the relational model.

vladmihalcea.com
21st Oct 2020

Column Groups

Here’s an odd little detail about the statistics of column groups. At first glance it’s counter-intuitive but it’s actually an “obvious” (once you’ve thought about it for a bit) consequence of the approximate_ndv() algorithm for gathering stats.

jonathanlewis.wordpress.com
21st Oct 2020

A Parameterization Puzzle With TOP: Part 1

While working with a client recently, they ran into a performance issue when trying to promote plan reuse by parameterizing the user-input number for TOP. In part 1, I’m going to show you what happened and why, and in part 2 I’ll discuss some workarounds.

erikdarlingdata.com
21st Oct 2020

YottaDB Releases Plugin for Popular SQL Tools

YottaDB, the database for transactional systems, is releasing production-grade Octo 1.0, a YottaDB plugin to query YottaDB application data using popular SQL tools.

dbta.com
First 43 44 45 46 Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2020 © DBplatz