Cheap But Good KVM Switch
I needed a KVM (keyboard-video-mouse) switch for home to let me switch between two machines, found the Trendnet 2 Port...
2008-04-03
327 reads
SQLAndy
Other Thoughts on Brand Building
Just a link today, but a good one on Building a Powerful Reputation that is a nice follow up to my...
2008-04-02
464 reads
If You Like Books - Look at LibraryThing
I've been following their blog for a while at LibraryThing and so far it looks interesting. The basic premise is...
2008-04-01
260 reads
Schedule Announced for SQLSaturday#3 in Jacksonville
Brian has just posted the schedule of sessions for SQLSaturday #3. I haven't gone through to see how many are...
2008-03-31
1,338 reads
Practices Does Make a Difference When Speaking
As I've mentioned a couple times previously I teach a free 'how to be a speaker' course, mainly to encourage...
2008-03-30
1,378 reads
More Code Per Module = More Bugs, But More Complex Code <> More Bugs?
SDTimes has an article up about Debunking Cyclomatic Complexity that talks about the results of some research that supports what I...
2008-03-28
1,512 reads
More Thoughts on LINQ to SQL
At the recent Orlando Code Camp I had the opportunity to spend a good bit of time discussing LINQ to...
2008-03-26
1,671 reads
Notes About our Raffle of the One Laptop Per Child Laptop at Orlando Code Camp
I've blogged about the OLPC project a couple times already, not as a political statement but just as a fascinating...
2008-03-24
1,367 reads
Orlando Code Code Follow Up
Although attendance was down this year (around 280 attendees) due to it being held Easter weekend, I thought this was...
2008-03-23
1,431 reads
Orlando Code Camp Reminder & A Special Raffle - One Laptop Per Child
Reminder that if you're registered the Orlando Code Camp is tomorrow. If you're registered and plans have changed, please cancel...
2008-03-21
1,595 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