Operation: Dinner Different
My wife and I try to have dinner out every other week or so, but we tend to fall into...
2010-03-12
766 reads
Blog Posts
Orlando Code Camp – March 27, 2010
I’ll be attending and speaking at the Orlando Code Camp on March 27, 2010 at Seminole State College along with...
2010-03-12
551 reads
SCSUG March Meeting Recap
The Monsoon
My trip to the meeting, short as it was, involved some of the worst driving conditions I've ever personally...
2010-03-12
393 reads
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
2010-03-12
3,687 reads
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
2010-03-12
509 reads
SPB Applications for Windows Mobile
<<placeholder>>
…for product review
Weblog by Paul Turley and SQL Server BI Blog.
2010-03-12
414 reads
Working for/with High Caliber Folks
Within a couple of days of each other, both Andy Leonard (@AndyLeonard) and Paul Randal (@PaulRandal) tweeted about possible job opportunities which would...
2010-03-12
1,856 reads
Alternate Row Colors in an SSRS 2000 or 2005 Matrix
To create a "greenbar" report in a table with alternating row colors, you can simply
use the RowNumber function to determine...
2010-03-11
1,688 reads
BiTemporal Tables, anyone?
I'm doing some interesting research on using BiTemporal tables and I was wondering if anyone out there has any real-world...
2010-03-11
724 reads
Column Chart with Goal Threshold Line
Chart reports are an effective way to visualize data to show trends and comparisons
in a way that can help the...
2010-03-11
2,019 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