April 29, 2010 9:32 PM
Posted by: Colin Smith
Administration,
DDL,
DDLGEN,
SybaseI completed an upgrade from Sybase 12.5 to Sybase 15.0 recently and I found that it ended up breaking some scripts that we use to generate ddl for all instance devices and all create databases. The scripts that we were using were writting log ago by people that are no longer working for the...
April 5, 2010 8:06 PM
Posted by: Colin Smith
Communication,
Planning,
Sybase,
UpgradeSo last week was our big go live of Sybase 15 in a production environment. Wow it did not go as smooth as I had hoped. 24 hours of College Basketball, 24 Hours of PASS, and perhaps 24 hours of some other things are pretty cool and fun, but 24 hours of Sybase was not. Now do not get me wrong, we had...
March 30, 2010 3:02 AM
Posted by: Colin Smith
Co-Workers,
DBA,
Politics,
Sybase,
Sybase 15,
UpgradeI have been working on a upgrade for one of our production systems from Sybase 12.5 to Sybase 15 for some time now. I, and my team, have done all the work from a DBA perspective to make sure that we are good to go for the upgrade. We have a system ready for testing and have provided connectivity...
March 12, 2010 5:28 PM
Posted by: Colin Smith
DBA,
MS SQL Server,
PASS,
SQL SaturdayLike I said in my last post, I attended my first users group and it was announced that a SQL Saturday is in the early planning stages. I am excited about this and since I am so excited I contacted Samson Loo, who is the one that made the anouncement, to see if I could help and also if I could post...
March 11, 2010 10:30 AM
Posted by: Colin Smith
DBA,
Education,
Free,
SQL Server,
TrainingLast week I came into work 2 hours early so I could be a part of a free all day training event. I am very glad that I did , but do not worry if you did not see it live. Since it was all web based you can get all the good content at your own pace. Check it out at
February 23, 2010 9:46 PM
Posted by: Colin Smith
corruption,
DBA,
DR,
On-Call,
Planning,
SQL AdministrationJust the other morning at 3:00 AM I get a page, Love being on call, and I see some errors about MSDB. Well this concerns me but it is 3:00 AM and my head is not really on straight. I doze back to sleep, in ten more minutes I get two pages, This time I get errors about MSDB again and I also get...
September 23, 2009 4:52 PM
Posted by: Colin Smith
Dataguard,
DBA,
DR,
Oracle,
Oracle Administration,
Standby DatabaseI had to bring down the standby server for the power outage in our DR location a few nights agon. No big deal, shut off replication from the primary, go to the standby and do a shutdown imediate, since you can not do a shutdown on the standby server. When things cam up I go to the secondary and do...
September 22, 2009 4:55 PM
Posted by: Colin Smith
DR,
Sybase,
Sybase AdministrationMonday morning my company was putting in a new UPS at our DR facility. This is great but it means that all database instances that are running at that location are coming down as power to the entire site was down for 2 hours. No big deal right, I got a list of the instances and shut them all down...
July 30, 2009 3:17 PM
Posted by: Colin Smith
Database Administration,
DBA,
Groups,
Powershell,
Roles,
SQL ServerIn SQL Server 2005 the Builtin Administrators group is a login, by default, to your MSSQL Server Instance and is also a member of the sysadmin role. Well this has been changed in SQL Server 2008 with good reason. I decided that I would like to add a group for my DBA Group to every SQL Server in...
