Fast Starts
We are barely under way with the New Year and it is shaping up to be a busier year already....
2013-01-08
992 reads
Jason Brimhall
SSRS Subscriptions Report
As a part of my series leading up to Christmas 2012, I shared a script to Report on SSRS Subscriptions....
2013-01-07
1,861 reads
SSRS Subscriptions Report
As a part of my series leading up to Christmas 2012, I shared a script to Report on SSRS Subscriptions. It was soon found to have a bug with...
2013-01-07
5 reads
T-SQL Tuesday #38 – Standing Firm
Introduction
Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community. This is the...
2013-01-04 (first published: 2013-01-02)
1,579 reads
T-SQL Tuesday #38 – Standing Firm
Introduction Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community. This is the party that happens on the second Tuesday of...
2013-01-02
3 reads
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!! What could be better than bacon wrapped frog legs? Oh yeah, more Virtual lab...
2012-12-25
4 reads
On the Twelfth Day…
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!!
What could be better than bacon...
2012-12-25
1,139 reads
On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies...
2012-12-24
1,024 reads
On the Eleventh Day…
Yesterday we had an introduction into setting up a virtual lab to help the DBA learn and test new technologies while improving his/her own skill set. Today we will...
2012-12-24
4 reads
On the Sixth Day…
What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras? No animals have...
2012-12-24 (first published: 2012-12-18)
1,710 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