Blog Posts

Blog Post

Set-Based vs Row-Based Database Code

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles of writing SQL code to manipulate data. These styles have implications for performance, readability, and...

2023-12-18 (first published: )

595 reads

Blog Post

A New Word: Nementia

nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering...

2023-12-15

34 reads

Blog Post

Azure Workbooks

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...

2023-12-13 (first published: )

314 reads

Blogs

Advice I Like: Training Employees

By

Train employees well enough that they could get another job but treat them well...

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

SQL Server Migration Overview

By

It’s Not Just Backup / Restore At some point every company faces it: the...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Why Data Modelling Still Matters - More Than Ever

By John Martin

Comments posted to this topic are about the item Why Data Modelling Still Matters...

hops from sql server to mysql to s4 hana - possible?

By stan

Hi when i think of server hops , i think of how kerberos assists...

Visit the forum

Question of the Day

Strange String Splits

When I run this code, how many rows are returned? 

DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食'
DECLARE @s NVARCHAR(1) = N'食'
SELECT value
FROM STRING_SPLIT(@meals, @s)
GO

See possible answers