A Beginner's Guide to Becoming a Performance Tuner
Discover hidden performance killers in SQL Server through worst practices. Learn server configuration, T-SQL parallelism, and TempDB issues to jumpstart your journey as a performance tuner.
The Evolution of the DBA in the Age of Cloud
Explore how cloud computing and automation are reshaping the DBA role, and learn strategies to adapt and thrive as a data professional in this evolving landscape.
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.
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.
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.
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.
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.
An Azure Data Engineer's ETL Toolkit
Explore Azure's data movement and transformation options, comparing SSIS with Data Factory, Databricks, and Logic Apps. Learn ETL patterns and Data Flow features for scalable cloud migration.
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.