Create Your First SSAS Tabular Model
Learn to create your first Analysis Services Tabular model using Visual Studio. Import tables, establish relationships, and write formulas for data browsing with Excel and Power View.
Business Intelligence Toolkit Overview - Microsoft Power BI and R
Explore data visualization with Power BI and R, focusing on cognitive psychology theory and practical applications for creating effective dashboards and analyses.
SQL Server AlwaysOn Quickstart
Explore SQL Server AlwaysOn for high availability and disaster recovery, covering Windows Clustering, SQL Clustering, and Availability Groups. Learn configuration, new capabilities, and SQL Server 2014 updates.
DAX Formulas in Action
Explore DAX formulas for BI solutions in Excel and SQL Server. Learn to create calculated columns, measures, and effective PivotTable analysis through hands-on demonstrations.
Agile Data Warehousing - Start to Finish
Learn agile data warehousing techniques to streamline production, maintenance, and evolution using SQL Server Data Platform, balancing cost-cutting and resource investment for optimal business value.
AMA Open Questions and Answers on SQL Server 2014 In Memory OLTP
Open Q&A session addressing queries about SQL Server 2014 In-Memory OLTP, offering expert insights and solutions for database professionals seeking to optimize performance.
The Role of Polybase in the Modern Data Warehouse
Explore PolyBase's role in modern data warehousing: streamline ETL, export dimensions, use Hadoop for archiving, and enrich relational data with ambient data from Hadoop.
Field Testing Buffer Pool Extension and In Memory OLTP Features
Explore SQL Server 2014's In-Memory OLTP and Buffer Pool Extension features through field testing results, benchmarks, and real-world examples to enhance database performance and scalability.
AMA Open Questions and Answers - SQL Server in Azure VMs
Live Q&A session with SQL Server Product Managers addressing user-submitted questions about SQL Server 2014 in Azure Virtual Machines, offering expert insights and solutions.
AMA Open Questions on SQL Server 2014, Microsoft Azure, and Big Data
Live Q&A session with SQL Server Product Managers addressing user-submitted questions on SQL Server 2014, Microsoft Azure, and Big Data technologies.
Changes to Query Plans
Explore SQL Server 2014's impact on query plans, focusing on statistics management for large tables and the redesigned cardinality estimator for improved plan costing and performance optimization.
In Memory OLTP Memory Storage Monitoring and Troubleshooting
Explore In-Memory OLTP monitoring, troubleshooting, and management using familiar tools like PerfMon, Profiler, DMVs, and XEvents for optimal performance and operational stability.
Patterns and Practices for Scaling Microsoft Azure SQL Database
Explore patterns and best practices for building scalable databases in Azure SQL Database, covering scale-up vs. scale-out models, horizontal partitioning, and tips for managing cloud database complexities.
In Memory OLTP Performance Troubleshooting
Troubleshoot In-Memory OLTP performance issues: diagnose and resolve log IO bottlenecks, index tuning, and query plan problems to achieve desired performance improvements.
Open Questions and Answers on Azure SQL Database
Live Q&A session with SQL Server Product Managers addressing user-submitted questions about Azure SQL Database, offering expert insights and solutions.
Designing Modern Apps Using New Capabilities in Azure SQL Database
Explore Azure SQL Database's latest features for designing mission-critical cloud applications, focusing on business continuity and performance optimization through architectural patterns and demos.
A Case Study Featuring In Memory OLTP and Hybrid Cloud Scenarios
Practical insights on upgrading mission-critical databases to SQL Server 2014, implementing In-Memory OLTP, Managed Backup, and Azure Storage integration for large workloads.
Migration and Deployment for SQL Server in Azure Virtual Machines
Explore migration and deployment strategies for SQL Server in Azure VMs, covering recommended principles and tools for efficient cloud-based database management.
AMA Open Questions and Answers on SQL Server 2014 HA-DR in the Cloud
Live Q&A session with SQL Server Product Managers addressing High Availability and Disaster Recovery solutions for SQL Server 2014 in cloud environments.
Power BI Deep Dive
Explora las nuevas capacidades de Excel y Office 365 para Business Intelligence. Descubre, analiza y visualiza datos en Excel, y comparte tus hallazgos a través de Office 365.
Back up to the Cloud
Learn to seamlessly back up SQL Server databases to Azure cloud storage using SQL Server Management Studio, enhancing data protection and disaster recovery strategies.