May 28, 2010 8:00 PM
Posted by: Colin Smith
DBA,
OracleI work in an environment that does use Sybase, Oracle, and SQL Server as the main RDBMS's. All of our Sybase and Oracle are running in Solaris Unix and or Linux. I just found out that I am about to have the opportunity to install and configure Oracle on a Windows Server 2003 R2 box. I am looking...
May 28, 2010 6:16 PM
Posted by: Colin Smith
DBA,
Powershell,
RecoveryIn my environment we have a few instances where the customer would like to have a refresh done from Production to a test server. This is good for me since it gives me a chance to test my backups and make sure that they are good. It is good for the developers because then they are working witht the...
May 27, 2010 10:00 AM
Posted by: Colin Smith
DBA,
Monitoring,
PowershellA while back, about a year ago, I wrote some custom scripts to monitor all of our SQL Server instances for errors. I have a driver file that has all the information that the script needs in order to find errors on the SQL Servers and it just walks thru them and checks for any errors that I might...
May 26, 2010 7:00 AM
Posted by: Colin Smith
AD,
Administration,
DBA,
Powershell,
ReportingJust like I needed to get a count of unique logins to an application on one of our Sybase instances I also needed to get these values for a few of our SQL Servers. Since SQL Server uses mixed mode authentication and we are using AD groups to aid in the security of the SQL Server, I could not just...
May 25, 2010 5:00 PM
Posted by: Colin Smith
DBA,
Stored Procedures,
SybaseA while back I wrote a post about how I took a system stored Proc called SP_WHO and I modified it to only give me results for a certian subset of logins to the Sybase server. I let it run once an hour every hour for two weeks and then presented the numbers to my boss. He was very pleased that I was...
May 25, 2010 2:38 PM
Posted by: Colin Smith
DBA,
Education,
SSAS,
TrainingI recently attended a deep dive bootcamp course in SQL Server Analysis Services. The class was geered more towards developers but it gave me a better understanding of what a cube is and how it works. The part that I was most interested in was the security portion and the 2008 version gives us a lot...
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
