Columnstore Index Compression in a Nutshell
Unlock the secrets of columnstore compression to enhance analytic query performance and optimize database architecture for modern analytics.
Changes to Azure Synapse Analytics and Their Impact on Data Architecture Designs
Explore Azure Synapse Analytics' evolution and its impact on data transformation, storage, and querying methods to evaluate its suitability for your data environment.
Data Modernization in a Hybrid World
Explore the data journey from consolidation to hybrid cloud, covering modern architectures, Linux, containers, and a holistic model approach for data management.
Unlocking the Power of WhoIsActive - Monitoring SQL Server Activity
Discover advanced SQL Server monitoring techniques using WhoIsActive. Learn to track activity, troubleshoot issues, and optimize performance effectively.
Effortless Low-Code Data Testing for Enhanced Data Quality
Explore low-code solutions for efficient data testing, integrating methods into CI/CD frameworks and applying them to real-world scenarios to enhance data quality across various technologies.
Mastering the Hybrid Environment - Essential Strategies for DBAs
Enhance performance and security in hybrid databases with strategies for managing cloud and on-premises environments effectively.
Defining Entities and Attributes for Tabular Models - 20 Minute Guide
Define entities and attributes for tabular models using real-life project examples to improve design and address common issues.
Top 10 Transactional Database Mistakes and How to Avoid Them
Discover common transactional database pitfalls and learn effective strategies to enhance security, maintenance, and optimization in this insightful session.
Getting Started Quickly with Database DevOps Using Flyway
Learn to safely deploy databases using Flyway in DevOps pipelines and explore a user-friendly sandbox environment for hands-on database DevOps experience.
Effortless Low-Code Data Testing for Enhanced Data Quality
Explore low-code solutions for efficient data testing. Learn to implement automated quality checks, integrate with CI/CD frameworks, and apply techniques across various data technologies for immediate organizational impact.
Effortless Low-Code Data Testing for Enhanced Data Quality
Explore low-code solutions for efficient data testing. Learn to implement automated quality checks, integrate with CI/CD frameworks, and apply techniques across various data technologies for immediate organizational impact.
Relational or Non-Relational? Choosing the Best Database for the Task
Explore strengths and weaknesses of relational and non-relational databases. Learn best use cases and real-world examples to make informed decisions for your data storage needs.
Relational or Non-Relational? Choosing the Best Database for the Task
Explore strengths and weaknesses of relational and non-relational databases, with real-world examples to guide your choice for specific data storage needs.
Managing the Challenge of Monitoring Growing, Multi-platform Database Estates
Learn best practices and real-world examples for monitoring multi-platform database environments, presented by experienced SQL Server professionals.
Speeding Data Product Delivery from Model to Marketplace
Transform your data strategy into an executable program with a blueprint for successful implementation.
Flight of Insights: Navigating Data Turbulence with SQL Modeling and Visualization
Explore data modeling and visualization techniques to identify risks and make informed decisions in project navigation, inspired by Captain Sully's story.
Let Me Show You Why Data Types Still Matter
Explore the importance of selecting appropriate data types in SQL, with practical examples demonstrating their impact on database performance and functionality.
Crossing The Streams - Adding PostgreSQL to Your SQL Server Skillset
Expand your database management skills by learning how to incorporate PostgreSQL alongside SQL Server, addressing the growing need for multi-platform expertise.
Building and Using Organizational Data Types in Power BI and Excel
Create and utilize data types in Power BI for Excel consumption. Enhance data modeling and visualization capabilities across platforms.
Avoiding Downtime with Effective Index Deployment Strategies
Learn strategies to avoid downtimes and blocking operations when managing indexes on busy SQL Server systems, ensuring smooth database performance and availability.
Azure Cosmos DB Serverless Unleashed
Explore Azure Cosmos DB Serverless: its benefits, use cases, and implementation strategies for efficient, cost-effective NoSQL database management.