Do You Use Projects/Solutions in SSMS?
When SQL Server 2005 was released Microsoft made a major change to the client tools provided with SQL Server, moving...
2009-12-10
1,774 reads
Jack Corbett
- Interests: Sports, books, Bible
OPASS December Meeting Recap
This was the first meeting where I really lead most of the meeting. Andy Warren (@sqlandy) did the networking at...
2009-12-09
364 reads
T-SQL Tuesday #001 – Dates and Times
T-SQL Tuesday was started by Adam Machanic (@AdamMachanic) on his blog to encourage SQL Bloggers to share their tips and...
2009-12-08
463 reads
Good Programmer = Lazy & Dumb?
Alternative title for programmers using C-derivatives and Java:
Good Programmer == Lazy & Dumb?
I read this blog post, Why Good Programmers Are...
2009-12-07
663 reads
Book Review: Apress Pro SQL Server 2008 Administration
Several months ago I received a copy of the Apress book, Pro SQL Server 2008 Administration (Amazon)by Ken Simmons (@kensimmons),...
2009-12-04
976 reads
Maintaining Security and Performance Using Stored Procedures Part II – Signing
Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security...
2009-11-30
1,648 reads
PASS Summit 2009 – Wrap-up – What’s the Value?
I’ve already written four posts (1, 2, 3, 4) that discussed what I did at the Summit, including what I...
2009-11-09
416 reads
PASS Summit Day 3 – Brain on Overload
After the first 2 official days of the Summit the brain is already on overload and then the second part...
2009-11-07
543 reads
Let the Learning Begin
Finally time for the sessions to begin after a day and a half in Seattle being overwhelmed by the people...
2009-11-05
731 reads
PASS Summit Day 2 – What More Can I Learn
I actually slept in on Wednesday until 6am. This was a change from being wide awake at 4am. I made...
2009-11-05
534 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