CosmosDB
Aprenda a transferir conhecimentos de SQL Server para CosmosDB, explorando semelhanças e diferenças entre as bases, com foco em projeto e modelagem específicos do CosmosDB. Demonstrações práticas incluídas.
Hacking SQL Server
Revisão de conceitos de segurança em SQL Server, abordando prevenção de invasões e acessos não autorizados. Aprenda a proteger seu banco de dados eficientemente.
Designing for Azure Data Warehouse Performance - Cloud
Learn Azure Data Warehouse design principles for optimal performance, covering architecture, data modeling, and practical considerations to balance current and future needs.
Log Shipping in SQL Server - High Availability and Disaster Recovery
Explore SQL Server log shipping for HA and DR, covering fundamentals, setup, use cases, and custom configurations. Gain practical insights through demos for server migration and business continuity.
Power BI From 0 to Hero - Analytics
Comprehensive Power BI tutorial covering data loading, modeling, report design, and advanced features. Learn to create impactful visualizations and leverage Power BI's full potential for data analysis.
Introduction to Google Cloud Platform
Explore Google Cloud Platform's infrastructure, databases, and machine learning offerings. Learn its strengths, differentiation from competitors, and successful enterprise use cases in this comprehensive introduction.
Relational Database in Azure
Explore Azure's relational database options, comparing features, benefits, and costs to help you choose the best solution for storing your information in the Microsoft cloud environment.
SQL Server Internals and Architecture
Explore SQL Server's internal workings and architecture, gaining insights into its core components, processes, and optimizations for enhanced database management and performance tuning.
High Availability - Disaster Recovery 101
Learn SQL Server 2019 HA/DR strategies to meet RTO/RPO goals. Compare technologies, design solutions, and develop policies for effective implementation in various scenarios.
Desenvolvimento e Administração em SQL Server com Python
Integração do Python com SQL Server para desenvolvimento de aplicações e administração de infraestrutura em ambientes de bancos de dados, explorando as capacidades multiplataforma e poliglotas do SQL Server desde a versão 2017.
SQL Notebooks in Azure Data Studio for the DBA
Explore SQL Notebooks in Azure Data Studio for DBAs: simplify workflows, create diagnostic query notebooks, and discover practical use cases for daily database administration tasks.
My Romantic Relation with Powershell Generally - and with dbatools Especially
Discover the power of PowerShell and dbatools for efficient database management. Learn practical scenarios like automatic restore testing, log shipping, migrations, and upgrades to enhance your DBA skills.
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.
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.
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.
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.