PowerShell/dbatools Tip – Clone a login / database user

One of the more frequent requests that a SQL Server DBA receives is to "Clone a login" with all its permissions. For example a request could be Clone BILL_BLACK's login and create a new login JACK_JOHNSON with exactly the same privileges in all databases. Clone AD group login BILLING_APP_ADMINS and create a login for new …

Advertisement

SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

A great and related reference to what we will discuss in this blog post is this one: https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although …

Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?

  The v$session view If you do not know already, to check who is connected and since when, what their connection status is etc., you would use dynamic view v$session. The view has the following columns: You would kill the required session by issuing Note: The IMMEDIATE option of the above command just returns control …

Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics

Most of us use data dictionary views on an everyday basis to find things like: In which schema does a table with a certain name exist? What tables use a certain column name? Get the line of code from any and all packages where a string named “EMPLOYEE_NUMBER” is used What privileges does a role …

Busy Buffer Waits ….and being a DBA

Yes. Yesterday was my last day as an application/database Architect. I still love to architect solutions but will not be doing that (only enabling it instead) officially at my job anymore. I want to learn more and so I chose to be a DBA for Oracle and SQL Server as my primary job function. You might be …