Upgrading Denali CTP3 to SQL Server 2012 RC0
When I started looking into the upgrade path for this, I saw a couple of notes online about the fact...
2011-12-05
788 reads
DataOnWheels
“Beyond Rounded Corners” at the Microsoft BI User Group of Minnesota-Dec 6, 2011
Come join me and other Business Intelligence professionals at the Microsoft BI User Group meeting at Microsoft’s new offices in...
2011-12-02
460 reads
SQL Saturday #99 Minnesota on Friday 11/11/11
SQL Saturday 99 on Friday is upon us. I look forward to seeing you at the event. For details check...
2011-11-08
397 reads
SQL PASS Summit Final Day (Sessions)
Here is a summary of the final day of sessions I attended at PASS. Vertipaq vs OLAP – Change Your Data...
2011-10-16
491 reads
SQL PASS Summit–Day 4 (BI Sessions)
Here is the summary of the session I attended while at my 4th day at the Summit. (Technically, this is...
2011-10-16
423 reads
SQL PASS Summit–Final Day (Keynote)
Got to David DeWitt’s Keynote a bit late so this will not cover as much as normal. (For the record,...
2011-10-14
486 reads
SQL PASS Summit–Day 4 (Keynote)
Bill Graziano kicked off the event today with the notice of the official “Kilt Day” at the Summit. He also...
2011-10-13
422 reads
SQL PASS Summit – Day 3 (the rest)
After a info filled keynote, on to the rest of the day. I decided to attend the Bare Metal Instructor...
2011-10-13
475 reads
SQL PASS Summit–Day 3 (Keynote)
From the PASS president, Rushabh Mehta. PASS has facilitated 430,000 hours of training and expansion into the global community. These...
2011-10-12
458 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