Countdown to PASS Summit 2012 – 5 to Go – Communities in the Community
Just 5 days to Summit kick off. Today’s discussion is about communities within the community. That’s right. There is more...
2012-11-01
583 reads
DataOnWheels
Countdown to PASS Summit 2012 – 6 to Go – Magenic Brings 9
Getting closer, 6 days to Summit 2012! Today, I just have to give kudos out to Magenic, my current employer....
2012-10-31
1,231 reads
Countdown to PASS Summit 2012 – 7 to Go – My First Summit Presentation
Seven days, one full week, until opening night at Summit 2012. Getting excited yet? In my first post of the...
2012-10-30
1,242 reads
Countdown to PASS Summit 2012 – 8 to Go – What Is PASS Anyway?
Eight days to go. So after going to my first conference, I was surprised that I did not know more...
2012-10-29
1,207 reads
Countdown to PASS Summit 2012 – 9 to Go – My First Summit
We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...
2012-10-28
588 reads
Using Word 2013 to Create Blog Entries
Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the...
2012-10-26
2,779 reads
X-XMLA: vii. Partition Management with XMLA
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
633 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window functions. The enhancements to SQL Server 2012...
2012-09-26
900 reads
X-XMLA: vi. Processing and Out-of-Line Bindings in XMLA
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
800 reads
SQL Saturday #149 and CodeMastery–Minnesota Events
We are less than two weeks away from SQL Saturday #149 in Minneapolis on September 29, 2012 with two preconference...
2012-09-18
517 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