SSC Editorial – Learning From Experts
Another story with a lesson today, this one about learning to work smarter and not just harder. Easy to say,...
2010-07-07
255 reads
Blog Posts
The PASS Session Selection Process, My Experience Part 1
Well, I have just finished up my part in the abstract selection process for the PASS Summit. This was my...
2010-07-07
543 reads
Visual Studio 2010 Giveaway - The Winners and the Answers
All three licenses of Visual 2010 Ultimate with MSDN have been claimed, and here are the winners:
John Pertell (twitter | blog)Jeff...
2010-07-07
629 reads
VS 2010 Ultimate with MSDN Giveaway - Completed!
UPDATE: The three licenses have been claimed!
Like other MVPs and Regional Directors, I've got three licenses of Visual Studio 2010...
2010-07-07
865 reads
What is an Easy Way to Return Results from a CLR Stored Procedure?
This post describes a helper class that I came up with to handle returning values from a CLR stored procedure. Continue reading ?
2010-07-07
199 reads
What is an Easy Way to Return Results from a CLR Stored Procedure?
This post describes a helper class that I came up with to handle returning values from a CLR stored procedure. Continue reading ?
The post What is an Easy Way...
2010-07-07
7 reads
What is an Easy Way to Return Results from a CLR Stored Procedure?
Introduction
What is an Easy Way to Return Results from a CLR Stored Procedure? The question sounds simple enough but yet...
2010-07-07
999 reads
WHERE to begin
Many people, once they start getting comfortable writing SQL, begin asking the same questions. One such common question is “Does...
2010-07-07
1,303 reads
Why Work on a SQL Saturday?
I was having a long call with Andy Warren (blog | Twitter), fellow founder of SQLServerCentral and SQL Saturday. We were...
2010-07-07
629 reads
Before You Begin Auditing...
There is a fine line between auditing and attacking. The line actually is one built based on authorization. Same tools,...
2010-07-06
950 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