Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
SQL SERVER – Beginning of SQL Server Architecture – Terminology
Beginning SQL Server Architecture: my friend Anil Kumar explains the basic terms and the main parts, the Relational Engine, Storage Engine and SQL OS.
SQL SERVER – Beginning of SQL Server Security
The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.
Time-Limited Access: Expiring Grants With a Valid-Until Column
A ValidUntil column does nothing by itself. Here is how to make the read path enforce it, with a demo you can run.
SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue
A friend could connect to SQL Server but could not see any user created object, while his colleague could. It was a security and permissions issue.
Second-Order SQL Injection: When Stored Data Becomes Code
A safe insert does not make the saved value safe forever. Here is how stored text turns into code later, and the plain fix.
Dynamic ORDER BY Without Injection: Whitelisting Sort Columns
Parameters cannot name a column, so grids end up gluing text into SQL. Here is the approved-list pattern that keeps the sort safe.