Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in SQLServerCentral Syndication

This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”.  My favorite DR solution is mirroring.  Mirroring is easy to setup and fast, if implemented properly.  It’s a database level solution that allows you to keep a remote copy of your database in sync with your principal database.  Everything is [...]

How to create a DSN on Windows 64bit for your 32bit application

How to set SQL Mirroring TIMEOUT and 2 scenarios where you want to.

Here is how to automate copying your SQL logins to your DR server.

No safe option in Windows 7 to run as an alternate user.

“Run As” was removed from Windows Vista! SysInternals has a fix.

“Run As” is not as secure in Windows XP as we thought