One of the recent Azure Cognitive Services additions is Azure OpenAI, a cloud-based resource that offers enterprise-grade capabilities typical of an Azure service (e.g. private networking, regional availability, and responsible AI content filtering) and provides access to OpenAI's generative AI models like GPT-3 and Codex.
Read MoreAzure Synapse Link for Dataverse provides a continuous pipeline of data from Dataverse to Azure Synapse Analytics or Azure Data Lake Storage Gen2. Once the link is established, the service will export all the initial data as well as sync any incremental changes, enabling customers to glean near real-time insights from data sourced from the Microsoft Dataverse service.
Read MoreA data architecture pattern that brings elements of the data warehouse to the data lake, enabling a broader set of analytical workloads to coexist on a unified platform. The data lakehouse is not a new product or service, but rather an evolution of the data lake pattern, made possible due to recent technology breakthroughs that have brought warehouse-like capabilities such as ACID transaction support, schema evolution, and time travel to the data lake.
Read MoreChange Data Capture (CDC) is the ability to identify and track changes made to data in a database. While there are a number of common patterns database administrators can employ to build custom CDC solutions, many database vendors provide embedded CDC features out of the box. This blog post will focus on Microsoft’s implementation of change data capture available across SQL Server and Azure SQL.
Read MoreA slowly changing dimension (SCD) is a dimension that is able to handle data attributes which change over time. Deciding on which specific type of slowly changing dimension pattern to implement in your data environment will vary based on business requirements (e.g. do you need to preserve history? do you need all history or just the previous value?).
Read MoreHarnessing the ability to ingest, explore, prepare, transform, and serve data, historically meant that customers needed to provision, configure and maintain multiple services, suited for the different stages of the data lifecycle. Within the Microsoft ecosystem and prior to the availability of Azure Synapse Analytics, the usual suspects that would help facilitate such a set of capabilities would include services such as Azure Data Factory for data integration, Azure Databricks for big data, and dedicated SQL pools (formerly SQL DW) for data warehousing. With Azure Synapse Analytics, Microsoft has unified these capabilities under a single analytics service.
Read MoreAzure Purview is the arrival of Microsoft’s long anticipated evolution of Azure Data Catalog, a unified data governance service that enables organizations to manage and govern data in a central location, while empowering users with the ability to perform data discovery across the entire data estate, with data sources that can exist on-premises, multi-cloud, or via software-as-a-service.
Read MoreAzure SQL is the term used to refer to the family of SQL database services, hosted on Azure, underpinned by the Microsoft SQL Server database engine. Microsoft provides several Azure SQL deployment options that provide varying levels of control and flexibility to meet different customer needs.
Read MoreMetrics Advisor is an Azure Cognitive Service that uses AI to automate the detection of anomalies in time series data. The service is able to ingest metric data from a variety of sources (e.g. Azure Data Lake Storage, Azure Cosmos DB, Azure SQL Database, etc), use machine learning to automatically find outliers, and provide diagnostic insights to aid root cause analysis.
Read MoreA collection of resources and learning material to help prepare for and pass exam DP-100: Designing and Implementing a Data Science Solution on Azure. This exam focuses on how to implement and run machine learning workloads on Azure; in particular, using Azure Machine Learning Service.
Read More
