Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: network

Using SQL Server on separate networks

By adminPosted on September 15, 2023

Question : I have a bunch of SQL Servers installed on Windows2008R2. Currently, each windows server has two NIC’s, each […]

How fast can I pull data through a SQL Server client connection?

By adminPosted on September 11, 2023

Question : What is the highest throughput possible? Has anyone seen anything above 25MB/sec? I’ve been trying to figure out […]

Why changing the order of network protocols does not make any sense?

By adminPosted on August 28, 2023

Question : All I want to do is to connect to SQL Server though Named Pipes without using an explicit […]

How Should TCP/IP be configured to allow an external application access to SQL via the same port #?

By adminPosted on August 20, 2023

Question : My SQL Server instance is hosted on an internal network server (10.x.x.x address). It’s a named instance currently […]

Does SQL Server handle databases on SMB shares different than on Hard Drives?

By adminPosted on July 18, 2023

Question : Does it, for example, automatically recover from network hiccups, perhaps? If so, would masking the file share under […]

IP Addresses tab is not showing a specific IP Address

By adminPosted on July 8, 2023

Question : I have SQL SERVER 2008 R2 installed on windows Server 2016, it runs smoothly on a LAN network […]

Web server accessing the database server in Always on availability group

By adminPosted on July 3, 2023

Question : We have a web server that is on the DMZ but that will need to query a database […]

MySQL (MariaDB) bound to 0.0.0.0, but doesn’t appear to be listening to all IPs?

By adminPosted on July 2, 2023

Question : My MySQL (actually MariaDB) server accepts connections at port 43210 without problems on the public IP address of, […]

How to backup MS SQL Server databases off-site?

By adminPosted on June 19, 2023

Question : Microsoft SQL Server supports backing up to remote network locations only by means of UNC names the SQL […]

Dynamic Ports are being set to different ports

By adminPosted on June 13, 2023

Question : On one of our instances of SQL Server (12.0.5571.0 if you really need to know) we use multiple […]

  • 1
  • 2
  • 3
  • …
  • 11

Recent Posts

  • Row level restore with Oracle Recovery Manager (RMAN)
  • Macroeconomic Time-Series Database
  • OUTER JOIN with join condition causes unexpected results
  • Need help with my.cnf: 32GB RAM and 3GB of InnoDB tables
  • How to model an activity feed
  • trigram matching on a jsonb array
  • Trigger to prevent update when Flag value is 1
  • SQL, SQLCLR objects & effective memory utilization
  • Queries on Mongo Secondary are not equally distributed
  • Timezone offset displayed though it shouldn’t be stored
  • Use composite type to create new table
  • what is ‘#’ in create table statement?
  • how to avoid duplicated column in two different tables?
  • RMAN – Archivelog deletion policy ignored
  • Query runs quicker when column calculation is done after initial query
  • Generating Error when data size is larger then max text repl size
  • mysql: Is mysqladmin -p create equivalent to create database?
  • Recovering from removal of ibdata1 [duplicate]
  • Reviewing all code on a SQL Server Instance
  • Select query on 8 million records with greater and less than columns (Slow)

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding