Advanced Scripting Using SSIS Script Tasks and Components
Enhance SSIS workflows with advanced scripting techniques for file management, dynamic business rules, and performance optimization.
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.
Distributed Replay Testing with Your Data, Your Way
Explore distributed replay testing for SQL Server, covering limitations, components, configuration, and practical applications for optimizing database performance.
Leadership Without Borders - Working with Global Teams
Develop effective leadership skills for managing diverse global teams, focusing on communication, cultural awareness, and collaboration across time zones and geographical boundaries.
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.
Building Better SSIS Packages
Discover techniques for building robust, efficient SSIS packages with improved reliability, maintainability, and security in this comprehensive tutorial on SQL Server Integration Services.
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.
Stress Inoculation - Maintaining Performance Under Pressure
Learn techniques to maintain peak performance under pressure, enhancing resilience and stress management skills for professional and personal growth.
Introduction to the Power BI Designer
Explore Power BI Designer: Create reports, connect data sources, and build dashboards efficiently. Learn setup, features, and future developments in this comprehensive introduction.
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.
The Data Loading Performance Presentation
Optimize massive data loading in SQL Server with techniques from Microsoft's whitepaper and beyond, covering minimal logging, indexing, parallelism, and more.
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.
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.
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.
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.