Rob Garrison

Download files for part 14 of this series. This is part 14 of a series. If you have not read part 13, you can find it here, but this article does not require any knowledge of the previous work in the series. Translation: Using Views and “Instead of” Triggers When everything in your application is […]

Download files for part 13 of this series. This is part 13 of a series. If you have not read part 12, you can find it here. This article is a follow-up to part 12 and assumes that you have read that. Let’s use “PCC” as an acronym for persisted computed columns and “IPCC” for […]

Download files for part 12 of this series. This is part 12 of a series. If you have not read part 11, you can find it here. SQL Server 2005 adds the option of “persisting” a computed column. Prior to SQL Server 2005, you could create a computed column, but it would not be stored […]

This is part 11 of a series. If you have not read part 10, you can find it here. The end user (ID 1000) creates the Account record through the web application. A CSR (ID 99) locks the account using the back-office application. A CSR (ID 99) re-enables the account using the back-office application. A […]

This is part 10 of a series. If you have not read part 9, you can find it here. Download the code for this article. There are three main sections here: MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings. MAC Performance Results Part 9 […]

Download the files for this article. This is part 9 of a series. If you have not read part 8, you can find it here. The Problem: Searching Encrypted Data Once we have encrypted the data in our table, we cannot efficiently search that data without making further changes. Remember from part 7 that “EncryptByCert, […]

» See All Articles by Columnist Rob Garrison Discuss this article in the SqlCredit – Developing a Complete SQL Server OLTP Database Project Forum.

This is part 7 of a series. If you have not read part 6, you can find it here. Let’s Get This Out Right Away The task here is to determine the performance impact of EncryptByCert and DecryptByCert. In short, the cost is high. Microsoft acknowledges this in the Remarks section of Books Online’s coverage […]

This is part 6 of a series. If you have not read part 5, you can find it here. There are many good articles available that cover data encryption and data security in general. I will not try to explain why you need to encrypt sensitive data within your database. If you don’t already have […]

Download the code for this article. This is part 5 of a series. If you have not read part 4, you can find it here. I am writing this month from Redmond, where I am attending the SQL Server Katmai “System Design Review”. Considering that we’re fairly close to seeing the first publicly-available CTP for […]

This is part 4 of a series. If you have not read part 3, you can find it here. In this month’s installment, we will add security to the existing code and add new unit tests to prove that security. Database Security: It’s Not Just For Administrators Too many applications are built assuming that security […]

This is part 3 of a series. If you have not read part 2, you can find it here. In this month’s installment, we will discuss updates based on feedback from part 2 as well as introduce automated unit testing. Running Changes As stated in part 1, “This series will be about the process that […]