Search Results: AlwaysOn

• 
  AlwaysOn: Configuring Secondary Read-Only Access

  Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary replicas. The first step is to set the connection access for the primary and secondary role, if you haven’t alr

  Author:  PatrickLeBlanc     Date: 2/8/2012     Section: Blog

  tags : AlwaysOn, High Avilability
• 
  Speaking for Baton Rouge UGs and SQL Lunch Next Week

  I have been quiet over the past year trying to get acclimated to my new job and my new found work life balance. Now that I have figured it all out I am slowly beginning to present on a regular basis. Next Wednesday (2/8/2012) I have the opportunity to giv

  Author:  PatrickLeBlanc     Date: 2/2/2012     Section: Blog

  tags : Baton Rouge SQL Server User Group, Speaking, SQL Lunch
• 
  What is the difference between Database Mirroring and AlwaysOn Availability Groups?

  Last year SQL Server 2012 launched with a new choice for high availability and disaster recovery (HADR) called AlwaysOn Availability Groups. The AlwaysOn Availability Groups feature is similar to Database Mirroring which will be removed from SQL Server in

  Author:  KathiKellenberger     Date: 2/15/2013     Section: Blog
• 
  Questions from My AlwaysOn Availabilty Group Presentation

  I gave a Training on the Ts Webinar today on AlwaysOn Availability Groups (AG) today. The recording should show up in a couple of days. My session was focused on showing how AG compares to SQL Server Failover Clustering and Database Mirroring as well as a

  Author:  KathiKellenberger     Date: 3/19/2013     Section: Blog
• 
  AlwaysOn Availability Groups: Read-only Routing

  When you set up AlwaysOn Availability Groups (AG) you have the choice for each node, when in secondary mode, to be readable. In fact, you can specify that connections will be accepted by the secondary node only with a special connection string specifying

  Author:  KathiKellenberger     Date: 3/29/2013     Section: Blog
• 
  What is the AlwaysOn Listener?

  With AlwaysOn Availability Groups (AG), you can fail a group of databases over to another node. You may be wondering how to configure your application so that it always connects to the primary replica of the database – the replica that allows writes

  Author:  KathiKellenberger     Date: 2/22/2013     Section: Blog
• 
  DTS to SSIS Migration Project

  With much fanfare, SQL Server 2012 launched earlier this year. With all the excitement about the new features, such as AlwaysOn Availability Groups, lots of new T-SQL functions, and ColumnStore Index, there are also features that go away. With each releas

  Author:  KathiK     Date: 6/22/2012     Section: Blog
• 
  Creating a practice SQL Server Cluster in virtual machines always has surprises

  Over the past few evenings, I have set up a virtual machine SQL Server cluster from scratch for my clustering pre-con in Nashville next week, meaning that I started with one Windows 2008 R2 Enterprise Edition virtual hard drive (VHD) and built everything

  Author:  KathiKellenberger     Date: 10/5/2012     Section: Blog
• 
  Speaking at the SQL Lunch UK

  Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change. Unlike the SQL Lunch that I host online here in the U.S., the SQL Lunch UK , which is hosted by Dave Bally (@davebally), will be held at a physical location. Well exce

  Author:  PatrickLeBlanc     Date: 2/24/2012     Section: Blog

  tags : AlwaysOn, Speaking, SQL Lunch, SQL Lunch UK