DBplatz

image
7th Apr 2021

MySQL 101: Basic MySQL Server Triage

So your MySQL server has crashed.  What do you do now?  When a server is down, in my opinion, there are two steps that a...

percona.com ⏰ 3 mins
7th Apr 2021

MySQL & macOS Silicon

It’s a problem for my students who purchased the new Apple hardware that uses Apple Silicon because they can’t install a...

blog.mclaughlinsoftware.com
image
7th Apr 2021

Design Pattern for Highly Parallel Compute: Recursive Scaling with Amazon SQS

Scaling based on Amazon Simple Queue Service (SQS) is a commonly used design pattern. At AWS Professional Services, we h...

aws.amazon.com ⏰ 6 mins
image
7th Apr 2021

Can a monitoring tool save money?

When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to help me do my jo...

red-gate.com
image
7th Apr 2021

Stairway to SQL essentials

SQL Essentials stairway series helps readers understand the most common database language SQL uses for data munging and ...

sqlshack.com ⏰ 5 mins
image
7th Apr 2021

PostgreSQL with Go in 2021

If you’re a modern web developer, it is inevitable to ignore a database for long as it plays an important part in the ap...

dev.to ⏰ 3 mins
image
7th Apr 2021

Getting started with Amazon Athena and S3

In this article, I am going to discuss Amazon Athena and how we can analyze data stored in S3 using Athena....

sqlshack.com ⏰ 6 mins
image
7th Apr 2021

MySQL NDB Cluster Installation Through Docker

host > docker pull mysql/mysql-cluster host> docker pull mysql/mysql-cluster:7.5 Let's wait for the download to finish. ...

clustertesting.blogspot.com
image
7th Apr 2021

Ten Best Intel Ice Lake-SP Processors for SQL Server

On April 6th, 2021 Intel held their “How Wonderful Gets Done“ launch event for the new 3rd Generation Intel Xeon Scalabl...

glennsqlperformance.com ⏰ 5 mins
image
6th Apr 2021

CIS Benchmarks April 2021 Update

CIS is excited to announce the release of the following CIS Benchmarks for March 2021. These CIS Benchmark releases woul...

cisecurity.org ⏰ 3 mins
image
6th Apr 2021

Never, Ever, Ever Start T-SQL Comments with Two Dashes

Never, ever use two dashes. Never. The problem is that monitoring tools and diagnostic management views often dump out t...

brentozar.com
image
6th Apr 2021

Export indexes and constraints from SQL Server graph databases to Neo4j

In our previously published article in this series, we explained how to migrate SQL Server graph tables into Neo4j and w...

sqlshack.com ⏰ 7 mins
image
6th Apr 2021

Default Maintenance Plan Shrink Database – Video Tip

The problem with using the default maintenance plans is that SQL Server Management Studio makes it easy to turn on some ...

stevestedman.com ⏰ 4 mins
6th Apr 2021

Spatial database management systems

A Spatial DBMS is a database management system that is able to efficiently store, manipulate and query spatial data. Spa...

db-engines.com
6th Apr 2021

Pluralsight is Offering a Free Month #FreeApril

This month Pluralsight is offering a free subscription to its entire course catalog. If you want to build your DevOps, p...

devopscube.com
image
6th Apr 2021

Monitor Azure Service Health events with Datadog

Azure Service Health continuously notifies you of issues that may affect the availability of your environment, such as s...

datadoghq.com ⏰ 4 mins
image
6th Apr 2021

IT Resilience Within AWS Cloud, Part II: Architecture and Patterns

In Part I of this two-part blog, we outlined best practices to consider when building resilient applications in hybrid o...

aws.amazon.com ⏰ 6 mins
image
6th Apr 2021

Scylla’s New IO Scheduler

As any other computational resource, disks are limited in the speed they can provide. This speed is typically measured a...

scylladb.com ⏰ 9 mins
6th Apr 2021

How to Setup Prometheus Node Exporter on Kubernetes

If you want to know how the Kubernetes nodes perform or monitor system-level insights of kubernetes nodes, you need to s...

devopscube.com ⏰ 4 mins
image
6th Apr 2021

Learn MySQL: Install MySQL server 8.0.19 using a noinstall Zip archive

In this article, I am going to explain the step-by-step installation process of MySQL server 8.0.19 using a noinstall Zi...

sqlshack.com ⏰ 6 mins
6th Apr 2021

Case Study

A recent question on the Oracle Developer forum posed an interesting question on “finding the closest match” to a numeri...

jonathanlewis.wordpress.com ⏰ 15 mins
image
6th Apr 2021

Five Facts about the SQL Server Resource Database

For many people familiar with SQL Server, system databases are associated only with four databases - master, model, msdb...

mssqltips.com ⏰ 5 mins
6th Apr 2021

How Database Automation Lowers The Total Cost of Ownership of Infrastructure Services

Krzysztof Książek, Director of Support at Severalnines. For nearly 15 years Krzysztof has held positions as a SysAdmin &...

severalnines.com
image
6th Apr 2021

Three Steps To Get Started With Database DevOps

Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve alrea...

red-gate.com ⏰ 10 mins
6th Apr 2021

PostgreSQL: Get member roles and permissions

PostgreSQL provides a highly sophisticated and powerful security and permission system. It allows you to define users (=...

cybertec-postgresql.com ⏰ 3 mins
image
6th Apr 2021

MySQL and UUIDs

In ALTER TABLE for UUID we discuss currently proper way to store and handle UUID in MySQL. Currently it works, even in a...

blog.koehntopp.info ⏰ 5 mins
image
6th Apr 2021

Where I See Databases Going in the Next 10 Years

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than ...

brentozar.com ⏰ 9 mins
image
6th Apr 2021

Powering Messaging Enabledness with Yelp's Data Infrastructure

In addition to helping people find great places to eat, Yelp connects people with great local professionals to help them...

engineeringblog.yelp.com ⏰ 6 mins
6th Apr 2021

Postgres Blog

Databases are often a critical part of enterprise infrastructure, so when and how to upgrade them is a common discussion...

momjian.us
image
6th Apr 2021

Query Optimization in SQL Server for beginners

This article intends to give some details about the query optimization process in SQL Server. The query optimization is ...

sqlshack.com ⏰ 6 mins
image
5th Apr 2021

Free Columnstore Training Class on Tuesday

Your report queries are too slow. You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores...

brentozar.com
image
5th Apr 2021

Common Query Plan Patterns For Windowing Functions: Partition By Parallelism

Prior to SQL Server 2012, this blog post would be wrong. If you’re still on a version prior to 2012, ignore this blog po...

erikdarlingdata.com
image
5th Apr 2021

SQL Server – Contained Database

You may have encounter already case when an application offers the possibility to create and maintain SQL database users...

blog.dbi-services.com ⏰ 3 mins
image
5th Apr 2021

SSMA Db2toSQL Migration Fails without Error

The SQL Server Migration Assistant (SSMA) is a tool for transitioning from other platforms like Db2 to Microsoft SQL Ser...

virtual-dba.com
image
5th Apr 2021

SQL1022C There is not enough memory available to process the command.

Last week, I was trying to check the version of my Db2 client on my laptop and I got an unexpected error message. This w...

blog.dbplatz.com
5th Apr 2021

Rename your DB clone completely

Have you ever renamed your database? When you cloned a DB, you probably started it with a new name and cloning (duplicat...

blog.dbi-services.com ⏰ 7 mins
5th Apr 2021

Simplify Log Management For Backup

Currently, there is a cronjob to delete backup logs older than 7 days. Typically, it not’s a big deal; however, having t...

mdinh.wordpress.com ⏰ 3 mins
image
5th Apr 2021

How to Encrypt MySQL Data Using AES Techniques

Sometimes clients want that the information they collected from the user should be encrypted and stored in a database. D...

thinkdiff.net
image
5th Apr 2021

Getting Started with OpenTelemetry Python v1.0.0

Since the OpenTelemetry Tracing Specification reached 1.0.0 — guaranteeing long-term stability for the tracing portion o...

splunk.com ⏰ 7 mins
image
5th Apr 2021

Understanding *args and *kwargs arguments in Python

In this article, I am going to talk in detail about the functions and arguments in Python. Python is one of the most pop...

sqlshack.com ⏰ 6 mins
image
5th Apr 2021

New CIS AWS Benchmarks Help Secure Cloud Products and Services

Amazon Web Services (AWS) continues to expand with new cloud products and services. The Center for Internet Security (CI...

cisecurity.org ⏰ 4 mins
image
5th Apr 2021

Convert the NUMBER data type from Oracle to PostgreSQL – Part 2

An Oracle to PostgreSQL migration in the AWS Cloud can be a multistage process with different technologies and skills in...

aws.amazon.com ⏰ 8 mins
image
5th Apr 2021

How to Benchmark and Tune Google Cloud

Engineers on cloud performance teams can spend their entire workday tuning and optimizing cloud configurations....

cockroachlabs.com ⏰ 3 mins
image
5th Apr 2021

AWS S3 as Docker volumes

We can attach an S3 bucket as a mounted Volume in docker. We need to use a Plugin to achieve this....

dev.to
image
5th Apr 2021

SQL Server Diagnostic Information Queries for April 2021

These are my SQL Server Diagnostic Information Queries for April 2021, aka my DMV Diagnostic Queries. They allow you to ...

glennsqlperformance.com ⏰ 4 mins
5th Apr 2021

Real-Time Big Data Analytics: How to Replicate from MySQL to Hadoop

First off: Happy 15th birthday, Hadoop! As most of you will know, Apaches Hadoop is a powerful and popular tool, which h...

continuent.com ⏰ 6 mins
image
5th Apr 2021

How to Assess Your SQL Server Environment

Give me six hours to chop down a tree and I will spend the first four sharpening the axe. Welcome back to the Two Weeks ...

straightpathsql.com ⏰ 3 mins
image
5th Apr 2021

Considerations for Running SQL Server on Kubernetes

Kubernetes is an open-source orchestration and management system for containers. It is an exciting technology to learn o...

mssqltips.com ⏰ 5 mins
    • First
    • 3
    • 4
    • 5
    • 6
    • Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2021 © DBplatz