The Multifunctioning DBA:

September, 2011


September 30, 2011  4:13 AM

Powershell to add logins to SQL Server

Colin Smith Colin Smith Profile: Colin Smith

This is a script that I threw together for an app that needed to have 60 logins created on the sql server. We had all the ad groups created using a standard naming convention.
app_dev_groupname
was the standard that we went with so here is...

September 28, 2011  1:27 PM

Dynamic SQL

Colin Smith Colin Smith Profile: Colin Smith

The other day I wanted to write a query that would create my actual query in the results pane. I wanted to generate the sql to delete all the logins on the instance that met a certain criteria. Well I had some trouble but I worked it out and once I did I thought wow that was way easier than I was...


September 27, 2011  10:00 AM

Some Powershell Help

Colin Smith Colin Smith Profile: Colin Smith

Since I started my new job, I let the guys that I used to work with know that I would be happy to help them out if they have any questions about anything especially powershell since I took care of pretty much all of our Powershell needs. And the other day I got an email asking about how to find out...


September 26, 2011  1:37 PM

On to Week Two

Colin Smith Colin Smith Profile: Colin Smith

Today I start my second week of work at my new job. The first week was alright but a little slow. That is to be expected as I need to learn the new environment and get up to speed with the way they are doing things. I did have a few fun things come up like the memory testing and I also got to write...


September 26, 2011  1:27 PM

Another DR Test

Colin Smith Colin Smith Profile: Colin Smith

So we have what sounds to be a great idea for our SQL Server DR. We are doing block level replication between datacenters and so we thought it might be a good idea to joust mount up our disk on another server that is in the DR Datacenter in case of a disaster. We want to do that with the disk that...


September 23, 2011  1:32 PM

DR SQL Server Memory Test

Colin Smith Colin Smith Profile: Colin Smith

My new company has a DR Test coming up and we came up with a great idea on how to make the SQL Servers test pretty simple. We use SAN Block level replication so we should be able to mount up our shared disk to any server that has the correct version of SQL Server installed. One question that we had...


September 20, 2011  3:59 AM

Day One

Colin Smith Colin Smith Profile: Colin Smith

Day one at the new job was a bit slow but I guess that is to be expected. Had to do a lot of paperwork and then get situated at my new desk, log into my new machine and start to figure out the new environment.  While I was doing that I found my own blog very useful. I downloaded some of my own...


September 19, 2011  10:00 AM

SQL Server Health Check Follow Up

Colin Smith Colin Smith Profile: Colin Smith

A long while ago I wrote a script that does a SQL Server Health check and I posted it here. Recently I have gotten some comments on it and I want to help some people out. So I thought I would...


September 18, 2011  11:47 PM

First Day

Colin Smith Colin Smith Profile: Colin Smith

Tomorrow is my first day at the new job and it sounds like it will be a pretty boring day. Just orientation stuff and I do not really get to do anything Tech just yet. I know all this has to be done but I am so anxious to get going and see what my new role will bring to me and what I can bring to...


September 18, 2011  11:45 PM

Great last Day

Colin Smith Colin Smith Profile: Colin Smith

Friday was my last day at my job and it was a good day. I finished up some things including putting scripts and notes and tools all in one location for my fellow DBA's to use. But it was a fun day as well. hanging out with friends and just reminiscing. I also put Windows 8 on my workstation just to...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: