Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

Database Collation Matters for Unicode: #SQLNewBlogger

Posted on December 3, 2025 by way0utwest

While trying to work with Unicode data, I found some issues with collation. This post showcases what I’ve seen, with probably not enough answers. The collation/UTF stuff is still slightly confusing to me. Another post for me that is simple … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Database Collation Matters for Unicode: #SQLNewBlogger

Don’t Let Corner Cases Drive Your Design

Posted on December 1, 2025 by way0utwest

If you graph computer/query cost against the size of data, you can get four quadrants: small data, small compute (most CRUD app queries) small data, big compute (complex BI queries for this quarter, most reporting) big data, small compute (logs, … Continue reading →

Posted in Editorial | Tagged | Comments Off on Don’t Let Corner Cases Drive Your Design

Reverse Engineering a Physical Model Diagram

Posted on December 1, 2025 by way0utwest

I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting, but creating all the objects is a pain. I decided to try creating a physical diagram from an existing database. This post looks at the experience. … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

What’s Your Theme Music?

Posted on November 28, 2025 by way0utwest

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 … Continue reading →

Posted in Editorial | Tagged | 3 Comments