DAX IsFiltered Function
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,033 reads
Salvo(z) SQL
Ten SQL Kindle eBooks for Under $10
Introducing Microsoft SQL Server 201231 Days of SSIS with SQL Server 2008 R2SQL Server Interview Questions and AnswersPerformance Tuning with...
2012-10-07
1,220 reads
SQL Azure–Failed to Update because the database is read-only
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...
2012-10-05
2,338 reads
SQL Saturday #149 Minneapolis 2012
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...
2012-10-03
821 reads
T-SQL Tuesday – Help! I Need Somebody
By Jennifer Salvo
Today is T-SQL Tuesday #34 hosted by Rob Volk (B, T). This month’s topic is ‘Help! I Need...
2012-09-11
888 reads
Azure Virtual Machine TempDb Placement
The recommended location for the tempDb on an Azure virtual machine, is the non-persisted D: drive. This drive is actually...
2012-09-06
2,070 reads
Personal Goals
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...
2012-09-01
1,514 reads
Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA
Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings. I’ve intended...
2012-08-24
2,154 reads
Meme15: Top 5 Reasons I Like My Job
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started...
2012-08-16
1,329 reads
T-SQL Tuesday: Trick Shots (Currency Conversion in SSAS)
Today is T-SQL Tuesday #33 hosted by Mike Fal. The topic is SQL Server – Trick Shots. This assignment involves blogging...
2012-08-14
951 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers