2
votes
2answers
252 views

Do I need to back up the SQL Server Encryption Password and Symmetric Key?

I'm trying to setup SQL Server to use Cell-Level Encryption on some sensitive data. It seems straightforward per this example on the MSDN: Create the Master Key with a strong password. Create a ...
0
votes
2answers
94 views

Leftmost column of Multi-column index not functioning as single column index

I was under the impression that an index like CREATE NONCLUSTERED INDEX IX_Name_Age ON People ( Name ASC, Age ASC ) would be used not only for a query like Select * From People WHERE Name = ...