The Multifunctioning DBA:

July, 2009


July 30, 2009  3:17 PM

Add a AD Group to MSSQL Server and add to a role using Powershell

Colin Smith Colin Smith Profile: Colin Smith

In SQL Server 2005 the Builtin Administrators group is a login, by default, to your MSSQL Server Instance and is also a member of the sysadmin role. Well this has been changed in SQL Server 2008 with good reason. I decided that I would like to add a group for my DBA Group to every SQL Server in...

July 28, 2009  10:18 PM

Migrating SQL 2005 Reporting Services

Colin Smith Colin Smith Profile: Colin Smith

I have been asked to help with Migrating a SQL Server 2005 Reporting Services server from one host to another. I set up a couple VM's and away I went. I found that it is pretty straight forward though. I did run into a couple little hickups along the way but nothing to dificult. I did have a...


July 28, 2009  7:14 PM

Helping Family

Colin Smith Colin Smith Profile: Colin Smith

Yesterday I was not feeling well so I decided to take the day off of work to rest and try to get better. Well things did not really work out that well for me. I am sure that most of you can relate to this and I am curious if you do what I did or if you deal with this in some other manner. Here is...


July 24, 2009  3:47 PM

Another New Language

Colin Smith Colin Smith Profile: Colin Smith

My team is going to be developing a new application that will handle all of our monitoring. Currently that includes the monitoring of Sybase Servers, Oracle Instances, and MSSQL Servers. We will also be adding another Database Type that will house all of the Monitoring data. We will be using a...


July 23, 2009  9:43 PM

More with Quest AD Powershell CMDLETS

Colin Smith Colin Smith Profile: Colin Smith

I am continuing work on the script that I am converting from VBScript to Powershell and I must say that it is going quite well with the help of the Quest cmdlets. In the script I want to go through a particular OU and delete any accounts that are currntly disabled, and were created a minimum of 180...


July 22, 2009  9:59 PM

Get List of all DC’s in your Domain

Colin Smith Colin Smith Profile: Colin Smith

I am working on converting a vbscript that I wrote a couple of years ago into a powershell script. This script requires that I query all of the Domain Controllers in my domain to get the most up to date data that is possible. I used the Quest AD Commanlets and they made it easy. I have discussed...


July 21, 2009  3:29 PM

SQL Server 2008 Learning

Colin Smith Colin Smith Profile: Colin Smith

I found this nice article that I thought I should pass on regarding Learning SQL Server 2008. http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1361184,00.html?track=sy41 The article talks about key features and enhancments from SQL Server 2005, BI, Security, and more good...


July 17, 2009  8:19 PM

Powershell Add a Login to SQL Server

Colin Smith Colin Smith Profile: Colin Smith

I have a need to write a script that will check to see if a Windows Group exists on a server instance and if not then add it. I was attempting to do this using Powershell and SMO, but I was not really having any luck with that. I changed modes and I have decided to use the invoke-sqlcmd commandlet...


July 17, 2009  3:59 PM

Update sysindexes table in Sybase 12.5.4

Colin Smith Colin Smith Profile: Colin Smith

I am moving a Sybase instance from one host to another. I have done all the installation and patching and I have loaded all the databases with little to no issues. I ran into a big issue when attempting to change to indexes in sysservers to allow duplicate rows. I had to go and find out what the...


July 17, 2009  2:56 PM

MR. Denny has a webcast

Colin Smith Colin Smith Profile: Colin Smith

I just saw this and I am looking forward to attending. MR. Denny is a great SQL Resource and I am sure that I will learn new things during this webcast. Here is a link to his blog entry about the...


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: