Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.
SQL Injection: How It Works and How to Stop It
Prevent SQL injection by separating values from command text, parameterizing dynamic SQL, and validating object names before using QUOTENAME.
SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines
sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
My students got Msg 262, SHOWPLAN permission denied, when they tried to view an execution plan. One GRANT SHOWPLAN statement fixes it.
TDE, Column Encryption and Always Encrypted Compared
Compare SQL Server encryption options by the threat they address, where keys live, what applications must change, and how recovery is tested.
Environment Settings in SSIS Projects
SSIS projects can deploy one package across environments by using project parameters, SSISDB variables, and tested references.
Auditing SELECT Statements on Sensitive Tables
Auditing SELECT statements on sensitive tables needs a narrow database audit, protected files, volume checks, and active review.