The Question – Why?
The question I get asked a lot by other data professionals at conferences, events, speaking engagements, family, friends, etc. is...
2014-10-14 (first published: 2014-10-06)
5,944 reads
The SQL Professor
C-R-U-D The Basics
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,119 reads
Passwords – A T-SQL Tuesday Topic
Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you...
2014-09-18
314 reads
SQL Prompt 6.4 – Get It
This guy looks just like me a few weeks ago only one difference…..he has hair!!! Okay seriously though, I felt...
2014-09-18
463 reads
What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,104 reads
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...
2014-08-20
581 reads
And Just Like That….Three Years
Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today...
2014-08-18
292 reads
T-SQL Tuesday #57 – SQL Family and Community
Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...
2014-08-12
300 reads
SQL Prompt – The Power Within
*Photo by Red Gate
Come a little closer; no seriously come on over just a little closer as I don’t want...
2014-07-15
562 reads
T-SQL Tuesday #56 – Assumptions
Question: “What time is it?”
Answer: “T-SQL Tuesday time”
Question: “What time?”
Answer: “T-SQL Tuesday time”
“I can’t hear you?!?!?!”
That’s right; it’s that time...
2014-07-09
409 reads
Blogs
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...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
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