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

Having a Little Fun at SQL Server Central

When we started the site, I had never met most of the other co-founders (we went from 7 to 3 inside of a few years). A few knew each other, but Brian, Andy, and I had only communicated through emails and phone calls. We ran the company remotely from Denver, Orlando, and Jacksonville. In fact, I met Brian for first time when he came to Denver for the 2002 PASS Summit (moved from 2001). I met Andy later that year at the Seattle Summit in November 2002. That, coincidentally, was my first meeting with Simon Galbraith, founder of Redgate Software.

Over the years, we've tried to enjoy running an online community in different ways. We wanted this to be a profitable endeavor, but one where we could have some fun. We did this in few different ways. One was with some off-topic articles. Early on, Andy wrote a piece asking Is Steve Jones Really Steve Jones? I still enjoy reading that one today.

Once I was running the site full-time, and stuck with the Question of the Day and editorial responsibilities, I added a category for humor that I used on holidays and other random times. April 1 was a fun day (and still is), with me trying to write plausible, but completely untrue articles about database topics. I'm still thrilled that my joke from Apr 1, 2005, SQL Server on Linux, finally came true.

We had a Lighter Side category for editorials that didn't fit anywhere else, which I and others have used to try and remind ourselves that not everything is about databases and it's also not the most important things in our lives. We have had a lot of articles on career topics and soft skills, especially editorials, as the guest editors and I know these are some of the most important skills to develop for career growth.

Thankfully, Redgate has supported some of my fun, as they agreed to pay for and publish a series of crosswords and cartoons over the years.

Perhaps the most fun I've had over the years was running the SQL Server Central parties at the annual PASS Summit. In exchange for promoting the event and getting people to register with our code, we got a small payment for each person. This started in 2002, and we decided not to take this money as profit, but rather to have fun with it. Each year we'd get a few thousand dollars from referrals, so we tried to be creative. We gave away books and shirts the first year, with a line stretching out the door during the welcome reception. In Florida in 2003 or 2004, we decided to have a video game party with XBOX consoles. We not only purchased consoles, but also TVs, and gave everything away at the end of the night to random people.

Somehow, I stumbled on the idea of a Casino party one year and contracted with a firm in Seattle. We ran those parties for years and even charged admission for people who hadn't used our code. I would guess how many people would come and then go shopping at Best Buy when I arrived in Seattle, spending a few more thousand dollars on random prizes to give away. I'm sure we lost money in a few of those years, but it was all for fun.

Maybe one of the most memorable things I did was for TechEd in 2004 or 2005. We wanted to brand ourselves and try to raise awareness of the site. Since I was in charge, I ordered 3 different styles of Hawaiian shirts for each of us, with a SQLServerCentral logo and name embroidered on each, intending to wear a different one each day. Andy and Brian were good sports, going along with me most of the time. There was a day Brian refused to wear my choice as it was a little too out there for him.

However, I did meet Euan Garden (RIP) for the first time there and he loved our chili pepper shirts. I arranged for a shirt to be made and shipped to him and I loved seeing him wearing it at a events over the next few years. I also got inspired to do an interview series, which I really enjoyed.

Thinking back on the history of this business, I'm both amazed by how it changed my life, and I can smile at so many good memories. Hopefully, you feel the same way.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

AR from SQLServerCentral

Introduction. Why AI Readiness Starts in the Database You probably don’t need machine learning today. Most organizations don’t. You already have reporting dashboards, operational workflows, and business intelligence that work just fine without neural networks or predictive models. That’s not a failure. It’s normal. The problem doesn’t show up immediately. It shows up a few […]

External Article

SSMS 22 Offline Installation

Additional Articles from MSSQLTips.com

Beginning with SQL Server Management Studio 21, Microsoft stopped providing the direct download package/binaries to install SSMS, instead it just downloads the SSMS installer. This installer then starts the installation of SSMS and downloads what is needed to install SSMS. Sometimes there may be a need to do an offline installation where you do not have access to the internet. In this article, we walk through the steps to do an offline install of SSMS.

Blog Post

From the SQL Server Central Blogs - Presenting with Visual Studio Code

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

A while back I wrote a quick post on setting up key mappings in Visual Studio Code…they make presenting (and generally working) in Visual Studio Code really smooth. But...

Blog Post

From the SQL Server Central Blogs - Setting FK Constraints in Data Modeler

Steve Jones - SSC Editor from The Voice of the DBA

One of the things a customer asked recently about Redgate Data Modeler was how to set a FK constraint between two tables. The tool seemed to make it easy,...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

 Question of the Day

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

 

String Similarity I

On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL')

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 III

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?

Answer: 1 JSON document with 5 elements, each with 1 key-value pair

Explanation: This returns one document, with 5 elements. Each row converts to a key-value pair. 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" […]
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
Doing Good at SQL Server Central - Comments posted to this topic are about the item Doing Good at SQL Server Central
Engineer Lessons - Comments posted to this topic are about the item Engineer Lessons
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
Article Discussions by Author
Missing the Jaro Winkler Distance - Comments posted to this topic are about the item Missing the Jaro Winkler Distance
25 Years Later: What SQLServerCentral Meant to Me - Comments posted to this topic are about the item 25 Years Later: What SQLServerCentral Meant to Me
Fun with JSON - Comments posted to this topic are about the item Fun with JSON
Creating JSON II - Comments posted to this topic are about the item Creating JSON II
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
SQL Server 2022 - Development
connections vs apis - hi , i hear more and more that we have too many connections to our servers.    many are sql.   many arent. so we are told to use api's where possible. Isnt there a connection behind the scenes when an api is asked to return data from whatever the erp's database is>
is it true we cant debug c# scripts in ssis anymore under vs - Hi, i'm running vs2022.   I'm trying out a c# script that i'd like to set breakpoints on to trap the exception that gets thrown when i debug.  From what i'm reading, i cant debug it because my runtime bitness is 64 and that setting cant be changed (it is greyed for me) in vs2022. is […]
 

 

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

 

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