DBplatz
27th Jan 2021

Compress and conquer with Amazon Keyspaces (for Apache Cassandra)

Amazon Keyspaces (for Apache Cassandra) is a scalable, highly available, and managed Apache Cassandra-compatible database service that enables you to run Cassandra workloads more easily by using a serverless, pay-as-you-go solution.

aws.amazon.com
27th Jan 2021

Import CSV file with MySQL Workbench

CSV imports with MySQL Workbench, is super simple. Since CSV’s are probably the most common data interchange format, it goes without saying that importing CSV data into MySQL is a staple task for all DBA’s and Developers. Continue reading to learn how easy it is using MySQL Workbench…

joshuaotwell.com
27th Jan 2021

Deploying AWS RDS PostgreSQL instances

In this article, we will look at the configuration of the AWS RDS PostgreSQL instances. AWS offers the relational database service for MySQL, Oracle, Microsoft SQL Server and PostgreSQL.

sqlshack.com
27th Jan 2021

InfoSec Handlers Diary Blog

In keeping with the Shodan theme, I’ve called the tool TriOp. It is a Python script, which enables you to quickly build a list (or multiple lists) of Shodan search terms and then repeatedly (e.g. once every day) get the count of public IPs, which satisfy each of them, from the Shodan API.

isc.sans.edu
27th Jan 2021

SQL Server interview questions for experienced developers

SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.

red-gate.com
27th Jan 2021

An overview of AWS Well-Architected Principles

In this article, I am going to explain about the AWS Well-Architected Framework that helps AWS customers to design solutions following best practices while designing the architectures of their solutions.

sqlshack.com
27th Jan 2021

MySQL Join Tutorial

Some believe the most important part of SQL is the ability to query data. Queries typically retrieve data by joining many tables together into useful result sets. This tutorial takes the position that visibility into the data helps those new to SQL understand how joins work.

blog.mclaughlinsoftware.com
27th Jan 2021

60+ Top PostgreSQL Tools

A software industry executive gives a detailed list of over 60 tools that developers can use, for various projects, to make it easier to work with PostgreSQL. PostgreSQL, or Postgres for short, comes with many out-of-the-box features that make it very popular among developers and data engineers.

dzone.com
26th Jan 2021

Use the Cockroach DB Console to Observe and Troubleshoot SQL

Whether you’re a developer or operator, we want to give you the observability tools you need to monitor your CockroachDB cluster. This includes standard tools such as logs, metrics like Prometheus and health endpoints, and alerting.

cockroachlabs.com
26th Jan 2021

How to Deploy the Chamilo MySQL Database for High Availability

Chamilo is, just like Open edX or Moodle, a platform that allows educational institutions to transfer their educational activities to the internet.

severalnines.com
26th Jan 2021

Mastering TempDB: The basics

Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration. I regularly deliver a presentation called “Mastering TempDB”.

red-gate.com
26th Jan 2021

Index Hints

At the end of the previous post on index hints I mentioned that I had been prompted to complete a draft from a few years back because I’d been sent an email by showing the optimizer ignoring an index_rs_asc() hint in a very simple query.

jonathanlewis.wordpress.com
26th Jan 2021

How to create Cloudwatch alarms for RDS (MySQL) on AWS

Monitoring your RDS instances is very important, and the same applies to other resources. In this article, we will create a simple alarm for an RDS MySQL instance which will check for free storage space on the instance.

howtoforge.com
26th Jan 2021

What’s new in MongoDB for VS Code

Since then, over 85,000 of you have installed the extension, and based on your feedback, we improved the extension quite a bit and released a few new versions that added new functionality and extended the existing one.

mongodb.com
26th Jan 2021

Introducing the MariaDB Jupyter Kernel

We are proud to announce the beta release series of the MariaDB Jupyter Kernel, making MariaDB Server accessible through the popular next-generation web-based interface. The MariaDB Kernel is ready to try out (installation, documentation, GitHub).

mariadb.org
26th Jan 2021

Getting more with PostgreSQL purpose-built data types

When designing many applications today, developers rightfully think of the end-user first and focus on what the experience will be. How the data is ultimately stored is an implementation detail that comes later.

aws.amazon.com
26th Jan 2021

Postgres scaling advice for 2021

So, you’re building the next unicorn startup and are thinking feverishly about a future-proof PostgreSQL architecture to house your bytes? My advice here, having seen dozens of hopelessly over-engineered / oversized solutions as a database consultant over the last 5 years, is short and blunt: Don

cybertec-postgresql.com
26th Jan 2021

Variations of PostgreSQL Replication

This webinar will help you understand the differences between multiple replication approaches, the requirements of each strategy, what can be achieved with each of them, and hopefully, you'll be more informed to identify what you really need for your system.   During this webinar, you will learn:

enterprisedb.com
26th Jan 2021

SQL Server SET STATISTICS IO ON Deep Dive

I've used STATISTICS IO to help performance tune SQL Server queries, but I focus mostly on logical reads. I see there is a lot more information in the output that I would like to understand and use for tuning queries.

mssqltips.com
26th Jan 2021

Replicate from MySQL 5.7 to MySQL Database Service

MySQL Replication is a very common topology, widely used in various architecture. People use it, among others, for High Availability, Read Scalability or Geographic Redundancy.

dasini.net
26th Jan 2021

A 250x improvement to tablespace truncation in MySQL Server 8.0.23

In MySQL Server 8.0.23 an improvement was made to InnoDB that allows truncation and deletion of all tablespaces to be faster. In fact, making it almost instantaneous as long as AHI is disabled.

mysqlserverteam.com
26th Jan 2021

Bye bye MySQL 5.6!

Adieu MySQL 5.6! When you arrived in 2013 you had a lot of cool new features. There was the NoSQL Memchache plug-in that was blazingly fast, an improved Performance Shema, full texted searching for InnoDB, big improvements in the optimizer, and great enhancements to replication.

elephantdolphin.blogspot.com
26th Jan 2021

Oracle SQL Developer version 20.4 is now available!

You can download it here. This release is primarily about BUG FIXES.

thatjeffsmith.com
26th Jan 2021

Performance: String Concatenation in SQL Server

String concatenation in SQL Server can be pretty quick but under certain circumstances it can really slow down. Something to be aware of if you are working with larger varchar(max) values that need to be appended to using concatenation in TSQL.

stevestedman.com
26th Jan 2021

SQL Server triggers: The good and the scary

SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues. SQL Server triggers are a subject of both functionality and controversy on any database platform.

red-gate.com
26th Jan 2021

The right way to make advanced and efficient MongoDB pagination

Onсe upon a time, we had a complex project enough (ride-sharing and taxi application) with stack Node.js and MongoDB. We have chosen this stack because it was preferable by the customer, good known by our team, and at the same time looks like good a suite for project tasks.

dev.to
26th Jan 2021

SELECT * Hurts Performance, Badly

Quite a few years ago, I wrote a post about SELECT * and performance. That post had a bit of a click-bait title (freely admitted). I wrote the post because there was a really bad checklist of performance tips making the rounds (pretty sure it’s still making the rounds).

scarydba.com
26th Jan 2021

Cloud Computing: Beginners guide

We all have been witnessing this buzz about cloud services, tech giants such as Google, Amazon, Microsoft, etc. releasing their cloud service platform such as GCP, AWS, Azure, etc. Every major company is hiring cloud developers.

dev.to
First 15 16 17 18 Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2020 © DBplatz