I was fortunate enough to get to present not 1 but 2 sessions at SQLRally 2012 in Dallas last week. As a core organizer of the event, this really made it a special week to present twice and see it all come together. My first session was a community choice pick. The second session I got [...]
Ryan Adams Blog
SQL, Active Directory, ScriptingSQLCruise Technical Lead
PASS Outstanding Volunteer
Browsing Posts in Mirroring
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on Mirroring. If you have not checked out the virtual chapters that PASS has, then you need to Go Check Them Out. These chapters are designed to fill the gap for areas of the country that [...]
I will be presenting two sessions at Dallas TechFest! I am honored and excited to be speaking. Dallas TechFest is a premiere technology conference that includes many technology areas like .Net, Java, Windows Phone, and of course SQL Server. This year the conference has grown and expanded from one day to two days, and is [...]
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 [...]
SQLSaturday #57 Recap
How to set SQL Mirroring TIMEOUT and 2 scenarios where you want to.
Mirroring: The Bear Necessities slide deck and sample code
Ryan Adams will be doing two presentations on SQL Mirroring this week.
If you have more than 4gig of RAM, consider enabling PAE and AWE.
You cannot mirror a database to two seperate servers, but there is an alternative.
