The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

Secure Business Intelligence from the Inside Out

Description

How well do your BI development practices protect your data? The job of protecting data is not limited to the DBA. The Microsoft BI stack contains multiple tools which each have different security configuration options and interdependencies. In this workshop, you see specifically how data can be compromised in this stack, learn where the potential risks of a data breach are lurking in your BI solutions, and leave with specific steps you can take to mitigate those risks.

This workshop starts with an overview of security principles. Throughout the day, we explore the anatomy of an attack on your data component by component. We review the security architecture of each component in the BI stack and highlight vulnerabilities in the architecture that must be addressed to properly secure your BI environment. We explore security by using a multi-tier, multi-layered approach,
leaving no stone unturned.

By the end of this workshop, you'll understand the relationship across the security settings not only in the BI tools, but also the backend databases and the Windows operating system. As we examine potential security issues, we show you how to build a security action plan for Integration Services, Analysis Services, and Reporting Services. Is Azure in your environment? We also cover important aspects of cloud security for a BI solution. Come learn how to preserve and protect your data effectively from the inside out.

Learning Objectives

Previous Experience

Tech Covered

Azure, SSRS, DBA, BI, security