Question : I have an Excel VBA application that connects to a SQL Server 2008 R2 database through ADODB. When […]
Tag: network
Cluster IP’s under Access Point for Administering the Cluster
Question : When adding the cluster IPs under Access Point for Administering the Cluster, do we only include IPs for […]
Does Oracle run queries to completion after SQLdeveloper disconnects?
Question : The query is a CREATE TABLE t as SELECT …..; statement. Can I reliably count on Oracle to […]
Multi-Subnet AlwaysOn: Is Routing and Remote Access always required?
Question : Context I’m setting up a 2-node AlwaysOn Availability Group (SQL Server 2017 Enterprise) with the following setup: Existing […]
Analysing SQL Server Network I/O
Question : A frequent request I get from clients is to help figure out what queries or clients are making […]
Disconnect from network without stopping the query
Question : I have an opposite problem to Does disconnecting the network stop a query?. I would like to launch […]
One instance, four clients, one is slow
Question : We have a small office setup with one Windows Server 2012 running SQL Server 2016 Express. The database […]
PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?
Question : On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. […]
MySQL Cluster over WAN: Best Architecture Options?
Question : My company is looking at a multi-data-centre solution for high-availability, fun, and profit. We have businesses across the […]
PostgreSQL: Save roundtrips / Network performance
Question : For my work I often have to to large selects loading a lot of data. The connection happens […]