SQL Server's implementation of Window Functions
Phil factor compares SQL Server 2008's implementation of Window Functions to PostgreSQL and finds SQL Server frustratingly lacking in some of the essentials.
2010-09-27
796 reads
Editorials
Great Service – All About Attitude
today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.
2010-09-24
134 reads
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
2010-09-23
64 reads
What Do We Need in SQL Server?
Steve Jones asks us today about what we might like to see in the next few versions of SQL Server.
2010-09-22
282 reads
NoSQL Is Not Everywhere
NoSQL has been getting a lot of press in the last year, but it's not necessarily the best platform or solution for you. Steve Jones comments on NoSQL and alternative platforms.
2010-09-21
381 reads
Big Data and SQL
Today Steve Jones talks about how some companies find efficiencies by training employees to use SQL. Perhaps that's a good idea for all developers.
2010-09-20
253 reads
The Cloud is Nothing Special
This week Steve talks about cloud computing, and the fact that a lot of what the cloud does is no big deal. But it can be helpful to IT professionals.
2010-09-20
281 reads
We Are Not Alone
Today we have a guest editorial from Robert Pearl that talks about the SQL Server community, and how you can get involved.
2010-09-16
138 reads
Social Engineering Dangers
Social engineering is one of the most effective ways to hack information out of a company. Steve Jones looks at this technique and a recent contest at DefCon that featured social engineering.
2010-09-15
164 reads
More Than SQL
Today Steve Jones talks about the upcoming SQL Saturday #52 in Colorado, and how it's encompassing more than just a day of SQL learning.
2010-09-14
95 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