Backup and restore or detach and attach are not the only ways. This SQL in Sixty Seconds #067 video shows how to copy the database with the built-in copy feature.
SQL SERVER – Reset SA Password – SQL in Sixty Seconds #066
Forgot the SA password or your DBA just left? This SQL in Sixty Seconds video shows how to reset SA password by logging in with Windows Authentication.
SQL SERVER – Puzzle #1 – Querying Pattern Ranges and Wild Cards
Readers often ask about querying pattern ranges. Wild cards are the usual answer, but not everyone uses them well. Solve my puzzle for a chance to win a book.
SQL SERVER – XML Data Type- SQL Queries 2012 Joes 2 Pros Volume 5 – XML Querying Techniques for SQL Server 2012
An abstract on the XML data type from SQL Queries 2012 Joes 2 Pros Volume 5, the book on shredding XML, XQuery, XPATH, namespaces and XML indexes.
SQL SERVER – Executing Dynamic SQL – SQL Queries 2012 Joes 2 Pros Volume 4 – Query Programming Objects for SQL Server 2012
An abstract on executing dynamic SQL from SQL Queries 2012 Joes 2 Pros Volume 4, the book on triggers, views, functions, error handling and cursors.
SQL SERVER – Introduction to GUIDs – SQL Queries 2012 Joes 2 Pros Volume 3 – Advanced Query Tools and Techniques for SQL Server 2012
An introduction to GUIDs from SQL Queries 2012 Joes 2 Pros Volume 3, the book on data storage, indexes, GUIDs, locks and isolation levels.
SQL SERVER – Identity Fields Review – The SQL Query Techniques Tutorial for SQL Server 2012
Identity Fields Review is a chapter abstract from the Joes 2 Pros SQL Query Techniques Tutorial for SQL Server 2012, a book first tested in my classroom.