In Defense Of Linked Servers 2016-08-28 Posted in: Database Administration Development Security SQL Server For my use case as a database administrator, I try to explain why the arguments against linked servers are bad ones. [...Read More]
It Takes A Village To Secure Our Data 2016-08-15 Posted in: Database Administration Development Security Software vendors aren't following the Principle of Least Privilege for SQL Server authorization. Can we be the catalyst for change? [...Read More]
Broken Backup Chains 2016-08-11 Posted in: Backup Database Administration SQL Server A recent discovery (sys.database_recovery_status) has helped me fix a couple of SQL Server backup issues. [...Read More]