Sometimes, you have to be the bad guy. Be resistant to change. Here’s a story about how stubbornness pays off. As we’ve written about before A 4 letter word divides Dev & Ops. A True Story of Resistance I had one experience working as the primary MySQL DBA for an internet startup. Turns out they had…
In the constantly evolving world of cloud computing, Amazon Web Services (AWS) has established itself as a pioneer. It is now offering businesses unparalleled levels of performance and scalability. Among the many features and services provided by AWS, Amazon Elastic Load Balancing (ELB) and Elastic Block Storage (EBS) stand out as the leader in achieving…
Recently at Surge 2011, the annual conference on scalability and performance, Google’s CIO Ben Fried gave an illuminating keynote address. His main insight was that generalists are the people that will lead engineering teams in successfully scaling the web. In a world where the badge of Specialist or Expert is prized, this was a refreshing perspective from an…
It seems like all I hear these days is Redshift, Redshift, Redshift! I met up with a recruiter today. We talked about this & that. The usual. Then when he came to the topic of technology he said, “Yeah, it seems as though suddenly everybody is looking for Redshift & Snowflake” As I blogged about…
Don’t believe me that you’re headed for the cliff? Here is the explanation why your cloud is speeding for a scalability cliff. A Startup Scales Up to No Avail Towards the end of 2012, I worked with an internet startup in the online education space. Their web application was not unusual, built in PHP and…
AWS SQL and Azure SQL server are excellent cloud services, with more than 99.9% availability, competitive pay-as-you-go pricing strategies, and more. Yet, they have certain limitations in scalability, integration, and security. So, choosing one can be tough if you’re just starting out. A comparison of SQL server on AWS vs Azure When comparing SQL servers…
When we delete or change a record from the parent table, we encounter a deadlock. It causes locks to be placed on the child’s table to prevent orphan records. As a result, we must first alter data in the child table. When the SQL Server executes a query in parallel mode, multiple threads are created….
If you’re getting DB2 SQL Error SQLCODE 551 SQLSTATE 42501, chances are your user account doesn’t have the required privilege. Perhaps, you use a different user account from other clients. So, try to grant access to the account you’re using to run the query. The actual error message here is the SQLCODE -551, which corresponds…
In the digital age, data has emerged as a valuable resource driving innovation, decision-making, and business success. Data scalability is crucial for organizations to handle an increasing amount of data without compromising its performance and efficiency. However, not all data systems can effectively handle scalability demands. Several toxic elements can negatively impact data scalability as…
You may already know that when the mysqldump client utility performs logical backups, it produces a set of SQL statements that you can execute to reproduce the original database object definitions and table data. Although it dumps one or more MySQL databases for backup or transfer to another SQL server, there are 5 things that…