The Multifunctioning DBA

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 it. I am sure I will have more to say about this after my first day though. Wish me luck

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 have a little fun. But the real good time was after work. A lot of people that I have gotten to know over the years came out to see me off. It was humbling, and very appreciated. We all drank and ate and just had a great time. It is very hard to say goodbye but it is time to move on to a new opportunity. I am excited and a bit nervous about my new job. Nervous only because I do not know exactly what to expect but I am sure it will be fun. I know that because I will be doing DBA work and that is fun to me so how can I go wrong. I hope to stay in touch with many of my friends that I will miss every day now but I look forward to making new friends as well. Here is to moving on but not forgetting where I came from.

September 10, 2011  10:00 AM

New Job

Colin Smith Colin Smith Profile: Colin Smith

After 8 years with the company I am working for now it is hard and sad to say that I am leaving for a new opportunity. This media company has been great to me and this is really where it all started for me. After DeVry this was my first job in IT. I started at the helpdesk and worked my way up and up until I got to be a Sr. DBA. This is where I grew up so to speak and it is very hard to leave. This week as I start to clear my desk it is starting to hit me that I am finishing up this chapter of my career.  I am very excited and eager for my new challenge but this is the first job that I have ever left where the last two weeks are not dragging out. I have really enjoyed my time here and all that I have learned here. I will sorely miss the people that I work with on the East and West coasts. I hope that I can keep in touch with many of my co-workers and keep these relationships strong. It is the people that I will miss the most for sure, but the work will be missed as well.

September 9, 2011  9:21 PM

Powershell Register Servers to CMS

Colin Smith Colin Smith Profile: Colin Smith

I wanted to take my list of servers that I have in a database and put them in a CMS so I could have them all listed and accesibile for other DBA’s to use that do not know powershell. This is a cool and powerfull thing, I just prefer powershell. Anyway I thought since I already have a listing of all the instances in my db it should be simple to throw together a script to register these. I did a bit of searching and I found this link and took some coed from it and modified it a bit to work for me.

So I found that this did not work just right and I had a big problem with named instances. When I would pass a server with a named instance the ‘\’ in the name really gave me issue and I figured out that I needed to use the HEX for the ‘\’ and that turns out to be ‘%5C’ So below is what I came up with and it works well now.

$devservers = invoke-sqlcmd -serverinstance SERVERNAME -database DBNAME -query “select i_name from instances i, Versions v where i.I_ID = v.I_ID and SQL_Version like ‘%2008%'”
cd ‘sqlserver:\sqlregistration\central management server group\SERVERNAME01%5CINSTANCENAME\2008’
foreach ($server in $devservers)

$name = $server.i_name
$name1 = $name
if ($name1 -like “*\*”)
$name1 = $name1.replace(“\”, “%5C”)

new-item $name1 -itemtype registration -value “server= $name1;integrated security=true”

I hope that will help some of you out there and please hit me up here with a comment or on twitter @smithco32 if you have any questions

August 31, 2011  10:00 AM

SQL Server Authentication

Colin Smith Colin Smith Profile: Colin Smith

I love when I am working with a Application team and they request an account to be created in order to have x access to y database on the server. The AD account gets created and I add that login to the server and map it to the database and give it the level af access that the application team has specified. Then I get a call saying that it is not working and I look in the logs and see that they are attempting to use SQL level authentication and not Windows. I mention that to them and they tell me that windows will not work with the application.

It just baffles me that people with the title of application and database architect do not have a basic understanding of authentication methods in SQL Server. I mean it is not that complex at a high level and we only have two methods for authentication.

All I can say is that if you ask for an account you need to know what type of account you need. The DBA may need to change the server to mixed mode and perhaps that is a major security concern on that instance so the DBA really does need to know this information. Please know what you need before you request it and if you are not sure go talk to the DBA. Most DBA’s are willing to help in order to get it done right the first time.

August 30, 2011  9:00 PM

Fantasy Football

Colin Smith Colin Smith Profile: Colin Smith

This year in my IT league for Fantasy Football the guy that is the commissioner is out of town for our draft and some how I was nominated to be the commissioner and run the draft. While this is an honor it really is not something that I am prepared to do. But I will give it a shot and see how it goes. I will post about it again when it is done and let you know my lineup. This is only my second year in the league so I think I will let the computer auto-pick for me as I did not do so great last year when I did the picks for myself.

August 30, 2011  3:33 PM


Colin Smith Colin Smith Profile: Colin Smith

Football is back and the regular season is about to start. I am excited about it but I do not know about you but I am pretty frustrated with all professional sports. When the lockout occurred I would have been fine with no season and even better if the league would have said your fired to all the current players and held a draft and got all new players that would play for less money, hopefully the execs would take a pay cut, and make it more affordable for the fans. We are the ones that matter and I think it is crazy how much it costs to take a family to a game. Just my two cents but I am glad to be able to watch on TV and get in a Fantasy league or two.

August 27, 2011  9:00 AM

SQL Server Accounts password policies

Colin Smith Colin Smith Profile: Colin Smith

When creating a SQL Server level account and not using windows authentication, how do you set things up so that you know you have a complex password that meets your requirments? Well that is what the is_policy_checked option is for. If that is set = 1 then SQL Server will read your password policy from the local security policy or the domain policy and enforce those same restrictions on the password. Restrictions are password length and complexity, password history and things like that. But I also need the passwords never to expire. these are accounts that applications use and if the passwords expire then that could cause a big mess when the application can no longer log into the database. Well that is why the put the is_expiration_checked option in as well. Both options are turned off by default but if you select the policy option then the default for expiration also becomes checked so if you do not want it to expire you need to make sure to uncheck that option after you turn on the policy. So if you do not check the expiration then the policy still gets checked but it does not apply the section of your security policy about expiration to the sql auth accounts.

Hope that makes sense and helps you out. Here is a link to BOL about this as well.

August 26, 2011  9:00 PM

Gamestop to stop selling Game?

Colin Smith Colin Smith Profile: Colin Smith

That is correct! because of agreements that Gamestop has with Square Enix the publisher of Deus Ex: Human Revolution, Gamestop will not sell the game as it was shipped with a coupon for online PC play free via Square’s OnLive gaming service. At first Gamestop was just opening every box and removing the coupon but because of all the bad PR for that now they have decided to only sell the game on-line and they have pulled the game from store shelves. I think this is a better way to do it but come on, people were still purchasing the game at Gamestop so why would you not want that and now all the negative PR. Whatever I do not shop and Gamestop any way and now I never will.

August 26, 2011  3:31 PM

Root EVO 3D

Colin Smith Colin Smith Profile: Colin Smith

Thanks to HTC I was able to root my EVO3D. I have not put another ROM on it and I am not going to yet. I am very happy with the stock ROM and everything works great but it is very nice to have the phone rooted so that I can do some things with it that were not possible before. So if you have an HTC phone go see if they have unlocked the bootloader for your phone and just follow the instructions. Here is a link.

Good luck and remember that this will void your warranty. Just because HTC does not mind you doing this that does not mean that your carrier will want you to do it.

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: