How to keep up with technology
(Side note: There is a “subscribe” button on the right side of my home page if you wish to receive my blogs updates via email as soon as they are published). I have been asked a number of times on … Continue reading →
Category Archives: SQLServerPedia Syndication
Power BI guidance documentation
Recently there has been a number of great articles published on Power BI that I wanted to make you aware of that go beyond the features descriptions found in the Power BI documentation. These new articles fall under the Power … Continue reading →
Questions to ask when designing a data architecture
When I’m leading a full-day architecture design session (ADS) with a customer and the goal is to come up with a data architecture for them, I first start doing “discovery” with them for at least a couple of hours so … Continue reading →
Power BI as a enterprise data warehouse solution?
With Power BI continuing to get many great new features, including the latest in Datamarts (see my blog Power BI Datamarts), I’m starting to hear customers ask “Can I just build my entire enterprise data warehouse solution in Power BI”? … Continue reading →
Power BI Datamarts
As mentioned in my previous blog about the Microsoft Build event announcements, the biggest news was Power BI Datamarts. This is a new self-service capability included with Power BI Premium (premium capacity or per user) that enables users to uncover … Continue reading →
Microsoft Build event announcements
There were a number of data platform announcements at Microsoft Build yesterday that I wanted to blog about. Everything announced at Build can be found in the Microsoft Build 2022 Book of News. Microsoft Intelligent Data Platform. This is not a … Continue reading →
Power BI connectors to Azure Synapse
When using Power BI and pulling data from Azure Synapse, you will use the “Get Data” feature in Power BI. There are now three connections that you can use that I will cover in this blog. But first, a review … Continue reading →
Power BI Performance Features
It’s hard to believe but Power BI has now been available for over 10 years (see history)! Over the last few years there have been a number of new features to improve the performance of queries for dashboards and reports, … Continue reading →
Azure IoT Central
This is a short blog to give you a high-level overview on a product called Azure IoT Central. I saw this fairly new Azure product (GA Sept 2018) in use for the first time at a large manufacturing company who … Continue reading →
Azure Synapse and Delta Lake
Many companies are seeing the value in collecting data to help them make better business decisions. When building a solution in Azure to collect the data, nearly everyone is using a data lake. A majority of those are also using … Continue reading →
Data Lakehouse, Data Mesh, and Data Fabric
(NOTE: I have returned to Microsoft and am working as a Solution Architect in Microsoft Industry Solutions, formally known as Microsoft Consulting Services (MCS), where I help customers build solutions on Azure. Contact your Microsoft account executive for more info. … Continue reading →
Microsoft industry clouds
In talking with Microsoft customers, I have found that most are not aware that Microsoft has created industry clouds (see Microsoft Industry Clouds). So I wanted to use this blog to briefly explain what they are and how they may … Continue reading →
Distributed SQL
A very brief history of databases for online transaction processing (OLTP) workloads starts with relational databases (RDBMS), which worked well for many years. With the advent of the internet and the need for millions of transactions per second, NoSQL filled that … Continue reading →
Azure Synapse Analytics November updates
Microsoft recently came out with a blog on a bunch of new features available for Azure Synapse Analytics (see Azure Synapse Analytics November 2021 Update), and I wanted to point out my top ten personal favorites: Synapse Data Explorer now … Continue reading →
Azure Synapse Analytics database templates
One of the biggest announcements at Microsoft Ignite that seemed to be overlooked by a lot of people was Azure Synapse Analytics database templates, now in public preview. I wanted to dive into it a bit in this blog because … Continue reading →
Microsoft Ignite Announcements Nov 2021
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: SQL Server 2022: A new version of SQL … Continue reading →
Azure Purview is generally available
After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview). In short, Purview’s main purpose is to collect metadata from various … Continue reading →
Data Platform products for Microsoft gaps
Microsoft has a ton of data platform-related products, but there are certain areas where they either don’t have a product or what they have is limited and you need to look at a 3rd-party product to fill that gap. At … Continue reading →
Single-cloud versus Multi-cloud
A discussion I have seen many companies have is if they should be single-cloud (using only one cloud company) or multi-cloud (using more than one cloud company). The three major Cloud Service Providers (CSPs) that companies use for nearly all … Continue reading →
Podcast and presentation decks on data architectures
Tomorrow (Tuesday (8/10/21) I will be on a podcast for SaxonGlobal called “The Alphabet Soup of Data Architectures” where I will talk about the modern data warehouse, data fabric, data lakehouse, data mesh, and more. I hope you can check … Continue reading →