DBplatz
15th Oct 2020

Getting started with Ansible security automation: Threat Hunting

AnsibleFest has just wrapped up, with a whole track dedicated to security automation, our answer to the lack of integration across the IT security industry.

ansible.com
15th Oct 2020

Unlocking Data from Existing Systems with a Serverless API Facade

In today’s modern world, it’s not enough to produce a good product; it’s critical that your products and services are well integrated into the surrounding business ecosystem. Companies lose market share when valuable data about their products or services are locked inside their systems.

aws.amazon.com
15th Oct 2020

Understanding Docker: part 9 – Docker Search

Understanding Docker can be difficult or time-consuming. In order to spread knowledges about Cloud technologies I started to create sketchnotes about Docker. I think it could be a good way, more visual, to explain Docker (and others technologies like Kubernetes and Istio).

dev.to
15th Oct 2020

Reasons Your Query Is Slow Right Now: A Bad Plan Appears

Okay look, you probably should update stats. At least when you do it, you have some control over the situation. If you let SQL Server get up to its own devices, you might become quite surprised.

erikdarlingdata.com
15th Oct 2020

Upgrade to Oracle 19c – performance issue

In this blog I want to introduce you to a workaround for a performance issue which randomly appeared during the upgrades of several Oracle 12c databases to 19c I performed for a financial services provider.

blog.dbi-services.com
15th Oct 2020

Couchbase N1QL Transaction: An Elastic and Scalable Distributed Transactions

See an explanation of transactions in Couchbase N1QL. SQL is the only 22nd-century language available for developers today. Abstract In relational database systems, SQL is more than a declarative query language.

dzone.com
15th Oct 2020

TiCDC GA: Offering High-Availability Replication Services for Production Environments

TiDB 4.0 introduces TiCDC as TiDB's change data capture framework. It's an open-source feature that replicates TiDB's incremental changes to downstream platforms by subscribing to change logs in TiKV (TiDB's storage engine).

pingcap.com
15th Oct 2020

SQL Server Clustered Index Fragmentation on GUID Columns

On some of the SQL Server databases I manage, I noticed that there are tables with GUID columns and the GUID column is defined as the primary key. On checking further, I noticed that these GUID columns also have a unique clustered index on the column.

mssqltips.com
15th Oct 2020

5-Minute Interview: Graph Databases For Dummies with Dr. Jim Webber and Rik Van Bruggen

Recently we sat down with the authors of Graph Databases For Dummies, Neo4j Special Edition, Dr. Jim Webber and Rik Van Bruggen. Dr. Webber is Neo4j’s Chief Scientist and Mr. Van Bruggen leads the Neo4j sales team in Europe, and has been doing so for eight years.

neo4j.com
15th Oct 2020

The Architecture of a Distributed SQL Database Pt 1: Converting SQL to a KV Store

CockroachDB was designed to be the open source database our founders wanted to use. It delivers consistent, scalable SQL in a distributed environment. Developers often have questions about how we've achieved this, and our short answer is this: Distributed SQL.

cockroachlabs.com
15th Oct 2020

SQL SERVER 2019 – Performance Issues After Upgrading from SQL Server 2012

I just finished a call with the client of Comprehensive Database Performance Health Check, who upgraded their SQL Server from 2012 to SQL Server 2019 and started to face SQL Server Performance Regression (poor performing SQL Server).

blog.sqlauthority.com
14th Oct 2020

Db2 12 for z/OS Function Level 508

Craig S. Mullins Sugar Land, TX, United States Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

db2portal.blogspot.com
14th Oct 2020

Rate Limit (Throttle) for MySQL With ProxySQL

In this article, explore rate limit for MySQL with ProxySQL. Maybe one of the more "obscure" operations when dealing with replica lag, or, in general, when one needs to control writes to the database, is the Rate limit. It's also lately one of the most popular conversations around the community.

dzone.com
14th Oct 2020

SQL Server Clustered Indexes internals with examples

In this article, we will learn the SQL Server clustered index concept and some internal details. Indexes are the database objects that accelerate the performance of data accessing when are designed properly.

sqlshack.com
14th Oct 2020

Architecting Offline-first and Edge Computing Solutions with Couchbase

Release 1.0 of Couchbase for mobile was announced in 2014, making it the industry’s first NoSQL mobile database for offline first applications. Offline first is an application development paradigm that ensures that the functionality of the apps is unaffected by the state of network connectivity.

blog.couchbase.com
14th Oct 2020

Craig Mullins Presenting at Data Summit Fall 2020

Keeping abreast of what is happening in the world of data management and database systems is important for all IT professionals these days.

datatechnologytoday.wordpress.com
14th Oct 2020

SQL Server AlwaysOn node “Add all eligible storage to the cluster”

I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage to the cluster”.

blog.dbi-services.com
14th Oct 2020

Introducing Data Redaction - An Enabler to Data Security in EDB Postgres Advanced Server - APJ

9.30am IST 12.00pm SGT 3.00pm AU ET With the rapid growth in digitalization, coupled with the current pandemic situation globally, many organizations and businesses are forced to operate remotely and online, more than they would prefer. At such times, how do corporations and businesses ensure data security, especially the secure management of perso

enterprisedb.com
14th Oct 2020

N1QL Transactions : An Elastic and Scalable Distributed Transactions

SQL is the only 22nd-century language available for developers today. In relational database systems, SQL is more than a declarative query language. It includes procedural language (T-SQL, PL/SQL, etc) and defines transactions and its semantics.

blog.couchbase.com
14th Oct 2020

The October 2020 release of Azure Data Studio is now available

The October release of Azure Data Studio is now generally available. Download Azure Data Studio and review the release notes to get started.

cloudblogs.microsoft.com
14th Oct 2020

Tuning Your Postgres Database for High Write Loads

As a database grows and scales up from a proof of concept to a full-fledged production instance, there are always a variety of growing pains that database administrators and systems administrators will run into.

info.crunchydata.com
14th Oct 2020

InnoDB Data Locking – Part 2 “Locks”

In InnoDB Data Locking – Part 1 “Introduction” we’ve described the difficulties Lock System tries to solve using metaphor of people trying to concurrently edit spreadsheets.

mysqlserverteam.com
14th Oct 2020

DASH: Four Properties of Kubernetes-Native Databases

Cloud-native application architectures help developers deliver amazing experiences to their customers around the world. They do this by taking advantage of billions in cloud provider investments, which provide nearly unlimited and on-demand resources spread across hundreds of data centers globally.

cockroachlabs.com
14th Oct 2020

Faster Bulk-Data Loading in CockroachDB

Last year the BulkIO team at Cockroach Labs replaced the implementation of our IMPORT bulk-loading feature with a simpler and faster data ingestion pipeline. In most of our tests, it looked like a major improvement: the release notes for CockroachDB v19.2 touted "4x faster" IMPORT.

cockroachlabs.com
14th Oct 2020

Reasons Your Query Is Slow Right Now: Unchecked Maintenance

I get it. You’re a good DBA. No, you’re a great DBA.

erikdarlingdata.com
14th Oct 2020

ScaleGrid Launches Google Cloud Platform (GCP) Support for Managed Database Hosting

PALO ALTO, Calif., October 14, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced the launch of Google Cloud Platform (GCP) hosting through their fully managed DBaaS plans.

scalegrid.io
14th Oct 2020

Free Webcast on Thursday: Avoiding Deadlocks with Query Tuning

To fix blocking & deadlocks, you have 3 tools: Have enough indexes to make your queries fast, but not so many that they slow down delete/update/insert operations. (I cover that in the Mastering Index Tuning class.) Use the right isolation level for your app’s needs.

brentozar.com
14th Oct 2020

Apply SQL Server patches or cumulative updates in SQL Server Always On Availability Groups

In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances.

sqlshack.com
First 48 49 50 51 Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2020 © DBplatz