SQL Server 2016 Hero Features in Action - Full Lifecycle of Financial Data
Explore SQL Server 2016's hero features, including record-breaking performance, enhanced availability, in-memory OLTP, and secure data protection, with practical applications in financial data management.
Relational Databases vs Non Relational Databases vs Hadoop
Explore the differences between relational, non-relational databases, and Hadoop, covering origins, key features, use cases, and Microsoft's data platform solutions.
Using JSON with SQL Server 2016
Explore JSON integration in SQL Server 2016, covering history, examples, support features, and practical applications for efficient data handling and querying.
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.
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.
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.
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.
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.
Performance Tuning Wisdom Needs Expiration Dates
Brent Ozar and Erik Darling challenge conventional SQL Server performance tuning wisdom through demos, debunking myths about indexing, scans, and seeks while offering updated insights for effective database optimization.
Monitoring Page Splits in SQL Server - Cross-Platform SQL Server Management
Learn to accurately monitor page splits in SQL Server, debunking common misconceptions and exploring the only documented method for correct monitoring. Gain insights into transaction logs and best practices.
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.
Essential Linux for the DBA - Cross-Platform SQL Server Management
Learn essential Linux skills for database administration, focusing on cross-platform SQL Server management. Gain insights from a multi-platform DBA with extensive Unix/Linux experience.
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.
Azure Data Lake - Summit Preview
Explore Azure Data Lake technologies, their benefits, challenges, and implementation strategies for effective big data storage, processing, and analysis in the cloud.