Reading a SharePoint List with Azure Logic App
Sometimes in life you have to do things you really don’t like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData...
2020-04-07
1,198 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Quickly Editing Data in SSMS
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having...
2020-04-02
44 reads
SUMX returns incorrect results with duplicates
Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been...
2020-03-02 (first published: 2020-02-27)
481 reads
Cool Stuff in Snowflake – Part 11: RESULT_SCAN
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-02-04
47 reads
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-27 (first published: 2020-01-21)
222 reads
Author of the Year 2019 Nomination at MSSQLTips
This year I’ve been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine people have been nominated as well, you can check...
2020-01-21
4 reads
Book Review: T-SQL Window Functions by Itzik Ben-Gan
A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. It’s has been one of my most...
2020-01-01 (first published: 2019-12-19)
1,033 reads
T-SQL Tuesday #121: Gifts received for this year
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be...
2019-12-24 (first published: 2019-12-10)
244 reads
Book Review: T-SQL Window Functions by Itzik Ben-Gan
A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. It’s has been one of my most...
2019-12-19
29 reads
Cloudbrew 2019 – Slides
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...
2019-12-19
15 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Create and Read the Analysis Services Flight Recorder
Comments posted to this topic are about the item Create and Read the Analysis...
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers