SQL Server Diagnostic Information Queries for November 2013
I have made a number updates and bug fixes, including some additional columns in some of the queries for all...
2013-11-15
1,155 reads
Glenn Berry
SQL Server Diagnostic Information Queries for October 2013
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,316 reads
SQL Server Diagnostic Information Queries for September 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-09-24
1,181 reads
TPC-E Benchmark Results for Intel Xeon E5-2697 v2
Two new TPC-E benchmark results have shown up for two-socket database servers using the brand new, 22nm Intel Xeon E5-2697...
2013-09-12
1,670 reads
Fixing a Bug: DBCC CHECKDB data purity checks are skipped for master and model
Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are...
2013-08-29
1,718 reads
SQL Server 2012 RTM CU9
On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes...
2013-08-22
1,571 reads
Speaking at PASS Summit
I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC....
2013-08-05
710 reads
24 Hours of PASS: Summit Preview Edition
The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one...
2013-07-30
1,298 reads
Hardware 201: Selecting and Sizing Database Hardware
On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download...
2013-07-26
1,110 reads
SQL Server 2008 Service Pack 3 CU12
On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count...
2013-07-23
706 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