Security Techniques for Cross Database Access
Explore secure methods for cross-database access, optimizing rights management and enhancing data protection in database environments.
Keeping Historical Data in Tables Forever - Mission (Im)possible
Explore solutions for storing and managing historical data in databases, addressing complex requirements for data retention, editing, and querying while optimizing performance.
Query Store Best Practices for Production Environments
Discover essential Query Store best practices for successful implementation in production environments. Learn from common issues and optimize your SQL Server performance.
Beware of Nondeterministic T-SQL Code
Explore the implications of nondeterministic T-SQL calculations and learn best practices to avoid potential issues in your database development.
Chaos Engineering for SQL Server
Explore Chaos Engineering concepts and methodologies to identify potential weaknesses in SQL Server, enhancing system resilience and reliability.
Merging Power BI into Azure DevOps - Version Control and CI/CD Pipelines
Integrate Power BI with Azure DevOps for centralized version control, change tracking, and streamlined deployment in team development environments.
Stop Indexing the Query - Optimizing Database Workload Indexing
Learn a methodology for optimizing database performance by indexing for your entire workload, not just individual problem queries.
Choosing the Right Database for Modern Cloud Applications
Design a data strategy and choose the optimal database for modern cloud applications. Learn about managed instances, Postgres, MySQL, and database engines across platforms.
A DBA's Guide to the Proper Handling of Corruption
Learn to detect, investigate, and respond to database corruption effectively, ensuring minimal impact on your company's operations.
Extend Azure Capabilities Anywhere with Azure Arc-Enabled SQL Server
Explore Azure Arc for SQL Server: view, manage, secure, and govern on-premises or multi-cloud SQL Servers from Azure. Learn use cases, onboarding, inventory management, and Azure service integration.
PaaS-like Benefits Outside Azure with Azure Arc Enabled SQL Managed Instance
Modernize SQL servers with Azure Arc enabled SQL managed instance for PaaS-like benefits outside Azure. Explore architecture, backups, HA, DR, monitoring, and provisioning with demos.
Azure Data Explorer - A Torch in the Dungeon of Observational Analytics
Explore Azure Data Explorer for observational analytics, learning its capabilities and getting a quick start in this powerful platform for handling big data and IoT scenarios.
Tidy Space, Tidy Mind - How to Better Manage SQL Environments Across Cloud Providers
Learn to efficiently manage SQL Server and Azure SQL estates across multiple cloud services, improving performance and creating budget space for new initiatives.
Building SaaS Solutions on Azure SQL Database
Explore real-world architectures for SaaS solutions on Azure SQL Database, from small-scale to millions of tenants. Learn multi-tenancy models and apply them to your scenarios.
Understanding SQL Server Checkpoints - Why They Matter
Explore SQL Server's checkpoint process, its impact on performance, and recent changes in SQL 2014 and 2016+. Learn to influence checkpoint intervals for optimal database management.
Azure Data Studio and the Surprises Inside
Discover hidden features and maximize your use of Azure Data Studio for enhanced database management and productivity.
Gathering Requirements for Your Star Schema
Collaboratively design dimensional models with business users for effective star schema requirements gathering and data visualization.
The Wonderful World of Collations, Encodings and Text Storage
Explore characters, collations, encodings, and text storage in databases. Gain insights into sort orders, diacritics, and code pages for improved data management and development.
From Your Couch to the Cloud - When and Why to Choose the Azure Portal for SQL Administration
Maximize Azure Portal capabilities for SQL administration. Learn when and why to use it for efficient cloud database management.
Performance Tuning Azure SQL Database
Learn Azure SQL Database performance tuning techniques, monitoring tools, and scaling strategies to optimize cloud database performance and overcome common challenges.
SQL Migrations to Azure Made Easy - Leveraging Microsoft's Migration Tools
Leverage Microsoft's Migration Tools to evaluate and accelerate SQL migrations to Azure, using Azure Data Studio extensions for optimized speed and productivity.