Tag Archives: administration

Attaching All Databases with PowerShell – The Overview

TL;DR Script is here: Git Hub Powershell Scripts. It’s the attachdbs.ps1 and will attach all databases in a folder to a SQL Server instance, if they don’t exist. I wrote a PowerShell script recently to actually accomplish a task I … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Attaching All Databases with PowerShell – The Overview

Backup Responsibility

One of the most important things that you can do as a DBA, or really as any sort of system administrator, is back up your system.Ensuring that you have have backups, and of course, that you can restore them, is … Continue reading

Posted in Editorial | Tagged , , | 1 Comment

No Handwaving Away the DBA

There’s a great quote I read, at the end of this article. It says: “…if you think that switching to NoSQL will just let you hand-wave away all of the challenges of running a database, you are terribly misguided.” The context … Continue reading

Posted in Editorial | Tagged , , , , | Comments Off on No Handwaving Away the DBA

Consolidation Matters

Throughout my career I’ve been looking to consolidate SQL Servers when I find them. The typical employer I’ve had usually grows their IT infrastructure over time and many projects look like this: Build or buy a software package Buy a … Continue reading

Posted in Editorial | Tagged , | Comments Off on Consolidation Matters