Three Years late, Was It Worth The Wait? Windows 7, Vista Promises Delivered.
Having been married to Microsoft for most of my professional career doesn’t mean I drink the Kool-Aid.
I have had...
2009-06-16
764 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week! Some quick observations: The build quality is outstanding. Nothing cheap at all about this card. The engineering that has gone into this shows in every way. It is made up of modules that...
2009-06-15
1,479 reads
What I’ve Read and Recommend to Others – SQL Server 2008 Part 1
I read, a lot. I’ve been a prolific reader all my adult life.
I use to split my reading between...
2009-06-14
1,126 reads
It’s Beginning to Look A Lot Like Christmas……
We got something good in the mail last week!
Some quick observations:
The build quality is outstanding. Nothing cheap at all...
2009-06-08
579 reads
Understanding File System IO, Lessons Learned From SQL Server
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and Assembler. I also spent quite a bit of time in Visual Basic. I loved it for prototyping and what we now call RAD development efforts.
2009-06-08
3,393 reads
Found a Bug in SQL Server 2005
It doesn’t happen often but every once in a while you may be the lucky person to find a previously unknown bug in SQL Server.
2009-06-05
4,014 reads
Found a Bug in SQL Server 2005
It doesn’t happen often but every once in a while you may be the lucky person to find a previously...
2009-05-29
2,147 reads
Fusion IO’s on Their Way!
My company has taken the plunge and we have two of the Duo 640’s coming. As soon as they get...
2009-05-29
1,533 reads
Understanding File System IO, Lessons Learned From SQL Server
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and...
2009-05-29
1,947 reads
SSD, The Game Changer
I’ve often described SQL Server to people new to databases as a data pump. Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour. If you want to upgrade your pumping systems it can be...
2009-04-21
6,824 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