For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using...
2014-11-18
51 reads
Blog Posts
For better Sql code use fake tables
When unit testing code there is a really powerful feature that is either called mocking or faking or sometimes using stubs and what these mean is creating objects that...
2014-11-18
9 reads
MDX #42–IsEmpty? or = 0 ? or IS NULL?
In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and...
2014-11-18 (first published: 2014-11-12)
22,719 reads
More on that Cyberwar
As a follow-up to my post on being at war, cyberwar:
State Department Hacked
If the experts are correct, this trend is...
2014-11-18
578 reads
Thoughts On A State of the Chapter Statement (and Doing More)
This is a follow up to a thought I voiced on Twitter last week – the value of a once a...
2014-11-18
568 reads
What Are You Thankful For
Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful...
2014-11-18
520 reads
2014 PASS Summit 2014 Board Q&A Notes
As has occurred in previous years at the PASS Summit the PASS Board of Directors held an open Q&A session...
2014-11-17
693 reads
Essentialism: The Disciplined Pursuit of Less by Greg McKeown
While on my trip to PASS Summit 2014, I have selected one more book to read on the long flights...
2014-11-17
447 reads
How To Use the Unpivot Transform in SSIS
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be...
2014-11-17 (first published: 2014-11-11)
7,983 reads
Interview Questions on SQL Server Database Mirroring
1) What is default port of Database Mirroring Endpoint?
Ans : 5022
2) Database Mirroring comes with which edition?
Ans: SQL Server 2005 SP1....
2014-11-17
20,512 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
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