Occasionally I get an inspiration on how to solve a problem with interesting SQL syntax or sound schema design.
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....
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.
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.