James Serra's Blog

Time 2021-05-23 20:12:18

Web Name: James Serra's Blog

WebSite: http://www.jamesserra.com

ID:178592

Keywords:

James,Serra,Blog,

Description:

At the Microsoft Business Applications Summit 2021, a ton of new features for Power BI where announced. Below is my list of top ten new features, but there were plenty more. For a list of all the announcements, see Microsoft Continue reading I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data warehouse (MDW) and the Azure products that you can use for Continue reading Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform and AI related announcements: Azure Arc enabled machine learning (preview): Build models Continue reading I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer is almost always star schema, and Patrick LeBlanc does a great Continue reading The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of this blog. Data Mesh was first introduced by ThoughtWorks via the Continue reading As a follow-up to my blog Data Lakehouse Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a recent paper by Databricks. Databricks uses the term Lakehouse in their Continue reading There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use cases for syncing databases are to distribute reads (i.e. a second Continue reading Announced last week is a major new feature for Power BI: you can now use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and combine it with other DirectQuery datasets and/or imported datasets. This is a HUGE Continue reading Azure Purview is at data governance solution that is the sequel to the product Azure Data Catalog, and is now available in public preview. Purview catalogs data from on-premises, multi-cloud, or software-as-a-service (SaaS) locations. Purview let s you understand exactly what Continue reading (Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th at 1:10pm EST, at the PASS SQL Saturday Atlanta BI (info) (register) (full schedule)) Great news! Azure Synapse Analytics is now GA (see announcement). While most Continue reading I will be speaking at two upcoming PASS SQLSaturdays. These are free events that you can attend virtually: Azure Synapse Analytics: A Data Lakehouse 12/5/20, 1:10pm EST, PASS SQL Saturday Atlanta BI (info) (slides) Azure Synapse Analytics is Azure SQL Continue reading For those companies that can t yet move to the cloud, have certain workloads that can t move to the cloud, or have limited to no internet access, Microsoft has options to build your own private on-prem cloud via Azure Stack and Continue reading A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus a T-SQL view on a file in a data lake? Note Continue reading I have listed below the top questions I see from customers about Azure Synapse Analytics and Power BI, and the blogs that I have written that try to answer each question. I have also added these questions to my blogs Continue reading As I was finishing up a demo script for my presentation at the SQL PASS Virtual Summit on 11/13 (details on my session here), I wanted to blog about part of the demo that shows a feature in the public Continue reading Microsoft Ignitehas always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related announcements: Usage-based optimization with Azure Synapse and Power BI: A new Continue reading There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and clicking the + at the top to the right of Data Continue reading (updated 12/8/20)The public preview version of Azure Synapse Analytics has three compute options and four types of storage that it can access (mentioned in my blog at SQL on-demand in Azure Synapse Analytics). This gives twelve possible combinations of querying Continue reading

TAGS:James Serra Blog 

<<< Thank you for your visit >>>

Blogs on concepts such as big data and data warehousing, as well as blogs about Microsoft technologies

Hot Websites