Daily Archives: September 17, 2018

A Summit Contest for registering by Sept 22

Posted on September 17, 2018 by way0utwest

If you haven’t registered for the 2018 PASS Summit and plan to go, you might press to get registration done this week. Next week prices increase, but this week you can save. There is a promotion from PASS that will … Continue reading →

Posted in Blog | Tagged , | Comments Off on A Summit Contest for registering by Sept 22

Deleting a User that Owns a Schema

Posted on September 17, 2018 by way0utwest

This was an interesting question I saw posted recently. Through SQL Server 2000, trying to delete a user that owned objects was a pain. We had to actually rebuild all the objects, which was problematic. With SQL Server 2005 and … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Dark Reads During a Migration

Posted on September 17, 2018 by way0utwest

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

Posted on September 17, 2018 by way0utwest

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