Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,564 reads
Blog Posts
Post Event Notes - SQLSaturday #8
Yesterday I posted an overview of the event, today I want to go over some areas where we excelled, and...
2008-10-27
1,328 reads
Post Event SQL Saturday #8 Orlando
This weekend I spoke at Seminole Community College with a session on Reporting Services 2008. If your interested you can...
2008-10-27
1,417 reads
Absolutely (Not?) - Why Did I Write This?
I've always been a little bit of a strong DBA. I try to get along and work with people, being...
2008-10-26
1,600 reads
SQLSaturday #8 - Orlando
The whole idea of having free events, bringing learning to people locally wasn't something that I was thrilled with. It's...
2008-10-26
1,436 reads
After Event Notes on SQLSaturday #8 in Orlando
By any measure the event was a success. We had a solid 275 attendees this year, up about 50 from last...
2008-10-25
1,499 reads
Good Ideas Take Time or How to Brainstorm - Part 2
In Good Ideas Take Time or How to Brainstorm - Part 1 I wrote about how I come up with ideas...
2008-10-23
1,602 reads
Out of Band Security Bulletin Release for Microsoft Windows
Microsoft tries to stick with the second Tuesday for security bulletin releases and has only released out-of-band a handful of...
2008-10-23
1,509 reads
ways to find the name of a running job
From time to time, I need to check (in my script) which jobs are running at the moment.So far, I...
2008-10-23
1,795 reads
What’s in a Name?
Why do folks continue to use outdated and unnecessary naming conventions? Specifically, the ridiculous ‘tbl’ prefix on tables, and the...
2008-10-23
1,384 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