Thanks Space Coast SQL User Group
I want to thank the Space Coast User Group for having me over to speak on the Default Trace last...
2009-09-11
366 reads
Jack Corbett
- Interests: Sports, books, Bible
What happened to that email?
This question:
Created script to send mails using sp_send_dbmail- working like a charm.
Now searching for a way to get...
2009-09-10
937 reads
Speaking at Space Coast User Group
I have the privilege of presenting, Dive into the Default Trace, at the Space Coast User Group, tomorrow evening (Sept....
2009-09-09
305 reads
Windows 7, UAC, and SQL Server
This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working...
2009-09-08
375 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
24 Hours of PASS
From 7:45 pm (Eastern DST) on Tuesday, September 1st until 8:00 pm on Wednesday, September 2 PASS provided free online...
2009-09-03
600 reads
Active August – Final Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-31
1,324 reads
SQLSaturday #21 – Orlando Update
Event Record
This is the third year that Orlando has hosted a SQLSaturday. In 2007, I was an attendee; 2008, I...
2009-08-28
345 reads
Access Denied, Not Possible
What’s going on here?
When trying to open Default Trace files on Windows 7 and SQL Server 2008 I got the...
2009-08-26
1,206 reads
Professional Growth – Community Involvement
As part of my professional development and to help raise my professional profile, I have become more involved with my...
2009-08-25
611 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