Stedman SQL Podcast Sn 3 Ep 1 What Will You Do Different This Year скачать в хорошем качестве

Stedman SQL Podcast Sn 3 Ep 1 What Will You Do Different This Year

Steve Stedman and Shannon Lindsay discuss SQL Server security and performance improvements for the new year. They highlight a 16% discount for new managed service customers and emphasize the importance of enforcing the principle of least privilege, implementing data encryption, and regular patching. They recommend using SQL Server audits, extended events, and the Database Health Monitor for advanced auditing and monitoring. For performance optimization, they suggest focusing on slow queries, optimizing storage and indexing, and enhancing backup and disaster recovery strategies. They also mention new features in SQL Server 2025 and the importance of ransomware preparedness. 00:00 Intro 02:03 Database Health Monitor Sponsor Break 03:46 Enforce Principle of Least Privilege 05:27 Implementing Data Encryption 08:16 Regular Patching and Isolation 10:58 Enable Advanced Auditing and Monitoring 12:46 Want to be a guest on our show? 13:25 Boosting Performance and Reliability 13:50 Leverage Performance monitoring Tools like Database Health Monitor 16:22 Optimize Storage and Indexing Strategies 18:24 Enhance Backup and Disaster Recovery 22:38 Adopt Performance Monitoring Best Practices 26:00 New 2025 Features for Scalability 27:58 Real Life Examples 30:16 Conclusion