Don’t Pass Null
I’ve been rereading an excellent book called “Clean Code” by Robert C. Martin. This book has some practices that each...
2012-06-08
1,209 reads
Blog Posts
June 2012 – Monthly SQL Server Checklist
It’s the first Monday of the month, have you checked your servers out? Do you know that everything with your...
2012-06-08 (first published: 2012-06-04)
2,439 reads
Microsoft Master Data Services in SQL Server 2012
Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft. Master Data Services is...
2012-06-08 (first published: 2012-06-04)
20,628 reads
Twitter Handle Change
I have been thinking about this for a while now, but I have decided to change my twitter handle. I...
2012-06-08
729 reads
A Busy Week of Speaking
I'm hitting 3 venues in 5 days giving 4 different talks. If you plan on making one of these, I'd...
2012-06-07
1,050 reads
A Visit to the Eugene Area SQL Server User Group
When in Portland… This week I am in Portland, Oregon working with a customer. While I was here, I thought...
2012-06-07
612 reads
C# Explicit Interface Implementation
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
42 reads
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,325 reads
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a...
2012-06-07
10,806 reads
Do You Know An Exceptional DBA?
Do you know a DBA that saves the day time and again? Or one that doesn’t need to save the...
2012-06-06
983 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