How Do Azure Subscriptions Work?
In this Azure Every Day installment, I’d like to talk about your organization’s subscription hierarchy. When working with Azure, it...
2018-09-14 (first published: 2018-08-31)
2,644 reads
Calculating Quartiles with DAX and Power BI
Like many of my blog posts, this post is inspired by some work I was doing with a customer who...
2018-09-18 (first published: 2018-08-31)
4,177 reads
Extended Security Updates: No More Freebies
As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our...
2018-08-31
971 reads
I’m Speaking at SQLSaturday Cambridge!
Speaking at SQLSaturday Cambridge!
I’m proud to announce that I will be speaking at SQL Saturday Cambridge on September 8th 2018! And wow, 748 SQL Saturdays! This one won’t let you...
2018-08-31
21 reads
I’m Speaking at SQLSaturday Cambridge!
Speaking at SQLSaturday Cambridge!
I’m proud to announce that I will be speaking at SQL Saturday Cambridge on September 8th 2018! And wow,...
2018-08-31
326 reads
Talking Data: Six Word Stories
In six words, can you give a compelling description of your data?
I’m taking the Microsoft DAT248x course as part of...
2018-08-30
337 reads
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,138 reads
ARM vs Classic Deployment in Azure
When Azure Resource Manager (ARM) was created back in 2014, I (like many) thought, “What does that mean?” Up until...
2018-08-30
317 reads
Repair Visual Studio for Mac: Extension node not found in path
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start....
2018-08-30
362 reads
Custom Data Purging in SQL Monitor
In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a...
2018-08-30
412 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers