Quests Performance Monitor Counters Poster
I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and...
2011-02-27
3,029 reads
BrianKMcDonald
February 2011 JSSUG Meeting Tomorrow
Tomorrow, I will be presenting at the Jacksonville SQL Server Users Group (JSSUG) meeting. Please join me for my talk...
2011-02-16
430 reads
Redgate’s Free SQL Search Tool
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,126 reads
SQL Rally: The Votes Have Been Tallied
First and foremost, I would like to send a sincere thank you to everyone who voted for my Reporting Services...
2011-02-10
590 reads
SQL Rally 2011 Voting - Reporting Services Boot Camp
All,
Since SQL Server Reporting Services 2005 came out, I have been working very close within the BIDS environment and every...
2011-01-31
1,539 reads
SQL Saturday Tampa Follow Up
This past weekend, I had a talk on SQL Server Reporting Services down in Tampa Florida for SQL Saturday 62....
2011-01-21
742 reads
My 2011 Aspirations
Yesterday, I posted a blog about my year in review for 2010. So, I thought that it would be a...
2011-01-04
439 reads
My 2010 Year in Review
While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too...
2011-01-04
390 reads
SQL Saturday 62 – Tampa FL – January 15th 2011
On January 15th, 2011, SQL Saturday is once again coming to Tampa Florida. This is going to be a tremendous...
2010-12-18
1,195 reads
Pragmatic Works Seeking Employment Candidates
If you’re anything like me, you enjoy constantly striving to new levels of knowledge. This new level of knowledge brings...
2010-12-18
424 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