DBAs Continue to Make More than Other IT Professionals
According to a study by PayScale, and published in the July/August 2009 issue of Inc. Magazine, Database Administrators make more...
2009-08-03
558 reads
Blog Posts
Eval Results from SQLSaturday #7
John finally got things caught up and had time to finish the evals, here’s how I did on my presentation...
2009-08-03
327 reads
Free Training! 24 hours of PASS
PASS is sponsoring a 24 hours of PASS event on September 2nd. Consecutive live (Live Q&A also) 1 hour sessions...
2009-08-03
319 reads
Looking back at SQLSaturday #17 – Baton Rouge
I woke up early on Saturday for a run. Staying at the Cook Hotel on the LSU campus, I had...
2009-08-03
585 reads
Pain of the Week Webcast
Thursday this week I get to hang out, virtually, with some of the heavy hitters of the industry, Brent Ozar,...
2009-08-03
521 reads
SQL Bloggers – Join The PASS Blogger Group on LinkedIn
We launched this last week, a dedicated sub group for sql bloggers. To be eligible to join you have to...
2009-08-03
250 reads
SQL Saturday #17 – Baton Rouge
At 5:00 AM on August 1, 2009 I was awaken by a ringing cell phone. It was Mark, the official...
2009-08-03
484 reads
SQL Saturday Baton Rouge – Recap
After a long weekend of travel and speaking, I’m finally able to put my feet up and get a little...
2009-08-03
990 reads
SQL Server Standard
PASS is relaunching the SQL Server Standard with a wholly new approach and format. I’ll put more out about it...
2009-08-03
713 reads
Technical Presenters – Make your point
I caught this blog post, Who says technical presentations can't be engaging?, today thanks to Dana Coffey (@crazeegeekchick on Twitter). ...
2009-08-03
335 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