Daniel Dodds-Wade

My feedback

  1. 436 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    34 comments  ·  SQL Database  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Dodds-Wade commented  · 

    We'd like to be able to capture historical data on certain important tables and data. For instance, on our products table, we'd like a record of each time the price changes, when it was made and by who. From what I've read, it appears that Change Data Capture is not available on SQL Azure and this is the server we are using to house our DB. Change Data Capture is exactly what we are looking for.

    https://msdn.microsoft.com/en-us/library/bb933994.aspx

    Thanks!

    Daniel Dodds-Wade shared this idea  · 
  2. 24 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Stream Analytics  ·  Flag idea as inappropriate…  ·  Admin →

    We are exploring the possibility of supporting CosmosDB change feed as ingress to Stream Analytics which will solve this scenario. For reference data, we already provide a mechanism to refresh reference data in Azure Blob storage using Azure Data Factory. More details about this here: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-use-reference-data

    We are listening and committed to making Stream Analytics even better! Keep your feedback coming.

    Daniel Dodds-Wade supported this idea  · 

Feedback and Knowledge Base