Use the WordPress Revision Counter to Keep Shipping Posts
I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve...
2015-03-24
707 reads
Blog Posts
Using New-TimeSpan to convert friendly time
The question was this:
This is just a quick/fast snippet in response to that question, but I can think of a...
2015-03-24
453 reads
Who is cjsommer?
I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...
2015-03-24
259 reads
0 to Speaker
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...
2015-03-23
699 reads
Exam Prep 70-463: Executing packages in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-23
1,071 reads
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...
2015-03-23
2,290 reads
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
684 reads
How to resolve Space issue in SQL server 2005 TIP #93
Hello friends,
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more...
2015-03-23
769 reads
New SQL Server Blog Author Challenge
My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back...
2015-03-23
461 reads
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-23 (first published: 2015-03-16)
7,891 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...
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...
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