Image
  • Home
  • About Us
  • Episode Archive

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

10 Jan, 2022

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
Image
  • Privacy & Policy
  • Terms of Services
Privacy & Policy
Terms of Services