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

Expanding into Print

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

When we started SQL Server Central, our goal was to build a great resource that helped other people advance in their careers and also made some money. Our decisions in building the site were based around the digital world and treating the community as we would want to be treated. Over time, however, we realized that continuing to grow this business was hard in a digital-only world. We experimented and proposed helping others build similar sites, like ReportingServicesCentral (which would have been great) or NotificationServicesCentral (which would not), but ultimately, we weren't experts enough in those areas and couldn't find people willing to partner.

Everyone thought they could do it themselves and that the knowledge was the hard part, and execution was easy. The truth is that the reverse is the way it works.

In any case, there was a point in time when we were sending 6 newsletters a week (Monday through Saturday) and we didn't think there was much room for growth there. Andy suggested that we compile all our articles into a Best of SQLServerCentral book. I didn't think they would sell well (they didn't), but we did enjoy giving them away at our annual SQL Server Central Party at PASS. We even added a second series where we compiled the Question of the Day series into books, based on the Two Minute Mysteries I read as a child. We called them SQL Server Stumpers. Those were hard to manage, and were multi-month long projects that I had to toil away at almost every week.

Then came the magazine: SQL Server Standard.

In the early 2000s, the Professional Organization for SQL Server was trying to grow as well. We knew magazines were popular and profitable back then, so we proposed helping them produce a magazine every other month (6 times a year). They were charging an annual membership fee and needed to give members more value, so we agreed to produce, publish, and ship a magazine to all their members. It was both a source of tremendous stress for me to manage, as well as a proud item I could point to every month.

I wish I had some online links, but this was intended to be a real-world, analog item. We hoped it would grow to be a substantial revenue item, but it never did and PASS shut it down after around a year of publication.

I was glad because these projects were a never-ending source of stress. Managing book projects that were 4-6 months, along with the every-other-month magazine, and a daily newsletter was overwhelming at times.

Our forays into the print world provided me with a lot of education about how books and magazines work, and gave me a few mementos.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Downtime Caused by the Postgres Transaction ID Wraparound Problem

Chandan Shukla from SQLServerCentral

Learn about transaction ID wraparound in PostgreSQL, which caused a problem for the author.

External Article

Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable Cross-Database Data Leaks

Additional Articles from SimpleTalk

This article reveals a critical SQL Server flaw: attackers can weaponize Date Correlation Optimization (DCO) views in restored backups

Blog Post

From the SQL Server Central Blogs - PowerPoint to HTML with Claude AI

Steve Jones - SSC Editor from The Voice of the DBA

I had an idea for an animated view of a sales tool, and started to build this in PowerPoint. I decided to switch to Claude and ended up with...

Introduction to PostgreSQL for the data professional

Introduction to PostgreSQL for the data professional

Site Owners from SQLServerCentral

Adoption and use of PostgreSQL is growing all the time. From mom-and-pop shops to large enterprises, more data is being managed by PostgreSQL. In turn, this means that more data professionals need to learn PostgreSQL even when they have experience with other databases. While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.

 

 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('Steve', 'Stan')
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)

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

Answer: CURENT_DATE()

Explanation: CURRENT_DATE() is the new function, which returns a DATE data type of the current date on the instance. Ref: CURRENT_DATE() - https://learn.microsoft.com/en-us/sql/t-sql/functions/current-date-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 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 […]
Editorials
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
Optimism Without Illusion or Why AI Needs Blunt Technologists - Comments posted to this topic are about the item Optimism Without Illusion or Why AI Needs Blunt Technologists
When SQL Server Central Went Down - Comments posted to this topic are about the item When SQL Server Central Went Down
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
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
Changing the AG Listener - Comments posted to this topic are about the item Changing the AG Listener
The String Distance I - Comments posted to this topic are about the item The String Distance I
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?
SQL Server 2022 - Development
SSIS with VS2022 64/32 issue with Excel files - Hi all, I'm trying to do classic scenario for loading multiple Excel files into db working in VS2022. I have reliable template which worked OK for csv files. But now after switching to xlsx I have problem when file name defined on Variable tab let say FileA.xlsx is not present in directory. If […]
Case part is sloooooow - Hi So the case statement is slowing this down - but for the life of me I cant think/find a more efficient way to get the results:   select * FROM pec.tBRClaimLinePreCalc WITH (NOLOCK) JOIN dbo.tclaim_procedure WITH (NOLOCK) ON tclaim_procedure.claim_procedure_id = tBClaimLinePreCalc.claim_procedure_id JOIN dbo.TPEC_RGV_ProcedureType WITH (NOLOCK) ON TPEC_RGV_ProcedureType.claim_procedure_id = tClaimLinePreCalc.claim_procedure_id WHERE claimProc_ServiceType IS NULL OR […]
Why the following cmds in sequence do not work - I need to delete rows from both the temporal main and history tables. The temporal main table can get deleted without issues. For the temporal history tables, I code to turn system versioning off, issue the Delete, then turn system versioning back on. If I execute manually each of the below cmds one at a […]
 

 

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

 

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