When Will You Begin Implementing SQL Server 2008?
As I have been talking to DBAs around the country, I have noticed a trend that many, if not most,...
2008-10-01
371 reads
Blog Posts
Notes from the Sep 24, 2008 Orlando .Net User Group Meeting
I don't seem to find the time often, but recently I was able to fit in another visit to the...
2008-09-30
1,375 reads
Returning Stuff to Amazon
I've used Amazon for years for the sheer convenience, and recently was the first time I ever needed to return...
2008-09-29
1,458 reads
SQL Saturday Orlando
Make sure you make it to the next SQL Saturday event that I will be speaking at October 25, 2008...
2008-09-29
1,301 reads
Technical Difficulties
Always something going wrong around here with the podcasts. Today I was editing a couple, or attempting to, and couldn't...
2008-09-29
1,443 reads
The Relational Manager and Managerial Relations - Why?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-09-29
1,360 reads
Data Quality, Part 1: The Discovery
I wrote a post a few months back about a healthcare data conversion project that I’ve been working on for...
2008-09-28
1,963 reads
Polos for SQLSaturday
One of things we've tried to do from the beginning is to provide each speaker & volunteer with a good quality...
2008-09-28
1,351 reads
SMO Videos on JumpStartTV.com
Last month I got to head out to Orlando and spend a couple of days with Andy Warren and the...
2008-09-28
1,670 reads
Sunday Morning
I woke up early, with my schedule a bit messed up from last week and yesterday. I was tempted to...
2008-09-28
1,430 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