Four Myths about SQL Server’s CLR Engine

1. There is an inherent overhead in calling CLR functions Not so. Try creating a T-SQL function and a CLR function that both do absolutely nothing other than return the value 0. When called in a loop, you will find that the CLR function executes substantially faster than the T-SQL one. The exception to this is…

Cryptography in SQL Server

What started as another blog post turned into an official SQL Server White Paper. If you are interested, you can find it here.

SQL Server Checklist

Every once in a while, a process gets too complex for humans to manage consistently. For example, when Boeing’s B-17 (the “flying fortress”) was first being evaluated, it crashed during initial tests due to pilot error. The consensus became that it “was too much airplane to fly.” Fortunately (for Boeing), someone came up with the…