Geeks With Blogs

News All source code published on this blog is placed in the public domain.
Chris Falter .NET Design and Best Practices Database Considerations Occasionally I get an inspiration on how to solve a problem with interesting SQL syntax or sound schema design.
How To Search Encrypted Text in SQL Server 2005/2008

We all know how to perform data lookups based on last name, zip code, and so forth. But what if you need to do a lookup based on encrypted data? This could be an extremely expensive operation, if you have to decrypt the data in every record. But if you use secure hash codes, you can perform the lookup very inexpensively.

Posted On Monday, October 6, 2008 12:14 AM

.NET Entity Framework: Is It Ready for Web Prime-Time?

The .NET Entity Framework is Microsoft's new tool for object/relational mapping (ORM). While MS does have big plans for it, it does have some important limitations....

Posted On Tuesday, May 27, 2008 9:50 AM

How To: Encrypt and Manage Documents with SQL Server 2005

This post describes when you should use SQL Server encryption, which type of encryption key to use, and how to create the infrastructure for managing documents whose size exceeds the maximum encryption block size of 8000 bytes. It also summarizes network and operations steps you need to take to make sure your entire infrastructure is reasonably secure.

Posted On Thursday, May 8, 2008 4:13 PM

A T-SQL Stumper

I recently encountered a real head-scratcher when trying to perform a SQL query against a service performance log. If you enjoy this kind of challenge, or if you just want to learn a new SQL query strategy, read on.

Posted On Saturday, December 15, 2007 5:20 PM

Copyright © Chris Falter | Powered by: GeeksWithBlogs.net