SQL Server and Azure Data - What to Use When
Explore SQL Server deployment options across on-premises, cloud, and hybrid environments. Learn decision-making strategies for modernizing your data platform and choosing the right solution for your needs.
Operationalize Data Science for Advanced Decision Support
Learn to develop and integrate predictive models using Azure Machine Learning, enhancing organizational decision-making through data science principles, best practices, and a real-world case study.
Introduction to Data Governance
Demystifying data governance: Learn its importance, core concepts, and practical implementation strategies for effective organizational data management.
How Do I Ensure My Azure Modern Data Warehouse Is Secure
Comprehensive guide to securing Azure-based data platforms, covering network security, client connections, firewalls, VNET rules, and Azure AD. Includes SQL security features and encryption options for robust data protection.
Turbocharge Your SQL Server with In-Memory Database
Discover how to leverage SQL Server 2019's memory-optimized technologies to enhance performance and scalability, taking advantage of modern hardware innovations for database applications.
Power BI Report Server Enterprise Architecture, Tools to Publish
Explore enterprise-grade Power BI Report Server architecture, publishing tools, and best practices for improved performance, security, and scalability in large-scale implementations.
Build Your Brand with Technical Writing
Discover how technical writing can boost your career, enhance your brand, and make a global impact. Learn about the publishing process and strategies to kickstart your writing journey.
What's in a Name? Data Stories that Would Make the Bard Proud
Learn to transform U.S. Census Bureau data on children's names into captivating stories. Discover techniques for identifying key data points, creating effective visualizations, and crafting compelling narratives to engage any audience.
Query Optimization Statistics - Driving Force Behind Performance
Explore SQL Server query optimization statistics, their impact on performance, and techniques to address common issues for improved query execution.
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.
Different Types of Many-to-Many Relationships in Power BI
Explore various many-to-many relationships in Power BI, including classical, simple, and filter propagation. Learn when and how to use different types with practical examples and understand their impact on data modeling.
Microsoft Power BI - Business Intelligence Strategy, Vision, and Roadmap Update
Explore Microsoft's BI strategy and roadmap with Power BI leadership. See demos of latest enterprise features and learn how to leverage data for organizational success.
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.
Aggregations in Power BI
Explore high-performance data analysis using Power BI Aggregations. Compare with Analysis Services, learn implementation strategies, and understand architectural approaches for optimized analytical solutions.
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.
Choosing Your Cloud - Step 2 in Your Cloud Migration Journey
Explore cloud vendor strengths, migration tools, and service mapping for OLTP and BI-stack migrations. Learn to evaluate single-vendor benefits and challenges for informed cloud platform selection.