Cosmic DB - Cosmos DB for SQL Server Admins and Developers
Explore Cosmos DB's NoSQL approach, indexing, consistency levels, and JSON design for SQL professionals. Learn to leverage schema-free advantages and optimize query patterns in document-based databases.
Performance Tuning Azure SQL Databases
Optimize Azure SQL Database performance using Automatic Tuning, Intelligent Insights, and Extended Events. Learn to leverage these features for time and cost savings while maximizing database efficiency.
Eliminating Anti-Patterns and RBAR for Faster Performance
Learn to boost SQL Server performance by identifying and fixing schema and code design issues, focusing on real-world examples and reproducible workloads to achieve faster query execution and better scalability.
Relational Data Modeling Trends for Transactional Applications
Explore modern data modeling trends for transactional applications, addressing challenges in NoSQL, microservices, and cloud environments. Learn to adapt traditional principles to meet current business demands and facilitate rapid changes.
Query Analysis Deep Dive - 13 Causes of a Slow Query
Comprehensive exploration of 13 common query performance issues, providing practical solutions and a checklist for optimizing slow SQL queries.
Amazon Aurora - Design for High Throughput Cloud-Native Relational DBs
Explore Amazon Aurora's innovative architecture for high-throughput cloud databases, focusing on network optimization, fast recovery, and fault tolerance without distributed consensus algorithms.
JSON for the Data Mortals
Explore JSON in databases: learn its origins, investigate, manipulate, and validate JSON data using Microsoft SQL Server tools and example code.
Virtual SQL Server Performance Deep Dive
Explore virtualization's impact on SQL Server performance, covering CPU scheduling, storage, networking, and optimization techniques for maximum efficiency in virtual environments.
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.
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.
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.
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.
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.
Using Open Source Software to Collect Performance Metrics
Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.
Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations
Discover innovations in SQL Server 2019 and Azure SQL Database that enhance database availability, reduce downtime, and streamline maintenance operations for improved performance and reliability.
Dynamic SQL - Writing Efficient Queries on the Fly
Learn to create fast, efficient queries using Dynamic SQL for automating complex processes, facilitating reporting, and solving seemingly impossible problems. Explore best practices, applications, and maintenance techniques.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
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.
Dipping Your Toes In - Azure Data Lake for DBAs
Explore Azure Data Lake basics, including storage, security, and U-SQL. Learn how this technology complements relational database skills and discover real-world use cases for data professionals.
Best Practices for Branching Database Code in Git
Learn best practices for branching database code in Git, covering strategies for different team sizes and release requirements. Explore popular branching models and their strengths, with special focus on database-specific considerations.
Emergency! Are You Ready for Disaster to Strike?
Prepare for data center disasters and ransomware attacks through regular practice of recovery processes. Learn strategies to ensure business continuity in critical situations.