Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Learn how you can enable map your security roles in Aurora PostgreSQL to AD groups using Kerberos.
2026-08-26
1,285 reads
Learn how you can enable map your security roles in Aurora PostgreSQL to AD groups using Kerberos.
2026-08-26
1,285 reads
Taming Resource Hogs: Using SQL Server Resource Governor to Restrict User Group Consumption As a SQL Server professional, I've often encountered situations where a single, poorly written query or a resource-intensive application threatened to cripple the entire database server. Performance bottlenecks, unexpected slowdowns, and user complaints become the norm, making your life as a DBA […]
2025-07-24
2,049 reads
Unlocking Interoperability: A Guide to Foreign Data Wrappers in PostgreSQL and Aurora PostgreSQL AWS RDS As a database professional, I often encounter scenarios where data is fragmented across various systems. In today's distributed IT landscape, it's not uncommon for critical business information to reside in different databases, perhaps an on-premise PostgreSQL instance for legacy applications, […]
2025-07-21
171 reads
This article explores how to securely clone the master user permissions in Amazon RDS for SQL Server using a custom stored procedure, usp_rds_clone_login. It outlines a step-by-step process to generate, review, and apply a script that replicates server- and database-level access from the master user to a new login without directly exposing elevated credentials. The guide emphasizes the principle of least privilege, supports named account management, and enables transparent, auditable permission handling for DBAs and applications. Designed for secure and scalable environments, this solution enhances operational security while maintaining administrative flexibility in Amazon RDS.
2025-07-09
1,247 reads
Linked servers in Amazon RDS for SQL Server allow seamless connectivity to remote databases for distributed queries and data integration. In this article, I guide you through the step-by-step process of creating a linked server using SQL commands, from setting up authentication to testing the connection. Learn best practices, advanced configurations, and essential considerations, including why you can't use SSMS for linked server setup in RDS. This professional guide is tailored for experienced database administrators looking to optimize cross-server operations.
2025-01-29
1,988 reads
Learn how to get started with PostgreSQL using a container to practice database skills.
2024-11-08
2,142 reads
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
Wa:083849450961 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
Wa:083849450961 Jl. Mangga Raya No.20, RT.4/RW.3, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Comments posted to this topic are about the item Training the next generation
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers