Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
424 reads
Tim Radney - Database Professional
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
869 reads
SQL Saturday #89 Atlanta GA
The official launch of SQL Saturday #89 was June 8th. Within the first week of the launch we have registered...
2011-06-15
507 reads
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,372 reads
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL...
2011-05-17
1,132 reads
SQL Saturday 74 – Jacksonville FL
I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak...
2011-05-02
886 reads
SQL Community Support
I have blogged before about my appreciation for the SQL community mainly within the PASS organization as that is what...
2011-04-25
529 reads
If you truly want to understand something try and change it.
I saw this quote on facebook last week and it really hit close to home. I had just started working...
2011-04-11
683 reads
SQL Saturday #70
This blog is long overdue about my journey to Columbia SC for SQL Saturday #70. I was very fortunate to...
2011-04-07
428 reads
SQL Saturday #62
I had the honor of traveling to Tampa Florida this past weekend and presenting a session to a great group...
2011-01-18
472 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