Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

SQL Server Licensing is Simple

Posted on December 3, 2025 by way0utwest

Over the years I’ve had no shortage of licensing questions for SQL Server. At times it’s felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you’re using VMs. … Continue reading →

Posted in Editorial | Tagged | 3 Comments

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 , , | Leave a comment

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 | Leave a comment

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