April 23, 2009 9:31 PM
Posted by: Colin Smith
Database Administration,
DBA,
Installation,
SQL ServerToday I had a developer ask about moving old DTS packages into SQL Server 2008 SSIS. This is our first real test SQL Server 2008 instance and we had never done this. He was attempting to use the Package Migration Wizard to move the package into SSIS. We installed the BI Visual Studio Components and...
April 23, 2009 2:25 AM
Posted by: Colin Smith
Database Administration,
DBA,
Oracle,
UpgradeI was able to finish up the Oracle Upgrade that I wanted to do today. First I removed the previous installation of Oracle 10 on the server. I then installed the software and all patches that I needed. I then changed my variables to reflect the new Oracle Home Directory that I wanted to use. After...
April 22, 2009 3:34 PM
Posted by: Colin Smith
Database Administration,
DBA,
Oracle,
UpgradeToday I will again embark on the journey that is Upgrading Oracle. This will be the third and final time that I do this on our test system in preparation to upgrade our Production Cluster that also has a DataGaurd Backup solution. I expect this process to take a about 4 hours including the removal...
April 21, 2009 9:06 PM
Posted by: Colin Smith
Database Administration,
DBA,
Education,
SQL,
SQL ServerIn an earlier post I said that I was about to start reading some books from the advanced Sybase Training course. I have changed course since then and I have decided to move on with some SQL Server education instead. I have decided that I would like to get my MCITP: Database Administrator...
April 21, 2009 7:04 PM
Posted by: Colin Smith
Database Administration,
DBA,
MS SQL,
SQL ServerI just had a battle with some applications support team members about securing our data. We have a system that connects to a SQL Server backend, this system has been in place for over a year now and is about to get a major application update. When this system was first implemented management let...
April 7, 2009 5:14 PM
Posted by: Colin Smith
Database Administration,
DBA,
Monitoring,
Powershell,
Windows AdministrationI have a script that goes out and pings all of my SQL Servers. This script, right now, simply makes a connection to the SQL Server instance. If I am able to connect I call it good and if not I send out notifications saying that the SQL Server is down. I found that more often than not I was getting...
March 31, 2009 4:36 PM
Posted by: Colin Smith
Database,
Database Administration,
Oracle,
Perstat,
StatspackHere is the update on changing the perfstat statspack job that I spoke of earlier. The question was how can I get statspacks to run every 15 minutes during OLTP and every 2 hours during batch. My thought is a Cron Job that will run the SQL for you. Just make a connection to the DB using SQLPLUS and...
March 31, 2009 3:57 PM
Posted by: Colin Smith
Database,
Database Administration,
Education,
SybaseToday I came back into the office after having a week off. It is always hard to come back into the office but it is nice to get back into the swing of things as well. When I arrived I found some new Sybase books sitting on my desk. Now I know that my company is not going to send me to another class...
March 30, 2009 9:57 PM
Posted by: Colin Smith
Active Directory,
Database Administration,
Linux,
Powershell,
Scripting,
System Administration,
Unix,
Windows,
Windows AdministrationSo I have people ask me all the time how I can get so much done in a day. I have to be honest with you, I do not really do that much. This is because I write scripts to do anything and everything for me if I have to do it more than once I script it. If I think something...
