Understanding Accelerated Database Recovery
Explore SQL Server 2019's Accelerated Database Recovery feature, its mechanics, benefits, and implementation in on-premises and Azure environments for rapid recovery and instant transaction rollback.
Real-World Challenges to Implementing Database DevOps
Explore practical strategies for implementing database DevOps, addressing challenges in data management, and optimizing deployment processes for both on-premises and cloud-based environments.
SQL Professional to Cosmic Superstar in 75 Minutes
Transition SQL Server skills to CosmosDB: Learn NoSQL concepts, JSON, multi-models, and key differences in monitoring and data structure. Prepare for a new approach to database management and optimization.
Notebooks, PowerShell, and Excel Automation
Automate Excel tasks using PowerShell and Jupyter Notebooks. Learn to create self-service solutions for users to generate custom Excel workbooks efficiently and effectively.
Do You Feel the Need the Need for Speed in SQL Server Database?
Discover efficient SQL Server query tuning techniques using Quest Foglight and SQL Optimizer. Learn to identify bottlenecks, analyze execution plans, and optimize database performance systematically.
A Deep Dive into Execution Plans & How to Use Them
Explore SQL Server Query Optimizer's execution plans, learn to read and fine-tune them for better performance, and master troubleshooting techniques to enhance database efficiency.
Moving Data with Azure Data Factory
Learn to build native ADF pipelines, lift and shift SSIS to Azure, and use design patterns for execution and monitoring in this comprehensive overview of Azure Data Factory's cloud data engineering capabilities.
Modernize Your SQL Applications Recently Enhanced Version Azure SQL Managed Instance
Explore Azure SQL Managed Instance's latest enhancements for modernizing SQL applications, including improved migration, security, and manageability features for optimal cloud transformation.
Giving Feedback - How to Effectively Communicate to Your Employees
Learn essential soft skills for effective feedback and communication as a manager. Discover best practices for coaching conversations, handling tough dialogues, and addressing performance issues tactfully.
How to Put DevOps Into Action for Your Databases
Learn to implement DevOps practices for database deployments, covering source control, automated testing, and continuous integration/delivery through live demonstrations and practical insights.
Statistics Techniques Can Fix Tough Performance Issues
Explore advanced statistics techniques to optimize query performance, including filtered statistics, computed columns, sample size adjustments, and solutions for stale statistics and correlated columns.
Developer Best Practices in SQL Server
Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.
From Docker to Big Data Cluster - A New Era for SQL Server
Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.
Microsoft SQL Server Machine Learning Workloads on Red Hat Enterprise Linux and Red Hat OpenShift
Accelerate machine learning pipelines using SQL Server on Red Hat Enterprise Linux and OpenShift. Learn in-database ML techniques and containerization for efficient model production and deployment.
Inclusive Presentation Design
Learn techniques for creating accessible presentations that maximize learning for audiences with diverse abilities, enhancing content delivery and impact for all viewers.
The Cases of The Unexplained Memory Problems
Explore advanced SQL Server memory usage troubleshooting through real-world cases, addressing complex issues and providing solutions for optimizing database performance.
Polybase - It's What's for Dinner!
Explore Polybase, Microsoft's linked server replacement, for connecting to diverse data sources. Learn setup best practices, scale-out groups, AlwaysOn integration, and performance optimization techniques.
Migrating Oracle Workloads to Azure
Learn strategies for migrating Oracle databases to Azure, including architecture design, deployment automation, and success factors for moving to IaaS while leveraging both Oracle and Azure products.
Microsoft Power BI - Business Intelligence Strategy, Vision, and Roadmap Update
Explore Microsoft Power BI's latest features and future roadmap for driving data-driven decision-making across organizations, presented by BI leadership at PASS Data Community Summit.
Azure SQL Is the Best Choice for Building Back-End REST API - Discuss
Explore Azure SQL's capabilities for building high-performance, scalable REST APIs with JSON support, CI/CD integration, and robust security features for modern agile development.
Deployment, High Availability & Performance Guidance for SQL Server Linux Azure IaaS Ecosystem
Explore deploying SQL Server on Linux in Azure, covering high availability, AD authentication, and performance optimization for production environments.