SQL Server and Kubernetes
Explore deploying SQL Server in Kubernetes: benefits, challenges, and practical implementation. Learn about orchestration, persistence, and chaos engineering for robust database management.
The Care and Feeding of SQL Server
Learn essential SQL Server administration tasks: backups, integrity checks, index maintenance, disk management, and alerting. Gain foundational knowledge for effective database management and maintenance.
Database Security, Who Owns It?
Explore layers of database security, from DBA to InfoSec roles. Learn secure-by-design practices within DevOps for comprehensive data platform protection throughout the development lifecycle.
SQL Server Security from the Ground Up
Comprehensive introduction to SQL Server database security, covering permissions, securables, principals, best practices, and management techniques to protect valuable company data.
Secure SQL Server Database Design - Tactics and Technology
Strategies for designing secure SQL Server databases, covering table design, roles, and built-in security features like Always Encrypted and Row-Level Security.
Performance Tuning Azure SQL Databases
Optimize Azure SQL Database performance using Automatic Tuning, Intelligent Insights, and Extended Events. Learn to leverage these features for time and cost savings while maximizing database efficiency.
Improving Columnstore Load Scalability on Large Servers
Optimize columnstore index load times from 260 to 6 minutes using advanced techniques for SQL Server. Learn scalability improvements for large servers and data warehouse workloads.
6 Months to 5 Minutes - DB & BI Deployments at the Speed of Light
Transforming database and BI deployments from months to minutes through Agile methodologies and Continuous Delivery, overcoming organizational barriers for faster innovation and happier teams.
SQL Containers in 5 Minutes and 5 Lines of Code
Learn to quickly set up and manage SQL Server containers using PowerShell and Docker. Discover how containers support development and testing environments with rapid deployment and easy management.
Encrypting Data Within SQL Server
Explore SQL Server encryption options, data privacy laws, and performance impacts. Learn to classify sensitive data, implement Always Encrypted, and audit data usage for enhanced security.
Reduce Cost by Tuning Queries on Azure DBaaS
Learn techniques to optimize queries on Azure SQL Database, improving performance and potentially reducing costs by lowering resource demands and compute size requirements.
SQL Injection - What Is It, Prevent It, Monitor For It
Comprehensive guide on SQL Injection: understanding attacks, monitoring systems, and implementing robust security measures to protect databases from vulnerabilities and unauthorized access.
Take Me to the Multiple Clouds Above Seattle
Explore multi-cloud strategies, benefits, and challenges. Learn from experienced architects about best practices, data integration, and migration in cherry-picking cloud services for optimal data platform design.
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.
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.
SQL Server and Azure SQL Database Intelligent Query Performance
Explore groundbreaking enhancements in Intelligent Query Processing for SQL Server and Azure SQL Database, improving critical parallel workloads at scale while adapting to evolving data landscapes.
SQL Managed Instance - A Fully Managed SQL Server in the Cloud
Explore Azure SQL Managed Instance's features, benefits, and migration best practices. Learn about architecture, pricing, and disaster recovery for efficient cloud-based SQL Server workloads.
Why the Database is at the Heart of DevOps Success
Discover how to integrate database changes into Agile practices, optimize development workflows, and bridge silos between teams for faster, more reliable software delivery in DevOps environments.
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.
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.
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.