Uncategorized

SQLServerCentral Editorial

Hack Your Brain

  • Editorial

Now, let's be really clear up front, I don't mean getting a surgically implanted chip in your head, done on your kitchen table. Brain hacks are generally either, forming habits that are good for learning and concentration, changing how you do things to help enhance your brains function, eating differently in support of brain health, […]

You rated this post out of 5. Change rating

2025-08-02

114 reads

SQLServerCentral Editorial

Get Your Chores Done

  • Editorial

I grew up in a pretty rural environment, in the southern US, in what's considered the Old West (Jesse James, reportedly, had a hideout a few miles from my current home, the Daltons, Belle Star, I can keep going, all came through this part of Oklahoma). Here, we call our daily tasks, like taking out […]

You rated this post out of 5. Change rating

2025-08-01

94 reads

SQLServerCentral Editorial

A Little Appreciation

  • Editorial

I'd like to take a moment and simply voice my appreciation for Steve Jones. Steve's still on sabbatical, so I've been doing some of the work, along with my co-worker, Kellyn Gorman (who I also appreciate, very much). I'm sure you've noticed. Oh, not simply that the editorials are different. That's to be expected. Nah, […]

(5)

You rated this post out of 5. Change rating

2025-07-30

101 reads

SQLServerCentral Article

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

  • Article

When a SQL Server Express-based factory app started crawling, the culprit wasn’t hardware or network — it was a decades-old WHILE loop migrated from C/C++ to SQL. This real-world story breaks down how procedural habits, memory grants, and lack of window functions nearly derailed a production floor.

(6)

You rated this post out of 5. Change rating

2025-07-28

14,361 reads

SQLServerCentral Editorial

Planning for the Right Emergency Response

  • Editorial

I'm currently testing a pair of POC radios <editor: can no one shut him up about the radios?> No, go away. So, where was I, oh yeah, POC radios. What are they, I hear you asking. <editor: no one asked that> Hush. Push-to-talk Over Cellular. POC or PoC. In short, you get a SIM card […]

(1)

You rated this post out of 5. Change rating

2025-07-28

84 reads

SQLServerCentral Editorial

When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense

  • Editorial

As we continue to build more applications using AI embedded solutions, database professionals are increasingly being asked to support workloads that would have seemed outside their charter just a few years ago. One of the most significant shifts has been the rise of vector data (i.e. high-dimensional numerical representations of content like text, images, and […]

(2)

You rated this post out of 5. Change rating

2025-07-26

311 reads

Blogs

Using Prompt AI for a Travel Data Analysis

By

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

By

I’ve often done some analysis of my year in different ways. Last year I...

Read the latest Blogs

Forums

reaching ftp thru winscp but erroring in ssis ftp task connection

By stan

Hi, below i show various results trying to reach our ftp site (a globalscape...

Finding Motivation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Motivation

The Last Binary Value of the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Binary Value of...

Visit the forum

Question of the Day

The Last Binary Value of the Year

What does this code return?

SELECT cast(0x2025 AS NVARCHAR(20))
Image 1: Image 2: Image 3: Image 4:

See possible answers