Live Streaming Keynotes From PASS Summit 2010
I just wanted to help spread the word that the PASS Summit Keynotes will be streamed live via LiveMeeting next...
2010-11-05
592 reads
Glenn Berry
Dr. DMV Queries From Fall 2010 SQLConnections Conference
This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr....
2010-11-04
868 reads
Speaking at SQL Server Connections in Las Vegas Next Week
I will be giving two presentations next week at the SQL Server Connections conference in Las Vegas. There is a...
2010-10-31
1,579 reads
Adding Data Compression to an Existing Clustered Index in SQL Server 2008 R2
Working at an ISV like NewsGator Technologies, I get to work on products like Social Sites for SharePoint 2010, that...
2010-10-28
2,597 reads
New Cumulative Updates for SQL Server 2005 and SQL Server 2008 R2
Late Monday night (October 18, 2010), Microsoft released the latest Cumulative Updates for SQL Server 2005 and for SQL Server...
2010-10-20
926 reads
This is What Task Manager Looks Like When You Restart the SQL Server Service
This is what Task Manager looks like in Windows Server 2008 R2 when you restart the SQL Server Service. This...
2010-10-19
621 reads
Birds of a Feather Lunch at PASS 2010 Summit
The volunteers at PASS (especially Mike Walsh) have organized another “Birds of a Feather” lunch event on Tuesday, November 9...
2010-10-13
701 reads
What are Physical Sockets, Physical Cores, and Logical Cores and Why Does it matter?
I witnessed a confused conversation on Twitter today where someone was talking about how he uses the terms sockets and...
2010-10-09
12,716 reads
SQL Server Memory Related Queries
What is using all of my memory in SQL Server? If you ever believe that you are seeing signs of...
2010-10-08
2,749 reads
CPU-Z Support For Sandy Bridge Processors
The CPUID website has a screenshot of CPU-Z 1.55.2, showing its support for the upcoming 32nm Sandy Bridge processor, which...
2010-10-04
584 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...
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...
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