Nominations for the seventh annual MongoDB Innovation Awards are now open until April 29th! The Innovation Awards are presented annually to honor groundbreaking use of data and the creativity of professionals expanding the limits of technology with MongoDB.
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:
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.
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.
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.
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.
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.
(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.
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...
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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).
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.