EVENTS

Understanding data security and compliance standards In today's data-driven world, organizations depend on SQL Servers to securely store, manage, and process critical information. Compliance is essential to protect this sensitive data, adhere to industry regulations, and maintain business integrity. It encompasses practices, policies, and standards that ensure SQL Servers meet legal, security, and operational requirements. Failure to comply with regulations such as GDPR, HIPAA, or PCI DSS can result in severe consequences, including financial penalties, reputational damage, and legal liabilities. Maintaining compliance not only minimizes these risks but also fosters trust with customers and stakeholders. It ensures data integrity, enhances security against breaches, and supports seamless audits. To achieve compliance, organizations should focus on access controls, encryption, patch management, and regular audits. Automated tools and built-in SQL Server features can assist in monitoring and enforcing compliance measures, but as estates grow sometimes enterprise level tools and processes can be more beneficial. Join Jess and Rob as they explore what compliance is and why you should care. You will leave with a greater understanding of some of the pitfalls and some of the measures that you can take to help your organisation avoid being mentioned in the media for the wrong reasons.

Join us live as we dive into the fundamentals of the Data Vault (DV) methodology—what it is, why organizations adopt it, and how it enables a flexible, business-aligned data architecture that scales with demand. We’ll explore how ER/Studio plays a critical role in successful DV implementation, helping teams design and maintain a consistent, governed core structure while staying in sync with evolving business needs. You'll also get a first look at new automation macros purpose-built to accelerate DV model creation and streamline ongoing maintenance. To bring this to life, we’re joined by the team at Sanlam, a leading financial services group with a century-long legacy and operations in 31 countries across Africa and Asia. Focused on long-term growth in high-potential emerging markets, Sanlam is committed to advancing financial inclusion and creating shared value through data-driven strategy. Representing Sanlam, you’ll hear from:

• Jonathan James, Lead Technical Business Analyst in the Scalable Warehouse team. A certified Data Vault 2.0 practitioner, Jonathan has spent the past four years designing and implementing Raw Vaults while championing the adoption of both Data Vault and ER/Studio across Sanlam’s BI environment.
• Craig Strachan, Senior Solutions Architect, whose background spans enterprise architecture, data integration, and business intelligence. With certifications in Data Vault 2.0 and DAMA, Craig led the architectural oversight of Sanlam’s scalable warehouse rollout, ensuring it aligned with both technical standards and strategic goals.

Their hands-on experience will give you practical insights into applying Data Vault in a real-world enterprise setting—and how ER/Studio helped them bring it all together.

To close, we’ll demonstrate powerful new automation macros that streamline DV model creation and maintenance, followed by a live Q&A.

Register today and learn to take your DV initiative further with ER/Studio.

Deadlocks can be one of the most frustrating and disruptive issues SQL Server DBAs and developers face—especially when they strike at peak business hours. While index tuning is often the first line of defense, query tuning is just as critical in preventing these concurrency conflicts. In this live session, renowned SQL Server expert Brent Ozar will walk you through the underlying causes of deadlocks beyond indexing issues, with a specific focus on query behavior and transaction design. You’ll learn how long-running transactions and inconsistent access patterns across tables can trigger deadlocks, and more importantly, how to fix them. Brent will demonstrate why working through tables in a consistent order and minimizing touches per table are key to reducing conflict—and how small adjustments in query design can make a huge impact on performance and reliability. The session will include a real-world deadlock example, followed by a live query rewrite to resolve the issue. Whether you're a DBA or developer, you'll walk away with practical strategies you can apply immediately to make your queries deadlock-resistant and your applications more resilient. 👉 Can’t make it live? Register now, and we’ll send you the recording to watch at your convenience.

Attend a live demo of the WhereScape Data Automation ecosystem hosted by a senior solutions architect. Experience the features that enable WhereScape users to save time, money and resources on data projects and enable individual developers to do the work of many.