The first thing that came to mind was the WITH ENCRYPTION
clause that you can use when creating a stored procedure. That particular encryption algorithm is
more than weak, and as far as I know it??™s homegrown. My imagination quickly constructed images of
encryption algorithms being created by means of a secret decoder ring that was obtained by collecting
20 UPC symbols off of some sugary breakfast cereal. My fears turned out to be nothing but paranoia.
SQL Server 2005 uses industry-standard algorithms for encryption. These same algorithms are
applied to both encrypting communication between servers and encrypting data stored within a table.
Some of the standard algorithms currently supported are Data Encryption Standard (DES), Triple DES,
RC2, RC4, and 128-bit to 256-bit Advanced Encryption Standard (AES) as well as X509(1) certificates
(up to 2,048-bit encryption). However, just because these algorithms are industry-standard doesn??™t
mean they??™re unbreakable. With enough computing resources and enough time, a hacker can break
nearly any encryption scheme.
CHAPTER 8 n DATABASE MIRRORING 202
Communication
While database mirroring revolves around duplicating database transactions from one
database to another, it does so differently than log shipping.
Pages:
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388