PASS Pre/Post Con Selections
One of my favorite people in the SQL community, Andy Leonard, posted a blog criticizing the selection process for the pre...
2010-05-31
1,776 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
IndyTechFest
What would get over 400 techies to give up a beautiful Saturday and spend the day inside learning about SQL...
2010-05-23
1,015 reads
News
If you follow me on Twitter or are my friend on Facebook, you might already know the news. I am joining...
2010-04-29
2,000 reads
MVP Summit Review
I was lucky enough to attend the MVP Summit held last week in Redmond and Bellevue. I attended the Summit...
2010-02-23
852 reads
T-SQL Speed Phreakery Explained
If you haven't seen the Simple-Talk newsletter (it's free, so sign up!) you may not have seen my article on...
2010-02-08
1,264 reads
PASS 2009 DVDs
I was really excited when my PASS DVDs arrived last week. I had purchased the DVDs (or maybe CDs) back...
2010-02-05
949 reads
What three events brought you here?
I'm not sure if I have been tagged by anyone, but this is such an interesting topic I thought I...
2010-01-19
446 reads
Holiday gift for your favorite SQL Server Professional
If you have been putting off ordering your copy of "SQL Server MVP Deep Dives", now is your chance to...
2009-12-23
474 reads
Teaching and Learning
You learn a lot when teaching someone else, whether that be writing articles or books or actually teaching a class....
2009-12-23
660 reads
Introduction to Common Table Expressions
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,221 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