![]() These environments are separated so that new development and troubleshooting can occur without having a negative effect on the performance and integrity of the production database.Īny proposed modifications to a production database should be first implemented and tested on a development or test database. ![]() The version of the database that is used to develop and test new functionality is referred to as the development database. The database that is utilized for daily business transactions is referred to as the production database. Development Environment Considerationsīefore we proceed with an exploration of obfuscation methods, let’s spend a few moments reviewing a strong candidate for the implementation of the obfuscation methods presented in this article: the development environment. While these methods of obfuscation will not be used by any federal government to protect nuclear missile launch codes, they can be highly effective when printing documents that contain sensitive data, transferring production data to test environments or presenting data through reporting and warehousing mechanisms. We will explore a handful of obfuscation techniques, which do not require an algorithm, encryption key, decryption key or transformation of data types.Įach of these methods, including character scrambling and masking, numeric variance and nulling, rely on an array of built-in SQL Server system functions that are used for string manipulation. By doing so, we mask the underlying data values, hiding their true nature, until the appropriate time to disclose it. These costumes are designed to hide the identity of their wearer and grant that person the freedom to shed their everyday demeanor and temporarily adopt the persona of their disguise.Īpplying the technique of obfuscation to our sensitive data is somewhat akin to donning a Halloween disguise. On this holiday, the young and young at heart apply make-up, masks, costumes and outfits and wander the streets in search of sweet treats from their neighbors. Halloween is one of my favorite times of the year.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |