The Multifunctioning DBA:

December, 2008


December 31, 2008  4:24 PM

ISQL



Posted by: Colin Smith

So I just told you about SQLCMD and it is a great tool for connecting into MSSQL servers. ISQL is a very similair tool that is used to connect to Sybase. Syntax and usage are the same and it will get you to the same wonderful SQL prompt for ASE Servers. I usually use PUTTY to connect in to the...

December 31, 2008  4:12 PM

Job Market



Posted by: Colin Smith

So in this economy I thing that just about everyone has seen someone close to them, hopefully not you, be laid off from work. I know that at my employeer we have had a couple rounds of layoffs and I have been very lucky. this last round one person from our Systems team was laid off and he was an...


December 31, 2008  4:06 PM

Happy New Years



Posted by: Colin Smith

Just wanted to wish everyone a Happy New Year and tell everyone to be safe on the roads. I will be hanging out with some freinds and my wife just having a nice quiet night. Have a good one and I hope that next year is great for you all.


December 26, 2008  6:15 PM

Sybase DBCC



Posted by: Colin Smith
Database, Sybase

Sybase DBCC or Database Consistency Checks. This was something that was talked about in my training class and so I thought I would implement this when I got back to work. I mentioned it to my team and they both said that I sounded just like them when they got back from class and they laughed a...


December 26, 2008  6:14 PM

Sybase DBCC



Posted by: Colin Smith
Database, Sybase

Sybase DBCC or Database Consistency Checks. This was something that was talked about in my training class and so I thought I would implement this when I got back to work. I mentioned it to my team and they both said that I sounded just like them when they got back from class and they laughed a...


December 26, 2008  5:59 PM

Sybase Training Day 5



Posted by: Colin Smith
Database, Sybase

Sorry that I have not done this entry yet. I have been busy with the holidays and my wife just graduated from ASU. I am back now and should be getting back to a more regular schedule. So I have touched on the first 4 days of training and it was a five day class. The last day of class was very...


December 10, 2008  10:26 PM

Sybase Training Day 4



Posted by: Colin Smith
Database, Sybase

Day 4 of training was really all about backup and restore. This was a good class and I learned a lot about why my company does some of the things that they do. I knew how to do a Database dump and a Database load, but I did learn a lot and found a couple things to be very...


December 10, 2008  10:12 PM

Sybase 15 Upgrade Project



Posted by: Colin Smith
Database, Sybase

My company is in the process of testing Sybase 15 with one of our homegrown apps. Since I am the new guy on the DBA team this project got dumped on me. This is OK by me since I think it is a great opportunity to learn some new things and I have. Anyway, I went through and found out everything...


December 10, 2008  12:16 AM

Sybase Training Day 3



Posted by: Colin Smith
Database, Sybase

In 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

Sybase Training Day 2



Posted by: Colin Smith
Sybase

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


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: