SQL Server Options on Azure: Can you migrate?

  Рет қаралды 1,605

Bryan Cafferky

Bryan Cafferky

Күн бұрын

Пікірлер: 7
@AronLovdahl
@AronLovdahl 4 жыл бұрын
Hi Bryan, I came here looking for more information in regards to the different options on Azure, like DTU, Elastic pools, etc. can you do a follow up video explaining those? thanks!
@katetuzov9745
@katetuzov9745 4 жыл бұрын
Thanks for another great video. I am sad to see there is no Azure equivalent for the Machine Learning Services.
@henniedenooijer4348
@henniedenooijer4348 4 жыл бұрын
Hi brian, i think azure sql db is positioned as oltp database. Certain settings which are handy for bulk load like autogrow are set to 2mb and this is cost performance in dwh solutions. As i agree with other reactions, MS is leaving a big gap for competitors. You did not mention synapse , but this is sometimes a step too far for companies.
@BryanCafferky
@BryanCafferky 4 жыл бұрын
Yeah, Synapse is new name for Azure SQL DW and is not a SQL Server migration option. It is MPP, Massive Parallel, Processing for Big Data. It is not designed for lots of concurrent users or for application OLTP. Thanks.
@BryanCafferky
@BryanCafferky 4 жыл бұрын
For a detailed comparison of Azure SQL DB to Azure SQL Managed Instance, see docs.microsoft.com/en-us/azure/sql-database/sql-database-features
@Noobsmove
@Noobsmove 4 жыл бұрын
This honestly makes me feel like Microsoft doesn't care about BI anymore. Simply comparing Data Factory with SSIS or SSAS/SSRS with Power BI... These comparisons feel like comparing toys with actual tools. Kinda sad :/
@BryanCafferky
@BryanCafferky 4 жыл бұрын
Did not mean to give that impression. Microsoft is very strong on Power BI and has a platform around it to scale. It' just not tied to SQL Server. Azure Analysis Services is a good BI scalable service. This video was focused on how difficult would it be to migrate on premise SQL Server to Azure. A BI workload might have to be redesigned to fit the Azure world.
Create an Azure SQL Database Tutorial
11:37
Bryan Cafferky
Рет қаралды 2,6 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.
Introduction To Prolog - Chaper 1 - EduGate
21:41
Edu-Gate
Рет қаралды 153
Migrate servers to Azure using Azure Migrate
25:00
Thomas Maurer
Рет қаралды 146 М.
How To Pass ANY Azure Certification in 2024 | Complete Guide
19:00
Travis Media
Рет қаралды 353 М.
How to migrate SQL Server databases to Azure
13:31
Microsoft Mechanics
Рет қаралды 82 М.
Introduction to Scaling Analytics Using DuckDB with Python
29:33
Bryan Cafferky
Рет қаралды 5 М.
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Database Star
Рет қаралды 97 М.
What to Learn for Your Career Path
16:53
Bryan Cafferky
Рет қаралды 2 М.