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.
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.
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.
Introduction to Data Mining in SQL Server Analysis Services
Learn to create and integrate data mining models in SQL Server Analysis Services for customer prediction, marketing optimization, and forecasting using various algorithms and tools.
Developing and Managing a Business Intelligence Semantic Model in SQL Server Analysis Services
Learn to create, manage, and troubleshoot BI Semantic Models using SQL Server "Denali" features, with PowerPivot as a starting point for enhanced business intelligence capabilities.
PowerPivot - A Cool Reporting Tool
Explore PowerPivot for Excel to combine diverse data sources, create analytics, and overcome Excel limitations. Learn to import, pivot, and visualize data for self-service business intelligence.
Reporting with Crescent - Your Organization's Got Talent
Become a Crescent hero and delight business users with beautiful, meaningful self-service reporting for your organization.
Many-to-Many Relationships in DAX
Explore advanced DAX techniques for handling many-to-many relationships in data modeling, with practical examples and insights into the Vertipaq engine's capabilities.
Swimming in the Data Lake
Explore data lake concepts, best practices, and tools for effective data management and analytics in modern cloud environments.
Perfect Fits for Azure SQL Database Migrations
Explore Azure SQL Database migrations, including challenges, limits, and best practices for new projects, instrumentation, web apps, parallel processing, and data warehousing.
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.
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.
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.
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.
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.
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.
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.
DBA's Proper Handling of Corruption
Learn to detect and plan for database corruption, including monitoring techniques, backup strategies, and recovery options for effective disaster management.
Database DevOps to Ensure Compliance
Discover how Database DevOps can streamline your software development process, ensuring compliance and gaining approval from auditors and security staff. Learn to implement best practices for efficient and secure database management.