In simple terms, SQL Server middleware—such as OLE DB or .NET providers
and ODBC and Java Database Connectivity (JDBC) database access drivers—provides
a connection between an application and a database.The SQL Server middleware
processes application requests and presents them to a back-end database in a
language, structure, or syntax that conforms to the requirements of the database
server, then returns the data to the application.
When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More