SQL Server 2005 SP3 eshte realizuar
Pershendetje te gjitheve!
Përderisa kemi qenë duke punuar me SQL Server 2005 SP2, pas shumë raportimeve nga ana e shfrytëzuesve...
2008-12-30
1,537 reads
Blog Posts
2008-12-29
1,519 reads
It's All About the Wireless Access
Steve Jones tells me that the biggest advantage that the Kindle offers is the ability to browse and buy a...
2008-12-29
1,393 reads
Joel Spolsky on servant leadership
With the holidays about over, I'm catching up on my RSS feed reading. This is an article from the beginning...
2008-12-29
1,616 reads
Review of Seadragon: Microsoft’s iPhone application
So I’ve spent the last couple of weeks playing around with the Seadragon application and have come to some conclusions.
Usefullness...
2008-12-29
1,478 reads
SSIS – Avoid OLE DB Command
I decided to do a little performance testing on some common SSIS “Tricks” that increase speed and effectiveness of SSIS...
2008-12-29
14,305 reads
April Fools Challenge
I know it's not April 1st yet, but I wanted to throw out a couple comments and a challenge well...
2008-12-28
1,512 reads
A Little Work
Tia came down and asked if we should do something with the kids, bowling, movies, etc. I told her I...
2008-12-26
1,432 reads
One Year In
I got my Toshiba Qosmio a little over a year ago and it has been a great machine for me...
2008-12-26
1,448 reads
When Data Mining Goes Too Far
Data mining is commonly used to find otherwise undetectable patterns in related sets of data. However, sometimes these patterns provide...
2008-12-26
1,521 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