Skip to content
Performance Tuning And Infra Automation

I love performance tuning and building automation

  • Home
  • About Me
  • All Articles
  • Contact Me
  • Home
  • Pretty Links
  • Privacy Policy
  • SQL Resources
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe

Logins

  • Home
  • Logins
How to Verify Given Access/Permissions to User/Login
Posted inDatabase Administration

How to Verify Given Access/Permissions to User/Login

Hi Friends, I have seen DBAs to wait for user's confirmation for long after providing access/permissions. This is not required since we have very easy way to verify user permissions.…
Posted by Ajay Dwivedi November 8, 2017
A Curious Case of Orphan User
Posted inDatabase Administration

A Curious Case of Orphan User

Hi Friends, Today at work I received an access request to provide multiple database permissions to multiple AD groups on servers. After providing appropriate db roles membership to requested AD…
Posted by Ajay Dwivedi November 30, 2016
How do I verify if my login if set to Non-Expiry [SQL Server]?
Posted inTSQL

How do I verify if my login if set to Non-Expiry [SQL Server]?

Today I was working on multiple access/permission requests of same user on multiple servers. Due to previous poor experience using sql authenticated login set to expiry by DBA, he kept…
Posted by Ajay Dwivedi November 28, 2016
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 100 other subscribers
See what other community members think about SQLMonitor.
Recent Posts
  • Get StackOverflow2013 Database for PostgreSQL & SQLServer
  • Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
  • LogRotate Policy For PostgreSQL
  • Run Ansible Playbooks with Github Action
  • SQLServer Gradually Becomes Slow Until Reboot
Facebook With Ajay Dwivedi
Facebook With Ajay Dwivedi

CATEGORIES

  • Ansible 1
  • Baseline-SQL-Server 22
  • Database Administration 11
  • DevOps 1
  • Errors 15
  • Execution Plan 8
  • Growth & Development 2
  • Health Check 8
  • Internals 3
  • Linux 4
  • Performance Tuning 35
  • PostgreSQL 3
  • Powershell 8
  • SQL Alerts 5
  • SQLMonitor 17
  • TSQL 41
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloghash WordPress Theme
Scroll to Top