A database backup does not carry the key that opens your encrypted data. Export both keys, restore one from its file, and see why the password matters.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Table-Valued Store Procedure Parameters – Day 25 of 35
SQL Server 2008 table-valued parameters let you pass a whole table into one stored procedure parameter instead of calling it 1000 times.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Easy Introduction to CHECK Options – Day 24 of 35
An easy introduction to CHECK Options on views: why an update through a view can make rows drop out of it, and how CHECK OPTION stops that.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Views – Day 23 of 35
An introduction to views from Joes 2 Pros: the rules a query must follow before it can become a view, like giving every expression column a name.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Constraints – Day 22 of 35
All about SQL constraints, starting with check constraints: how to keep a column to sensible values, like no negative height on a medical form.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – All about SQL Statistics – Day 21 of 35
All about SQL statistics, starting with a real life example: just as we plan for winter from past seasons, SQL Server uses statistics to plan ahead.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Introduction to Page Split – Day 20 of 35
An easy introduction to page split: what happens when a new record belongs on a data page that is already full, following the clustered index order.