Alta Disponibilidade com Azure SQL Database
Explore alta disponibilidade no Azure SQL Database, aprendendo estratégias e práticas para garantir operações contínuas e confiáveis em ambientes de nuvem.
Query Store no SQL Server 2016
Explore Query Store in SQL Server 2016, a powerful feature for performance tuning and query optimization, presented in Portuguese by Andre Batista.
SQL Azure Database
Explore SQL Azure Database fundamentals, features, and best practices with expert Vitor Faria Tomaz in this comprehensive Portuguese-language session.
Business Analytics Marathon - Tools for Exploratory Data Analysis
Explore essential tools for data analysis, including Power Query and Pivot Tables, with practical demos and insights into machine learning applications.
Modular Data Extraction and Integration Patterns
Explore modular data extraction and integration patterns for efficient business analytics, enhancing data-driven decision-making processes.
Hacking Exposé Too - Just How Transparent is TDE?
Explore Transparent Data Encryption (TDE) in SQL Server, its implementation, and potential vulnerabilities through hands-on demonstrations and practical insights.
Index Internals - RowStore, ColumnStore, and NoStore
Explore index internals in SQL Server, covering RowStore, ColumnStore, and NoStore structures. Learn when to use each type and understand their performance implications.
Taking the Scare out of Monster Reports - Pam Shaw
Learn techniques to simplify complex reporting tasks, focusing on breaking down large projects, handling disparate data, and creating efficient dashboard and control table solutions.
Integrating SQL Server Analysis Services with Hadoop
Explore the integration of SQL Server Analysis Services with Hadoop, focusing on leveraging big data for enhanced business intelligence and analytics capabilities.
Optimize All Data with a Modern Data Warehouse Solution
Explore modern data warehouse solutions for optimizing data lifecycle, enhancing business insights, and maximizing value from your data infrastructure.
50 Things All SQL Server Developers Need to Know
Discover 50 essential SQL Server development tips, covering database design, T-SQL best practices, and query optimization techniques for improved performance and efficiency.
7 Tips to Performance Tuning, Optimization, and Everything
Learn essential performance tuning and optimization techniques for databases from expert Pinal Dave. Discover practical tips to enhance efficiency and solve common challenges.
How to Be a Ninja - Troubleshooting SQL Performance
Learn advanced SQL performance troubleshooting techniques, including storage tips, best practices, and optimization strategies for efficient database management and improved query execution.
What's New for High Availability in SQL Server 2016
Explore SQL Server 2016's high availability features, including WSFC enhancements, Storage Replica, Storage Spaces Direct, and Availability Group improvements for robust database management.
Hadoop Essentials for the SQL Server Professional
Learn Hadoop essentials, including HDFS, MapReduce, and Hive, with a focus on comparisons to SQL Server. Explore on-premises and cloud options for implementing Hadoop ecosystems.
The Enterprise Scripting Workshop
Learn enterprise scripting techniques to automate database tasks, improve productivity, and avoid common mistakes. Covers cursor usage, multi-database operations, and object deployment strategies.
Don't Repeat Yourself - An Introduction to Agile SSIS Development
Learn to streamline SSIS development using Biml and BimlScript. Generate packages from metadata, implement changes efficiently, and reuse code across projects for faster, more agile development.
Understanding and Visualizing Data Using R in SQL Server
Explore data analysis using R with SQL Server. Learn to connect, validate, and visualize data through statistical methods and reporting tools. Includes sentiment analysis demo of Twitter PASS MVP Summit.
Curious Cases of Availability Groups
Explore common and unique challenges in implementing AlwaysOn Availability Groups, with practical solutions and insights for seamless production deployment.
SSAS Design and Performance Best Practices
Explore scalable SQL Server Analysis Services cube design patterns and optimization techniques to enhance SSAS performance for your organization's needs.
The Art and the Science of Designing a Mission Critical SQL Server Solution
Explore mission-critical SQL Server design archetypes, selecting optimal features for high availability and scalability. Learn best practices and real-world advice for robust database system implementation.