PASS Update #37 (Elections and Re-Election)
We’ve got 6 days left before the call for nominations for the 2010 PASS election closes and I want to...
2010-07-14
852 reads
Blog Posts
Professional Licensing for Software Professionals?
Over the past few days I have been thinking that the Software Industry is in drastic need of a Professional...
2010-07-14
1,299 reads
Red Gate SQL Source Control
You just have to love Red Gate tools. They find the small area that they want to cover and then...
2010-07-14
1,866 reads
Retrieving last backups of the databases
The script below is a simple and quick way to find out the last backup performed successfully to the databases...
2010-07-14
762 reads
Simplify Your DBCC CHECKDB Output
"Defend Your Data"
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to...
2010-07-14
521 reads
Speaking at SQL Server Connections in Las Vegas, November 1-4, 2010
Today, I received the official word that I will be presenting two sessions in the SQLServerCentral.com track at the SQL...
2010-07-14
882 reads
SQLServerCentral.com Track at SQL Server Connections November 1-5, 2010
November will be a busy time of the year for many SQL Server DBAs as they head off to the...
2010-07-14
675 reads
Video Test
One of the things I've been wanting for awhile is the ability to embed videos here on the blogs. It's...
2010-07-14
447 reads
Access Annoyance – Bit Columns
Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe...
2010-07-13
332 reads
Advanced Troubleshooting Week at SQL University, Lesson 1
Advanced Troubleshooting Week at SQL University, Lesson 1
Welcome to Advanced Troubleshooting Week at SQL University. Once again, I’m your guest...
2010-07-13
5,419 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