The Multifunctioning DBA:

MSSQL Administration


January 22, 2010  1:12 PM

Health Check into SQL Server



Posted by: Colin Smith
Audit, Baselining, MSSQL, MSSQL Administration, Trending

I have recently posted about my new job and how I am walking into the unknown. Like I have said in the past, I did get a list of Host Names that are running SQL Server. I have written a script to go out and look at each of those hosts and get me all instances. I have put together a list of about...

January 21, 2010  10:00 AM

More fun with MS SQL Server



Posted by: Colin Smith
Cluster, MS SQL, MSSQL Administration, Replication

I have a customer who would like to have a couple things. They would like to have, above all, HA. Secondly they would like to be able to configure the application to write to one database and read from another. They want to do this to boost performance as they feel that IO may be an issue. I...


January 8, 2010  7:19 PM

Find SQL Server Instances using Powershell



Posted by: Colin Smith
MS SQL Server, MSSQL Administration, MSSQL Instance, Powershell, Scripting

As I had mentioned before, I recieved a network scan that lists the host names of servers that have some sort of SQL Server running on them. Now I need to get a list of all instances that are on those servers. I thought I could do it in Powershell and I was correct. I know that all instnances of...


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


October 26, 2009  4:26 PM

Databases not accessible



Posted by: Colin Smith
MS SQL Admin, MS SQL Server, MS SQL Troubleshooting, MSSQL Administration, SQL Server 2005

Just got a call that three databases on an instance where many reside were not accessible. Users were getting errors about not enough disk, memory, or the files were inaccessible. I logged into the server and found that the databases were not offline but could not be accessed. I looked into the...


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


August 28, 2009  7:12 PM

Powershell execute SQL Server Jobs



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

I have been asked to write a script that will allow users to connect to a server, get a list of only the jobs that I want them to see, and execute only those jobs. No options to do anything other than execute the job. This is what I have come up...


August 27, 2009  3:13 PM

Questions about health check script



Posted by: Colin Smith
Answers, MS SQL, MS SQL Server, MSSQL Administration, Powershell, Powershell Tips, SQL Server

I recieved a comment that contained a question about my previous post about writing a script to output a health check of SQL Server. http://itknowledgeexchange.techtarget.com/dba/powershell-sql-server-health-check-script/ The following is the question: should we make anychanges for this do...


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


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: