Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Doing Good at SQL Server Central

This is part of a few memories from the founders of SQL Server Central, celebrating 25 years of operation this month.

We did photoshoots at Redgate many years ago. We had a bunch of props, including some phrases written down. We could create our own, but my handwriting is atrocious (likely why I never became an architect), but I ended up with this one:

Steve Jones caption

I couldn't really explain why I picked "Doing Good", but the more I thought about it over the years, it's been a lot of what has driven my life forward, both here at SQL Server Central and in my personal life. I've been a Boy Scout and Girl Scout leader, have been and am a sports coach, and I have given up no shortage of time to help others with speaking efforts. I put time into the SQL Saturday charitable foundation, trying to get more SQL Saturday and Day of Data events that teach, train, and inspire data professionals.

SQL Server Central has a huge reach. We've been very popular, and millions of people have seen our newsletters. Our mission early on was to help database professionals get better every day, and we provided a lot of free (as in beer) resources: articles, quizzes, and answers to your questions. Many community members have also volunteered their time and expertise to help, and I thank them as well.

There have been a few times when I've tried to use that reach to do good. I don't want to point out the specifics, but a few times I've known people with very sick children. One was a local friend I'd worked with (tech pro, but not database) and another was a speaker in our community. This started when I was sitting at dinner with a fellow speaker, who was talking about this family struggling and needing help. I thought, surely we as a community could raise money and help them. I used the reach of our newsletter at that time to ask for donations and managed to raise substantial amounts of money to help a family. I did it again a few years later, raising well over USD$10k in both cases.

In those cases, as well as with SQL Saturday, I have done what I thought was in the best interests of everyone and ensured all the monies raised went to the intended recipients. The families got all the money donated, and all sponsorship monies to to events. If there are bank charges or other fees, I absorb them. In the case of SQL Saturday, I go begging for donations to support the admin costs and fees.

Those might be some of the things I'm most proud of in my life, which is an interesting thing I learned. I really like helping others. As much as I enjoy living my life, I get more satisfaction that I would have expected by helping others grow, learn, succeed, and enjoy their own lives.

I think everyone should volunteer some of their time/resources/knowledge/etc. at some point in their life. It might not be now, but think about where you can help make the world better. You'll gain way more than you ever spend from helping others..

 

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 Featured Contents
SQLServerCentral Article

25 Years Later: What SQLServerCentral Meant to Me

Brian Knight from SQLServerCentral

A look back at SQL Server Central after 25 years from founder Brian Knight.

External Article

I Just Don’t Understand Why You Don’t Update SSMS.

Additional Articles from Brent Ozar Blog

A long time ago in a galaxy far, far away, SQL Server Management Studio was included as part of the SQL Server installer.

Blog Post

From the SQL Server Central Blogs - The Book of Redgate: SQL Server Central

Steve Jones - SSC Editor from The Voice of the DBA

It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...

Blog Post

From the SQL Server Central Blogs - tSQLt Test Adapter for Visual Studio 2022+

Ed Elliott from Ed Elliott's Sql Developer Blog

I have had a number of requests for me to update the tSqlt Test Adapter over the years so it would work with more recent versions of Visual Studio....

Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices

Steve Jones - SSC Editor from SQLServerCentral

In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Missing the Jaro Winkler Distance

I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:
Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.
What is wrong?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Creating JSON II

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO

Answer: I get a JSON document like this: {"City":"Denver"}

Explanation: This returns a JSON string. Ref: JSON_OBJECTAGG - https://learn.microsoft.com/en-us/sql/t-sql/functions/json-objectagg-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2019 - Development
Which 'Where' statement conditional upon a variable - Thanks in advance for any clues on this. I am trying to write a 'conditional where' statement in a typical select statement. Early in the stored procedure the variable @Type is set to either 'AB or 'CD'. I'm trying to have my WHERE be dependent on that variable e.g.: WHEN @Type = 'AB' my "WHERE" […]
SQL Azure - Administration
Transactional Replication setup issue - Hi! I've been banging my head against the wall for 2 days now trying to setup Transactional Replication between an Managed Instance and Azure SQL Database. Documentation: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-two-instances-and-sql-server-configure-tutorial?view=azuresql That's the documentation I'm working with although I'm using the same instance for distribution and publishing. I've double checked the config on Azure and replication multiple times […]
Integration Services
Foreach Loop still executes after process and delete all the folders - I have two challenges XML source control not displaying the XML file parent node columns even though it is showing in the XSD file. Is there any solution to get the XML parent nodes columns in the XML source component. Foreach loop container control not stopping. it still executes if more than two files in […]
Editorials
Microsoft Security Changes and SQL Server - Comments posted to this topic are about the item Microsoft Security Changes and SQL Server
Expanding into Print - Comments posted to this topic are about the item Expanding into Print
The Power of Data and Privacy - Comments posted to this topic are about the item The Power of Data and Privacy
The DBA is Dead; Long Live the DBA - Comments posted to this topic are about the item The DBA is Dead; Long Live the DBA
Discussions about Books
Data Warehouse Toolkit meets Star Schema: The Complete Reference - Is there a good syllabus for reading these two together? (Yes, it's called the table of contents!) Just wondering because Kimball's book is super high level, and Adamson's book is much more detailed. Maybe I'll just have to put it all in my book report. LOL
Article Discussions by Author
Backup to Immutable Storage - Comments posted to this topic are about the item Backup to Immutable Storage
Downtime Caused by the Postgres Transaction ID Wraparound Problem - Comments posted to this topic are about the item Downtime Caused by the Postgres Transaction ID Wraparound Problem
The String Distance I - Comments posted to this topic are about the item The String Distance I
What's the Date? - Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform - Comments posted to this topic are about the item Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
GPX distance and time analysis in SQL Server - Comments posted to this topic are about the item GPX distance and time analysis in SQL Server
SQL Server 2022 - Administration
SSMS 22 Latest Update Crashing - Hi all, I've just had to roll back my SSMS 22 version from 22.3.0, because this version seems to crash as soon as I open it (just after selecting an instance to connect to). Anyone else having any issues with 22.3.0?
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -