Tag Archives: powershell

Boring or Scripting

Do you want to continue to perform boring, repetitive, mundane tasks as a part of your job? Many of you might not be challenged at work, or you might be burdened with a series of requests that repeat themselves over … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Boring or Scripting

The Demo Setup–Attaching Databases with Powershell

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

Parsing SQL Saturday Data – Getting Titles from the XML document

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Parsing SQL Saturday Data – Getting Titles from the XML document

Powershell Quick Parameters for Scripts

I was working on a script recently to manage a particular process and wanted to make it generic by allowing the user to pass in a parameter. I have seen lots of examples, especially those that work with SQL Servers, … Continue reading

Posted in Blog | Tagged , | Comments Off on Powershell Quick Parameters for Scripts