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

Tag: client

Stream every row coming from a Postgres function

By adminPosted on January 29, 2023

Question : This is the how the function definition looks: CREATE OR REPLACE FUNCTION my_function(foo NUMERIC) RETURNS SETOF my_type AS […]

How to identify a client application whose host_process_id points to sqlserver.exe

By adminPosted on October 9, 2022

Question : I am in the process of trying to identify a client application which uses one of the SQL […]

Using letsencrypt with postgresql [closed]

By adminPosted on September 2, 2022

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

What happens when the same application from different server tries to connect to the always on primary server

By adminPosted on August 17, 2022

Question : In our environment we have an always on availability group and the reporting server is acting as a […]

can mysql cli exit with error if no records returned?

By adminPosted on August 3, 2022

Question : I would like to execute a sql command in bash, and do something based on whether or not […]

Oracle connection from Squirrel SQL

By adminPosted on July 30, 2022

Question : I am trying to set up Squirrel SQL for the first time on my Ubuntu Desktop. Here is […]

Postgres Client – save table sorting

By adminPosted on July 6, 2022

Question : Is there a Postgres client (for Windows) that can save customized sorting when viewing tables? Obviously I could […]

psql coloured prompt misbehaving

By adminPosted on June 28, 2022

Question : In theory, there is a possibility to use coloured prompts in psql. I decided (not the first time […]

Where can I find Oracle Admin client download link for version 11.2.0.3

By adminPosted on June 25, 2022

Question : I was trying to download oracle admin client for 11.2.0.3 ,however only 11.2.0.1 version is available. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html Any […]

Where I can find the tnsnames.ora file for my Oracle Windows client? [duplicate]

By adminPosted on May 26, 2022

Question : This question already has answers here: How do I generate a tnsnames.ora file to connect to an Oracle […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • How to pass a parameter into a subquery in a join statement [closed]
  • Replicate a database with a subset of data offered by custom queries [closed]
  • Are there any benefits in certain ordering of columns when defining indexes
  • Logins aren’t syncing across Availability Groups
  • Finding same values and updating rankings
  • Servers running on Microsoft Windows instead output carriage
  • Master ip has changed in postgresql replication
  • optimize design for a table with 50 columns [closed]
  • SQLServer In-Memory database and log file size unexpected increase
  • Is it worth to optimize queries with EarlyTermination Timeout?
  • Is there way to get transaction commit timestamp in Postgres?
  • MySQL/PHP Returning Blank Error Message [closed]
  • Mysql might have too many indexes
  • Database replication with ability to revert to previous states
  • Linked server to Oracle doesn’t use filters. Are there any performance changes in different versions of SQL Server?
  • Enable query store for all databases
  • SQL Server 2012 Enforce Password Policy [closed]
  • Maintenance in MYSQL when innodb_file_per_table disabled
  • SQL Server stored procedure producing data related to months between two dates [duplicate]
  • Efficient way to store multi choice in a column with few options

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