Tag Archives: administration

Getting Database Properties – DatabasePropertyEx()

Posted on May 14, 2015 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had someone ask me a question about security recently, and while working through the answer, I ran across … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Getting Database Properties – DatabasePropertyEx()

Dig Out the Root Cause

Posted on April 28, 2015 by way0utwest

Early in my career in technology, I worked as a system administrator on a Novell network. Periodically we’d have crashes of servers on our network, or application failures, and while we understood that sometimes these were caused by transient errors, … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

The Demo Setup–Attaching Databases with Powershell

Posted on March 16, 2015 by way0utwest

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases. TL;DR I have a script that detaches all user databases from a SQL Server instance and then reattches certain ones. Full script at … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Starting a New Job

Posted on February 12, 2015 by way0utwest

I’ve had practice here, and was reminded of this when I ran across this thread on starting a new job. In my career, I’ve had far too many employers. I’d like to think it’s not my fault, but after having double digit … Continue reading →

Posted in Editorial | Tagged , , , , | Comments Off on Starting a New Job