Unlocking Data Insights
Empower users with robust BI tools to transform raw data into business insights. Learn to enable easy data access, leverage Microsoft's tools, and build a comprehensive data platform across on-premises, cloud, and devices.
Buffer Pool Extension and Resource Governor for IO
Explore SQL Server 2014's Buffer Pool Extension for OLTP performance and Resource Governor enhancements for improved IO control in resource pools.
Dark Matter - Domain Experts & Nextgen Spreadsheets Are Our Future
Unlocking organizational potential through domain expertise and advanced spreadsheets. Learn to leverage existing knowledge, improve data strategies, and turn Excel into a competitive advantage.
SQL Server 2014 - In-Memory OLTP End-to-End - Preparing for Migration
Explore SQL Server 2014's In-Memory OLTP feature, its performance benefits, and learn how to plan and execute a successful migration using a sample workload demonstration.
Extending Your Hadoop Implementations to the Cloud
Explore cloud-based Hadoop deployment benefits, including scalability and cost-efficiency. Learn to integrate on-premise and cloud implementations for optimal performance and flexibility.
Breakthrough Data Platform Performance with SQL 2014
Explore SQL Server 2014's in-memory technologies for enhanced OLTP, Data Warehousing, and BI performance. Learn about mission-critical features and hybrid cloud capabilities for improved database management.
AlwaysOn in Microsoft SQL Server 2014
Explore upgrading mission-critical databases to SQL Server 2014, enabling new features like in-Memory OLTP and Managed Backup, with minimal downtime for large workloads.
Columnstore Technical Deep Dive
Explore SQL Server 2014's updateable columnstore for massive query performance gains. Learn internals, differences from row store, and metadata insights in this technical deep dive.
The Modern Data Warehouse
Explore Microsoft's approach to evolving data warehouse infrastructure, addressing explosive data growth and new data types. Learn about scale-out technologies, in-memory performance, and Hadoop integration.
SQL Server 2014 In-Memory OLTP Management
Explore SQL Server 2014's in-memory OLTP technology, focusing on ACID compliance, storage optimization, memory provisioning, high availability, and manageability for enhanced database performance.
Columnstore Indexes in SQL Server 2014 - Flipping the DW Faster Bit
Explore optimized columnstore indexes in SQL Server 2014 for data warehousing, including architecture, challenges, and real-world applications. Learn how this hybrid technology can revolutionize your database performance.
Always-On Enhancements in SQL Server 2014
Explore AlwaysOn enhancements in SQL Server 2014, including increased secondary replicas, improved read availability, and seamless Azure deployment. Learn the business value and see practical demonstrations.
SQL Server Solutions to Deploy a Database to a Microsoft Azure VM
Deploy databases to Microsoft Azure VMs using SQL Server solutions. Learn efficient techniques for seamless migration and optimal performance in cloud environments.
How to Make a Killer Presentation
Learn effective techniques for crafting and delivering impactful presentations that captivate your audience and convey your message with clarity and confidence.
Branding Yourself for a Dream Job - The Modern Resume
Discover strategies to enhance your professional brand, create impactful resumes, and leverage online profiles for career advancement in the data industry.
Who's Responsible - The Vendor or the DBA?
Explore the roles and responsibilities of database vendors and DBAs in managing SQL Server environments, addressing common challenges and best practices.
Building a Professional Development Plan
Develop a strategic roadmap for career growth in data management, focusing on key skills, networking, and continuous learning opportunities.
No More Bad Dates - Best Practices for Working With Dates and Times
Learn best practices for handling dates and times in databases, avoiding common pitfalls and optimizing performance for date-related queries and operations.
SQL Server Execution Plans - From Compilation to Caching to Reuse
Comprehensive exploration of SQL Server execution plans, covering compilation, caching, reuse, and optimization strategies for improved database performance and scalability.
Query Optimizer Deep Dive
Explore advanced techniques for optimizing SQL queries, enhancing database performance, and mastering the intricacies of query execution plans with expert Paul White.
Page and Row Compression Deep Dive
Explore advanced techniques for optimizing database performance through in-depth analysis of page and row compression strategies for DBAs.