Monthly Archives: May 2019

Communicate Smarter Not More

Posted on May 13, 2019 by way0utwest

I recently installed Microsoft Teams. Not because I wanted to, or because Redgate is abandoning Slack, but because Microsoft requires it for some MVP calls. This replaces Skype for Business (S4B), and while it worked OK, I’m not sure it … Continue reading →

Posted in Editorial | Tagged | Comments Off on Communicate Smarter Not More

A Clean Values Clause with SQL Prompt

Posted on May 13, 2019 by way0utwest

I’ve had this code in a snippet for a long time: I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen. I can’t tell you how many times I’ve used CTRL+Z to undo that … Continue reading →

Posted in Blog | Tagged , , | Comments Off on A Clean Values Clause with SQL Prompt

Always Use Roles–#SQLNewBlogger

Posted on May 10, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Which of these is more complex? GRANT SELECT ON dbo.Customer TO JoeDev or CREATE ROLE SalesGRANT SELECT ON dbo.Customer … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

The Impediments to Change

Posted on May 10, 2019 by way0utwest

SQL Server is releasing a new version of the engine every 12-24 months at this point. That puts pressure on all of us to learn constantly about the changes. Even if we don’t look to upgrade all of our existing … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Impediments to Change