Random tokens in SQL Server need more than a generated value. Their stored state must define expiry, revocation and whether consumption already occurred. A guarded disposable fixture makes the boundary conditions explicit.
SQL SERVER – Best Practices for DBA Before Taking Vacation
Why is it so hard for a DBA before taking vacation to relax? For T-SQL Tuesday I share my best practices, starting with the hardest: do not think about your job.
SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password
Strange emails and a missing shared folder led me to a reset router with a weak key. My lesson on wireless router security and complex passwords.
SQL SERVER – Difference Between GRANT and WITH GRANT OPTION
What is the difference between GRANT and WITH GRANT? Only WITH GRANT OPTION lets a user pass the same permission on to other users.
Reading a Network Trace of a SQL Server Connection
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.