Monthly Archives: April 2018

Checking Tempdb with dbatools

Posted on April 20, 2018 by way0utwest

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Checking Tempdb with dbatools

Keep It All

Posted on April 20, 2018 by way0utwest

I love this quote, though I’m not sure it’s accurate. From The Future of Data Storage, the piece states: “What’s the most expensive thing you can do with a piece of data? Throw it out.” That’s from a storage vendor, and … Continue reading →

Posted in Editorial | Tagged | Comments Off on Keep It All

The Prompt Actions Menu

Posted on April 19, 2018 by way0utwest

A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that appears when you highlight code. I’ve got a quick animation of this working. In the gif, I highlight code, click … Continue reading →

Posted in Blog | Tagged , , | Comments Off on The Prompt Actions Menu

The Right Connection

Posted on April 19, 2018 by way0utwest

Travis-CI had some staffers connect to the wrong database and truncate production tables. Needless to say this caused an outage and disrupted their business. Hopefully they didn’t lose too many customers, but they certainly did not help their reputation. I’m sure there are … Continue reading →

Posted in Editorial | Tagged | 4 Comments