ABCs of the Power BI REST API
Explore managing Power BI content using REST API, covering dashboards, datasets, reports, and groups. Learn to automate tasks, retrieve information, and enhance Power BI workflow efficiency.
Failure Prediction for Manufacturing Industry with SQL Server & R
Explore predictive modeling for manufacturing failure using SQL Server and R. Learn regression, binary classification, and random forest techniques to forecast product failures and estimate lifespans.
Successful ORM Design Strategies
Explore effective Object Relational Mapper design patterns for improved data access, schema management, and object structures. Learn strategies to ensure maintainable and flexible ORM implementations.
AI for the BI Professional
Explore AI integration in BI solutions for enhanced data insights. Learn to use pre-built AI tools, consume data scientist models, and leverage Power BI's AI features for intelligent reporting.
AI Cognitive Services - Vision 101
Introduction to Azure's Computer Vision and Custom Vision APIs, covering basics, model creation, training, and implementation using Python in Azure Notebooks.
Batch Execution Mode on Rowstore Indexes
Explore SQL Server 2019's Batch Execution Mode for Rowstore Indexes, its benefits, challenges, and optimal usage scenarios to significantly enhance workload performance.
Never Lose Data - Digging Out From Corruption
Learn essential recovery techniques to prepare for, detect, and repair various corruption-based problems in databases, ensuring data integrity and minimizing disruptions in your enterprise.
Working with SQL Server Containers to Build Database Solutions
Explore efficient SQL Server solution deployment using containers, covering basic and advanced methods, real-world scenarios, and cross-platform portability for streamlined database management.
Managing and Monitoring SQL Server on Linux from the Command Line
Explore command-line tools for managing SQL Server on Linux, including installation, configuration, and monitoring. Learn to leverage bash for querying DMVs and gain insights for seasoned command-line users.
Azure SQL Database Edge - Overview
Explore Azure SQL Database Edge: optimized for edge computing with streaming support, machine learning, and "develop once, deploy anywhere" capabilities. Learn about features, deployments, and customer scenarios.
Database CICD - Continuous Integration and Deployment
Learn to automate database operations and deployments for efficient management of hundreds of databases, meeting industry demands for faster, streamlined processes.
Azure SQL Database - Lessons Learned from the Trenches
Discover best practices, tips, and monitoring techniques for optimizing Azure SQL Database performance in production environments, based on real-world Microsoft CSS support cases and customer engagements.
Continuous Intelligence - What's This All About?
Explore Continuous Intelligence, combining Continuous Integration and Business Intelligence for flexible BI application deployment. Learn advantages, challenges, and implementation strategies for Analysis Services.
Using PowerShell on Linux
Learn to install and use PowerShell on Linux, interact with Azure and SQL Server, and discover its potential for Linux administrators. Explore use cases and resources for further learning.
HA - DR - Too Many Choices
Explore various high availability and disaster recovery options for SQL Server, weighing pros and cons to find the best fit for your company's needs and requirements.
Linux Fundamentals for SQL Server DBAs
Explore SQL Server on Linux: installation, configuration, and management. Learn essential Linux commands and file systems for DBAs transitioning to this open platform.
ETL in Azure Made Easy with Data Factory Mapping Data Flows
Explore Azure Data Factory's Mapping Data Flows for efficient, scalable ETL without coding. Learn to transform data using Databricks integration and graphical tools.
The Power Platform Game Changer
Comprehensive guide to building and deploying business apps using Microsoft Power Platform, covering PowerApps, Flow, SQL Server, Power BI, and Cortana with focus on security and enterprise governance.
Understanding Execution Plans
Explore SQL Server execution plans to optimize query performance. Learn to capture, read, and analyze plans, identifying potential issues and understanding key operations for efficient database queries.
MDS from the Ground Up - Let Your Users Maintain Their Data
Master Data Services (MDS) empowers users to manage data quality and governance. Learn how MDS integrates with Excel, enforces data standards, and streamlines operational and analytical solutions.
Data Warehousing - Which of the Many Cloud Products is the Right One for You
Explore cloud-based data warehousing options, comparing Snowflake, Databricks, and Azure solutions. Learn to choose the best fit for your environment based on size, architecture, and unique features.