December 10, 2008 12:16 AM
Posted by: Colin Smith
Database,
SybaseIn day 3 we covered another 5 sections so once again I am just going to go over what I found to be the most interesting.
I would say that I have two things in day 3 that I found to be very cool. First is permissions and how they work in Sybase. So first you have to have a login to the server....
December 5, 2008 10:03 PM
Posted by: Colin Smith
SybaseSybase ASE Database Administration training class day 2 was a busy day and we again covered 5 chapters. We covered Database Devices, Creating Databases, Disk resource strategies, Auto Expansion, and finally the big one TempDB. I am not going to go into too much detail about these as I think you...
December 2, 2008 3:10 AM
Posted by: Colin Smith
SybaseToday was my first day of class and it was a good day of class. I arrived at the Sybase Training facility this morning, found the class and saw the student list and only three students are registered for the class. Only two of us showed up though. I found this ironic because the person that did...
December 2, 2008 2:46 AM
Posted by: Colin Smith
SybaseMy work is sending me to Sybase Training in Dublin CA. I am on my way to SFO and I will be using the BART system to make my way Dublin for training. I am looking forward to this class as I have not yet had any formal training in Sybase. I have been to one entry level class in Oracle, but Oracle...
November 11, 2008 10:58 PM
Posted by: Colin Smith
Database,
Microsoft Windows,
Powershell,
SQL ServerIt has been a while since my last post about MS SQL Server Monitoring using Powershell. This is because I found that I was not catching all the errors that I wanted. I was missing any jobs that were...
October 28, 2008 5:59 PM
Posted by: Colin Smith
Database,
Microsoft Windows,
Powershell,
SQL ServerIn MS SQL Server Monitoring Part 2 we talked about inserting the Marker into the ERRORLOG file. Now that we know we can do that we need to look at how we can scan the ERRORLOG file for errors, and only new...
October 23, 2008 9:58 PM
Posted by: Colin Smith
Database,
DBA,
Microsoft Windows,
Powershell,
SQL ServerOK so in MS SQL Server Monitoring we left off asking about how we can insert a Marker into the ERRORLOG file while the SQL Server is running and the SQL Server has the file locked. Actually, the answer is pretty...
October 23, 2008 8:30 PM
Posted by: Colin Smith
Database,
DBA,
SybaseI am currently working on upgrading one of our applications from ASE12.5 to ASE15 and the developers are in the middle of testing. This morning I got a call saying that the developer working on this could no longer connect to the server. I looked into it and found that the server was shutdown. I...
October 22, 2008 4:25 PM
Posted by: Colin Smith
DBA,
Exchange,
Microsoft Windows,
Powershell,
SQL ServerIn my first few posts here I have done a lot of things in Windows Powershell. Some of you may be asking why Powershell and I am busy asking why not Powershell. Since being introduced to Powershell any time I hear a request to do just about anything in Windows I think about how I can script that...
