Are you sticking to your goals? Do you know what they are?
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,187 reads
Blog Posts
Book Review: The Deceived
The Deceived by Brett Battles
I haven’t post on any fiction lately, thought it was time to write about something more...
2009-10-15
346 reads
More SQL Server 2008 Book Involvement
Last night, I received my hard-copy of Pro SQL Server 2008 Mirroring from APress. This book has a lot of...
2009-10-15
614 reads
Off-Hours Work: A Guide For Non-Managers
In my last post I talked about how I think managers should approach off-hours work with their teams. It's a...
2009-10-15
526 reads
Separating Out Indexes
I saw a post recently where someone was asking how to separate out all indexes from the data into a...
2009-10-15
907 reads
SNESSUG October Meeting
The Southern New England SQL Server Users Group’s October meeting was a bit sparsely attended with 7 attendees. The sponsor...
2009-10-15
704 reads
SQL Lunch/Call for Speakers
Patrick Leblanc has started a new project called…SQL Lunch! The concept is to present a 30 minute topic every two...
2009-10-15
879 reads
SQL MVP Profile of the Week - Michael Coles
As we continue to get ready for the NY\NJ SQLSaturday User Group meeting this October 24, 2009, I had the...
2009-10-15
1,151 reads
SQLSaturday #21 Is Tomorrow (Oct 17)
I’m writing this in advance because I’ll be busy with all the last minute preparations, but I’m looking forward to...
2009-10-15
289 reads
The PASS Board of Directors Election
There has been some great discussion about the upcoming PASS Board of Directors election over on Brent Ozar’s blog. If...
2009-10-15
1,256 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