The Multifunctioning DBA:

MSSQL Server


January 28, 2011  5:48 PM

Recent SQL Disaster

Posted by: Colin Smith
Database Administration, DBA, MSSQL Server

In my last post about the disabled sa account I mentioned that I would have more on why I could not use windows authentication to get to my SQL Server instance. Here is the short of it and I know many of you will be screaming at the screen as you read this. Again this is a server that I have walked...

January 18, 2010  6:34 PM

PASS Summit

Posted by: Colin Smith
Education, MS SQL, MS SQL Admin, MSSQL Server, PASS, PASS Summit

I am trying to get my company to pay for me to attend the PASS Summit 2010 in Seattle Washington. I am still pretty new in the world of Databases but I think that attending the Summit would be very good for...

October 27, 2009  3:30 AM

Active, Active, Active

Posted by: Colin Smith
Cluster, MSSQL, MSSQL Administration, MSSQL Install, MSSQL Server, SQL Server 2008

Last week I got the chance to work on an Active, Active, Active SQL Server 2008 Cluster install. This was new to me and very fun. We have three physical hosts all using SQL Server 2008 Enterprise Edition. The Servers are also running Windows Server 2008 Enterprise Edition. I worked with one of our...

September 16, 2009  3:23 PM

Installing SQL Server 2008

Posted by: Colin Smith
MSSQL, MSSQL Administration, MSSQL Install, MSSQL Server

Yesterday I had to install SQL Server 2008 for the first time. I went through it on a development server first before installing on a production server. As I went through the setup process I noticed one thing that I think is long overdue. The Database Configuration step is a great addition to the...

July 28, 2009  10:18 PM

Migrating SQL 2005 Reporting Services

Posted by: Colin Smith
Database Administration, MSSQL, MSSQL Administration, MSSQL Server, Reporting Services

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 21, 2009  3:29 PM

SQL Server 2008 Learning

Posted by: Colin Smith
Database Administration, Education, MSSQL Administration, MSSQL Server, SQL Server

I found this nice article that I thought I should pass on regarding Learning SQL Server 2008.,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

Posted by: Colin Smith
Database Administration, MSSQL Server, Powershell, SQL Server

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...


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: