The Multifunctioning DBA:

Database


July 30, 2010  10:00 AM

Backup and Restore



Posted by: Colin Smith
DBA, Recovery, Restore

I am fighting a battle right now of whether or not I, the DBA, or the backup team at my company should be in charge of backups and restores of the SQL Server Databases in the company. We use Netbackup with a SQL Agent to back up the databases and I am still not sure that I am a huge fan of that. I...

July 27, 2010  8:36 PM

IT Audit



Posted by: Colin Smith
Audit, DBA, Roles

Recently my company went through an internal audit of our financial systems. First let me say that I am proud because we did well and do not have many issues to resolve, and no issues on the Database Side. Any way I also want to point out that the auditors are not IT people. They are accountants...


May 29, 2010  8:12 PM

Oracle OEM



Posted by: Colin Smith
DBA, Oracle

Today 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 28, 2010  8:00 PM

Oracle on Windows



Posted by: Colin Smith
DBA, Oracle

I 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

Database Restores



Posted by: Colin Smith
DBA, Powershell, Recovery

In 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

Powershell Gui



Posted by: Colin Smith
DBA, Monitoring, Powershell

A 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

Powershell to get unique login count from SQL Server



Posted by: Colin Smith
AD, Administration, DBA, Powershell, Reporting

Just 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

Sybase SP_Who modified



Posted by: Colin Smith
DBA, Stored Procedures, Sybase

A 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

SSAS Class



Posted by: Colin Smith
DBA, Education, SSAS, Training

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


May 12, 2010  5:00 PM

Modify sp_who in Sybase



Posted by: Colin Smith
Sybase

After the Sybase upgrade, my boss needed to know how many users we have connecting to a specific database using a specific application. In order to accomplish this I extracted sp_who and modified it to gather the information that I needed. I also did not overwrite the original sp_who but I had it...


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: