Task Factory's Address Parse Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,063 reads
BrianKMcDonald
Task Factory's: Terminator Destination
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,558 reads
Task Factory: File Properties Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
2,082 reads
Task Factory: Advanced Email and SMS Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,691 reads
JAX Code Camp 2011 Review and Slide Deck
Yesterday, my wife (twitter: @sherrilmcdonald) and I spoke at JAX Code Camp 2011 in Jacksonville, Florida. The event was well...
2011-08-28
915 reads
JAX Code Camp 2011
For the past 7 years, Bayer White and other Jacksonville .Net leaders have put on great Code Camps for .Net...
2011-08-19
1,007 reads
Columbus GA SQL Server Users Group Webinar Tomorrow
I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that...
2011-07-25
1,307 reads
End Of Month Function in Denali CTP 3
While playing around with Denali, I came across a function that I believe should have been included in SQL for...
2011-07-17
1,669 reads
BI Documenter: Impact Analysis and Object Lineage
Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database...
2011-07-13
2,680 reads
SQL Server 2011 CTP3 (Denali) Released
I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...
2011-07-12
1,372 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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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