PASS Votes
I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three...
2013-09-26
751 reads
Blog Posts
Performance Tuning In LA!
Hello Dear Reader! This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta. Due to...
2013-09-26
531 reads
SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,222 reads
Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,354 reads
Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,583 reads
Which personal traits should a #SQLPASS Director have?
A lot has been said about what each candidate would like to do and their track record of delivering in...
2013-09-26
1,089 reads
AdventureWorks2012 Bug on Azure
While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...
2013-09-25
1,315 reads
Houston Tech Fest 2013
I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at...
2013-09-25
605 reads
I’m Voting for Allen Kinsel
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
757 reads
It’s Election Season
It’s that time of the year again – time to make your voice heard as a PASS member. The PASS board...
2013-09-25
881 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