To hide procedure code, create the procedure WITH ENCRYPTION. A demo shows what the clause blocks: the text, the definition and the plan. It also shows the ALTER trap that unhides a procedure, and why this is obfuscation and not security.
CHECK_POLICY and CHECK_EXPIRATION for SQL Logins
Audit CHECK_POLICY and password expiration for SQL logins, inspect LOGINPROPERTY evidence, and plan safe service-account exceptions.
Who Dropped Your Table? – SQL in Sixty Seconds #112
Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.
Azure SQL Firewall Rules: List, Add and Remove With T-SQL
Azure SQL firewall rules decide which IP addresses can reach a logical server and its databases. This post lists the server-level and database-level rules with T-SQL, adds, changes and removes one, and explains how to find the address Azure sees. It also covers the one thing T-SQL cannot do, which is let you in for the first time.
SQL Azure – Add IP Address to Firewall
To Add IP Address to Firewall rules, I first confirm the intended Azure SQL network path. A home connection prompted this walkthrough.
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
An empty password on sa is a serious security failure. I stopped an e-commerce consultation after noticing passwordless administrator sign-ins.
LPIM Memory Model: Check It With sys.dm_os_sys_info
The LPIM memory model tells you whether SQL Server runs with locked pages. This post reads it from sys.dm_os_sys_info in one query, confirms it with the process memory view and the error log, and explains what each value means.