4 Attitudes I Wish I Had Earlier as a DBA
I was tagged by Mike Walsh (blog | twitter) in his post 4 Attitudes I Wish I Had Earlier As a...
2014-09-05 (first published: 2014-08-28)
8,123 reads
Blog Posts
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-05
640 reads
Database Free Space Monitoring – The right way
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
457 reads
Four things I wish I’d known back then
In the blogging meme of the day, I was tagged by my friend Tim Costello to share four things I...
2014-09-05 (first published: 2014-08-28)
8,204 reads
Friday Followup For September 5, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-09-05
337 reads
Reblog: August 29 to September 4
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-09-05
734 reads
Silicon Valley is a different world
I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing...
2014-09-05
783 reads
Speaker of the Month: September 2014
This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to...
2014-09-05
524 reads
Speaking at SQLSaturday Barcelona, Spain 2014
A couple of days ago, when I was in Germany – I have received some extremely exciting news that I was...
2014-09-05
135 reads
SSC Editorial-Titles Matter – Part 2
I wrote Titles Matter – Part 2 based on lessons learned the hard way not long ago. Titles matter because they...
2014-09-05
519 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