2019-08-20
432 reads
Career Growth
Organized Learning
Learning to become a DBA is often a winding and twisty road. Steve has a little advice today.
2019-08-13
252 reads
Measuring the Right Things
In this weeks Simple Talk editorial Kathi Kellenberger discusses how to measure the performance of a development team and why you should always make sure you are measuring the right thing, not just the easy thing.
2019-08-12
The 2019 Home Lab
Steve wants to know what's in your current home lab. Leave a note and help others learn to set one up.
2019-08-09
610 reads
More MVPs Than Awards
Every year, July 1 is the Microsoft MVP Renewal date and quite a few people received good news that day. I was one of those renewed for another year, and I am honored that Microsoft chose me again. I also congratulate all the others that received the award for the first time as well as […]
2019-07-29
277 reads
Learning to Stop Being a Hero
There is a hero complex for many in IT. Steve provides some advice in how we should look at our workload and our employer's expectations when we consider a new job.
2019-07-11
1,111 reads
Building Helpful Commit Messages
Using a VCS is a core skill, according to Steve. One part of that is learning to write better commit messages.
2019-07-08
477 reads
Balancing Hard and Soft Skills
Today Steve talks about the soft skills and why these might be important as you advance in your career and grow into a senior role.
2019-07-02
537 reads
Improving Tech with Compassionate Code
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
2019-06-27
Setting Session Skill Levels
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
2019-06-10
374 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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...
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