Monthly Archives: September 2018

Dark Reads During a Migration

I caught a post from the Slack Engineering team titled: Re-architecting Slack’s Workspace Preferences: How to Move to an EAV Model to Support Scalability. In the post, an engineering intern describes the move from a blob table (actually a table storing … Continue reading

Posted in Editorial | Tagged | Comments Off on Dark Reads During a Migration

Learn about SQL Source Control in Redgate University

I love the SQL Source Control product from Redgate. It’s not perfect, and it can be slow to run at times, but the simplicity of what it does, of getting my code quickly and easily to a VCS is fantastic. … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Learn about SQL Source Control in Redgate University

We Need Data Privacy Consistency

For most of the last year, I’ve had quite a bit of my time devoted to the GDPR and related topics. My company is affected, as it’s based in the UK. Not only must we comply, but we know many … Continue reading

Posted in Editorial | Tagged , , | Comments Off on We Need Data Privacy Consistency

How Do You Setup Your Instances?

I’ve set up a lot of SQL Server instances in my career. I’ve gone from manual only setup in SQL Server 4.2 to more automated means in the latest versions. The easiest was actually in Azure where I only need … Continue reading

Posted in Editorial | Tagged , | Comments Off on How Do You Setup Your Instances?