Dba Courses

PASS Data Community Summit

Getting Started with PowerShell as a DBA

Learn PowerShell fundamentals for DBAs: syntax, TSQL translation, and practical applications. Discover how this powerful tool can enhance your database administration skills and workflow efficiency.

• YouTube
• 1 hour 18 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

The DBA and Developer Relationship

Explore strategies for effective collaboration between database and application developers to create efficient, well-managed business solutions that meet expectations.

• YouTube
• 1 hour 16 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Is the DBA Dead?

Explore the evolving role of DBAs, current challenges, and insights for career success in database administration through real-world statistics and expert analysis.

• YouTube
• 55 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Essential Linux for the DBA - Cross-Platform SQL Server Management

Learn essential Linux skills for database administration, focusing on cross-platform SQL Server management. Gain insights from a multi-platform DBA with extensive Unix/Linux experience.

• YouTube
• 1 hour
• On-Demand
• Conference Talk

PASS Data Community Summit

Making the Leap from Developer to DBA

Discover strategies for transitioning from developer to DBA, including essential skills and knowledge needed for success in database administration.

• YouTube
• 1 hour
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server Agent - The Life Preserver for the Drowning DBA

Learn to automate DBA tasks using SQL Server Agent. Discover job creation, alerts, monitoring, and common pitfalls to streamline your database management and boost efficiency.

• YouTube
• 57 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Como fazer bonito para o DBA

Estratégias e dicas para desenvolvedores otimizarem o uso do SQL Server, melhorando a eficácia na extração de informações e atendendo aos requisitos internos do sistema.

• YouTube
• 51 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

DBA Mythbusters

Debunking common SQL Server myths and misconceptions, covering topics like non-logged operations, corruption risks, MAXDOP settings, and table-scan behaviors. Gain accurate insights for better database management and maintenance.

• YouTube
• 1 hour 27 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

More DBA Mythbusters

Debunking SQL Server myths and misconceptions, covering data compression, file management, isolation levels, checkpoints, logging, recovery, and more for improved database administration.

• YouTube
• 1 hour 30 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Who's Responsible - The Vendor or the DBA?

Explore the roles and responsibilities of database vendors and DBAs in managing SQL Server environments, addressing common challenges and best practices.

• YouTube
• 1 hour 14 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Being the DBA of the Future - A World of On-Premise and Cloud

Explore the evolving role of DBAs in hybrid environments, covering essential skills for managing on-premise and cloud databases, and strategies for adapting to future technological changes.

• YouTube
• 1 hour 13 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Notebooks in Azure Data Studio for the DBA

Explore SQL Notebooks in Azure Data Studio for DBAs: simplify workflows, run diagnostic queries, and leverage powerful features for daily database management tasks.

• YouTube
• 1 hour 6 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

SQL Server Farm Management vs Single Instance Management - DBA Fundamentals

Discover efficient SQL Server farm management techniques, inspired by dairy farming, for large-scale database control. Learn FarmDataLanguage to enhance monitoring and management of multiple instances.

• YouTube
• 52 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

Diversity, Belonging, & Allyship - Essential DBA Skills for the Data Professional

Explore essential non-technical skills for data professionals: embracing diversity, fostering belonging, and practicing allyship. Learn techniques to cultivate inclusive cultures and become a better ally in the tech industry.

• YouTube
• 1 hour 11 minutes
• On-Demand
• Conference Talk

PASS Data Community Summit

ORMs and the DBA - How to Keep Both Happy

Explore strategies to mitigate ORM-related issues, improve performance, and satisfy both developers and DBAs. Learn to audit SQL, optimize code, and use tools for better ORM implementation.

• YouTube
• 38 minutes
• On-Demand
• Conference Talk