Fundamentals of Storage Systems, Understanding Reliability and Performance of Solid State Storage
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
1,135 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
Fundamentals of Storage Systems, Solid State Storage Basics
Solid state storage is the new kid on the block. We see new press releases every day about just how...
2010-10-25
1,433 reads
At The End of the IO Road With C#? Pave New Road!
Not being one for letting a problem get the best of me, I took another look at the asynchronous overlapped...
2010-10-07
2,791 reads
Software Review: Idera’s Virtual Database
Ever since the upgrade from SQL Server 6.5 to 7.0 one of the most requested features I’ve heard people complain...
2010-09-21
3,177 reads
At The End of the IO Road With C#
Previously I’ve written about doing fun IO stuff in C#. I found out that some of my old tricks still...
2010-09-07
1,879 reads
What A Great SQL Saturday! Baton Rouge
Had a great time in Baton Rouge. The event was well attended and had an awesome lineup of speakers. I...
2010-08-16
806 reads
The Dangers of Sub-queries!!!!
Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...
2010-07-29
738 reads
Fusion-IO releases new 2.1 driver and firmware
And it is well worth the upgrade. I recently had the opportunity to interview David Flynn CEO of Fusion-IO and...
2010-07-23
1,092 reads
Creating UDL Files On The Fly
Many years ago, in the dark ages of DTS I created a little app that would take two parameters and...
2010-07-19
659 reads
Building My New Home, SQL Server IO
April of 2009 I decided it was time to blog about my SQL Server experiences in earnest. Steve Jones (twitter|blog)...
2010-07-14
532 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