Azure Cosmos DB’s Post

Tutorial: Configure Microsoft Fabric mirrored databases from #AzureCosmosDB (Preview) Learn how to configure a mirrored database from Azure Cosmos DB in Microsoft Fabric. https://lnkd.in/e5m6wj5H

Headed today to #FabConEurope so it is fitting that my tip for this week is to take a look at #fabricmirroring for #AzureSQL. I often see customers struggle with "mixed" workloads on their database so often a technique is to offload the read users to a replica. Fabric Mirroring for SQL provides a nice solution for this. Furthermore, you have the benefit of being integrated into #MicrosoftFabric and all the goodness it provides. Here is a bonus. Mirroring storage in Fabric is free! Give it a spin today by setting up a free Fabric trial and use the free offer for Azure SQL Database (https://aka.ms/freedboffer). https://lnkd.in/gvMSRvQy.

In Azure Fabric Big tables, bear in mind if your table count of rows is greater than 2.5 B, you have to use COUNT_BIG instead of COUNT in order to be able to count this table newly introduced at Azure Fabric warehouse, however in Fabric Spark same spark sql or Spark dataframe count function can be used with small and large tables.

Check out our new #PowerMates video on how to configure and setup your Microsoft Fabric Mirroring to Azure SQL DB    Don’t miss out!    🎥 Watch now: https://lnkd.in/gaZdgAPq  #SQL #MicrosoftFabric 

Lesson Learned #492: Improving Extended Events in Azure SQL. In the last months, our Product Team has been working to enhance Extended Events for Azure SQL as you could see in their blog: Improving Extended Events in Azure SQL - Microsoft Community Hub. These updates simplify monitoring and troubleshooting Azure SQL databases, offering a more SQL Server-like experience and enabling more granular control over events and sessions.    These improvements include:   Direct Event Data Visualization in SSMS: Users can now view event data directly in SQL Server Management Studio (SSMS) without downloading files, streamlining the... #techcommunity #azure #microsoft https://lnkd.in/ehxKNXnJ

Today at SQLBits, we announced two new Copilot preview experiences! 1) We added Azure SQL Database skills into Microsoft Copilot for Azure and 2) We added natural language to SQL into the Azure portal query editor. Learn more here: https://lnkd.in/gN3crj77. Stay tuned for more updates as we're just getting started here... #SQLBits #Microsoft #AzureSQLDatabase #Copilot

Learn about the flexibility of Azure SQL Managed Instance pools and when to use them in this explainer video by Djordje Marinkovic. https://lnkd.in/dqXnTsjt

The recording of my session about Fabric Real-Time and CDC: Ingesting in Real Time from Azure SQL delivered in Fabric Online Global Conference is available Link in the comments #microsoftfabric #powerbi #dataplatform #realtime #azuresql #cdc

In our latest blog post, Pwned Labs' Ian Austin shares research showing how Azure SQL Server Managed Instances (part of the Platform as a Service) can be used to exfiltrate data from a blind SQL injection, enumerate hosts, paths, files, and more! Link in the comments! 👇

ntroduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition. When updating data in SQL Server, operators run the gambit of incurring issues if not done correctly. Sometimes, they manifested as lock escalation, the dreaded blocking, disastrous deadlocks, or poor performance. With the release of Optimized Locking in Azure SQL Database, issues are mitigated while helping to enhance performance and transactional concurrency. In this quick 10-minute episode of Data Exposed, we’ll showcase how this new feature helps prevent those manifestations!   Resources: Optimized locking   #techcommunity #azure #microsoft https://lnkd.in/gYMrB6dp