This question is about the correct way of accessing an Availability Group Listener? Assume I have two AlwaysOn Availability Groups with the following AG's: AG1 and AG2. I also have 2 listeners cal...

I encounter that SqlCommand.ExecuteScalar() returns NULL sometimes in production environment. I've crossed a lot of similar questions here, the most close one is: SqlCommand.ExecuteScalar returns ...

I have a database that was moved off of an old SQL Server 2008R2 instance and into a SQL Server 2012 AlwaysOn cluster. There are several fields within the database that are encrypted using SQL Serv...

I have a pair of SQL Server 2014 databases set up as a synchronous AlwaysOn availability group. Both servers are set to the Synchronous commit availability mode, with a session timeout of 50 secon...

I am writing some code for automatic deployment of Azure websites (including the creation of the website in Azure). I'm using the Azure Management Libraries and Azure Resource Management Libraries ...

I'm using SQL Server 2012 AlwaysOn listener and I want to use a connection with ApplicationIntent=ReadOnly parameter for calling some stored procedures, and this is my question: stored procedures w...

I'm trying to make a Delphi application to work with AlwaysOn solution. I found on Google that I have to use MultiSubnetFailover=True in the connection string. Application is compiled in Delphi XE...

How to show a slider control with a tooltip/label under the thumb showing the value (timespan) always while it moves with/without user dragging. I tried AutoToolTipPlacement="BottomRight" AutoTool...

I'm trying to read data from synchronous secondary replica just after writing data to primary replica. But my data is not present on secondary. There is a latency about 100-500ms before data appe...