Forum Widgets
Latest Discussions
Azure Synapse dedicated SQL pool vs. Azure SQL vs SQL
Hello, currently we operate on-premises PostgreSQL DB that we use as our data warehouse. I would like to set up a data warehouse in Azure, but the Azure portal is bit confusing, as there are multiple options: 1) in Azure Synapse, there is dedicated SQL pool (formerly labeled as Azure Data Warehouse) Then, outside Azure Synapse there are two additional options: 2) Azure SQL database ( /BrowseResource/resourceType/Microsoft.Sql%2Fazuresql ) and 3) "SQL database" (/BrowseResource/resourceType/Microsoft.Sql%2Fservers%2Fdatabases) https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing describes that Azure SQL (#2 above) uses symmetric multiprocessing (SMP) while "Azure Synapse Analytics" (#1) above uses massively parallel processing (MPP). My data needs are not so vast to utilize the MPP. Thus it seems I should be considering #2, i.e. outside the Synapse Analytics. Azure SQL (#2) above further branches into "Single Database", "Elastic pool" and "Single instance managed DB". I am guessing that for my scenario, "Azure SQL - Single Database" is the best option. If I choose this, will I be able to use this storage in Azure Synapse Analytics? Furthermore, to use Azure Data Factory (ADF) - if I set up "Azure SQL - Single Database", should I be aiming to use Data Factory within Azure Synapse Analytics, or outside it (i.e. use ADF in Azure portal)?
Exporting the results to CSV from Azure log analytics workspace
When i am trying to export the results of KQL Query in Azure log analytics workspace the results have some sort of limit and not all results are being exported.. What could be reason ? i can see the results at the bottom, but only get 50 rows when try to export to CSV file. I tried changing the page size from 50 to 200 rows but still same issue. Its not exporting the results from all other pages.. What could be the reason ? is there anything i need to change ? Help this rookie pleaseWelcome to the Azure Data and Analytics AMA!
Welcome to the Azure Data and Analytics Ask Microsoft Anything (AMA)! This live hour gives you the opportunity to ask questions and provide feedback. Please introduce yourself by replying to this thread. Post your questions in a new thread within the Azure AMA space, by clicking on, "Start a New Conversation" at the top of the page.
Loganalytics - Query not able to create a chart?
Hi, I am pretty new with Azure LogAnalytics. I am running this Query and I get expected result. // Not reporting VMs // VMs that have not reported a heartbeat in the last 5 minutes. // To create an alert for this query, click '+ New alert rule' Heartbeat | where TimeGenerated > ago(24h) | summarize LastCall = max(TimeGenerated) by Computer | where LastCall < ago(5m) But when I select "Chart" I get the following error message: Failed to create visualization The Stacked Column can't be created as you are missing a column of one of the following types: int, long, decimal or real Do you know how to get this chart working, how to I fix this? Many Thanks, MattiasNetwork metrics on VM
Hello! I'm looking at my VM's metrics (Monitoring->Metrics), and wodening what is the difference between below ones: Netwokr in (billable) vs Netwokr in total, and the same question about network out. I know it's a network traffic, but does this traffic include any internal (within vnet) traffic, backup, etc? Thanks for info! Best Regards, LukKQL: One Successful login followed by X failed login in Y time period for same user
Hello, I am new to KQL, and struggling to find the best option to build the query for One successful login followed by X failed logins in Y time period for same user. The scenario is user tried to do password guess for Y times and succeeded and a successful login was triggered and the whole scenario is time boxed. Any suggestion will be appreciated. I did find almost similar query "https://stackoverflow.com/questions/54041200/azure-log-analytics-monitoring-successful-sign-ins-following-repeated-sign-in-f" but this does not check if successful login came after failed. Thanks in advance.
