Database Patch News — December 2020 (Issue 5)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
SQL Server Always Encrypted—Is It Right for My Data?
New privacy regulations and other compliance and data governance mandates are driving more and more SQL Server users to leverage Always Encrypted. It can be a big help with separating those who own and can view the data from those who manage the data but should otherwise not access it.
Database Patch News — May 2020 (Issue 3)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Schemas, Databases and Instances—Defined and Discussed
What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB?These terms are very important when planning a database architecture, so let’s explore them.
Database Patch News — February 2020 (Issue 2)
Welcome to Database Patch News, Buda Consulting’s monthly newsletter of current patch information for Oracle and Microsoft SQL Server.
SQL Server Data Encryption Options
These days it’s only a matter of time before our firewalls or access controls are breached. Then what? In a multi-tiered security strategy, data encryption is a critical next line of defense.
Database Patch News — November 2019 (Issue 1)
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 month.
SQL Server Contained Databases and Oracle Multi-tenant: Advantages Compared
In short, the main goal of multitenancy is to facilitate database consolidation, while the main purpose of contained databases is to enable isolation and thus portability. Yet each approach addresses both these concerns.
Oracle Virtual Private Database (VPD) — Granting Just Enough Access
Robust Access Control At The Database Layer Many Companies struggle with the difficult problem of providing fine grained access control at the database layer to sensitive data . We will discuss Oracle’s Virtual Private Database feature which provides a robust way of handling this problem for all types of database users. Security vs Effectiveness Securing access […]
Time to Validate Your Database Backup
Another new client, Another bad backup I originally wrote this post in July but I am updating it today because it is so important. Yesterday we did an initial Oracle Database Health Check for another new client and found yet again that their backups are useless. This time the client was taking backups regularly, but […]
