Compunnel Inc.’s Post

Update records in a Kusto Database (General Availability). Kusto databases, either in Fabric (KQL Database) or in Azure (Azure Data Explorer), are optimized for append ingestion.   In recent years, we've introduced the .delete command, allowing you to selectively delete records.   In February, we introduced the .update command in public preview.  This command allows you to update records by deleting existing records and appending new ones in a single transaction.   Today, the .update is Generally Available (GA)!   During the public preview, we introduced two syntaxes:  the simplified and expanded syntax.  We only GA the expanded... #techcommunity #azure #microsoft https://lnkd.in/gCCs8K9k

Exciting news for Azure SQL users! Introducing the public preview of database watcher for Azure SQL, a managed monitoring solution designed to elevate your database performance monitoring experience. Say goodbye to the hassle of deploying monitoring infrastructure or managing agents – with database watcher, you can kickstart monitoring your Azure SQL environment in minutes. Once activated, database watcher diligently gathers comprehensive monitoring data from your databases, elastic pools, and managed instances, all conveniently stored in a central data repository within your Azure subscription. Experience minimal latency with real-time insights, ensuring you're always up to date with your database's status. Stay tuned for more updates on how you can leverage this powerful tool to enhance your Azure SQL experience! #AzureSQL #DatabaseMonitoring #Microsoft #Azure https://lnkd.in/dgBVmZyr

💡 Quick Tips to Boost Your Azure SQL Database Performance! 💡 📊 Right-size Resources: Monitor and adjust DTU/vCore usage. ⚡ Optimize Indexes: Speed up your queries effortlessly. 🔍 Use Performance Insights: Identify and fix slow queries. 🔧 Enable Auto-Tuning: Let Azure optimize your indexes. 🔄 Regular Backups: Ensure your database's reliability. Elevate your database game today! 🚀 #Azure #SQLDatabase #TechTips #CloudComputing #DatabaseManagement #AzureSQL #DatabasePerformance

The Data API Builder for #AzureCosmosDB is now generally available! This #opensource project offers REST and GraphQL endpoints for Azure databases and on-premises stores. Learn more on #InfoQ 👉 https://bit.ly/3VXW5Wm

The Data API Builder for #AzureCosmosDB is now generally available! This #opensource project offers REST and GraphQL endpoints for Azure databases and on-premises stores. Learn more on #InfoQ 👉 https://bit.ly/3VXW5Wm

Lesson Learned #460: DataIO vs Buffer Pool. In the past week, we have dedicated our efforts to a service request where our customer asked questions:   Whether DataIO signifies the utilization of memory by the Buffer Pool. The rationale behind Azure SQL Database not releasing the memory allocated in the buffer pool.   In the following discussion, I would like to share with you the details of this explanation.    The first thing is to know, how buffer pool works: Azure SQL Server employs a sophisticated approach to manage its buffer pool, a critical component in the overall performance of the database system. The lifecycle of data... #techcommunity #azure #microsoft https://lnkd.in/gJS2dRA2

Fantastic update! The new Azure SQL Database free offer truly sets the bar higher with expanded limits, premium features, and flexible scaling—all at zero cost. These quick, insightful videos are perfect for understanding the enhanced value. A must-watch for anyone looking to leverage cloud innovation with ease!

Here is my latest post, where I break #Azure #SQL Managed Instance storage speed limits using #AKS #Arc data services and #ANF

🛬🛬🛬 Migrate SQL Server to Azure with Azure Arc and get the best Azure SQL option for your workload! ⏯ Try the new Azure SQL migration assessment feature in public preview: https://lnkd.in/dpH9iaqF 👨⚕️ Contact me to learn more about Azure Arc and hybrid SQL Server. #Azure #SQLServer #AzureArc #CloudMigration #HybridCloud

Here's a great writeup on connection modes in Azure SQL and how to improve your application's resiliency, latency and throughput.