by Robert Buda | Jun 20, 2022 | SQL Server
As SQL server became a world-class database system over the past two decades, setting a trap for many organizations. Twenty years ago, mission-critical applications were generally only served by enterprise-level database systems (think Oracle and DB2) . SQL Server...
by Buda Consulting | Jan 4, 2022 | SQL Server
SQL injection attacks represent over 65.1 percent of all website application attacks. To prevent your server from becoming a part of that statistic, you’ll need to take action. That way, you can mitigate damages and possibly prevent them. Moreover, you’ll want to...
by Robert Buda | Jun 28, 2021 | Database Security, SQL Server
By now you all know how hackers are having their way with business all over the world. I don’t need to give examples to remind you of that. Some are mentioned here and here and I’ve written a number of blogs about the importance of protecting the database here,...
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 Willie Gray | Mar 18, 2021 | Best Practices, Database Patch News, database patching, Database Security, Oracle, SQL Server
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server. Here you’ll find information recently made available on patches—including security patches—and desupported versions. Why should you care...
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...