Sometimes You Need an Analog Solution, Sorta - Earth Class Mail
Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so...
2008-01-09
499 reads
SQLAndy
SQL Injection, Again!
Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in...
2008-01-09
630 reads
Partitioning Part 3 Posted on SSC
Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in...
2008-01-08
259 reads
ACM Queue Article about One Laptop Per Child
If you happen to read ACM Queue there is a great article in the Nov/Dec 2007 issue called 'A Conversation...
2008-01-07
278 reads
SQL Community - The Site
A friend sent me a link to www.sqlcommunity.com and I think I'd list it. So far doesn't seem impressive, but...
2008-01-06
512 reads
SQLSaturday Tampa Call for Speakers
Just a reminder to anyone in the Tampa area, or willing to travel, that the call for speakers for the...
2008-01-03
237 reads
Blog Update & Feedburner
Steve finally got the bugs worked out of the recent blog software upgrade and RSS should be available again. Note...
2008-01-03
448 reads
Congratulations to Bayer White - Connected Systems MVP
Just saw that Bayer posted a note confirming that he is a 2008 MVP. I met Bayer a couple years...
2008-01-02
183 reads
Google Bigtable
Google has - and continues - to do some amazing things. It's easy to be awed by their products and their infrastructure,...
2008-01-01
458 reads
Congratulations to Steve Jones on MVP Status
Steve is a 2008 SQL Server MVP. Well deserved, I can think of few people more visible in the community...
2008-01-01
639 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