Cost Performance Model (to evaluate MySQL on ARM)

ARM processors are fast gaining popularity in the High Performance Computing (HPC) space with multiple cloud providers providing powerful and flexible variants of ARM instances to boot.

mysqlonarm.github.io

16th Sep 2020

How to Create a Table with a Partitioned Clustered Columnstore Index

If you need to create a table and you want it to be partitioned right from the start, AND you want it to have a clustered columnstore index, here’s a creation T-SQL example: The partition scheme name goes on the outside of the parenthesis, the index name goes on the inside, and the order of the w

brentozar.com

16th Sep 2020

PostgreSQL 13: LIMIT … WITH TIES

There! White Rabbit had to be listed, and now he is. A couple notes before you go too mad. LIMIT (or more precisely FETCH FIRST) no longer promises to return exactly the number of rows you specify. You could get two or twenty additional rows, or 100x as many rows as you asked for.

2ndquadrant.com

16th Sep 2020

ORACLE database on AWS : Architecting for HA

When planning to deploy your critical oracle databases in the aws cloud high availability is one of the most critical criteria. So let’s see what option do we have to deploy a HA oracle databases in the aws cloud whether using oracle RDS or simply an EC2 instances.

mahmoudhatem.wordpress.com

16th Sep 2020

UK's NCSC Publishes Guide to Implementing a Vulnerability Disclosure Process

The U.K.’s National Cyber Security Center (NCSC) has released a guide to help organizations get started with implementing a vulnerability disclosure process.

securityweek.com

16th Sep 2020

HOT updates in PostgreSQL for better performance

HOT updates are not a new feature. They were introduced by commit 282d2a03dd in 2007 and first appeared in PostgreSQL 8.3. But since HOT is not covered by the PostgreSQL documentation (although there is a README.

cybertec-postgresql.com

16th Sep 2020

Introducing Graph Databases For Dummies

Graph databases are the fastest growing database technology. Some people are drawn to graph databases for technical or performance reasons; others become interested because of the intuitive data model.

neo4j.com

16th Sep 2020

Rethinking Resilience: Tips for Your Disaster Recovery Plan

As more organizations face disruptions, a defined approach to recovery is imperative so they can successfully recover, experts say. The worst time to learn your disaster recovery plan is outdated is when a disaster occurs.

darkreading.com

16th Sep 2020

Capture Executions of Stored Procedures in SQL Server

SQL Server database developers would probably agree that capturing stored procedure executions can be essential in understanding what code is running. This is because capturing the procedure’s execution can be easily debugged.

mssqltips.com

16th Sep 2020

TL;DR Tech Tips – How to Extract Values, Visualize Scalars, and Perform Custom Aggregations with Flux and InfluxDB

In this post, we learn how to use the reduce(), findColumn(), and findRecord() Flux functions to perform custom aggregations with InfluxDB.

influxdata.com

16th Sep 2020

New MrbMiner malware has infected thousands of MSSQL databases

Thousands of MSSQL databases have been infected so far, according to the cybersecurity arm of Chinese tech giant Tencent. In a report published earlier this month, Tencent Security has named this new malware gang MrbMiner, after one of the domains used by the group to host their malware.

zdnet.com

16th Sep 2020

SQL SERVER – What is Spinlock?

Earlier this week, I had posted two blog posts SQLOS Scheduler and the Process States and What is Latch. After reading both the blog post, I got another question from my client on What is Spinlock? Let us discuss today What is Spinlock.

blog.sqlauthority.com

16th Sep 2020

ICYMI: From Docker Straight to AWS Built-in

In July we announced a new strategic partnership with Amazon to integrate the Docker experience you already know and love with Amazon Elastic Container Service (ECS) with AWS Fargate. Over the last couple of months we have worked with the community on the beta experience in Docker Desktop Edge.

Cost Performance Model (to evaluate MySQL on ARM)

How to Create a Table with a Partitioned Clustered Columnstore Index

PostgreSQL 13: LIMIT … WITH TIES

ORACLE database on AWS : Architecting for HA

UK's NCSC Publishes Guide to Implementing a Vulnerability Disclosure Process

HOT updates in PostgreSQL for better performance

Introducing Graph Databases For Dummies

Rethinking Resilience: Tips for Your Disaster Recovery Plan

Capture Executions of Stored Procedures in SQL Server

TL;DR Tech Tips – How to Extract Values, Visualize Scalars, and Perform Custom Aggregations with Flux and InfluxDB

New MrbMiner malware has infected thousands of MSSQL databases

SQL SERVER – What is Spinlock?

ICYMI: From Docker Straight to AWS Built-in

Monitor Alcide kAudit logs with Datadog

Percona Server for MongoDB 4.2 vs 4.4 in Python TPCC Benchmark

Increase your PostgreSQL databases security by checking a few settings Part 2

My MariaDB Playbook

Configuring ODBC drivers for Azure Database for MySQL

Starting SQL: I Don’t Care How Many Rows Are In Your Table Variable

Free Webcast Wednesday: Pushing the Envelope with Indexing for Edge Case Performance

Benchmark: MariaDB vs MySQL on Commodity Cloud Hardware

CIS Benchmarks September 2020 Update

The Journey to Better Cybersecurity in 2020 and Beyond

AWS Outposts: Run Fully Managed NoSQL Workloads On-Premises Using Scylla

Access control for Azure ADLS cloud object storage

Database Load Balancing: Distributed vs Centralized Setups

Introducing Pebble: A RocksDB Inspired Key-Value Store Written in Go

Why Serverless GraphQL Is Better with AWS AppSync