SQL Saturday Richmond - Postponed
If you’re anywhere from the southwest to the deep south, you’re probably aware of the impending winter weather bearing down...
2010-01-28
1,397 reads
Tim Mitchell
SQL Saturday 30 – Richmond VA
This weekend, I’ll be headed for the east coast to speak at the SQL Saturday in Richmond, VA on Saturday. ...
2010-01-25
715 reads
We Are Microsoft (GiveCamp Dallas)
Last weekend (January 15-17) found me at the third annual GiveCamp Dallas event, known locally as We Are Microsoft. This...
2010-01-23
732 reads
Three Things
So for the latest database geek meme, Paul Randal started this thing off and tagged Tom LaRock, who enlisted Grant...
2010-01-19
2,435 reads
LEFT(), or Left Out?
So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language. Like the...
2010-01-13
666 reads
PASS DBA Virtual Chapter Presentation
I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of...
2010-01-13
919 reads
Webcast Tomorrow - Dynamic SSIS: Using Expressions and Configurations
Join me tomorrow at 1:00pm CST as I present "Dynamic SSIS: Using Expressions and Configurations" for the PASS DBA virtual...
2010-01-12
1,023 reads
Goals for 2010
So I’d planned to already have this done and published before the new year rolled around, but life got in...
2010-01-06
1,174 reads
Board Election for the North Texas SQL Server User Group
The new year is less than 24 hours old and I’ve already been blessed with two different honors. I shared...
2010-01-01
553 reads
I’m a Microsoft MVP!
I received a notification e-mail earlier this morning that I’ve been selected as a Microsoft SQL Server MVP for 2010! ...
2010-01-01
907 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