Monthly Archives: February 2017

Let NonAdmins Get Logins

Posted on February 8, 2017 by way0utwest

I saw a question recently about how to allow some users to see the logins on a server without being a sysadmin or securityadmin. This was in support of a migration effort, so users needed read rights without being able … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Let NonAdmins Get Logins

Backups Aren’t Backups Until a Restore Is Made

Posted on February 8, 2017 by way0utwest

One of the interesting things I saw in the recent GitLab outage and data loss was the fact that none of their backups were available. They use PostgreSQL and I’m not familiar with the ways in which the modern PostgreSQL … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Backups Aren’t Backups Until a Restore Is Made

A View of the Cloud

Posted on February 6, 2017 by way0utwest

Amazon has been an amazing digital company in the last twenty years. I remember making my first order from them, unsure of whether the online bookstore would work better than browsing locally, or if I’d even get my books. I … Continue reading →

Posted in Editorial | Tagged | Comments Off on A View of the Cloud

Get Your SQL Server Product Key with Powershell #dbatools

Posted on February 3, 2017 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 , , | 4 Comments