CREATE Snapshot: Note that NAME=AdventureWorks2008R2_Data is the logical name of the source’s datafile Revert to Snapshot: Reverting will fail if other users are connected. Here’s how to put the database in single user mode: ALTER DATABASE YourDB<br />SET SINGLE_USER WITH<br />ROLLBACK IMMEDIATE (If you want to give open transactions time to finish, you can set ROLLBACK AFTER 60) Make sure to drop any other snapshots first Drop Snapshot:

I always forget the syntax for doing an update from a select: <p> <!--CRLF--> </p> <pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; background-color: #f4f4f4; margin: 0em; border-left-style: none; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; border-right-style: none; font-size: 8pt; overflow: visible; padding-top: 0px"> <span style="color: #0000ff">Table</span></pre> <p> <!--CRLF--> </p> <pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; background-color: white; margin: 0em; border-left-style: none; padding-left: 0px; width: 100%; padding-right: 0px; font-family: &#39;Courier New&#39;, courier, monospace; direction: ltr; border-top-style: none; color: black; border-right-style: none; font-size: 8pt; overflow: visible; padding-top: 0px"><span style="color: #0000ff">SET</span></pre> <p> <!

I always forget the syntax for doing an update from a select:

From Steve Smith’s article: 3 Tips to Improve Your Connection Strings Use Windows Authentication (if you can) Use a Fully Qualified Domain Name for your Database Server Name Include Your Application’s Name in its Connection String (App parameter)

Checklists / Guides WCAG 2.0 Checklist Section 508 Checklist Penn State’s Accessibility and Usability Guide Side by Side WCAG vs 508 Tools: Web Accessibility Evaluation Tool Web Accessibility Evaluation Toolbar for Firefox Functional Accessibility Evaluator

I can never seem to remember where the log viewer is and spend 15 minutes trying to find it every time. Not anymore: C:Program Files (x86)Microsoft SDKsWindowsv7.0ABinFuslogvw.exe Seriously…