Availability and Infrastructure for SQL Server Deployments
Explore SQL Server's 20-year evolution in availability and infrastructure. Learn about virtualization, storage trends, clustering, and future developments in this comprehensive overview.
Modelado y carga de datos con SSAS
Explora el papel de SSAS en Azure para soluciones BI, aprende sobre modelado y carga de datos, y descubre cómo visualizar información con Power BI y Excel.
Install & Configure SQL Server with PowerShell DSC
Implement infrastructure as code for SQL Server using PowerShell Desired State Configuration (DSC). Learn to prepare a new Windows Server and explore the advantages of this approach.
MSAs, GMSAs, and Groups - Use SQL Without Traditional User Accounts
Explore Active Directory features for enhanced SQL security, including AD Groups, MSAs, and GMSAs. Learn to simplify access management and reduce risks in database environments.
JSON for the Data Mortals
Explore JSON in databases: learn its origins, investigate, manipulate, and validate JSON data using Microsoft SQL Server tools and example code.
Should I Move My Production SQL Server Workloads to Containers
Explore the pros and cons of containerizing SQL Server workloads, examining architectural differences, advantages, and challenges to help decide if containers are right for your production environment.
SSRS and Paginated Reports in Power BI
Explore SSRS 2019 and Paginated Reports in Power BI, covering new features, report authoring, subscriptions, and management. Learn about pixel-perfect reporting alongside interactive Power BI reports.
Comparing Predictive Models from R, Python, SSAS, and Azure ML
Explore techniques for evaluating and comparing predictive models across R, Python, SSAS, and Azure ML, with insights on integrating diverse tools for optimal data mining results.
Deploying Availability Groups in Virtualized Architectures
Best practices for deploying SQL Server Always On Availability Groups in virtualized environments, covering on-premises, cloud, and hybrid architectures across VMware, Hyper-V, Azure, AWS, and GCP.
Building Your First Hybrid Lab
Extend your local SQL Server lab to Azure with a step-by-step guide on implementing a hybrid cloud Availability Group, network connectivity, and highly available Active Directory.
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.
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.
Navigating Row Level Security
Explore fine-tuned data access with Row Level Security in SQL Server, covering implementation patterns, scaling solutions, and practical tips for sensitive information management.
SQL Server 2022 - The Hybrid Data Platform
Explore SQL Server 2022's advanced hybrid capabilities, including cloud-connected disaster recovery, real-time analytics, and enhanced security features for seamless integration with Azure services.
Linux Container in Windows 10 or Windows 2016 Deep Dive
Explore Linux container internals on Windows using Hyper-V technology. Learn about information isolation, resource management, and differences between Windows and Linux containers.
Kubernetes on Windows - A Journey
Explore the journey of implementing Kubernetes on Windows Server, including design, development, installation, and deployment. Learn about benefits, challenges, and lessons learned in this unique environment.
Emulating Hyper-V in 2022
Explore KVM's Hyper-V emulation capabilities, recent advancements, and potential applications beyond Windows environments in this technical deep dive.
Deploying Docker Containers on Windows Server 2016
Explore Docker on Windows Server 2016: deploy apps, manage containers, combine Linux/Windows, understand Nano vs Server Core, Hyper-V isolation, and security model for efficient application deployment.
The Velvet Revolution - Dockerizing Legacy ASP.NET Apps
Learn to containerize legacy ASP.NET apps with Docker, enabling scalable deployment on Windows Server and Azure. Explore CI/CD integration and future microservices potential.
Deploying Applications to Windows Containers and Windows Server 2016
Learn to deploy applications using Windows Containers on Windows Server 2016. Explore development environments, building, scaling, and integration with Linux containers for real-world deployments.
Deploying Applications as Containers on Windows Server 2016
Explore Docker integration with Windows Server 2016, covering deployment, management, and security of Windows containers. Learn about Nano and Server Core containers, Hyper-V isolation, and cross-platform solutions.