Temporal Tables and Their Role in ETL and Data Warehouse
Explore temporal tables in SQL Server, their functionality, and applications in ETL and data warehousing. Learn implementation, querying techniques, and considerations for effective use.
Winning with Column Store in SQL Server 2016 - A Customer Story
Explore SQL Server 2016's Column Store feature through a real customer migration case, covering challenges, best practices, and performance improvements in data warehousing.
Four Reasons to Migrate Your SQL Server Databases to the Cloud
Explore AWS solutions for SQL Server migration, covering deployment, security, performance monitoring, scaling, storage options, and high availability features.
Columnstore Technology Improvements in SQL Server 2016
Explore the latest enhancements to Columnstore technology in SQL Server 2016, improving database performance and efficiency for large-scale data processing and analytics.
Advanced R Analytics in SS2016 Using R Tools for Visual Studio
Explore advanced R analytics using R Tools for Visual Studio, covering predictive modeling, data access, parallelization, and integration with SQL Server for improved performance and efficiency.
SQL Server 2016 Always On Availability Groups Enhancements
Explore SQL Server 2016 Always On Availability Groups enhancements, including improved failover, security, and performance features for high availability and disaster recovery.
A Gentle Introduction to Data Analytics in SQL Server 2016
Explore data analytics using SQL Server 2016, comparing it to BI and data science. Learn to organize data, use Power BI, R, and Analysis Services for exploration and visualization techniques.
What's New in SQL Server 2016 Analysis Services
Explore new features in SQL Server 2016 Analysis Services, including Extended Events, Tabular Mode enhancements, DAX functions, and Direct Query improvements for more powerful data analysis.
Predictive Analytics Using R and SQL
Explore predictive analytics concepts, applications, and integration with BI environments. Learn data science processes, methodologies, and practical techniques using R and SQL for effective predictions.
Common Data Science Mistakes
Explore common pitfalls in data science, from data preparation to analysis. Learn to avoid mistakes in statistics, outlier handling, and visualization for more accurate insights and predictions.
Turning Membership Surveys Into Action - Predictive Analytics
Learn to transform membership survey data into actionable insights using factor analysis and predictive modeling techniques for more effective decision-making and stakeholder engagement.
Digital Storytelling with Power BI
Learn to leverage Power BI's features for effective data storytelling, guiding users to better understand their information through visualization and narrative techniques.
Data Storytelling 101
Learn effective data storytelling techniques to create impactful visual narratives, focusing on key elements like goal-setting, snapshots, and actionable insights for compelling business intelligence presentations.
Spatial Data Analysis in Power BI
Learn to create stunning thematic maps and perform impactful spatial data analysis using Power BI's ArcGIS Maps and MapBox Visual for enhanced data visualization and insights.
Data Science Success Using Microsoft Azure - Predictive Analytics
Explore data science options in Microsoft Azure, including Power BI, Cortana Intelligence Suite, and HDInsight. Learn about pre-built machine learning algorithms and tools for tackling various data science needs.
Azure Machine Learning Studio and PowerBI - Predictive Analytics
Explore differences in data loading between Azure ML Lab and PowerBI, focusing on predictive analytics techniques and data visualization for effective decision support systems.
Adding Data Quality - Kimball Data Warehouse
Learn to enhance small to mid-size Kimball data warehouses with a design architecture for capturing, measuring, and relating data quality issues to existing fact and dimension tables.
Transaction Log for Developers
Explore transaction log architecture, batching, rollbacks, and their impact on performance. Gain insights to optimize database operations and enhance system efficiency.
Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage
Learn to monitor SQL Server instances using extended events, capturing data for CPU utilization, resource usage, and performance analysis. Gain insights into best practices and practical implementation techniques.
Building Modern Data Pipelines with Spark on Azure HDInsight
Explore common patterns for building end-to-end data analytics pipelines using Apache Spark on Azure HDInsight, covering architecture, integration points, and various pipeline options.
Open Source Databases - Summit Preview
Learn to centrally monitor, diagnose, and report on open source databases alongside SQL Server, Oracle, and DB2 deployments in a single pane of glass.