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

25 Years of SQL Server Central

The oldest article we have on the site is Tame Those Strings! Part 4 - Numeric Conversions, by me. It's dated 2001-04-18, though I think that's a date we picked when we converted all the content from one database to another. The founders agreed sometime during Feb 2001 to jointly run SQL Server Central. Since we each owned the copyright of our articles from another site, we migrated several articles to build up our content library. This was back when Andy, Brian, and I all had full-time jobs and managed the site during breaks, nights, and weekends.

That was 25 years ago.

Twenty. Five. Years.

It's incredible to think that almost half my life has been spent working with this community. That joint effort morphed into a full-time job for me sometime in late 2003 or 2004. I took a pay cut to run the site, though as we grew from one to two to five to six newsletters a week, we started to make enough money to make up the difference. I was a horrible salesman, but fortunately, we had a great site that kept growing week after week, and we didn't need to rely on my salesmanship. The site grew from dozens of users when we started to thousands in a few months to tens of thousands in a year. Eventually, we reached a million registered users, which was quite a milestone for us.

Apart from the site, we published books and gave out copies at our annual party during the PASS Summit. That party was one of the highlights of my year. We also used to publish a magazine in partnership with the PASS organization. That was a stressful time, with me trying to manage an every-other-month schedule for the magazine, which had to be laid out, printed, and shipped to subscribers. While that was going on I had to keep a couple of yearly book projects going and still get daily articles published.

I started writing these editorials because I was a little bored with the job. I never imagined how popular these pieces would become and how many people would read them. I suppose I should have as I was the one who negotiated and paid for our emailing software. We used to pay for Lyris Listmanager, which cost a few thousand dollars when we started. As we grew, we needed to send more emails overnight. One year I received a quote from Lyris for a few hundred thousand dollars to add the additional sending capacity. When I called the sales rep, he told me the only small companies sending more emails than us were the porn people. Needless to say, Andy took that as a challenge, not wanting to pay hundreds of thousands of dollars for email software.  we designed a system using an SMTP component that would let us send a lot more emails. At our peak, we were sending over 8 million emails a week.

I had to learn a lot about running this site, from SMTP tricks and the how CAN-SPAM act applies to negotiating advertising contracts with customers. I had to manage hosting locations in the early 2000s. We first rented a VM, but they were too small after about six months. We moved to the house of a friend of mine, where he had 3Mbps broadband connection (this was 2002). At the time, I only had an ISDN connection, which wouldn't cut it. We migrated through a few different co-location facilities in the Denver area that I had worked with as a corporate employee. Those moves entailed me physically moving servers into cages (or partial cages) in cold rooms, re-configuring our switch and firewall, and ensuring everything connected to the Internet. I even had an account at Dell as we regularly upgraded hardware.

When we sold the site to Redgate, some of those hassles went away, and I could focus on just being the editor of the site. I no longer had hosting responsibilities or even coding ones. Things were good and bad with that change . Good as I had developers to whom I could send bugs, but bad in that they had other, higher priorities. In the last few years, I've struggled to get things enhanced or fixed on the site, though I've been promised that is changing this year.

Despite all the changes over the years, I'm still thrilled to be the editor of SQL Server Central and glad that Redgate continues to run and support the community. Most of my time is spent doing other work with Redgate, but managing this site continues to be a significant portion of my work week.

And I still enjoy it.

I want to thank everyone who has read an article, asked or answered a question, syndicated their blog, tried the Question of the Day, written an article, or just left a comment on a piece. This has been an amazing community where many of you learned to be a better data professional. Lots of you asked, debated, and shared your knowledge with others in an extremely neighborly way. It's been a joy to see this community grow into one where we appreciate, value, and love each other. I've made many friends here, met many of you in person, and seen you get a value from this community that cannot be measured. The success of this community is because of all of you.

I'm blessed to have joined you here for 25 years, and I look forward to many more.

We'll likely do a few fun things later this month and have a few more memories posted from the founders.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS

Sujai Krishna from SQLServerCentral

This article shows how you can deploy SQL Server Developer Edition in an AWS Kubernetes configuration.

SQLServerCentral Article

SQL Server 2025 Build List

Steve Jones - SSC Editor from SQLServerCentral

This is a list of the builds for SQL Server 2025. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

SQLServerCentral Article

SQL Server 2022 Build List

Steve Jones - SSC Editor from SQLServerCentral

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]

External Article

Database Development with AI in 2026

Additional Articles from Brent Ozar Blog

This seems like the appropriate first BrentOzar.com blog post in the year 2026, eh?

Blog Post

From the SQL Server Central Blogs - Flyway Tips: AI Helps with Commit Messages

Steve Jones - SSC Editor from The Voice of the DBA

At Redgate, we’re experimenting with how AI can help developers and DBAs become better at their jobs. Everyone is asking for AI, as well as the ability to turn...

Blog Post

From the SQL Server Central Blogs - Startup scripts in SQL Server containers

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

I was messing around performing investigative work on a pod running SQL Server 2025 in Kubernetes the other day and noticed something…the sqlservr process is no longer PID 1...

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Site Owners from SQLServerCentral

This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.

 

 Question of the Day

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

 

The Decoded Value

In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!';
DECLARE @encoded VARCHAR(MAX);

SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000)));
SELECT BASE64_DECODE(@encoded) 

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)

The Query Optimizer and Page Density

If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?

Answer: Yes, always

Explanation: A lower page density (and lower fillfactor) results in more IO for retrieving data. The query optimizer uses IO costs in choosing plans and a lower page density can affect the plan chosen. However, the optimizer always considers IO, so the lower fillfactor affects it. Ref: Concepts: index fragmentation and page density - https://learn.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver17#concepts-index-fragmentation-and-page-density

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.


Reporting Services
Microsoft no longer being supported? - The word is finally out that Microsoft is no longer supporting SSRS. I just wanted to get everyone's thoughts on this.  For those working in this environment who got the same notice, what are your company's contingency plans? Switching to Report Builder for Power BI? Going to a different environment? continuing with what you have […]
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
There Are a Lot of Databases - Comments posted to this topic are about the item There Are a Lot of Databases
More Documentation is Needed - Comments posted to this topic are about the item More Documentation is Needed
Article Discussions by Author
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 - Administration
SQL Agent job running gMSA cannot backup to NAS target - I'm running a group MSA for the database engine and SQL Agent in a clustered environment with Availability Groups. For backups, we currently use the Ola Hallengren scripts and agent jobs. Despite me granting all permissions to the MSA on the backup NAS, it cannot see it and the jobs fail with an error "the […]
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 […]
sys.query_store_query question - All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime, first_execution_time AS endtime, q.last_optimize_cpu_time FROM sys.query_store_query_text t JOIN sys.query_store_query q ON t.query_text_id = q.query_text_id INNER JOIN sys.query_store_plan p ON q.query_id = p.query_id INNER JOIN sys.query_store_runtime_stats rs ON rs.plan_id=p.plan_id WHERE OBJECT_NAME(q.object_id) = 'x' AND (rs.first_execution_time BETWEEN '19/01/2026 00:00:00' AND '19/01/2026 23:59:59' OR […]
 

 

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

 

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