Tag: Access
-
DBA Scripts: Get Orphaned Users
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Security The Login Exists, the Database Still Says No An account that worked last week stops working against one database. The password is right, the login is there in Object Explorer, the user is still in the database with its roles intact, and…
Written by
-
DBA Scripts: Get Login Security Audit
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Security What’s Actually Happening at the Login Level, Not Just Who’s Allowed Permissions and Role Membership covers who can do what. These three scripts cover something different: what’s actually happening at the login layer right now. Get-FailedLoginSummary surfaces brute-force patterns and locked accounts…
Written by
-
DBA Scripts: Get Permissions and Role Membership
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Security Who Can Actually Do What, at Every Level Sysadmin Members answers the single highest-stakes question: who has unrestricted access. These 4 scripts answer everything underneath that: explicit object and schema grants inside a database, explicit server-level grants and denies on logins, database…
Written by
-
DBA Scripts: Get User Permissions Audit
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Security The One Login You Actually Care About Right Now Off-boarding someone, or asked why one login can read a database it should not? Set @LoginName and run this. It returns one row for the server and one for every database the login…
Written by
- How to Back Up a SQL Server Certificate and Its Private Key
- How to Back Up a Database in SQL Server
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- Backups & Recovery (18)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (24)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (236)