More on Mentoring
Two weeks ago I did five posts on mentoring, and based on that I received a couple interesting notes, here...
2008-04-28
1,368 reads
Blog Posts
SQLSaturday #3 Jacksonville - Final Reminder!
Just checked the registrations and we're at 354, with plenty of room for more! Brian has been busy tweaking the...
2008-04-28
1,354 reads
Visiting the Space Coast .Net Users Group in June
My friend Ken Tucker invited me to speak on June 11, I'll be doing a short presentation on SQL performance...
2008-04-28
1,567 reads
Gotta love the Information Age
First it was CNN 24x7. Next the Internet brought us live information from around the globe.
Now this... real-time pizza tracking...
2008-04-27
1,438 reads
Orlando Heroes Launch Event
I attended this on Friday along with fellow oPASS members Mike Antonovich and Ulysses Vasquez to represent PASS, and we...
2008-04-27
1,507 reads
SQL Server in the Cloud
The April 15, 2008 edition of SDTimes (PDF download here) has some information about SSDS, the SQL Server in the...
2008-04-27
1,507 reads
Recent slate of IIS attacks - more info
The recent slate of attacks on IIS servers don't seem to be an attack directly against IIS or against SQL...
2008-04-26
2,198 reads
Cursors and high gas prices
Using cursors is a controversal topic. As a former developer, that is the way I thought about processing data at one...
2008-04-25
1,392 reads
I've got a date with an Error Log -- Error Logs Part II
Error Logs Part II -- Enumerating the error logs
In my first post on SQL Server Error Logs, I briefly mentioned using...
2008-04-25
1,749 reads
More LINQ Discussion
Steve Jones recently posted an editorial about LINQ and the resulting discussion encapsulates most of the points of view on...
2008-04-24
1,771 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