Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,130 reads
Adventures in SQL
SQL University Troubleshooting Week: Having a Plan for Every Situation
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
723 reads
SQL University Troubleshooting Week: Keeping an Open Mind
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
760 reads
SQL University Troubleshooting Week: Communication
It should come as no surprise that the first topic I am covering this week is communication because the first...
2011-05-24
1,434 reads
SQL University Troubleshooting Week Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
697 reads
SQL University Troubleshooting Week: Syllabus
Welcome to SQL University Troubleshooting Week. For anyone unfamiliar with SQL University, it is a project created by Jorge Segarra...
2011-05-23
870 reads
SQL Saturday 67 Slides Are Now Available
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
721 reads
Looking Up Email Addresses with PowerShell
A week or so ago Aaron Nelson (Blog|Twitter) put out a call for help on Twitter looking for anyone that...
2011-01-20
13,763 reads
Making It Right
Last week Jonathan Kehayias (Blog|Twitter) used his blog to publicly call out Thomas LaRock (Blog|Twitter). I am not going to...
2011-01-11
659 reads
Would You Like To Play A Game?
Do you have a favorite line from a holiday movie? Can you change it around slightly to make it SQL...
2010-12-20
770 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