Top Issues #1
Description
SELECT with many JOINs
Identify the AZ in which my query is executing (AlwaysOn Availability Groups)
USEROPTIONS / @@options (https://www.mssqltips.com/sqlservertip/1415/determining-set-options-for-a-current-session-in-sql-server/; https://sqlsunday.com/2014/09/28/connection-flags/; https://www.brentozar.com/archive/2018/03/troubleshooting-parameter-sniffing-issues-right-way-part-2/)
JDBC: instance name & portnumber:
SQL Browser Service (https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15; https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15)
exec sp_help
Know your SQL Server name when you request a DBA to support you! (host, service, tcp port, database)
Asking for sysadmin permissions
"Access and permissions" = authentication and authorization (A&A)
Request A&A "like this person's"
Requesting information about the SQL server when you don't have A&A to obtain it yourself