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

Tag: logins

InnoDB MySQL account usage history

By adminPosted on September 26, 2023

Question : I would like to view the account usage history. I know it can be viewed via my.cnf through […]

SQL Server – Windows Group Authentication

By adminPosted on September 24, 2023

Question : I am trying to understand how to create Windows Group based access to a SQL Server (2012) database […]

Application unable to connect after doing a failover ,Mirroring

By adminPosted on September 20, 2023

Question : After doing a failover to mirror database, the application is throwing below error Login failed for user ‘NT […]

How can I map a login to a database using T-SQL (not SSMS)

By adminPosted on September 17, 2023

Question : I’m writing a program that requires me to assign all permissions and everything in code. I have gotten […]

How to find unused logins in SQL Server?

By adminPosted on September 13, 2023

Question : I have a couple of databases on my server, each with its own users. Now I need to […]

Handling user logins while using a multiple schema design to support multi-tenancy

By adminPosted on September 9, 2023

Question : I’m creating a web application (in PHP and PostreSQL) that will be used by organisations and their staff […]

SQL Server – How does contained database user password expiration work?

By adminPosted on August 19, 2023

Question : I’ve recently started working with contained databases and I do not understand if/how contained database users have passwords […]

Should I delete disabled windows Active Directory accounts from SQL 2008?

By adminPosted on August 18, 2023

Question : Is there a risk of not deleting unused Windows logins that have been disabled in AD or is […]

Proper way to create logins on Always on

By adminPosted on August 13, 2023

Question : What is the proper way to create logins on Always on? An application database requires an active directory […]

Oracle – Can’t login with “/ as sysdba”, but can with “sys as sysdba”

By adminPosted on August 8, 2023

Question : I’ve been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container […]

  • 1
  • 2
  • 3
  • …
  • 24

Recent Posts

  • Postgres backup PITR strategies [closed]
  • Installing SQL Server 2014 Enterprise in Windows 7 Ultimate 64 Bit Incompatibility Error
  • CPU Time Slower in SQL Server 2014 than in SQL Server 2008 R2 [closed]
  • Postgres doesn’t use expression index for group by
  • Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
  • Creating Indexes to optimize query
  • Does joining to the same table twice have a predictable performance impact
  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency
  • Many-To-Many relationship between Students and heights (Is it necessary?)
  • What is the ideal composite index for this query?

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