Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

PASS Keynote Shots

Rodney Kidd took some great shots of the keynote and published an album here: https://www.flickr.com/photos/127113040@N04/albums/72177720330695911 A few of my favorites: Here’s one of the 8 ball and keynote (and I’m enjoying myself) //embedr.flickr.com/assets/client-code.js This is a great shot of the … Continue reading

Posted in Blog | Tagged , , | Comments Off on PASS Keynote Shots

SQL Server Licensing is Simple

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

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

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