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

When SQL Server Central Went Down

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

"The site is down."

I got a phone call from one of the other founders around 9 am in Denver one day. At the time, I was working at a small startup, in a semi-private office with one other person. Most of the company knew I had a site on the side, and alternately cheered me on or celebrated hiccups, depending on the person.

I checked, and things were down. I had a side channel to telnet into the server, but couldn't access things. At this time, the site was hosted on a single server, running IIS and SQL Server, in a friend's basement. This was in 2002 or 2003, and broadband was a lot different then. No cable internet, and most other solutions were in the kbps range. I had ISDN at my house, but a friend had gotten into a trial from Sprint, giving him 3Mbps over a microwave link.

My office-mate was listening and watching. I said I was taking an early, and long, lunch. She chuckled and went back to her own tasks. I let my boss know and started driving, stressed out. After all, the site was growing, popular, and downtime could be a killer.

We've had a few outages over the years, but not many. This was one of the more stressful ones as I fought traffic on I-25, trying to get from the Denver Tech Center up to Westminster. I can't remember the weather, but I was sweating when I got to my friend's house. This was the before-times, when remote work was a rarity. Luckily, my friend had left me a key to get into his house, where I ran into the basement. Unable to get the server to respond, I rebooted it and crossed my fingers.

I'm sure a few of you have had the stressed-out feeling of waiting for a database server to restart, hoping that it comes back up cleanly. It did this time, and I don't remember what went wrong, but things were back up and running with no major issues. I was probably in the basement for less than 30 minutes, and I left, dreading the long drive back to the office. Almost two hours driving for a 30-minute fix.

I do remember thinking if this was going to be a regular occurrence, I might need a new job. Or a new place to host the server.

We weren't in the basement for too long. Revenues were increasing enough that I started to look at co-location facilities. My current employer had investigated quite a few when we set up our systems, and I reached out to a few contacts. I negotiated a half-rack at some point, moving our servers to a real facility. By that time, my employer had failed, and I got an F5 firewall as part of my severance, which fronted SQL Server Central for quite a few years.

Those were the days, with lots of CLI access to remote systems and a power strip where I could cycle them off and on. Those were skills I had to learn to avoid more drives at inconvenient times.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How Database Professionals Sent a Million Emails a Day from SQL Server

Steve Jones - SSC Editor from SQLServerCentral

This is part of a look back at the history of SQL Server Central as a part of our 25-year celebration in Feb 2026. "They want how much?" That was a question I got from Andy one afternoon as we discussed how we were going to manage the growth of SQL Server Central. I had […]

External Article

How Filters and Sorting can Derail SQL Pagination Performance

Additional Articles from MSSQLTips.com

In my previous tip, Pagination Performance in SQL Server, I showed how to make SQL pagination more predictable – turning O(n) into O(1). I materialized and cached row numbers to page through instead of calculating them on every request. It wasn’t the whole story, though; real pagination queries rarely get to sort without filtering. Users always want more control, and filtering can threaten that predictability.

Blog Post

From the SQL Server Central Blogs - Advice I Like: Ranch Rules

Steve Jones - SSC Editor from The Voice of the DBA

Leave a gate behind you the way you first found it. – from Excellent Advice for Living This is a ranch rule. Leave something as you found it. If...

Blog Post

From the SQL Server Central Blogs - PASS Data Community Summit 2025 Recap

alevyinroc from FLX SQL

This is long overdue but life and distractions happened. It’s been a little over two months since I returned home from PASS Summit 2025.

Refactoring Databases cover

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

 

 Question of the Day

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

 

The String Distance I

In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled.

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 I

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

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

Answer: I get an nvarchar string like this: {"City":"Denver"}

Explanation: This returns an NVARCHAR(max) string. You can test this with the following code:

DECLARE @a SQL_VARIANT
SELECT @a = JSON_OBJECTAGG( 'City':'Denver')

This returns an error: Msg 206, Level 16, State 2, Line 16 Operand type clash: nvarchar(max) is incompatible with sql_variant 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.


Integration Services
SSIS 2019 or 2022 - Microsoft Connector for Oracle - Hello all, I am having one heck of a time installing Microsoft Connector for Oracle on a VS2019 instance with Integration Services 3.15 and also on VS2022 with integration services installed. For the life of me, I cannot get the Oracle connection manager to show up when I right click on the connection managers and […]
Create txt file in SSIS without NON UTF-8 characters - Hello SSC Community, I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version.  […]
Create txt file in SSIS without NON UTF-8 characters - Hello SSC Community, I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version.  […]
Create txt file in SSIS without NON UTF-8 characters - Hello SSC Community, I am running into and issue with SSIS creating a text file from a SQL query. Apparently, there is a known issue that SSIS cannot produce a text file without NON UTF-8 characters without some kind of workaround. I am using VS 2026, and the issue still remains in the latest version.  […]
Editorials
25 Years of SQL Server Central - Comments posted to this topic are about the item 25 Years of SQL Server Central
You Have Homework - Comments posted to this topic are about the item You Have Homework
There Are a Lot of Databases - Comments posted to this topic are about the item There Are a Lot of Databases
Article Discussions by Author
The Decoded Value - Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS - Comments posted to this topic are about the item Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Automating Database Cleanup for PostgreSQL Using Python - Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL Using Python
The Query Optimizer and Page Density - Comments posted to this topic are about the item The Query Optimizer and Page Density
Adding and Dropping Columns II - Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform - Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
SQL Server 2022 - Development
bringing a .bak across the wire without rdp'ing or mapping into the sql server - hi,  a peer of mine would like to be self sufficient in bringing small .bak's over to her local without rdp'ing to the sql server or mapping a drive to that server or asking our dba for help. I dont even think she would mind if sql sent the .bak straight across the wire to […]
Create filegroups in partition - I have a table with partition on create_timestamp field. Though we're storing all data in one file group, the boundary values are defined for each quarter. I would like to add few filegroups for the next quarters: 2025-04-01, 2025-07-01 and 2025-10-01 I attached file for the partition, filegroup and rows info. With huge number of […]
 

 

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

 

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