STRING_SPLIT Has Ordinals
I noticed the docs for STRING_SPLIT now show that there is a third parameter. This brings us an ordinal for the positioning of the data. The format is now:...
2021-11-22 (first published: 2021-11-17)
1,599 reads
Blog Posts
Daily Coping 19 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-19
42 reads
My PASS Data Community Summit 2021 Speaking Experience
If you’d asked me 5 years ago if I would ever speak at Summit, I’d have said “no way, not possible.” I didn’t even think I was able to...
2021-11-19
8 reads
Notes on the 2021 PASS Summit
I attended the three main days this year and wrote notes as I went. As I sat down to type them up I started by going back to look...
2021-11-19 (first published: 2021-11-14)
335 reads
Power BI Adding Translations to Rename Columns – XMLA, TOM, C#
If you are new to using C# and the Tabular Object Model (TOM), please check out the previous blog post (https://dataonwheels.wordpress.com/2021/10/15/power-bi-meets-programmability-tom-xmla-and-c/) for both an introduction to the topic and...
2021-11-19 (first published: 2021-11-12)
256 reads
Daily Coping 18 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-18
12 reads
Daily Coping 17 Nov 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-11-17
14 reads
Days of future past
There’s a lot going on in the world today. It feels like there’s too much for us to think about. Speaking for myself, I’m worried about the environment first...
2021-11-17
16 reads
Notes on SQLSaturday Orlando 2021
We held an in-person SQLSaturday here in Orlando last weekend (Oct 30th). We didn’t organize one last year, there was just too much risk and too much uncertainty, so...
2021-11-17 (first published: 2021-11-10)
204 reads
Row-Level Security Basics–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I realized recently that I hadn’t really blogged...
2021-11-17 (first published: 2021-11-08)
343 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU SEMARANG Call CSO; (+62 821°3111°179
Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
BCA KCU THAMRIN Call CSO; (+62 821°3111°179
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Wonogiri Call CSO; (+62 821°3111°179
Jl. Jend. Sudirman No.233, Cubluk, Giritirto, Kec. Wonogiri, Kabupaten Wonogiri, Jawa Tengah 57611
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers