In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios REST API using Azure Data Factory. Any tool that can...
2024-06-19 (first published: 2024-05-26)
216 reads
I returned last Sat, 15 Jun, from 9 weeks of crazy travel. It wasn’t all for work, but it was a long stretch. I spent a good portion of...
2024-06-19
14 reads
As I type this, we’re leaving behind spring, and all the amazing events that take place then, and entering the quiet time of summer. After that, we’ll go into...
2024-06-18
21 reads
Recently I was trying to delete a folder and kept getting the “something is using this, try again” dialog. It was annoying, but I couldn’t figure out what process...
2024-06-17 (first published: 2024-05-27)
570 reads
Oh good gosh. Six months without a single blog post. Most important information: I’m not dead. Apologies. The issue is pretty simple. I’m getting old. Ha! Seriously though, I...
2024-06-17
33 reads
I’m very excited to announce I’ve been selected as a speaker for dataMinds Connect 2024, Belgium’s (and maybe/probably/most likely mainland Europe’s) best and greatest Microsoft data platform conference. My...
2024-06-17
15 reads
I recently graduated with a Master’s in Strategic Communication from the University of Delaware. Attending the graduation ceremony with my sister made it a truly memorable experience. Here’s a...
2024-06-17 (first published: 2024-05-28)
299 reads
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a career game-changer. Companies crave professionals who can wrangle data, uncover insights, and drive decision-making. If...
2024-06-16
82 reads
I have a client using Planview Portfolios to manage their PMO. As part of the data warehouse, we want to extract the project data from the Planview REST API....
2024-06-14 (first published: 2024-05-26)
313 reads
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it, and perhaps building a data warehouse of sorts. The modern view of data warehousing seems...
2024-06-14 (first published: 2024-05-20)
341 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
India’s Leading Testing Laboratory FARE Labs Pvt. Ltd. offers precise OTR and WVTR testing...
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
This is a generic question. To the moderators, I wasn't sure where to place...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers