Updating a SharePoint List Item With Flow When You Don’t Have The ID
I recently worked on a project that used Flow to update a SharePoint list each time an item was updated...
2017-07-17
539 reads
Data Savvy
Azure Data Factory and the Case of the Missing JRE That Wasn’t
On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...
2017-05-11 (first published: 2017-05-01)
1,291 reads
I Like to Move It, Move It – But Azure Data Factory Doesn’t
I’ve spent the last couple of months working on a project that includes Azure Data Factory and Azure Data Warehouse. ADF...
2017-04-11
607 reads
Insufficient Disk Space (T-SQL Tuesday #88)
This month’s T-SQL Tuesday – hosted by Kennie T Pontoppidan(@KennieNP) – is called “The daily (database-related) WTF“. He asked us to be...
2017-03-27 (first published: 2017-03-14)
2,777 reads
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 2
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll...
2017-03-21 (first published: 2017-03-10)
1,726 reads
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
617 reads
Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs
I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...
2016-11-07
754 reads
Process Compatibility Level 1200 SSAS Tabular Model from SSIS 2014
A client wanted to upgrade their SSAS model to SSAS 2016 to take advantage of some of the features of...
2016-10-21 (first published: 2016-10-14)
4,857 reads
Documenting your Tabular or Power BI Model
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,347 reads
BYO Time Zone Conversion With SSAS DMVs
This is just a quick note (since I apparently forgot and was puzzled for a moment) that the MDSCHEMA_CUBES DMV...
2016-09-21
485 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers