Deadlocking for Mere Mortals
Explore common SQL Server deadlocks, their causes, and troubleshooting methods using various tools like Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Azure Data Security
Explore Azure's data security tools: encryption, masking, threat protection, and more. Learn to safeguard your data assets effectively in the cloud environment.
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.
Data Types Do Matter
Explore the critical importance of selecting appropriate data types for optimal data quality, storage, performance, and query accuracy in database management.
Storage 101 for the DBAs
Learn essential storage concepts for SQL Server, including IO basics, best practices, and troubleshooting tips to optimize performance and quickly diagnose issues.
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.
Bad Designs Have Consequences
Explore real-world SQL database design pitfalls, their consequences, and learn from 15 years of experience to avoid common mistakes and improve your database architecture.
Tips and Tricks for Using SQL Server Management Studio Effectively
Discover essential tips and tricks to enhance your productivity with SQL Server Management Studio, covering features like object explorer, scripting, query plans, and multi-server management.
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.
Packaging Permissions in Stored Procedures
Learn advanced techniques for fine-grained permission control in SQL Server stored procedures, including certificate signing and EXECUTE AS. Discover how to securely grant privileged actions without compromising overall database security.
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.
Azure DevOps and the SSIS Development Lifecycle
Learn to manage SSIS projects through their lifecycle using Azure DevOps, from initial development to production release, with practical demonstrations and expert guidance.
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.
What's Going On in My Power BI Environment?
Comprehensive guide to monitoring Power BI environments, covering compliance, governance, performance, and implementation aspects using audit logs, APIs, and various tools for effective administration.
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.