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...
2022-06-30
25 reads
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...
2022-06-30
25 reads
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...
2022-06-29 (first published: 2022-06-08)
323 reads
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...
2022-06-20 (first published: 2022-05-25)
226 reads
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...
2022-06-08 (first published: 2022-05-13)
212 reads
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...
2022-05-04 (first published: 2022-04-25)
427 reads
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...
2022-04-11 (first published: 2022-03-31)
139 reads
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...
2022-03-02
103 reads
(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...
2022-02-08
32 reads
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...
2022-01-28 (first published: 2022-01-18)
150 reads
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...
2022-01-07 (first published: 2021-12-29)
482 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Over the past couple of years, I’ve developed several tools that I’ve been using...
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
Can someone let me know why I'm not able to use CAST method to...
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
So I have inherited an older SQL 2014 Server and have been working on...