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
Glenn Berry
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
Intel Westmere-EP Screenshots
CPUID.COM, which hosts the wonderful CPU-Z utility, has a post up that shows where someone has taken a screenshot of...
2009-09-20
774 reads
Memories Of PanzerBlitz
Back when I was a small tyke, I vividly remember playing an Avalon Hill board game called PanzerBlitz, which was...
2009-09-11
1,082 reads
Proper T-SQL Stored Procedure Formatting
Here is a very good blog post from Aaron Bertrand (another SQL MVP) on how to write and format stored...
2009-09-04
942 reads
Nice Discounts On Microsoft Certification Exams From Prometric
Prometric is offering 15% or 20%, or 25% off on selected Microsoft certification exams. The lower level Technology Specialist (TS)...
2009-09-02
601 reads
Shameless Self Promotion
NewsGator’s marketing department put up a nice post yesterday mentioning myself and Dan Larson, who are both Microsoft MVPs. I...
2009-08-27
675 reads
Upcoming Microsoft Gadgets
Microsoft has finally officially announced the long rumored price cuts for the XBox 360 Elite, which will go down from...
2009-08-27
645 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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...
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