Guy and Eitan discuss some interesting announcements and focus on the topic of Security in SQL Server.
Relevant links:
- Announcing new features for the SQL IaaS Agent Extension! - Microsoft Tech Community
- Troubleshooting SQL Server made easy via Notebooks – seeking your feedback - Microsoft Tech Community
- Veeam security breach: Backup “Removal” Solutions - From Conti Ransomware With Love
- sp_helprotect is very useful in permission issue - Microsoft Tech Community
- Databases and Guests - Vitaly Bruk
- Performance Tuning Like a Pro - with Hypothetical Indexes - Eitan Blumin
- Dynamic Data Masking in SQL Server
- Madeira Toolbox Roundup:
- GUEST user with database permissions.sql
- PUBLIC role with excessive permissions.sql
- DBCC CLONEDATABASE (Transact-SQL)
- Audit trace file binary search by timestamp.sql
- Security_Audit_Default_Trace.sql
- SQLSecurityAudit.sql
- Detect Weak Passwords in SQL Server
- track_logins_in_use_extended_events.sql