Where in the world are Jen and Sean?
Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January...
2016-01-28
1,037 reads
Jen McCown
Fun with Operator Precedence
Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...
2016-01-06 (first published: 2015-12-31)
2,814 reads
Issues and opinions on the PASS anti-harassment policy (#sqlpass)
PASS just published an anti-harassment policy reminder, quickly followed by a blog by Wendy Pastrick (about a bad experience at last...
2015-11-25
945 reads
A Data Age proclamation
Twice in two days now, I’ve gotten in discussions with people about the state of data usage…the idea that we have...
2015-11-12
697 reads
Improved #MinionBackup and #MinionReindex – new versions!
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
667 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
608 reads
You DO have outstanding, free backup and maintenance, right?
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
663 reads
Today at 12pm Central: #MinionEnterprise Talk – Backup Management!
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how...
2015-10-06
641 reads
PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2015-09-28 (first published: 2015-09-09)
1,262 reads
SQL Saturday San Diego tomorrow! (September 18)
This weekend we’re going to hit SQL Saturday San Diego for the first time ever! We are the excited. Come and...
2015-09-18
809 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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...
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