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 … Continue reading SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication
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 … Continue reading Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?
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 … Continue reading Oracle – Data Dictionary Views – USER vs ALL vs DBA Views – 100 Level Basics
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 … Continue reading Busy Buffer Waits ….and being a DBA