410 reputation
28
bio website
location Oklahoma
age
visits member for 3 years
seen 2 days ago

Sybase 4.9.2 up through 12.5. SQL Server since 6.5; now SQL 2005, 2008, and 2008 R2. Most recently maintaining databases in e-commerce, oil and gas.


Jul
15
awarded  Yearling
Feb
28
comment Security for Oracle linked server from SQL Server
Its is possible. I am able SELECT from my SQL 2005 server to my Oracle server while mapping a local SQL 2005 login to a remote Oracle login without issue. I assume that you can successfully connect from your SQL 2005 server to your Oracle server via Oracle Net Manager?
Oct
22
comment Sql Server 2008 x64 ODBC Linked Server to Oracle Not Working
Is the "Allow Inprocess" box checked in the OraOLEDB.Oracle provider on the SQL Server?
Aug
7
awarded  Popular Question
Apr
8
comment What must I already know to get profound knowledge in Oracle
As of this past December, Oracle certification (associate dba/dba) required attending the first and second Oracle admin classes (around $3500 each). I recently have had to take on oracle (we purchased an app that only runs on it) and have had more issues to date with the utilities assoicated with it. I read the oracle docs and then subscribe to safari.com for a different perspective.
Oct
12
comment Restoring Oracle prod backup to test server with new database name
Yes, the respective paths for aatest and aaprod are identical.
Oct
11
comment Restoring Oracle prod backup to test server with new database name
No RMAN is involved so far. This is a manual process for the data, control, etc.
Oct
10
comment Restoring Oracle prod backup to test server with new database name
My bad, it is Windows.
Oct
10
asked Restoring Oracle prod backup to test server with new database name
Jul
15
awarded  Yearling
Jul
11
answered Safely moving and creating new tempdb files
Jun
8
awarded  Caucus
May
14
comment Why can the SA account no longer access the master database?
Anyone have a read on where the connection string is stored? If the connection is made by hitting a webserver, it might be stored there. If there is a separate application server, perhaps there. I've even seen vendors store their connection information in the registry of the database server (with the password in clear text!)
May
14
comment Why can the SA account no longer access the master database?
Maybe watching the app connect while running Profiler will get you closer to where you want to be.
May
14
comment Why can the SA account no longer access the master database?
Presumably this application requires connection string information that is used to make a database connection. Based upon what I am reading I'm not seeing how the same connection string is being used for all of the database connections the application makes.
May
14
comment Why can the SA account no longer access the master database?
What are the specific sa account permissions you are seeing? "Error state 16" - what error code are you seeing?
Apr
11
comment Is there any benefit to having one sql server login for multiple users?
I have seen a lot of this in my experience and I do not recommend it. Consider sp_who2 output with numerous 'generic-sql-login' connections appearing. What happens if there is an issue and a need to id a specific developer? Generic logins are of no use.
Mar
27
comment How to recover SA account password without restoring it?
Concur with HLGEM (and +1).
Mar
27
comment Recommendations on creating user-objects on system database
I've seen it both ways. I think user objects in master are prone to be forgotten, whereas a DBA database that contains those objects you use to enable you to do your job is more self-documenting.
Mar
24
comment What is the signifigance of a fillfactor of 20?
I'm willing to bet someone was confused and was wanting to specify 80% full.