Deep Dive with Data Migration Tools and Azure Database Migration Service - DMS
Explore SQL Server migration to Azure with near-zero downtime using Microsoft's tools. Learn to assess, plan, and execute migrations efficiently across your data estate.
Making the Leap to Management
Learn strategies for transitioning from technical expert to effective team leader. Develop a personal action plan, discover suitable roles, and prepare for a successful leap into management while avoiding common pitfalls.
Effective Requirements Gathering for Successful Project Outcomes
Learn best practices for gathering project requirements, including scoping, stakeholder communication, documentation, and avoiding common pitfalls. Improve project outcomes and stakeholder satisfaction.
What's New in SQL Server Tools
Explore upcoming features in Azure Data Studio and SQL Server tools, including SQL Notebooks. Learn about recent improvements and get a first look at highly requested functionalities to enhance your database management experience.
Ingesting and Managing Petabytes of Data with Azure Data Factory
Explore improvements in Azure Data Factory for simplified data integration and management, including code-free ETL/ELT and comprehensive data overview, empowering enterprises to handle petabytes of data for valuable insights.
Choice with Compatibility - SQL Server 2019 on Linux and Containers
Explore SQL Server 2019's enhanced capabilities on Linux and containers, including new features like Replication, DTC, and Polybase, for a robust enterprise database solution across diverse platforms.
SQL Server in Azure Virtual Machine Re-Imagined
Explore new features of SQL Server on Azure VM: enhanced manageability, improved performance, flexible licensing, and integration with unified Azure SQL Service for optimal database management.
Reporting Services - A Smart Migration Strategy
Discover strategies for migrating to Power BI Report Server, utilizing ReportServer database metadata to determine which reports and data sources to migrate, and learn PowerShell techniques for efficient extraction and migration.
Infrastructure for the DBA - An Introduction
Comprehensive overview of infrastructure layers for DBAs, covering hardware, network, storage, virtualization, and operating systems to enhance problem-solving and proactive management skills.
Hidden Gems of SQL Server 2019
Discover lesser-known features and improvements in SQL Server 2019 beyond the main highlights, exploring hidden capabilities that can enhance database management and performance.
Best, Better, Hyperscale! The Last Database You Will Ever Need in the Cloud
Explore Azure Hyperscale: a cloud-native, scalable database solution offering SQL Server features for innovation and future-proofing. Learn deployment patterns, best practices, and its underlying architecture.
AI for Developers
Explore Azure AI platform's tools, infrastructure, and services for integrating AI into existing applications. Learn skills needed to become an AI developer and create intelligent solutions.
Hidden Differences Between Azure ML Products Revealed
Explore Azure ML products, their differences, and use cases. Learn to create end-to-end ML workflows, integrate with SQL Server, and manage models in production using various Azure tools.
Removing the SELECT * - Helping Your App Developers and Yourself
Optimize database performance by understanding ORM frameworks, LINQ, and application impact. Learn to improve queries, enhance developer collaboration, and boost your value as a data professional.
Azure Data Studio - The Challenger
Explore Azure Data Studio's features, benefits, and comparison to SQL Server Management Studio. Learn about its cross-platform capabilities, monitoring tools, and use cases.
Data Quality Round-trip in the MS Dataplatform
Explore comprehensive data quality solutions using Microsoft's Data Platform, including Machine Learning, Azure Data Factory, and SQL Server 2019, to address and resolve data quality challenges.
Architecture Blueprints for Power BI Implementation
Learn essential architecture design principles for Power BI solutions, covering sharing, security, connections, and components like dataflow. Gain insights into key considerations and blueprint designs for effective implementation.
Data Privacy, Security, Ethics and Compliance in a Data-Driven World
Explore ethical challenges in data-driven technologies, focusing on privacy, security, and compliance. Learn tools and strategies to mitigate risks and maintain integrity in the evolving landscape of AI and big data.
How I Would Attack SQL Server
Explore SQL Server vulnerabilities and attack strategies from an adversary's perspective, learning detection, prevention, and response techniques for enhanced database security.
Columnstore Indexes in 2017-2019
Explore recent enhancements to Columnstore Indexes in SQL Server 2017-2019, focusing on performance improvements for Data Warehouses and BI solutions. Learn about new features and fixes for high-scale environments.
Entity Framework Debugging Using SQL Server - A Detective Story
Aprenda a depurar consultas LINQ de Entity Framework investigando SQL Server. Técnicas para otimizar el rendimiento mediante configuración, perfilado y planes de ejecución.