DataOps - Deploy SQL Server Databases Using Azure Pipelines
Learn to automate SQL Server database deployments using Azure Pipelines and Visual Studio Database Projects. Covers creating projects, manual deployments, and setting up automated pipelines with secure credential management.
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.
From Fear to Confidence – Learn the Art of Influence
Learn to confidently evaluate and communicate about new technologies in your workplace, enhancing your reputation and leadership skills while staying relevant in a rapidly evolving tech landscape.
Let's Automagically Stage 100 Tables - For SSIS or ADF - With Biml - Live
Explore how Business Intelligence Markup Language (Biml) can automate SSIS package creation and generate JSON for ADF pipelines, streamlining data transformation processes from on-premises to Azure.
Take Me to the Multiple Clouds Above Seattle
Explore multi-cloud strategies, benefits, and challenges. Learn from experienced architects about best practices, data integration, and migration in cherry-picking cloud services for optimal data platform design.
Successfully Communicating with Your Customers
Explore techniques for effective customer communication in tech, including stakeholder identification, requirements gathering, and managing expectations to enhance project success and career growth.
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.
Modern Excel - The Supercomputer Hiding on Everyone’s Desktop
Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.
Accelerate Migrations of Legacy SQL Server and SSIS with Azure Data Factory
Streamline SQL Server and SSIS migration to Azure using ADF. Learn to provision SSIS-IR, run SSIS packages in ADF pipelines, and leverage DMA and DMS for efficient batch migrations.
CosmosDB - Designing and Troubleshooting Lessons
Learn to design, query, and troubleshoot high-performance Cosmos DB solutions through hands-on labs covering partition design, SQL API querying, and request optimization techniques.
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.
Innovative Data Modeling for Cool Data Warehouses
Explore agile data warehouse modeling techniques beyond traditional norms. Learn to build flexible, auditable solutions adaptable to various industries, leveraging MDM and Azure for enhanced performance and data integration.
Two Truths That's A Lie - Data Visualization Ethics
Explore data visualization ethics, examining how color and chart choices influence storytelling. Learn to create truthful, impactful visualizations while protecting your company's reputation.
Should I Move My Production SQL Server Workloads to Containers
Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.
Choosing Database Hardware for SQL Server 2019
Optimize SQL Server 2019 hardware selection for performance and cost-efficiency. Learn to evaluate workloads, choose processors, and navigate licensing changes to maximize database server capabilities.
Bringing Source Control to BI World
Discover how to implement source control in Business Intelligence environments, improving version management, tracking changes, and facilitating parallel development for databases, cubes, and reports.
Data Modeling and Prototyping in Power BI Desktop
Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.
Design Strategies and Advanced Data Visualization
Advanced techniques for effective data visualization, including accessibility design, data storytelling, and creating impactful reports and dashboards for diverse audiences.
Improving Database Code Quality with Unit Tests
Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.
Azure SQL Database - Maximizing Cloud Performance and Availability
Optimize Azure SQL Database performance and availability for mission-critical applications. Learn best practices, configuration tips, and troubleshooting techniques to maximize cloud resources and achieve 99.995% uptime.
Privacy and Security by Design in a Cloud Environment
Learn security and privacy design principles for cloud architectures, with practical implementation examples and best practices for integrating these crucial aspects into your solutions.