SQL Server 2005 Diagnostic Information Queries (May 2012)
Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are...
2019-04-02 (first published: 2012-05-04)
2,364 reads
Glenn Berry
Building an Intel Ivy Bridge Desktop System, Part 2
A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm...
2012-05-02
1,851 reads
Checking Your Main BIOS Version
As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....
2012-05-01
1,769 reads
SQL Server 2008 Diagnostic Information Queries (May 2012)
Since tomorrow is May 1, I think it is time to publish the latest set of SQL Server 2008 Diagnostic...
2012-04-30
1,941 reads
SQL Server 2012 Diagnostic Information Queries (April 2012)
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,701 reads
Quick Roundup of Intel Ivy Bridge Reviews
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically...
2012-04-23
1,031 reads
Intel Ivy Bridge Release Coverage
Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories,...
2012-04-23
1,051 reads
SQL Server 2012 Core Factor Table for AMD Processors
As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can...
2012-04-23
2,968 reads
Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers
If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...
2012-04-18
2,172 reads
Windows Server 2012
Microsoft’s Corporate Vice President Brad Anderson announced today at the Microsoft Management Summit 2012 in Las Vegas that the next...
2012-04-17
1,021 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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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