Pure Report Podcast: Databases!!!
Catch up with Anthony Nocentino on the latest episode of the Pure Report podcast where we dive into trends in database operations and the impact of AI on DBA roles - plus how new Pure platform announcements and Fusion drive better efficiency and performance for SQL Server and Oracle. Anthony tackles the pressing challenges faced by database environments today, including fragmented storage infrastructure, manual provisioning, and the complexities of compliance, disaster recovery, and hybrid cloud strategies. He sheds light on how these issues contribute to real-world burnout among DBAs and infra team members. The discussion will also cover the evolving roles of these professionals as they increasingly become platform performance engineers, cloud strategists, and data ops troubleshooters in a world of multiple database engines and unpredictable resource needs driven by AI workloads.
Using FlashArray Volume Snapshots with Microsoft SQL Server
FlashArray volume snapshots are an amazing tool for any DBA/DBRE managing SQL Server. You can use them to: Instantly recover from user errors or ransomware attacks Create rapid dev/test copies without full restores Offload CHECKDB to another host to avoid production performance hits Refresh reporting environments on demand Seed Always On availability groups faster, without large full backups Enable point-in-time recovery when paired with SQL log backups And the best part? Snapshots on FlashArray are: Immutable Space-efficient Fast to create and restore Fully automatable through the REST API or SDK tools! I worked very closely with our SQL Server field super stars (Anthony Nocentino, Andrew Pruski and Andrew Yun) on a white paper going VERY deep into the architecture and how to. It includes everything from crash- vs. application-consistent snapshots, to step-by-step restore and cloning procedures, to using SQL Server 2022’s new T-SQL snapshot backup. Did we miss anything ? Let us know!New SQL Server with Pure Storage Reference Architecture!
We have a new SQL Server with Pure Storage Reference Architecture! It’s been out for a few months, but this is a great start to your journey to a simpler, high-performance database environment! This reference architecture shows how to: Consolidate transactional and analytical SQL Server workloads using FlashArray Use FlashBlade for rapid, parallel T-SQL backups to file or object storage Enable zero-downtime operations with ActiveCluster and near-synchronous replication via ActiveDR With this RA you will find detailed technical guidance for storage provisioning for SQL Server databases on Windows or Linux as well as best practice guidence on how to take the best advantage of the primary storage layer. Check out the full reference architecture here: Optimizing SQL Server Operations and Scale with Pure Storage (PDF) Have feedback, use cases to share, or questions about implementation? Please reach out!
