Presentation slides for Modern Data Warehousing
Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday. The abstract...
2014-08-14
1,211 reads
Thanks to everyone who attended my session “Modern Data Warehousing” at the Central New Jersey SQL User Group yesterday. The abstract...
2014-08-14
1,211 reads
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
639 reads
All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free. Check the session schedule for...
2014-08-07
1,255 reads
When doing ETL, you have the choice of using T-SQL or SSIS (see When to use T-SQL or SSIS for ETL). ...
2014-07-22
1,323 reads
I have a lot of books on my shelves dealing with business intelligence, data warehousing, master data management, and consulting....
2014-07-16
1,214 reads
All PASS Business Analytics Conference 2014 recordings are now available. If you purchased the online sessions, to view, log on to your myPASS...
2014-06-19
879 reads
Thanks to everyone who attended my session “Modern Data Warehousing” for Pragmatic Works last Thursday. The abstract for my session is below...
2014-05-25
1,001 reads
Thanks to everyone who attended my two sessions at SQLSaturday in Houston (more info). Here are the abstracts and PowerPoint links:
Best...
2014-05-12
922 reads
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics conference. The abstract is below. I...
2014-05-09
937 reads
This upcoming Saturday I will be presenting two sessions at SQLSaturday in Houston (more info). I hope to see you...
2014-05-08
786 reads
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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