Канал: DBAFundamentals

Snowflake Part 2 Surbhi Pokharn

Snowflake Part 2 Surbhi Pokharn

Azure MLOps Bring your DevOps to Machine Learning Stefano Tempesta

Azure MLOps Bring your DevOps to Machine Learning Stefano Tempesta

This is Not Your Daddy's Backup Routine Armando Lacerda

This is Not Your Daddy's Backup Routine Armando Lacerda

Answering the Auditor's Call with Automation Andy Levy

Answering the Auditor's Call with Automation Andy Levy

End to End SQL Database Development A Comprehensive guide with Interactive Prompts

End to End SQL Database Development A Comprehensive guide with Interactive Prompts

Continuous SQL with Kafka and Flink Tim Spann

Continuous SQL with Kafka and Flink Tim Spann

Automate Deployments with Azure DevOps Erin Dempster

Automate Deployments with Azure DevOps Erin Dempster

Uncovering Duplicate, Redundant, and Missing Indexes Andy Yun

Uncovering Duplicate, Redundant, and Missing Indexes Andy Yun

Tame Your Unruly Data With Constraints!

Tame Your Unruly Data With Constraints!

Divide and conquer – Partitioning

Divide and conquer – Partitioning

Handle Azure SQL Auditing with Ease Josephine Bush

Handle Azure SQL Auditing with Ease Josephine Bush

Here's the execution plan now what

Here's the execution plan now what

What is Azure Arc enabled data services

What is Azure Arc enabled data services

Hybrid Disaster Recovery with SQL Server 2022

Hybrid Disaster Recovery with SQL Server 2022

Parallelism in Microsoft SQL Server

Parallelism in Microsoft SQL Server

The magnificent seven and beyond Intelligent Query Processing in SQL Serve

The magnificent seven and beyond Intelligent Query Processing in SQL Serve

Execution plans … Where do I start?

Execution plans … Where do I start?

Uncovering Duplicate, Redundant, and Missing Indexes

Uncovering Duplicate, Redundant, and Missing Indexes

Development Lifecycle Basics for DBAs GIT

Development Lifecycle Basics for DBAs GIT

Getting Started SQL Server Data Security John Deardurff

Getting Started SQL Server Data Security John Deardurff

Modern Data Warehouse Using Azure Synapse Analytics

Modern Data Warehouse Using Azure Synapse Analytics

Introduction to Spark for SQL Pros Warner Chaves

Introduction to Spark for SQL Pros Warner Chaves

Protect your data with Microsoft Azure Backup

Protect your data with Microsoft Azure Backup

SQL Server Backup Strategis in Azure DBA Fundamentals

SQL Server Backup Strategis in Azure DBA Fundamentals

Data Warehouse or Data Lake Which do I choose

Data Warehouse or Data Lake Which do I choose

Scaling Clustered Column Store

Scaling Clustered Column Store

Crushing a Cloud Migration Moving Mountains While Migrating Data

Crushing a Cloud Migration Moving Mountains While Migrating Data

Achieving Wonders with Query Store

Achieving Wonders with Query Store

Data Virtualization with PolyBase and SQL Server 2022

Data Virtualization with PolyBase and SQL Server 2022

Memory Optimized TempDB Torsten StrauB

Memory Optimized TempDB Torsten StrauB

SQL Assessment Microsoft's Best Practices Checker

SQL Assessment Microsoft's Best Practices Checker

GIT For DBAs – Justin Dearing

GIT For DBAs – Justin Dearing

Advanced insides into System Versioned Temporal Tables Uwe Ricken

Advanced insides into System Versioned Temporal Tables Uwe Ricken

Storing and Searching Files in SQL Server Filetables Sam Nasr

Storing and Searching Files in SQL Server Filetables Sam Nasr

Introduction to Azure Synapse Serverless Pool Warner Chaves

Introduction to Azure Synapse Serverless Pool Warner Chaves

Python for SQL Server dba & Developers Jean Joseph

Python for SQL Server dba & Developers Jean Joseph

Azure SQL Server & DevOps

Azure SQL Server & DevOps

Infrastructure DBA In the Cloud Kellyn Pot'Vin Gorman

Infrastructure DBA In the Cloud Kellyn Pot'Vin Gorman

The Encryption Primer – Steve Jones

The Encryption Primer – Steve Jones

Query Store on Prem and in the Cloud Deepthi Goguri

Query Store on Prem and in the Cloud Deepthi Goguri

Azure SQL Year in Review - Bob Ward and Anna Hoffman

Azure SQL Year in Review - Bob Ward and Anna Hoffman

Introducing SQL Server 2022 Bob Ward

Introducing SQL Server 2022 Bob Ward

Backup Basics with Powershell and DBATools

Backup Basics with Powershell and DBATools

Advanced Data Types JSON in SQL Server

Advanced Data Types JSON in SQL Server

How to Audit SQL Server for Free Josephine Bush

How to Audit SQL Server for Free Josephine Bush

How to Conduct a Database Design Review - Kevin Kline

How to Conduct a Database Design Review - Kevin Kline

Creating Azure SQL Database Users with a Service Principal using Azure Devops Rob Sewell

Creating Azure SQL Database Users with a Service Principal using Azure Devops Rob Sewell

Introduction to Data Engineering with Azure Synapse Analytics

Introduction to Data Engineering with Azure Synapse Analytics

Azure SQL Database for DBAs – Ameena Lalani

Azure SQL Database for DBAs – Ameena Lalani

Azure SQL Databases for DBAs

Azure SQL Databases for DBAs

Turn Runbooks into Notebooks: Azure Data Studio for the On-Call DBA

Turn Runbooks into Notebooks: Azure Data Studio for the On-Call DBA

Need to Monitor Any Azure Resource? Must Learn Kusto Query Language

Need to Monitor Any Azure Resource? Must Learn Kusto Query Language

Streamline Database Deployments

Streamline Database Deployments

NoSQL For the DBA - Jean Joseph

NoSQL For the DBA - Jean Joseph

Become a Contributor to Microsoft Docs

Become a Contributor to Microsoft Docs

Azure SQL Database and Managed Instance vs OnPremise

Azure SQL Database and Managed Instance vs OnPremise

Going to Azure SQL: Admin differences no one told you Before

Going to Azure SQL: Admin differences no one told you Before

Packaging Permissions in Stored Procedures

Packaging Permissions in Stored Procedures

Five Ways to Reduce Database Size and Improve Performance

Five Ways to Reduce Database Size and Improve Performance

From Service Level Agreement to HA/DR solution

From Service Level Agreement to HA/DR solution

SQL Admin Best Practices with DMVs - William Assaf

SQL Admin Best Practices with DMVs - William Assaf

Optimizing your SQL Server for Azure VMs

Optimizing your SQL Server for Azure VMs

2017 High Availability Disaster Recovery 101 Glenn Berry

2017 High Availability Disaster Recovery 101 Glenn Berry

Common SQL Server Mistakes and How to Avoid Them Tim Radney

Common SQL Server Mistakes and How to Avoid Them Tim Radney

Index Design Patterns for Beginners Kendra Little

Index Design Patterns for Beginners Kendra Little

Help! SQL Server 2008 is Still Here! Brent Ozar

Help! SQL Server 2008 is Still Here! Brent Ozar

Introduction to SQL Server Temporal Tables Tim Mitchell

Introduction to SQL Server Temporal Tables Tim Mitchell

Modernizing on SQL Server 2019

Modernizing on SQL Server 2019

14 Habits of Great SQL Developers Ike Ellis

14 Habits of Great SQL Developers Ike Ellis

Journey to the Cloud with Azure Database Migration Service Warner Chaves

Journey to the Cloud with Azure Database Migration Service Warner Chaves

DevOps Fundamentals What, who, why and how Kendra Little

DevOps Fundamentals What, who, why and how Kendra Little

Using Open Source Products for Collecting Performance Metrics Tracy Boggiano

Using Open Source Products for Collecting Performance Metrics Tracy Boggiano

Hardware 201 Selecting and Sizing Database Hardware for OLTP Performance Glenn Berry

Hardware 201 Selecting and Sizing Database Hardware for OLTP Performance Glenn Berry

3 Performance Tuning Tricks you Always Wanted to Know Pinal Dave

3 Performance Tuning Tricks you Always Wanted to Know Pinal Dave

Administering Beyond the Speed of Light Managing SQL Server with Ansible

Administering Beyond the Speed of Light Managing SQL Server with Ansible

Where Should My Data Live and Why

Where Should My Data Live and Why

Stored Procedure Optimization Techniques Kimberly Tripp

Stored Procedure Optimization Techniques Kimberly Tripp

Architectural Choices That Affect Performance Kevin Kline

Architectural Choices That Affect Performance Kevin Kline

Understanding SQL Server Backup and Restore Tim Radney

Understanding SQL Server Backup and Restore Tim Radney

Free Downloads for Powerful SQL Server Management

Free Downloads for Powerful SQL Server Management

Plan Stability through Plan Forcing in Query Store

Plan Stability through Plan Forcing in Query Store

Cross querying multiple SQL sources using Xpath based queries

Cross querying multiple SQL sources using Xpath based queries

Introduction and Use cases for working with Azure Databricks

Introduction and Use cases for working with Azure Databricks

Data Compression 101

Data Compression 101

An Introduction to Partitioning

An Introduction to Partitioning

Indexing from the Ground Up

Indexing from the Ground Up

Five Shifts to Becoming a Rockstar Data Professional Without the Stress and Burnout Caused by Being

Five Shifts to Becoming a Rockstar Data Professional Without the Stress and Burnout Caused by Being

Linux Fundamentals for SQL Server DBAs

Linux Fundamentals for SQL Server DBAs

Data Types Do Matter

Data Types Do Matter

Beginning Admin: The Care and Feeding of SQL Server

Beginning Admin: The Care and Feeding of SQL Server

Bad Designs have Consequences

Bad Designs have Consequences

Top 7 Thing’s a New DBA Should Know

Top 7 Thing’s a New DBA Should Know

What is this Temporal Table thing anyway Come and see!

What is this Temporal Table thing anyway Come and see!

Choosing The Right Azure SQL Service for You

Choosing The Right Azure SQL Service for You

Tips and Tricks for Using SQL Server Management Studio Effectively

Tips and Tricks for Using SQL Server Management Studio Effectively

Advanced Indexing for Beginners

Advanced Indexing for Beginners

Index Design Patterns for Beginners Kendra Little

Index Design Patterns for Beginners Kendra Little

Execution Plans 101 Thomas LeBlanc

Execution Plans 101 Thomas LeBlanc

Test Driven Development in SQL Server – it will make your database deployments better

Test Driven Development in SQL Server – it will make your database deployments better

Index Fragmentation Internals, Analysis, and Solutions Paul Randal

Index Fragmentation Internals, Analysis, and Solutions Paul Randal

What To Do When SQL Server is Slow Brent Ozar

What To Do When SQL Server is Slow Brent Ozar

Common SQL Server Mistakes and How to Avoid Them Tim Radney

Common SQL Server Mistakes and How to Avoid Them Tim Radney

Migrating to SQL Server 2017

Migrating to SQL Server 2017

2017 High Availability Disaster Recovery 101

2017 High Availability Disaster Recovery 101

Migrating to In Memory OLTP Erin Stellato

Migrating to In Memory OLTP Erin Stellato

Statement Execution and the Plan Cache - Kimberly Tripp

Statement Execution and the Plan Cache - Kimberly Tripp

The Jr DBA Workout Plan Erik Darling

The Jr DBA Workout Plan Erik Darling

Ten Surprising Performance Killers on Microsoft SQL Server

Ten Surprising Performance Killers on Microsoft SQL Server

SQL Operations Studio SQL Tiger Team Introduction

SQL Operations Studio SQL Tiger Team Introduction

SSIS 2016/2017 Intermediate

SSIS 2016/2017 Intermediate

Strategies to get maximum concurrency for your workload in SQL Server Redo

Strategies to get maximum concurrency for your workload in SQL Server Redo

SQL Server 2017 - Deep Dive Bob Ward

SQL Server 2017 - Deep Dive Bob Ward

T SQL's Hidden Support Feature Jennifer McCown

T SQL's Hidden Support Feature Jennifer McCown

Comprehensive Guide for Monitoring SQL Server and Azure SQL DB

Comprehensive Guide for Monitoring SQL Server and Azure SQL DB

Upgrade Strategies for Highly Available SQL Server Environments Edwin Sarmiento

Upgrade Strategies for Highly Available SQL Server Environments Edwin Sarmiento

From DBA to Data Scientist - Mike West

From DBA to Data Scientist - Mike West

Shortcuts From an Impatient DBA Andy Mallon

Shortcuts From an Impatient DBA Andy Mallon

T SQL's Hidden Support Feature Jennifer McCown

T SQL's Hidden Support Feature Jennifer McCown

SSMS Shortcuts & Secrets Kendra Little

SSMS Shortcuts & Secrets Kendra Little

Extending DevOps to SQL Server

Extending DevOps to SQL Server

SQL Server 2017 What's New

SQL Server 2017 What's New

Linux for the SQL Administrator David Klee

Linux for the SQL Administrator David Klee

Azure SQL Data Warehouse for the SQL Server DBA Warner Chaves

Azure SQL Data Warehouse for the SQL Server DBA Warner Chaves

SQL Server Performance Tuning Made Easy

SQL Server Performance Tuning Made Easy

DevOPs and the DBA

DevOPs and the DBA

SQL Server 2016 SP1 All the Enterprise Features You Ever Wanted—In Standard Edition

SQL Server 2016 SP1 All the Enterprise Features You Ever Wanted—In Standard Edition

Plan, Design and Implement a HADR Solution GÇô a Journey

Plan, Design and Implement a HADR Solution GÇô a Journey

All about Indexing with Gail Shaw

All about Indexing with Gail Shaw

SSIS Fundamentals and Beyond SSIS 2016 Features

SSIS Fundamentals and Beyond SSIS 2016 Features

Survey of the Azure Data Landscape

Survey of the Azure Data Landscape

How to Assess Technical Quality of Apps Running on Microsoft SQL Server

How to Assess Technical Quality of Apps Running on Microsoft SQL Server

How to Triage SQL Server Emergencies

How to Triage SQL Server Emergencies

Analyzing I O Subsystem Performance

Analyzing I O Subsystem Performance

Dr DMV’s Troubleshooting Toolkit

Dr DMV’s Troubleshooting Toolkit

In Memory OLTP What can it do for me

In Memory OLTP What can it do for me

Deadlocking for Mere Mortals

Deadlocking for Mere Mortals

Performance Troubleshooting Using Wait Statistics

Performance Troubleshooting Using Wait Statistics

Partitioning Basics: Treating your tables like Lego

Partitioning Basics: Treating your tables like Lego

Stored Procedure Optimization Techniques

Stored Procedure Optimization Techniques

Answering the Question, “WHAT HAPPENED ” with QUERY STORE

Answering the Question, “WHAT HAPPENED ” with QUERY STORE

FIRE! A Fullproof Checklist for Tuning and Troubleshooting

FIRE! A Fullproof Checklist for Tuning and Troubleshooting

DBAFundamentals Live Stream

DBAFundamentals Live Stream

How SQL Server 2016 SP1 Changes the Game

How SQL Server 2016 SP1 Changes the Game

What Smart SQL Server DBAs Ought to Know About Windows Server Failover Clustering

What Smart SQL Server DBAs Ought to Know About Windows Server Failover Clustering

Travelling in Time with SQL Server 2016

Travelling in Time with SQL Server 2016

Very Large Databases Lessons Learned

Very Large Databases Lessons Learned

The Server is Down What will you do

The Server is Down What will you do

SQL Server 2016 Always On Availability Groups Perf Enhancements Internals

SQL Server 2016 Always On Availability Groups Perf Enhancements Internals

Watch Brent Tune Queries

Watch Brent Tune Queries

Understanding SQL R Services What Every SQL Professional Should Know

Understanding SQL R Services What Every SQL Professional Should Know

Understanding Backups

Understanding Backups

Statistics and Query Plans

Statistics and Query Plans

Peformance Tuning as Pinal Dave Sees It

Peformance Tuning as Pinal Dave Sees It

Securing SQL Server; Recommended Practices

Securing SQL Server; Recommended Practices

High Availability Disaster Recovery 101

High Availability Disaster Recovery 101

SQL Server Performance Monitoring & Baselining

SQL Server Performance Monitoring & Baselining

Azure SQL Database for the Production DBA

Azure SQL Database for the Production DBA

Skills Every Junior DBA Must Know

Skills Every Junior DBA Must Know

SQL Server Database Administration for the non DBA

SQL Server Database Administration for the non DBA

SQL 2016 Enhancements That Will Make your SQL Server Roar

SQL 2016 Enhancements That Will Make your SQL Server Roar

Securing a SQL Server Checklist Visit to theDentist

Securing a SQL Server Checklist Visit to theDentist

SQL Server Encryption

SQL Server Encryption

Beyond CXPACKET Understanding Wait Statistics

Beyond CXPACKET Understanding Wait Statistics

Understanding SQL Server Backup and Restore

Understanding SQL Server Backup and Restore

Kicking and Screaming Replacing Profiler with Extended Events

Kicking and Screaming Replacing Profiler with Extended Events

The Transaction Log and How It Affects HA DR

The Transaction Log and How It Affects HA DR

How to use Parameters like a Pro and Boost Performance

How to use Parameters like a Pro and Boost Performance

Performance Tuning Methodology as Gail Shaw Sees It

Performance Tuning Methodology as Gail Shaw Sees It

Top 10 Clustering Dos and Don’ts

Top 10 Clustering Dos and Don’ts

Silent Killers Lurking in Your Schema

Silent Killers Lurking in Your Schema

Index Fragmentation Internals, Analysis, and Solutions

Index Fragmentation Internals, Analysis, and Solutions

End to End Troubleshooting for SQL Server

End to End Troubleshooting for SQL Server

Big Data and Hadoop

Big Data and Hadoop

KNOW YOUR ROLES!

KNOW YOUR ROLES!

SQL Server on Flash Re Thinking Best Practices

SQL Server on Flash Re Thinking Best Practices

Common SQL Server Mistakes and How to Avoid Them

Common SQL Server Mistakes and How to Avoid Them

SQL Server Performance Tuning Controlling Parallelism

SQL Server Performance Tuning Controlling Parallelism

Going Asynchronous with Service Broker

Going Asynchronous with Service Broker

Moving from Profiler to Extended Events

Moving from Profiler to Extended Events

What Execution Plans can tell you about Query Performance

What Execution Plans can tell you about Query Performance

SSRS 101

SSRS 101

Identifying Long Running Queries

Identifying Long Running Queries

XML WITHOUT XANAX HOW TO HANDLE XML IN SQL SERVER

XML WITHOUT XANAX HOW TO HANDLE XML IN SQL SERVER

Getting Started with Azure s SQL Database

Getting Started with Azure s SQL Database

Build the Right Backup Strategy

Build the Right Backup Strategy

I’ve got a SQL Database, Now What

I’ve got a SQL Database, Now What

Dr DMV s Troubleshooting Toolkit

Dr DMV s Troubleshooting Toolkit

Virtualization 101 for SQL Server

Virtualization 101 for SQL Server

Statement Execution and the Plan Cache

Statement Execution and the Plan Cache

Performance Tuning Pit Stop for DBAs

Performance Tuning Pit Stop for DBAs

Changing Your Habits to Improve the Performance of Your T-SQL

Changing Your Habits to Improve the Performance of Your T-SQL

Solving the Accidental DBA Problem

Solving the Accidental DBA Problem

The Roadmap to Better Performance: Reading Query Plans

The Roadmap to Better Performance: Reading Query Plans

Treating Tables Like Legos, Partitioning Basics

Treating Tables Like Legos, Partitioning Basics

Rolling Upgrades the Easy Way!

Rolling Upgrades the Easy Way!

Table Indexing 101

Table Indexing 101

The Minimalist Guide to Database Administration

The Minimalist Guide to Database Administration

Statistics Starters

Statistics Starters

Manage Your Shop with CMS and Policy Based Management

Manage Your Shop with CMS and Policy Based Management

Microsoft SQL Server 2014 Countdown: SQL Server 2014 In-Memory OLTP Overview"

Microsoft SQL Server 2014 Countdown: SQL Server 2014 In-Memory OLTP Overview"