Uploading a List of Names For a LinkedIn Group
It’s been a couple months since we set up the OPASS group on LinkedIN and we’ve had some people join,...
2009-09-07
291 reads
Blog Posts
Workaholics Anonymous – Providing A Development/Deployment Management Template on Labour Day
As mentioned by Phil Factor during the previous post’s comments regarding an example disaster recovery template/plan, and to keep in...
2009-09-07
1,928 reads
Tampa Code Camp Date Announced
The next Tampa Code Camp will be Nov 7th, 2009 at the KForce Building in Tampa. For the first time...
2009-09-06
307 reads
e-Readers - $50?
I don’t think this survey was done well. Most people want an e-reader for $50, according to the survey. That’s...
2009-09-05
510 reads
Networking Successes
Over the last few weeks I’ve had several instances where I’ve had to learn new things and, in my struggles,...
2009-09-05
472 reads
Product Review: SQL Pretty Printer
SQL Pretty Printer for SQL Server Management Studio $39.95 single user $99.95 site license
having coding standards is a must for...
2009-09-05
1,883 reads
30 Days of Adventure in Australia and New Zealand
Starting Saturday, September 26, 2009, I will begin a 30 day, 9 city, and 11 session speaking tour of Australia...
2009-09-04
651 reads
A Great Business Model
Tia and I were moving dirt around the ranch this weekend. It was a chore that needed to be done,...
2009-09-04
346 reads
Amazon Finally Making Good on 1984
They should have done this on day 1 of the issue: offer users a legitimate copy and move their annotations....
2009-09-04
578 reads
Debuting: Beginning SQL Server 2008 Administration
The new book is up on Amazon. I only worked on three chapters of Rob Walter’s new book and that...
2009-09-04
625 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