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 think about hosting our databases. But relational databases are still relied upon […]

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.

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.

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.

Skip to content