We Can Get More from Spatial, GIS, and Public Domain Datasets
Explore spatial data analysis and interpolation techniques using pyinterpolate for insights on rental prices, pollution mapping, and socio-economic factors at various scales.
Breaking the Stereotype - Evolution & Persistence of Gender Bias in Tech
Explore the evolution of gender bias in tech, from female-dominated programming to current stereotypes, and its impact on the industry and society.
A Brief History of Data Storage
Explore the evolution of data storage from ancient clay tablets to modern digital solutions, examining key innovations, challenges, and future prospects in preserving human knowledge.
Being the DBA of the Future - A World of On-Premise and Cloud
Explore the evolving role of DBAs in hybrid environments, covering essential skills for managing on-premise and cloud databases, and strategies for adapting to future technological changes.
Policy-Based Management and Central Management Server
Explore policy-based management and Central Management Server for efficient SQL Server administration, including server registration, policy creation, and evaluation modes.
Query Tuning Techniques Every SQL Programmer Should Know
Learn essential query tuning techniques to optimize SQL performance, enhance database efficiency, and improve application responsiveness. Gain valuable insights from industry experts.
Dos and Don'ts of Database Corruption
Learn essential strategies for preventing, detecting, and recovering from database corruption, ensuring data integrity and minimizing downtime in critical systems.
SQL Server Index Internals - A Deep Dive
Explore SQL Server index internals, uncovering optimization techniques and performance insights for database professionals seeking advanced knowledge.
Troubleshooting Clusters
Learn essential techniques for diagnosing and resolving issues in clustered environments, enhancing your ability to maintain high availability and performance in complex database systems.
Windows Azure SQL Database Design - Silver Lining and Dark Side
Explore Windows Azure SQL Database design, covering editions, limitations, costs, data types, and modeling. Learn 10 tips for effective design and migration strategies.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Automate Your ETL Infrastructure with SSIS and PowerShell
Streamline ETL processes using SSIS and PowerShell automation techniques. Learn to enhance efficiency and reduce manual tasks in data integration workflows.
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.
Hekaton - Why, What, and How
Explore Hekaton, Microsoft's in-memory OLTP engine for SQL Server, with David DeWitt. Learn its purpose, functionality, and implementation details in this comprehensive keynote presentation.
Windows Azure Deep Dive
Explore Windows Azure's architecture, services, and capabilities with Microsoft Technical Fellow Mark Russinovich in this comprehensive deep dive session.
How to Use DMVs to Diagnose Performance Issues
Discover how to leverage Dynamic Management Views (DMVs) for effective SQL Server performance diagnostics and troubleshooting with expert Glenn Berry.
Microsoft's Data Platform
Explore Microsoft's data platform vision and strategy, including latest innovations and future directions in database technology and analytics.
SQL Server Integration Services Roadmap
Explore the future of SQL Server Integration Services with industry experts, covering upcoming features, best practices, and strategic insights for data integration professionals.
Data Mining in SQL Server Analysis Services
Explore advanced data mining techniques using SQL Server Analysis Services to uncover hidden patterns and gain valuable insights from your datasets.
Index Fragmentation - Internals, Analysis, and Solutions
Explore index fragmentation in SQL Server, covering internal structures, analysis techniques, and practical solutions for optimizing database performance and query efficiency.
SQL Server 2014 In-Memory OLTP Overview
Explore SQL Server 2014's in-memory OLTP technology, its architectural pillars, and integration with SQL Server for optimized workloads and improved performance.