SQL Saturday 14 - Pensacola
I’ve just arrived home from a quick trip to Pensacola to speak at SQL Saturday 14 in Pensacola, FL. I’m...
2009-06-07
1,338 reads
Tim Mitchell
Upcoming Speaking Engagements
For those who are interested, I've got a couple of speaking engagements coming up in the next two weeks. I'll be speaking...
2009-06-01
613 reads
Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,160 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,940 reads
Sometimes, code comments are informative and helpful
... and other times, they are stop-you-in-your-tracks funny. Here's an example of the latter:
http://msmvps.com/blogs/brianmadsen/archive/2009/04/21/funniest-code-comment-ever.aspx
2009-05-19
702 reads
The Windows 7 RC0 Experience
Over the past 2 days, I’ve gone full bore into Windows 7. I’ve installed RC0 on 2 of my laptops,...
2009-05-12
656 reads
Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,204 reads
SQL Saturday Pensacola - Schedule published
The event schedule for SQL Saturday Pensacola has been published. This event will be held on Saturday, June 6 at...
2009-04-16
792 reads
Never Delete Data
Should you ever delete data? In a production environment, do the benefits of deleting old data outweigh the possible risks?
Data...
2009-04-07
1,688 reads
SQL Saturday Jacksonville call for speakers
If you’re available and are (or can be) in the Jacksonville FL area the first weekend of next month, check...
2009-04-02
755 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...
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...
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