I did a couple of recent podcasts that I wanted to mention: The first one was with Kirby Repko from the YouTube channel SQLTalk: Modern Data Warehouse Design with...
2019-08-23 (first published: 2019-08-08)
476 reads
Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to...
2019-07-29
64 reads
Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...
2019-07-22
966 reads
A challenge I have with customers who want to get hands-on experience with the Azure products that are found in a modern data warehouse architecture is finding a workshop...
2019-07-30 (first published: 2019-07-10)
358 reads
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they...
2019-07-08 (first published: 2019-06-25)
307 reads
The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources. Another way...
2019-06-20 (first published: 2019-06-06)
1,647 reads
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event last week, the major announcements in the data platform and AI space were: Machine Learning...
2019-05-30 (first published: 2019-05-16)
302 reads
As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...
2019-04-25
2,111 reads
I recently made available two more presentations that you might find helpful. Feel free to download them and present them to others (adding a line that you got them...
2019-04-04
58 reads
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data...
2019-03-14
2,257 reads
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Hi all, First I want to ask just a generic question. Does RLS in...
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
I have installed the SSIS extension for VS 2022 community. When I go into...
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers