Unexpected and expected outcomes emerged when testing the same star schema data structures and queries across five different database technologies with comparable capacities: • SQL Server 2019 • SQL Server 2022 • Synapse Dedicated SQL Pool • Azure Managed Instance • Microsoft Fabric Looking forward to doing the same with Snowflake.
Gary Melhaff’s Post
More Relevant Posts
-
Data Exposed session LIVE from PASS Summit 2024! You'll receive the latest updates containing all things SQL Server and Azure SQL. #passdatasummit
What’s New in SQL Server & Azure SQL | Data Exposed Live @ PASS Summit 2024
https://www.youtube.com/
-
Data Platform MVP (2020-2023) | Certified Expert in Fabric Analytics Engineering, Azure Data Engineering, Solutions Architecture, DevOps, and Development
SQL Database on Fabric - First thing to discover: when to use Azure SQL and when to use SQL on Fabric ? #azuresql #microsoftfabric #sqlinfabric #dataplatform #powerbi
-
-
Senior Consultant & Data Expert | SQL Server, Azure SQL, and AWS RDS DBA at Madeira Data Solutions | Driving Data Strategy & Optimization
What's New in SQL Server and Azure SQL: 2024 Year in Review https://buff.ly/3AxgLhk #SQLServer #AzureSQL #database #Microsoft #madeiradata
-
-
✨ Tip Of The Week ✨ 5 Reasons from John Sterrett on Why Azure SQL Database is Ideal for Your Next Application Build. #AzureSQL #DataSecurity #CloudComputing #ProcureSQL
-
|Tech enthusiast|Data Professional|Data Analyst📊|Microsoft sql| Power Bi Data visualization|MsExcel|Power pointlTableau| R |. Music director|Minister|Performing|recording artist|multi-instrumentalist🎹🎼|business man🛒|
Just decided to do little stuff on sql, What do you think? Automatic Date and time capturing included in a database. Tool microsoft sql server connecting and operating it on a cross-platform management tool known as Azure data studio
-
What's New in SQL Server and Azure SQL: 2024 Year in Review #sqlserver #sqldb #azuresql #azure
-
Build Chatbot with a LLM and Azure SQL Database to Answer Questions
Build Chatbot with a LLM and Azure SQL Database to Answer Questions
-
🌟 Excited to share that I've just earned my "𝙈𝙞𝙜𝙧𝙖𝙩𝙚 𝙎𝙌𝙇 𝙎𝙚𝙧𝙫𝙚𝙧 𝙬𝙤𝙧𝙠𝙡𝙤𝙖𝙙𝙨 𝙩𝙤 𝘼𝙯𝙪𝙧𝙚 𝙎𝙌𝙇 𝘿𝙖𝙩𝙖𝙗𝙖𝙨𝙚" badge! 🎉 As I delve deeper into migrating to Azure SQL Database, I’ve learned: 🔹 Different migration types: schema and data, schema-only, and data-only, using the Data Migration Assistant. For best results, it's smart to temporarily upgrade the Azure SQL Database to performance level P15 during migration. 🔹 Migration Status Monitoring: The migration process has several statuses, such as preparing for copy, copying, and rebuilding indexes, to keep you updated on progress. 🔹 Transactional Replication: The only online migration method, allowing near real-time updates, though it requires SQL Server authentication and configuration outside the Azure portal. 🔹 SQL Data Sync: Ideal for hybrid applications, enabling incremental synchronization across databases, albeit with a higher performance impact compared to transactional replication. Onward and upward! 🚀 #AzureSQL #SQLServerMigration #AzureSQLDatabase #DataMigration #CloudInnovation #ArtificialIntelligence #LearningJourney #Microsoft #WomenInCloud
Migrate SQL Server workloads to Azure SQL Database
learn.microsoft.com
-
The preview availability of the feature to shrink database and data files in the Hyperscale tier has been announced. Check it out now! #microsoft #azure #sql #database #preview #techbits #athentechbits