10 Cool Things You Can Do With Azure Databricks
Discover 10 practical Azure Databricks applications through live demos, including VS Code integration, streaming with Event Hub, and Delta time travel, enhancing your data engineering skills.
Azure Storage Options for Analytics
Explore Azure storage options for analytics, including data lakes and databases. Learn best practices, structures, and appropriate choices for different scenarios to build effective data ecosystems.
On-Premises Power BI and Reporting - Reporting Services 2019
Explore on-premises Power BI reporting with PBIRS: installation, configuration, report development, and management through the portal. Learn tips for leveraging on-premises features effectively.
Using Open Source Software to Collect Performance Metrics
Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.
Elementary! The Curious Case of Deceptive Query Optimizer
Uncover the mysteries of SQL Server Query Optimizer through case studies, investigating performance issues and revealing unexpected culprits in query execution plans.
Improving Availability in SQL Server and Azure SQL Database with Accelerated Database Recovery and Resumable Operations
Discover innovations in SQL Server 2019 and Azure SQL Database that enhance database availability, reduce downtime, and streamline maintenance operations for improved performance and reliability.
Dynamic SQL - Writing Efficient Queries on the Fly
Learn to create fast, efficient queries using Dynamic SQL for automating complex processes, facilitating reporting, and solving seemingly impossible problems. Explore best practices, applications, and maintenance techniques.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
Everyone Has a Story to Tell - Developing Your First Presentation
Learn to create and deliver your first presentation with expert tips on idea development, content creation, and effective delivery techniques.
Enabling End to End Scenarios with Data Virtualization in SQL Server 2019
Explore SQL Server 2019's data virtualization for seamless querying of Oracle tables, with enhanced features like data classification and server-based auditing for comprehensive data management solutions.
Real-time Sentiment Prediction in SQL Server
Explore CosmosDB's capabilities for high-volume transactions, global distribution, and diverse data types. Learn to set up a local instance, load JSON data, create PowerBI visualizations, and seamlessly transition to the cloud.
Data Classification and Masking - The What and How of Data Protection
Learn techniques for protecting sensitive data across systems using SSMS and SQL Server tools. Explore data classification, dynamic and static masking to ensure data security while maintaining accuracy for testing and analytics.
Dipping Your Toes In - Azure Data Lake for DBAs
Explore Azure Data Lake basics, including storage, security, and U-SQL. Learn how this technology complements relational database skills and discover real-world use cases for data professionals.
SQL PowerShell 2019 - The Lingua Franca for the Data Platform
Explore PowerShell's versatility in managing diverse data platforms, from Excel to Azure SQL. Learn object-based data handling, code documentation, and sharing through PowerShell Notebooks for seamless integration across Microsoft data products.
Best Practices for Branching Database Code in Git
Learn best practices for branching database code in Git, covering strategies for different team sizes and release requirements. Explore popular branching models and their strengths, with special focus on database-specific considerations.
Power BI Data Privacy Settings Deep Dive
Explore Power BI data privacy settings: configuration, impact on performance, and error prevention. Learn to optimize query speed while ensuring sensitive data protection across sources.
Dr. DMV's Troubleshooting Toolkit
Comprehensive toolkit for SQL Server diagnostics using Dynamic Management Views. Learn to identify performance bottlenecks, optimize queries, and fine-tune database configurations for enhanced efficiency.
A Behind the Scenes Look at ML, AI, and Deep Learning
Explore the mechanics of ML, AI, and Deep Learning, understanding their differences and inner workings. Gain fundamental knowledge to support decision-making and organizational AI initiatives.
Neither Here Nor There - Hybrid AO SQL Architecture On-Prem - Azure
Explore hybrid Always On SQL architecture, transitioning from on-premises to Azure Cloud. Learn configuration, troubleshooting, and best practices for global architecture in this eToro case study.
Six Ways to Improve SQL Server Application Security
Explore six mindsets for enhancing SQL Server application security, covering encryption, key management, data governance, and more. Gain actionable strategies to improve database development security.
Azure Machine Learning 101
Explore Azure ML's no-code approach to machine learning, from data preparation to model deployment, suitable for both beginners and experienced data scientists.