May 29, 2010 8:12 PM
Posted by: Colin Smith
DBA,
OracleToday I needed to log into a Oracle instance using OEM to look at some users and roles. I found that when attempting to log into the instance with the sys username and password and as sysdba I was getting insuffcient privledges. Well I immediatley logged into the host machine and I was able to...
May 29, 2010 7:00 AM
Posted by: Colin Smith
AndroidSo I have had my HTC Hero from Sprint since the day it was released and I love it. It is a great phone and the Andriod OS is great and HTC did a good job adding some features. My biggest complaint has been that Sprint would not allow the phone to be updated to newer versions of the OS. Well a...
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 5:00 PM
Posted by: Colin Smith
testingNot long ago I decided to purchase a Technet Subscription from MS. This is one of the best things that I ever did. I get pretty much unlimited access to all MS products and I get to try them all out. I do not get to use the products in production of course, but for learning this is the best. I use...
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...
