Episode 136 - On the First Day of Christmas I got a TSQL Script

SQL Server Radio

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