by Robert Buda | May 14, 2021 | MySQL, NoSQL, PostgreSQL, SQL Server
How do you improve SQL query performance? That is a big question, and one that we get asked all the time. There is no one answer, but there is a process that we apply to make a difference in query performance. In this post, I will discuss some of the questions we ask,...
by Robert Buda | Mar 18, 2021 | Best Practices, Database, MySQL, SQL Server
The Lost Science Of Relational Algebra And Set Theory I originally wrote this post in 2011. Much has changed in the database technology landscape since then. Big Data Technologies such as Hadoop have gone mainstream, cloud technology and is changing how and where we...
by Robert Buda | Dec 10, 2019 | Database Security, MariaDB, MySQL, Uncategorized
MySQL and MariaDB Encryption Options Encryption remains one of the most widely used cornerstones of data security across organizations of all sizes and industries. Why? In many cases it’s both effective and relatively simple to implement. There are two fundamental...
by Robert Buda | Oct 29, 2019 | Best Practices, Database Patch News, database patching, Database Security, MySQL, Oracle, Oracle DBA, SQL Server, Uncategorized
Welcome to Database Patch News, Buda Consulting’s monthly newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information on available patches—including security patches—and desupported versions made available during the past...
by Robert Buda | Jul 12, 2014 | MySQL, NoSQL, Oracle DBA
Oracle Corp. is currently the world’s second-largest software vendor—and it isn’t going to let a little thing like unstructured data stand in its way. With the recent release of its MySQL Fabric technology, which is meant to meet the demands of cloud- and web-based...
by Robert Buda | Jul 5, 2013 | Best Practices, Database, MySQL
MySQL is a very popular database for many applications. But the parser has some important deficiencies that developers need to be aware of. The parser is inconsistent and not robust in the way that it enforces statement syntax. This may lead to ambiguity and...
