Book: Expert Cube Development with SSAS Multidimensional Models
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube...
2014-03-04
2,317 reads
James Serra's Blog
Introduction to Hadoop
Hadoop was created by the Apache foundation as an open-source software framework capable of processing large amounts of heterogeneous data-sets in...
2014-03-11 (first published: 2014-02-27)
8,327 reads
What is HDInsight?
There are two flavors of HDInsight: Windows Azure HDInsight Service and Microsoft HDInsight Server for Windows (recently quietly killed but...
2014-02-25
2,086 reads
Annoying Recruiters
In a follow-up to my blog post Low-rate recruiters – The bane of my existence, Michael Bramante (website) wrote me a...
2014-02-20
1,297 reads
PolyBase explained
PolyBase is a new technology that integrates Microsoft’s MPP product, SQL Server Parallel Data Warehouse (PDW), with Hadoop. It is designed to...
2014-02-25 (first published: 2014-02-18)
18,169 reads
Why I just became a Microsoft Employee
I have been an independent consultant (IC) for quite a while now. In an amazing number of coincidences, or just plain...
2014-02-11
1,502 reads
Power BI for Office 365 now available!
Microsoft has announced today the general availability of Power BI for Office 365!
Microsoft describes it as: Power BI for Office 365 is...
2014-02-10
799 reads
24 Hours of PASS: Business Analytics Edition videos online
On February 5, 2014 business intelligence experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...
2014-02-06
733 reads
Forcing a contractor to go W2
I have had a few questions like this: “I was wondering if there is a reason the vendor/broker/head hunter forces...
2014-02-04
778 reads
SQL Server Data Tools (SSDT) – January 2014 update
The SSDT January 2014 release has been updated to support both SQL Server 2012 Parallel Data Warehouse Appliance Update 1...
2014-01-28
1,473 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