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...
2012-02-10 (first published: 2012-02-08)
10,040 reads
SQLDownSouth
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...
2012-02-08
1,078 reads
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...
2012-02-03 (first published: 2012-02-02)
1,399 reads
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...
2012-02-02
386 reads
PowerView: Coordinating Chart Colors
During a recent customer engagement I was asked if it was possible to ensure that the colors in a Line...
2012-01-10
1,597 reads
Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
985 reads
Free Business Intelligence Workshop
If you are in and around Dallas next week drop by my FREE half-day Business Intelligence workshop. The details are...
2011-11-01
1,666 reads
SSIS 2012: Project Reference
One of the less advertised enhancements of SSIS in SQL Server 2012 is the Project Reference type available when using...
2011-10-24
3,240 reads
SQL Server 2012 SSIS – Why is my toolbox empty?
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed...
2011-10-13
32,463 reads
SSRS 2008 R2: Implementing Row-level Security
When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there...
2011-10-13
9,782 reads
Blogs
9 questions to ask before adding generative AI to your data project
Will adding generative AI to your data project improve the outcomes? It might, but...
Accelerating Database Modernization Through DevOps & Cloud Integration
By Chris Yates
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure...
Speaking at the PASS Data Community Summit
By Steve Jones
I’m honored to be speaking at the PASS Data Community Summit in Seattle this...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Migrate from Linux to Windows with Availability Groups
Comments posted to this topic are about the item Migrate from Linux to Windows...
We Gave Memory-Optimized Tables a Hash Lookup — Then Tried Pattern Matching Instead
Comments posted to this topic are about the item We Gave Memory-Optimized Tables a...
Question of the Day
Always On AG Latency for Read-Only Workload After Failover?
You're responsible for managing a SQL Server environment using Always On Availability Groups across two data centers. During a recent planned failover to the secondary replica, you noticed increased application latency and errors related to read-only routing. Upon investigation, you discover that read-only routing continues pointing to the former primary, now a secondary, for a period of time after the failover.
Which of the following best explains this behavior and how to resolve it?