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

Changes, Happiness, and a Few Tears

Change is inevitable for most of us. The jobs we hold, the places we work, the people we know, even our families grow and change over time. As I get older and live longer, I've learned to accept, appreciate, and flow with changes. I might resist, delay, embrace, or anticipate tomorrow, knowing there is always a positive and negative side to things.

This week, one of my colleagues retired. Annabel has been a part of Redgate nearly as long as I have, and we've worked together for many years. If you've ever attended a Redgate event, live or online, she likely had a part to play in the planning, organizing, execution, financing, and every other part of the process.

My colleague, Allison, made a wonderful post yesterday, on Annabel's final day with memories and thoughts from their time together. I wrote my own post with pictures and memories of our time together. There are so many more, and every time I think about our history, I'm touched, blessed, thrilled, and sad.

At PASS Europe last week, we said goodbye to Annabel at the last event she's worked on. We toasted, laughed, and cried. She shed tears, which is a rarity, but Grant and I probably cried the most. She's been a part of our lives and careers for many, many years.

Even typing these words brings tears to my eyes.

The future brings opportunity and excitement. It also brings sadness and wistfulness of the past. I can enjoy the memory of what I've experienced, miss the way things were, balancing those feelings with the my view forward to what is coming.

I can also think about what didn't go well previously. We've had some issues at events, challenges, stressful times. Both at events, and while working with others in technology. I can learn from the past, be proud of the war stories, be glad we got past the failures, celebrate our successes, and plan to do better tomorrow.

The thing I miss most about growing older and moving forward are the people who I enjoyed spending time with. Those are the memories that stick with me more than the projects, the successful tech solutions, the elegant and fast code, the awards, bonuses, and achievements.

I miss the humans who have touched my life, and hopefully, whose lives I've touched.

I wish Annabel the best in retirement, I'm excited for where she journeys tomorrow. I hope those of you reading this make, cherish, and enjoy the great friends in your life.

 

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

You Probably Don't Need a Vector Database

Kumar Abhishek from SQLServerCentral

Introduction Conversations about RAG almost always start with a vector database. This article suggests you dig deeper before implementing one.

External Article

The LLM layer you’re probably missing (LLM gateway pattern explained)

Additional Articles from SimpleTalk

The LLM gateway pattern is a thin service layer that sits between your app and large language model (LLM) providers, centralizing every AI call through a single entry point. It gives you immediate control over routing, logging, retries, fallbacks, and cost tracking – preventing the chaos of scattered integrations, unclear billing, and provider lock-in as your system scales. Learn all you need to know about the LLM gateway pattern in this article.

Blog Post

From the SQL Server Central Blogs - T-SQL Tuesday #199: Back to the on-prem

Koen Verbeeck from Koen Verbeeck

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s topic is chosen by myself, and it’s inspired by a blog post of Alexander Arvidsson....

Blog Post

From the SQL Server Central Blogs - SQL Server instance metadata inventory with PowerShell and SMO

SQLPals from Mission: SQL Homeostasis

SQL Server instance metadata inventory with PowerShell and SMO

The purpose of this article is to introduce a PowerShell script that I wrote and published on...

Technical Article

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

Site Owners from SQLServerCentral

This book is your comprehensive guide to building robust Generative AI solutions using the Databricks Data Intelligence Platform. Databricks is the fastest-growing data platform offering unified analytics and AI capabilities within a single governance framework, enabling organizations to streamline their data processing workflows, from ingestion to visualization. Additionally, Databricks provides features to train a high-quality large language model (LLM), whether you are looking for Retrieval-Augmented Generation (RAG) or fine-tuning.

 

 Question of the Day

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

 

BCP on Linux

When running bcp on Linux, what is the field terminator?

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)

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)

Here is the sample data I am testing with:

CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor

How many rows are returned?

Answer: 10

Explanation: All the rows are returned. In a default installation, the collation is case insensitive. In this collation, 'A' = 'a', so all rows match. Ref: SQL Server Collations - https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver17#sql-server-collations

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
identity increments by 10,000 when it was supposed to be 1 - hi a peer of mine who ive never known to be wrong says a new table he created with pk identity(1,1) jumped by 10000 on one insert.   has anyone ever seen this anomaly?
Editorials
Follow Your Hunch - Comments posted to this topic are about the item Follow Your Hunch
The Slow Growing Problems - Comments posted to this topic are about the item The Slow Growing Problems
Liability for AI Errors - Comments posted to this topic are about the item Liability for AI Errors
How Do the Experts Become Experts? - Comments posted to this topic are about the item How Do the Experts Become Experts?
Article Discussions by Author
What Happens When You Ask a Local AI to Query Your Database? - Comments posted to this topic are about the item What Happens When You Ask a Local AI to Query Your Database?
Detecting Characters - Comments posted to this topic are about the item Detecting Characters
Displaying Money - Comments posted to this topic are about the item Displaying Money
Calculating the Harmonic Mean in Power BI - Comments posted to this topic are about the item Calculating the Harmonic Mean in Power BI
Pro SQL Server Internals - Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry - Comments posted to this topic are about the item SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Running SQLCMD II - Comments posted to this topic are about the item Running SQLCMD II
SQL Server 2022 - Administration
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica - Hello , I would like to run a stored procedure on a secondary replica in an AlwaysOn Availability Group to offload read-only workload from the primary. However, this procedure currently suffers from parameter sniffing, and we sometimes need to recompile it to restore acceptable performance. I would like to know: What are the risks of […]
Backup Availability Group - Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022 Availability Group with 4 replica I am trying to make sure I am using the best method of backing up my databases. I cannot use the Ole Hollengren jobs because of my environment Currently I have all four nodes set up […]
SQL Server 2022 - Development
Increment a number in a SQL Query based on a value - I have an issue where I have a Bill of Material list of items where some of the item numbers are blank. I need to give them sequential numbers from a beginning number like 9000000. then the next blank would be 9000001 and so on. I thought I could create a table and store 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

 

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