SQL Server 2008 R2 SP1 Cumulative Update 10
Microsoft has released SQL Server 2008 R2 Service Pack 1 Cumulative Update 10, which is Build 10.50.2868. I count 15...
2012-12-17
1,928 reads
Glenn Berry
SQL Server 2005 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements....
2012-12-07
1,103 reads
Two Blogs, One Writer
I started blogging back on August 9, 2006, so I have been at it for quite a while. I am...
2012-12-07
1,070 reads
OT: Space Exploration and the Future of Humanity
I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after...
2012-12-03
1,472 reads
SQL Server 2008 Diagnostic Information Queries (Nov 2012)
Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-11-27
1,151 reads
Free One Week Passes to PluralSight
As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly...
2012-11-26
1,187 reads
SQL Server 2012 Service Pack 1 CU1 is Available
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 1, which is Build 11.0.3321. I count 44 fixes...
2012-11-20
1,451 reads
SQL Server 2012 Diagnostic Information Queries (Nov 2012)
Here is the November 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-11-16
925 reads
Migrating to SQL Server 2012
I had the opportunity to deliver my Migrating to SQL Server 2012 presentation at the PASS 2012 Summit last Friday...
2012-11-14
1,339 reads
Book Signing at SQLSentry Booth at PASS Summit 2012
A new book that I wrote a couple of chapters for has just been released. It is Professional SQL Server...
2012-11-08
933 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