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.
SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It
Explore SQL Server 2017's Database Engine enhancements, including improved query processing, scalability features, and reasons to upgrade from previous versions.
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.
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.
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.
Roles and Responsibilities of the Azure Data Engineer
Explore the role of Azure Data Engineer, including key responsibilities, required skills, and relevant Azure services. Learn how to align your career path with the Microsoft certification.
SQL Server in Containers - Your Next Dev - Test - Integration - Upgrade Server
Learn to leverage Docker containers for rapid SQL Server deployment, streamlining development, testing, and upgrade processes. Discover how containers differ from VMs and accelerate your software development lifecycle.
An Introduction to AI for Everyone
Explore AI fundamentals, including key concepts, business applications, and recent developments. Gain insights into the AI ecosystem and its impact on technology careers.
Hash Match, the Operator
Deep dive into SQL Server's Hash Match operator: its versatility, memory usage, and performance characteristics. Explore how it functions in execution plans for advanced query optimization.
Cosmic DB - Cosmos DB for SQL Server Admins and Developers
Explore Cosmos DB's NoSQL approach, indexing, consistency levels, and JSON design for SQL professionals. Learn to leverage schema-free advantages and optimize query patterns in document-based databases.
Designing Azure Data Disaster Recovery Strategies
Explore strategies to protect Azure data from regional outages, covering SQL Databases, VMs, and Managed Instances. Learn to meet recovery objectives and safeguard your cloud-based applications.
Inside Kubernetes - An Architectural Deep Dive
Comprehensive exploration of Kubernetes architecture, components, and advanced concepts for deploying and managing applications and data platforms in production environments.
Analytics Spotlight - The New Analyst
Explore evolving analytics trends, skills, and technologies for business analysts. Learn to work with data science, improve data literacy, and embrace ambiguity in modern business intelligence.
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.
Eliminating Anti-Patterns and RBAR for Faster Performance
Learn to boost SQL Server performance by identifying and fixing schema and code design issues, focusing on real-world examples and reproducible workloads to achieve faster query execution and better scalability.
Relational Data Modeling Trends for Transactional Applications
Explore modern data modeling trends for transactional applications, addressing challenges in NoSQL, microservices, and cloud environments. Learn to adapt traditional principles to meet current business demands and facilitate rapid changes.
Azure Data Studio - The New Frontier
Explore Azure Data Studio's features for managing data platforms, including dashboards, snippets, profiling, charting, and more. Learn when to use it over SQL Server Management Studio.
Complete CI - CD for C# and SQL
Practical demonstration on automating CI/CD for C# applications and SQL databases, covering source control, build processes, and deployment strategies for different environments.
How to Deploy SQL Server Containers on Kubernetes in Azure
Explore deploying SQL Server containers on Azure Kubernetes Service. Learn container creation, SQL Server deployment, and automation techniques for scalable and highly available database management.
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.