Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

What's Your Theme Music?

A few weeks ago, I was at the Small Data SF 2025 Conference in San Francisco. I attended the inaugural event last year and decided to go back again. It's a great chance to hear people thinking about data and its impact on the world in a different way, recognizing that building lager and larger systems isn't always possible. Or a good idea. We might find that smaller systems fit well, especially smaller datasets, which can both serve our purposes and create agility. The manifesto of the conference says that "We champion the power of Small Data and smart AI, believing that less is truly more." There's a bit more, but that's the idea.

The format for the conference is a little different, with 3-5 talks in a row, all on one stage, each about 25 minutes long. These are talks with or without slides, but no live demos, just speaking and expressing a point of view. What I found fun was that each person picked their own music to play as they walked onto stage (or ran/danced in the case of Glauber from Turso). It was a bit of fun, with the DJ letting the music play as the person made their way to the front and were welcomed by the audience. I heard rock, metal, hip hop, and more.

It's Friday during the week of the PASS Data Community Summit, and I had the chance to deliver part of the keynote on Wednesday. I've done this before, and no one has every asked me if I wanted a pick a piece of music, but it got me thinking. What would I pick?

For a fun Friday during the holiday season, think about if you were going to give a presentation. Maybe to your team, maybe other groups in the company, or (for some of you) on a conference stage. What music would you choose to accompany your walk into the bright lights? Imagine you get between 10 and 30 seconds.

Have some fun, and remember this is a professional setting. My first thought was something from the Notorious BIG, but I realized I'd have to walk fast as most of his lyrics wouldn't be appropriate. I'm not sure, but I lean towards one of these: one, two, three, or four.

 

Steve Jones - SSC Editor

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

Ad for State of Database Landscape survey
 
 Featured Contents
SQLServerCentral Article

T-SQL in SQL Server 2025: The PRODUCT Function

Steve Jones - SSC Editor from SQLServerCentral

Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]

Technical Article

How to Query JSON Data Quickly in SQL Server, Part 1: Pre-2025

Additional Articles from SQLServerCentral

Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:

Blog Post

From the SQL Server Central Blogs - Advice I Like: Failure

Steve Jones - SSC Editor from The Voice of the DBA

If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...

From the SQL Server Central Blogs - Why Databases Still Fascinate Me

Chris Yates from The SQL Professor

I get asked a lot about why or how I began working with databases years ago. I did not wake up one day and decide, “I am going to...

Learn T-SQL Querying

Learn T-SQL Querying

Additional Articles from SQLServerCentral

Troubleshoot query performance issues, identify anti-patterns in your code, and write efficient T-SQL queries with this guide for T-SQL developers

 

 Question of the Day

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

 

Which Object Definitions Are Available?

For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)

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 Ending Substring

In Azure SQL Database and SQL Server 2025, if I run this, what is returned?

SELECT '[' + SUBSTRING('Steve Jones', 7) + ']'

Answer: [Jones]

Explanation: The SUBSTRING function changed in SQL Server 2025 to make the third parameter optional. Ref: SUBSTRING - https://learn.microsoft.com/en-us/sql/t-sql/functions/substring-transact-sql?view=sql-server-ver17#arguments

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.


Suggestions
Email change does not work - I changed my email address in Edit Profile page, but it has no effect - I still receive emails to my old mailbox. Did I miss anything? Thanks  
Editorials
Is Data Modeling Common? - Comments posted to this topic are about the item Is Data Modeling Common?
Personal Contact Is Vital - Comments posted to this topic are about the item Personal Contact Is Vital
An Unexciting Exciting Release - Comments posted to this topic are about the item An Unexciting Exciting Release
The case for "Understanding our business" training - Comments posted to this topic are about the item The case for "Understanding our business" training
Don't Create Workslop - Comments posted to this topic are about the item Don't Create Workslop
Article Discussions by Author
SQL Server 2025 Build List - Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server - Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Getting The Database Name - Comments posted to this topic are about the item Getting The Database Name
Getting the Schema for Tables - Comments posted to this topic are about the item Getting the Schema for Tables
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability - Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Specifying the Collation - Comments posted to this topic are about the item Specifying the Collation
SQL Server 2025 has arrived! - Comments posted to this topic are about the item SQL Server 2025 has arrived!
SQL Server 2022 - Development
SQL Server 2022 order by bug? - Hi, I was using order by on a column with characters and saw something I couldn't explain. Seems a bug to me, or am I missing something. SELECT @@VERSION SELECT N'1.' Id UNION ALL SELECT N'1-' Id ORDER BY Id SELECT N'1.w' Id UNION ALL SELECT N'1-w' Id ORDER BY Id DECLARE @s TABLE (Id […]
Looking for help with SQL statement - Hi there I am seeking some help with an SQL statement. Any help would be welcomed. TIA   See the query i have used below. I have an SQL statement that is trying to return all the values of a column from a table called stockallocations. However as no record exists for one of the […]
 

 

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

 

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