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

14th Oct 2020

Automating database migration monitoring with AWS DMS

AWS Database Migration Service (AWS DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.

aws.amazon.com

14th Oct 2020

Announcing pg_stat_monitor Tech Preview: Get Better Insights Into Query Performance in PostgreSQL

I am very passionate about database observability, and I believe query performance observability is the most important insight you can get in your database.

percona.com

14th Oct 2020

Your NoSQL database has an implicit schema

There's an assumption in our industry that NoSQL or document database systems doesn't have schema, and hence are more easy to use.

dzone.com

14th Oct 2020

Getting started with Azure SQL Edge

The cloud is becoming increasingly distributed, with container technologies allowing easy deployment of what had been cloud functionality to devices at the edge of the network.

infoworld.com

14th Oct 2020

.conf20 is ‘Virtually' FREE – Are You Ready to Rock the Data Age? (Federal Edition)

If you are a Splunk customer or even follow us, you know that .conf20 is virtual this year and it is FREE! That means you don’t have to go looking for budgets for the conference – no airfares, no boarding & lodging and no conference fees.

splunk.com

14th Oct 2020

Talking PostGIS on Podcasts

Here in the Covid-times, I haven’t been able to keep up my previous schedule of speaking at conferences, but I have managed to participate in a couple of episodes of the MapScaping Podcast, hosted by Daniel O’Donohue.

blog.cleverelephant.ca

14th Oct 2020

Enterprise SQL Server Management and Performance Monitoring with dbWatch

We have a large SQL Server environment across numerous locations that has grown tremendously over the years. However, our small team has difficulty gaining insight into the performance of our environment beyond just simple CPU, memory and disk utilization.

mssqltips.com

14th Oct 2020

Implement K Nearest Neighbor Solution with T-SQL

Problem I am looking for T-SQL code to implement the K nearest neighbors (KNN) algorithm. I want to get a first-hand feel for the algorithm's logic for classifying objects because I recently joined a data science team and wanted to see if this could be implemented in SQL Server with T-SQL.

mssqltips.com

14th Oct 2020

wal_level = logical max_replication_slots = 10 # minimum 1 shared_preload_libraries = 'pg_squeeze'

The most important thing is to set the wal_level to logical. Internally pg_squeeze works as follows: It creates a new datafile (snapshot) and then applies changes made to the table while this snapshot is copied over. This is done using logical decoding.

cybertec-postgresql.com

14th Oct 2020

Fundamentals of table expressions, Part 7 – CTEs, optimization considerations

This article is the 7th part of a series about named table expressions. In Part 5 and Part 6 I covered the conceptual aspects of common table expressions (CTEs). This month and next my focus turns to optimization considerations of CTEs.

sqlperformance.com

13th Oct 2020

Database Migrations made Easy.

Looking to achieve DevOps with Flyway? Watch our latest webinar on the Redgate Hub ▶ Watch now Easy to setup, simple to master. Flyway lets you regain control of your database migrations with pleasure and plain sql.

flywaydb.org

13th Oct 2020

Version Control for Distributed SQL With Flyway’s Maven Plugin

In this article, take a look at version control for distributed SQL with Flyway's Maven plugin. Flyway is an open source database version control and migration tool that stresses simplicity and convention over configuration.

dzone.com

13th Oct 2020

What you need to know to begin your journey to CDP

Recently, my colleague published a blog build on your investment by Migrating or Upgrading to CDP Data Center, which articulates great CDP Private Cloud Base features. Existing CDH and HDP customers can immediately benefit from this new functionality.

blog.cloudera.com

13th Oct 2020

Branching in Git with SQL Database Projects

As a SQL Server Database Developer, I need to understand and implement the concept of Dev branch in Git source control especially when multiple developers have to work on the same branch in a state based development. How can I accomplish this with Git?

mssqltips.com

13th Oct 2020

Video: Working with Problematic SQL in Oracle Autonomous Database

Most performance problems will be identified, analyzed, and fixed before you even have a chance to be impacted by them in Oracle Autonomous Database. And with our Machine Learning algorithms and technologies like Automatic Indexing and the Exadata Appliance – this will only get better over time.

thatjeffsmith.com

13th Oct 2020

Infuse machine learning and AI in Db2 for z/OS

IBM Db2 AI for z/OS & Watson Machine Learning for z/OS - keep getting better! Join this IBM webcast to learn how your organization can benefit from the power of machine learning and AI to improve Db2 for z/OS application and system performance.

worldofdb2.com