How GDPR Compliant Are You - The New World of Data Privacy
Explore data privacy and security in centralized architecture, focusing on GDPR compliance using SQL Server 2017, SSIS, and SSRS through practical demonstrations.
Data Privacy and the Data Driven Professional - The New World of Data Privacy
Explore challenges in data privacy, tools for mitigating risks, and strategies for responsible data use to avoid misuse and financial penalties in the modern data-driven world.
Masking Sensitive Data - The New World of Data Privacy
Practical demonstration on automatically masking and refreshing sensitive data in database copies for developers, enhancing data privacy and security in SQL environments.
Introduction to Azure Data Bricks - Cloud
Explore Azure Databricks for big data processing, advanced analytics, and real-time insights. Learn platform basics, architecture, and integration with Azure components for data-driven solutions.
Azure Basics for the DBA - Cloud
Explore Azure fundamentals for DBAs, covering key concepts, terminology, and hands-on demos. Learn to set up virtual machines and SQL databases, enhancing your cloud skills for career growth.
What's New in SQL Server 2019
Explore SQL Server 2019's enhancements in performance, security, Linux support, and Big Data Clusters. Learn about new features and improvements across the SQL Engine and Availability groups.
SQL Server Security Basics - Security
Learn SQL Server database security essentials, including permissions, principals, and best practices. Gain practical knowledge to protect your company's valuable data and manage security effectively.
Azure Data Security
Explore Azure's data security tools: encryption, masking, threat protection, and more. Learn to safeguard your data assets effectively in the cloud environment.
TDE, Encryption, and Compliance With Azure Key Vault - Zero To Hero
Learn to secure and comply with data regulations using SQL Server TDE, encryption, and Azure Key Vault. Covers basics to advanced topics, including AlwaysON and hybrid cloud scenarios.
Identifying Anti-Patterns in Analytical Queries
Learn techniques to optimize SQL-based analytical queries, restructure jobs, and eliminate performance bottlenecks. Improve efficiency and deliver results faster across various data tools and platforms.
Encrypting Data Within SQL Server
Explore SQL Server encryption options, data privacy laws, and performance impacts. Learn to classify sensitive data, implement Always Encrypted, and audit data usage for enhanced security.
SQL Injection - What Is It, Prevent It, Monitor For It
Comprehensive guide on SQL Injection: understanding attacks, monitoring systems, and implementing robust security measures to protect databases from vulnerabilities and unauthorized access.
Enterprise-Grade BI with Power BI - EIM, Scale and Performance
Explore enterprise-grade BI with Power BI, focusing on EIM, scale, and performance. Learn about data lineage, impact analysis, semantic models, and data protection for optimized large-scale analytics solutions.
Data Classification - Taking Your First Step on the Road to Agile Data Governance
Learn to build and maintain an evergreen catalog of your SQL Server estate, enabling agile data governance. Discover best practices for data classification, protecting sensitive information, and ensuring compliance with privacy regulations.
On-Premises Power BI and Reporting - Reporting Services 2019
Explore on-premises Power BI reporting with PBIRS: installation, configuration, report development, and management through the portal. Learn tips for leveraging on-premises features effectively.
Data Classification and Masking - The What and How of Data Protection
Learn techniques for protecting sensitive data across systems using SSMS and SQL Server tools. Explore data classification, dynamic and static masking to ensure data security while maintaining accuracy for testing and analytics.
Power BI Data Privacy Settings Deep Dive
Explore Power BI data privacy settings: configuration, impact on performance, and error prevention. Learn to optimize query speed while ensuring sensitive data protection across sources.
What's New in Security for Azure SQL - MI
Explore cutting-edge Azure SQL security innovations, including network security, authentication, data encryption, and management. Gain insights into new customer scenarios and opportunities unlocked by these technologies.
Reporting Services - A Smart Migration Strategy
Discover strategies for migrating to Power BI Report Server, utilizing ReportServer database metadata to determine which reports and data sources to migrate, and learn PowerShell techniques for efficient extraction and migration.
Data Privacy, Security, Ethics and Compliance in a Data-Driven World
Explore ethical challenges in data-driven technologies, focusing on privacy, security, and compliance. Learn tools and strategies to mitigate risks and maintain integrity in the evolving landscape of AI and big data.
How I Would Attack SQL Server
Explore SQL Server vulnerabilities and attack strategies from an adversary's perspective, learning detection, prevention, and response techniques for enhanced database security.