Tag Archives: sql server

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

Allowing a User to Create Objects in a Schema

Posted on March 12, 2015 by way0utwest

I was testing something the other day and realized this was a security area I didn’t completely understand. I decided to write a few posts to help me understand the issues. I want to give a developer rights to create … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

The Express Choice

Posted on February 27, 2015 by way0utwest

There are a number of editions of SQL Server, each of which has different capabilities, features, and restrictions. Over the years, the mix has changed, and it can get confusing for customers trying to decide what to purchase and use. … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Missing Full Text Extensions in Express

Posted on February 23, 2015 by way0utwest

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Missing Full Text Extensions in Express