Improving Analytics Performance With Columnstore Indexes
Explore columnstore indexes for efficient OLAP data storage and analytics in SQL Server. Learn architecture, optimization techniques, and best practices to enhance query performance on large datasets.
Identifying, Understanding, and Combating Gender Bias & Inequality
Explore unconscious gender biases, their origins, and impacts. Learn strategies to identify and combat these biases in professional and personal settings, fostering positive solutions for equality.
The Fundamentals of DAX Contexts
Explore DAX contexts and their resolution through practical demonstrations, enhancing your ability to create advanced measures and ensure accurate data analysis in Power BI.
Move Your Entire BI Platform to Azure and Power BI
Comprehensive guide to migrating BI platforms to Azure and Power BI, covering architecture, implementation, governance, and support. Includes real-world examples and demos for enterprise-level deployment.
Practical Guidance to Make Your Tier-1 SQL Server Roar
Optimize high-performance tier-1 SQL Server systems with expert guidance on configuration, tuning, and maintenance for modern hardware, covering platform, server, and infrastructure considerations.
Navigating Row Level Security
Explore fine-tuned data access with Row Level Security in SQL Server, covering implementation patterns, scaling solutions, and practical tips for sensitive information management.
Neutralize Troublesome SQL Server Indexes - Fun Stories & Demos
Explore SQL Server index optimization with real-world scenarios and demos. Learn to identify and resolve performance issues caused by problematic indexes for improved query efficiency.
Intro to Azure Data Catalog
Learn how Azure Data Catalog can help your organization efficiently discover, understand, and utilize vast amounts of data across various sources, improving data accessibility and decision-making.
Demystifying Query Store Plan Forcing
Explore Query Store's plan forcing feature through real-world examples, understanding its benefits, potential issues, and best practices for implementation in production environments.
Leading Virtual Teams with Trust
Discover strategies to enhance virtual team leadership through trust-building techniques, improving remote work effectiveness and productivity in the post-pandemic era.
Consuming API Data Using Built in SSIS Components
Learn to consume API data using SSIS components, focusing on building requests, parsing JSON, and outputting data in a standard pipeline without additional tools. Practical example using NOAA Weather API.
Providing High Availability to SQL Server on Linux
Explore configuring Linux Pacemaker for SQL Server high availability, comparing it to Windows Server Failover Cluster and learning proper architecture for robust database systems on Linux.
Self-Service Analytics Using Azure Synapse Link for Azure Cosmos DB
Learn to build real-time BI dashboards using Azure Synapse and Cosmos DB. Discover no-ETL analytical processing on operational data without impacting critical workloads.
Deploy Your Database Using AWS DevOps
Learn to implement DevOps database deployments in AWS, from basic setup to advanced processes. Gain practical skills to streamline and expand your deployment capabilities.
Skill up on Azure with Microsoft Learn - Professional Development
Explore Microsoft Learn's comprehensive training options for advancing your technical skills in Azure, including free self-paced learning, instructor-led training, and certifications.
SQL Server to Azure SQL - Availability - Cloud
Explore Azure SQL's robust availability options, from backup and restore to high availability architectures, ensuring your business continuity needs are met across various service tiers.
Monitor Azure SQL Databases - Cloud
Explore Azure SQL Database monitoring using Azure portal, DMVs, and tools for metrics, resource usage, and performance. Learn to configure alerts and analyze logs for effective database management.
Data Visualization for Entrepreneurs
Learn key differences between data visualization tools, their pros and cons, and how to choose the best one for your entrepreneurial needs.
Azure Data Engineering 101
Explore Azure Data Engineering essentials, including storage, security, DevOps, and automation. Learn key skills for certification and career advancement in the evolving data landscape.
Moving Data to the Cloud with Azure Data Factory
Explore Azure Data Factory for efficient cloud data migration, covering variables, looping, Integration Runtime, file uploads, triggers, and secure credential management with Azure Vault.
Machine Learning in Power BI
Explore ML tools and features in Power BI, including built-in visuals, Azure Cognitive Services integration, and new ML capabilities in data flows for enhanced data analysis and reporting.