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.
ANY and ALL: Comparing a Value to a Whole Subquery in T-SQL
One missing price is enough to make ALL return nothing while ANY returns rows. Here is how to see it, and how to ask the question more safely.
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.