Azure Cosmos DB - How to Design and Implement for SQL API
Explore Azure Cosmos DB SQL API design and implementation through demos, best practices, and monitoring techniques. Learn data modeling, query optimization, and issue identification for efficient database management.
Detecting AI Trojans Using Meta Neural Analysis
Explore meta neural analysis techniques for detecting AI trojans, covering Jumbo Learning, feature extraction, query tuning, and adaptive attacks.
Intelligent Query Processing
Explore SQL Server optimizer advancements that improve performance without code changes, including techniques for table variables, user-defined functions, and common anti-patterns in T-SQL development.
A Query Runs Through It - An Introduction to the SQL Server Engine
Explore SQL Server internals, from data types to query processing, enhancing your ability to write and optimize queries across various platforms. Gain valuable insights into the engine's inner workings.
Improving App Performance with Snapshots
Learn to enhance app performance by optimizing database queries using the "snapshot-queries" library. Discover techniques for efficient Python coding and scaling without increased costs.
Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad
Explore how skewed data affects cardinality estimates and query plans, learning strategies to improve SQL Server performance and optimize database operations.
50 Things All SQL Server Developers Need to Know
Discover 50 essential SQL Server development tips, covering database design, T-SQL best practices, and query optimization techniques for improved performance and efficiency.
Query Tuning Mastery - Manhandling Parallelism, 2014 Edition
Mastering parallel query execution techniques for optimal SQL Server performance, focusing on advanced tuning strategies and best practices.
Modernizing SQL Server the Right Way
Discover efficient SQL Server modernization strategies, from assessing upgrade readiness to optimizing performance using free Microsoft tools. Learn about compatibility, deprecated features, and post-migration best practices.
Reduce Cost by Tuning Queries on Azure DBaaS
Learn techniques to optimize queries on Azure SQL Database, improving performance and potentially reducing costs by lowering resource demands and compute size requirements.
Do You Feel the Need the Need for Speed in SQL Server Database?
Discover efficient SQL Server query tuning techniques using Quest Foglight and SQL Optimizer. Learn to identify bottlenecks, analyze execution plans, and optimize database performance systematically.
Identifying Slow Queries and Fixing Them in PostgreSQL
Optimize PostgreSQL performance by identifying and fixing slow queries through configuration, monitoring, and query analysis techniques.