A DBA’s Fantasy
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs...
2009-10-08
1,393 reads
Glenn Berry
Very Useful SQL Server 2008 High Availability White Paper On MSDN
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL...
2009-10-08
776 reads
Updated SQL Server 2008 Diagnostic Information Queries
Here is the October 2009 version of my SQL Server 2008 Diagnostic Information Queries. They are very useful for gathering...
2009-10-07
1,792 reads
More SQL Server Benchmarks From AnandTech
AnandTech has another I.T. oriented post up comparing the performance and value of two-socket servers to four-socket servers. The gist...
2009-10-06
805 reads
How to Diagnose and Correct a “Runaway” Transaction Log
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I...
2009-10-05
8,560 reads
A Tale of Two Utility Companies
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have...
2009-10-05
611 reads
Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,337 reads
SQL Server MVP Deep Dives Book available for pre-order
The "SQL Server MVP Deep Dives" book that I wrote two chapters for is up for pre-order. This will be...
2009-10-02
617 reads
More Evidence Why You Should Avoid Lots Of Conditional Logic In Stored Procedures
Gail Shaw, who is a SQL MVP from South Africa, has an excellent blog post about this subject.
The executive...
2009-09-25
812 reads
New Cumulative Updates For SQL Server 2008
Yesterday, Microsoft released SQL Server 2008 SP1 CU4, which is Build 2734, and SQL Server 2008 RTM CU7, which is...
2009-09-22
643 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