SQL Saturday Atlanta Recap
I had a great time at SQL Saturday Atlanta last weekend. I drove from Orlando to Atlanta on Friday with...
2009-04-29
1,530 reads
Blog Posts
SQLSaturday #15 is May 2nd, 2009 in Jacksonville
My friend Brian Knight is leading the 2nd annual SQLSaturday in Jacksonville on May 2nd. Right now it looks like...
2009-04-29
1,326 reads
The #1 Secret to Building Your Skill Set is...
Self-Discipline
Yes, I've said it: self-discipline.
I'm reading a book called Disciplines of a Godly Man by R. Kent Hughes. Now...
2009-04-29
1,979 reads
The Industry’s Best IT Certification
The Best 10 IT Certification
Every IT Technology has the importance and positive values to use for the business.So the people...
2009-04-29
1,592 reads
Bonuses – Management Inequalities
If you own a business, I believe that you have a right to make more money than the rest of...
2009-04-28
1,962 reads
2009-04-28
1,482 reads
European PASS Conference 2009 Has 254 Attendees
The 2009 European PASS Conference, which was held April 22-24, 2009, had 254 attendees from 22 different countries. In spite...
2009-04-28
1,623 reads
Security Basics: Defense-in-Depth
In my security presentations, another basic I talk about is defense-in-depth. The idea here is to produce multiple layers of...
2009-04-28
4,237 reads
Starting Conversations - Part 3
If you haven't already, start with Part 1 and Part 2. In Part 2 I mentioned that I have hired...
2009-04-28
1,414 reads
Asymmetric Keys in SQL Server
I've been tech editing an encryption book for SQL Server. It's long overdue, and I think it will be a...
2009-04-27
2,711 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