SQL Bad Practices
Aprenda práticas inadequadas de SQL e como evitá-las para melhorar o desempenho e a manutenção de seus bancos de dados.
Entendendo o Transaction Log
Explore o Transaction Log do SQL Server, sua importância, funcionamento e impacto no desempenho do banco de dados nesta palestra técnica em português.
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.
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.
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.
The Top 8 Reasons for Your Transaction Performance Problems
Explore the top 8 causes of transaction performance issues and learn effective strategies to identify, troubleshoot, and optimize database performance for improved efficiency.
Beginners Guide to MDX
Explore MDX fundamentals, including T-SQL queries, star schemas, and cube visualization. Learn key concepts like sets, tuples, and subcubes through demos and practical examples.
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.
Finding Your Balance - BI in the Cloud, On Premises, or Both
Explore BI solutions across cloud, on-premises, and hybrid environments. Learn about Power BI, SQL Server, Azure services, and tools for effective data analysis and decision-making.
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.
Curious Cases of Availability Groups
Explore common and unique challenges in implementing AlwaysOn Availability Groups, with practical solutions and insights for seamless production deployment.
Offline Database Development and Unit Testing with SSDT
Explore offline database development, unit testing, and customization in SQL Server Data Tools. Learn to create test projects, write T-SQL unit tests, and extend functionality with C#.
SQL Server Agent - The Life Preserver for the Drowning DBA
Learn to automate DBA tasks using SQL Server Agent. Discover job creation, alerts, monitoring, and common pitfalls to streamline your database management and boost efficiency.
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.
Data Pages, Allocation Units, IAM Chains Oh My!
Explore SQL Server's data organization, including row structure, data pages, and index types. Learn how understanding these internals can improve database design and performance.
Azure IOT - A Practical Introduction to Stream Analytics
Explore Azure Stream Analytics for real-time IoT data processing. Learn to capture, analyze, and present device data streams, integrating with Microsoft's IoT suite for business insights.
Common Table Expressions - Advanced
Explore advanced Common Table Expressions: recursive queries, hierarchical data, data manipulation, common use cases, performance considerations, and classic recursive algorithms in SQL Server.
Every Byte Counts - Why Your Data Type Choices Matter
Explore how data type choices in SQL Server impact performance and storage efficiency. Learn best practices for optimizing database design and mitigating performance issues through informed data type selection.
Database Design - Solving Problems Before They Start
Explore key database design principles to prevent future issues. Learn about data types, normalization, and naming conventions through live demos, enhancing your TSQL skills and decision-making abilities.
Making the Leap from Developer to DBA
Discover strategies for transitioning from developer to DBA, including essential skills and knowledge needed for success in database administration.
Optimizing Your Data Warehouse for OLAP Processing
Optimize data warehouse processing for OLAP with SSAS best practices, enterprise features, and database engine alignment. Learn compression, partitioning, and file group strategies for 200%+ performance improvement.