CloudWatch Contributor Insights for DynamoDB – Now Generally Available

Improvements to the Ingress API in Kubernetes 1.18

The Ingress API in Kubernetes has enabled a large number of controllers to provide simple and powerful ways to manage inbound network traffic to Kubernetes workloads. In Kubernetes 1.18, we’ve made 3 significant additions to this API:

kubernetes.io

Top Considerations When Moving from On-Premise to AWS (Part Two)

As discussed in part one, this series is meant to go over some of the biggest differences you will likely encounter when moving from on-premise to the cloud. In this portion, I’ll look at the architectural and operational differences that are commonly seen.

Best Practices for Monitoring Kubernetes using Grafana

Microservices and containers have taken the tech industry by storm. Kubernetes is one of the tools that has evolved to manage these new aspects of software development. It is an open-source system for automating deployment, scaling, and management of containerized applications.

logz.io

Understanding Dynamic Data Masking in SQL Server

In this article, I’m going to explain the Dynamic Data Masking feature in SQL Server. As it goes by the name, Dynamic Data Masking is one of the security features that was introduced in SQL Server 2016.

sqlshack.com

The 5 Best Open Source Load Balancers

Consider for a moment which fundamental pieces of technology enable the modern web. Odds are, you’re thinking about things like Javascript and HTTP—and yes, they are fundamental parts of the modern web.

logz.io

How Performant is Your ProxySQL Node?

ProxySQL has gained a lot of interest right now in the MySQL and MariaDB database world, not to mention ClickHouse which helps make the case for ProxySQL.

severalnines.com

SQL Server and Undocumented Extended Procedures

Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead.

red-gate.com

datatechnologytoday.wordpress.com

World Backup Day and Your Databases

Today, March 31, 2020, is World Backup Day. So I thought I’d take the time to blog a bit on the importance of preparing and testing your database backup and recovery plans. The recoverability of your organization’s data is perhaps the most important thing that a DBA must do.

SQLpassion Online Training in April

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) Today I’m quite happy to announce my upcoming SQLpassion Online Training for April.

sqlservercentral.com

Shutdown with MySQL 8

On StackExchange for Database Administrators I recently have seen a question which attracted my interest. The question puzzled me a bit because the answer seems too easy. Further the question was not so clear. An all theses factors smell dangerous...

fromdual.com

Implementing a Multi-Datacenter Setup for PostgreSQL - Part One

Having a multi-datacenter setup is a common topology for a Disaster Recovery Plan(DRP), but there are some limitations around implementing this kind of environment. You should first solve the communication between the data centers by using SSH access or configuring a VPN.

severalnines.com

Migrate SQL workloads to the cloud with confidence

Wouldn’t it be great if you could see how a workload will perform in a new environment before migrating a database to the cloud? Then you could fix any queries that have compatibility errors or move forward with the migration with confidence.

cloudblogs.microsoft.com

Becoming Familiar With the Little Known SQL Keyword LATERAL

Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14, so I wanted to share how it can be used. The keyword “LATERAL” comes into play when you work with derived tables.

5 Ways the Role of the Database Administrator Has Changed

NetApp sponsored this post. The rules around IT service delivery are changing. This is because we’re in a world where IT stability is a set expectation rather than an ask.

thenewstack.io

Useful Queries For PostgreSQL Index Maintenance

PostgreSQL has a rich set of indexing functionality, and there are many articles explaining the syntax, usage, and value of the index. In this article, I will write basic and useful queries to see the state of database indexes.

An overview of ksqlDB

ksqlDB is an event streaming database. What exactly does that mean? An event streaming database is a particular kind of database that helps you build stream processing apps. It consolidates the many components found in virtually every event streaming architecture.

ksqldb.io

Replaying Workloads to a different Database

One of the features I was asked to implement for WorkloadTools is the ability to replay commands to a database name different from the one recorded in the source workload. This is something that I had been planning to implement for a while and it totally makes sense.

sqlservercentral.com

Oracle Offers Free HR Tool to Help Customers Keep Employees Safe

As we continue to face increasing concerns about COVID-19, many organizations and HR professionals are facing new and unprecedented challenges. In an effort to help, we are providing free access to our Workforce Health and Safety solution to current Oracle Human Capital Management Cloud customers.

oracle.com

Top Considerations When Moving from On-Premise to AWS (Part One)

One of the most common questions I get as a Technical Account Manager (TAM) from clients considering a migration from their current on-premise data center to AWS is “what are the biggest differences I will need to address?” In an earlier post MySQL to the Cloud! Thoughts on Migrating Away from

Two million ways to use Postgres

You need a database. Maybe you need more than one. Fifteen years ago you’d choose MySQL if you were from the open source camp, SQL Server if you were on the Microsoft stack, and Oracle if you were operating in a large enterprise.

dev.to

Learn SQL: SQL Query examples

In the previous article we’ve practiced SQL, and today, we’ll continue with a few more SQL examples. The goal of this article is to start with a fairly simple query and move towards more complex queries.

sqlshack.com

Free Oracle Learning and Certifications for OCI and Autonomous database - Limited period

Hello All, Oracle announced a limited period free access to Oracle Learning and Certifications on OCI and Autonomous Database technologies. Its absolutely free of cost for everyone. Indeed it is a very good chance everyone to learn something new to update Oracle knowledge and get certified.

jaffardba.blogspot.com

Hunting for IT staff? Lost your job during the pandemic? Sysadmin vacancies – and a free job ads offer – inside

Job alert We've received a couple of solid responses to our offer last week, in which we invited organizations seeking tech staff to tackle the coronovirus pandemic to send in their recruitment ads and we would run them for free online. No catch, snark, nor strings attached.

theregister.co.uk

Using WinSCP with SQL Server Agent

In past tips, Using SFTP with SQL Server Integration Services and SFTP in SQL Server Integration Services SSIS Package with Bitvise, we looked at how to use SFTP to transfer files via SQL Server Integrations Services (SSIS).

mssqltips.com

How to Restore a Single MySQL Table Using mysqldump?

Mysqldump is the most popular logical backup tool for MySQL. It is included in the MySQL distribution, so it’s ready for use on all of the MySQL instances. Physical backups are usually all or nothing type of backups.

severalnines.com