Database Blog
SQL Server Health Check Checklist
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...
Our Cloud Migration Roadmap: Set Yourself Up for Success
67% of businesses have migrated their workloads to the cloud in 2020 alone. Are you considering following this trend? If so, you’ll need a stellar cloud migration strategy. Otherwise, your services will have poor performance, which your customers will also...
A Step-By-Step Guide to Upgrading Oracle 11g to 12c
Is your company's IT infrastructure an out-of-date eyesore? The 11g support clock has been ticking since 2013, when Oracle released the major version upgrade for 12c. Like in any software cycle, Oracle has been phasing out support for version 11g. If you are still...
Database Patch News — November 2021
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...
What Is CUI Data? | An Expert’s Explanation
Did you know there are 125 categories of controlled unclassified information (CUI)? With so much data that is now under the umbrella of CUI, ensuring your business recognizes which data to protect is essential. But what exactly is CUI data? Read on to learn about this...
The Ultimate Oracle Database Security Assessment Checklist for 2021
They are two simple words, but they are two of the most feared words in business: Data Breach! Your data is your business. When companies lose their data, they lose trust and the ability to conduct much of their business. The problem is many companies spend their time...
6 Types Of Cloud Migration Services
We are right in the middle of a huge focus in the business world on cloud migration. In fact, in 2020, cloud migration was the number one top modernization project. More than half of business leaders were working on or planning...
Seven Reasons To Employ Database Tuning Services
If your business has invested in a database, chances are that it's a valuable asset that's integral to the smooth and effective performance of your operation. Unfortunately, without regular maintenance and attention, a database can begin to deliver sub-optimal...
Database Patch News — July 2021
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...
MySQL and MariaDB Encryption Choices for Today’s Use Cases
Long a cornerstone of data security, encryption is becoming more important than ever as organizations come to grips with major trends like teleworking, privacy mandates and Zero Trust architectures. To comprehensively protect data from the widest possible range of...
Thoughts On Deleting Data – Considerations & Best Practices
In a recent blog post on database maintenance tips, I mentioned that one important facet of cleaning up the database is to remove records that we no longer need -- those that don’t contribute value to the applications and users who use the database. This is an...
Roles vs Direct Database Privileges
A colleague asked me today for my opinion on database security and the best way to grant a certain database privileges to a few users in a postgreSQL database. I will share my thoughts here and I welcome your thoughts as well. These basic database security concepts...
When Should The Database Be Updated?
Why if it's not broke don't fix it does not work for databases (or anywhere in IT for that matter) One of the hotly debated items among IT professionals is the age-old question,”When should the database be updated?” At Buda Consulting we always like to make sure our...
SQL Server Vulnerability Assessment – Keep Your SQL Database Safe With This Microsoft Tool
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, here...
The Elements Of A Good Disaster Recovery Plan
What is a Disaster Recovery Plan The elements of a disaster recovery plan (also called a Business Continuity Plan) is a document that describes how an organization will survive a disaster. These can be natural disasters like hurricanes, fires, terrorist attacks, or...
Database Maintenance Tips: Weeding the Database
This time of year I spend a lot of time in the garden. Early mornings are peaceful and quiet, and the perfect time to reflect on the garden and clean it up. This is a discipline that I also apply to the databases that I manage. I will describe the process that I...
7 Ways To Improve SQL Query Performance
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...
Beyond “Fast and Simple”: Top 5 Use Cases for NoSQL Database Technology
Since I first blogged about NoSQL back in 2013, the use of “Not Only SQL” databases for mission-critical applications has proliferated across businesses of all sizes and sectors. With trends like big data analytics, cloud, mobile and IoT driving the modern digital...
Database Patch News — March 2021 (Issue 7)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Relational Database Design: It’s All About The Set
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...