vanderhouwen.com
User Groups | VanderHouwen & Associates | Staffing for Portland, Oregon | Seattle, Washington and the Pacific Northwest
http://www.vanderhouwen.com/user-groups
VanderHouwen and Associates, Inc. Below are links to many user groups in the Oregon/Washington vicinity. These groups are excellent venues for networking, meeting like minds, and increasing your career skills and knowledge. NET Developers Association (Washington). Adobe InDesign User Group (Portland). Agile Project Leadership Network. Association for Training and Development. Association for Women in Computing - Puget Sound. Computer-Human Interaction Forum of Oregon. Data Administration Management Assoc.
dbrat.blogspot.com
Adventures In DBAsitting: OMG What Do I Do? - "The database is slow!" - Part II
http://dbrat.blogspot.com/2011/03/omg-what-do-i-do-database-is-slow-part.html
OMG What Do I Do? The database is slow! Okay, when we last left our heroine, she was bravely dodging the arrows of slow databasity. Well, here's the thing. When someone says their database is slow, what does this mean? I don't mean what's causing it, I mean what is the client really trying to say? Me: "Oh my god! It's just. creeping! Sr DBA DE: "Hmm. When did this start? As he types on something completely unrelated in the background.). Me: "Um, when? Me: Trying not to have the panic show in my voice, I ...
dbrat.blogspot.com
Adventures In DBAsitting: June 2012
http://dbrat.blogspot.com/2012_06_01_archive.html
What-What © Duplicate Clone using RMAN. Seriously, a duplicate clone using RMAN is about the most fun anyone can do with a database. why? Because it's EASY. It WORKS. It never ever goes WRONG. So here's what to do. step by step. Refreshing a test database from a production database using RMAN duplicate (UNIX SYSTEM). Verify Server name Database name and Database version on both production and test sides. Check mount point of TARGET (PRODUCTION) and AUXILIARY (DEV/TEST) databases. Instance name @ hostname.
dbrat.blogspot.com
Adventures In DBAsitting: REFRESHING A DATABASE
http://dbrat.blogspot.com/2011/07/refreshing-database.html
No, this is not about how cool and refreshing a database can be, although I certainly do think they can be. This is like one of the most important things a database administrator can do, and just like everything else we do in our jobs there are like 10 DIFFERENT WAYS TO DO IT! So, first way to refresh and the easiest, I swear, is doing a duplicate from a cold backup. OMG, you say, I can't bring my production database down for ANY amount of time, love, nor money! Whatever shall I do! A little background&#...
dbrat.blogspot.com
Adventures In DBAsitting: How Do I Do That? - Installing a pks, pkb file
http://dbrat.blogspot.com/2011/03/how-do-i-do-that-installing-pks-pkb.html
How Do I Do That? Installing a pks, pkb file. S" before "B" when using the "P". Just when I was feeling a little more secure in tidbits of knowledge, I got a request from a client today. Please run a simple SQL statement in Production. Okay", I thought, "Here goes! Then I got another request two minutes later. Please run these two attachments. Attachments: ThingOne.pkb; ThingOne.pks]. What was I supposed to DO with them? Was I supposed to RUN them? Was I supposed to import them into a schema? Sr DBA R sh...
dbrat.blogspot.com
Adventures In DBAsitting: July 2011
http://dbrat.blogspot.com/2011_07_01_archive.html
OMG What Do I Do? The database is slow! So, the last time I wrote an epic adventure about my databasing, it was like, three months ago. I've learned a LOT in the last three months. More vi practicing, how to refresh a database, how to do datapump imports and exports, moving lobs. in fact I am going to move a lob today! Four of them in fact! I'll post about that later. What I really wanted to discuss quickly was how the smallest of changes can really F*& up how a database coughs up information to users.
dbrat.blogspot.com
Adventures In DBAsitting: PANIC TIME or OMG HE'S LEAVING IN 7 DAYS!!
http://dbrat.blogspot.com/2011/04/panic-time-or-omg-hes-leaving-in-7-days.html
PANIC TIME or OMG HE'S LEAVING IN 7 DAYS! So I have seven days. What do we do? Imports/Exports. Tuning. Partition maintenance. Architecture advice. Moving databases. Working with upgrades. Running scripts in Production. Reports. And this is just the stuff I know about. I'm sure it will be JUST FINE. In the meantime, I'm getting over a horrible cold and swigging down Sarah Silverman orange Cold/Flu relief cough syrup. Subscribe to: Post Comments (Atom). PANIC TIME or OMG HES LEAVING IN 7 DAYS!
dbrat.blogspot.com
Adventures In DBAsitting: March 2011
http://dbrat.blogspot.com/2011_03_01_archive.html
How Do I Do That? Installing a pks, pkb file. S" before "B" when using the "P". Just when I was feeling a little more secure in tidbits of knowledge, I got a request from a client today. Please run a simple SQL statement in Production. Okay", I thought, "Here goes! Then I got another request two minutes later. Please run these two attachments. Attachments: ThingOne.pkb; ThingOne.pks]. What was I supposed to DO with them? Was I supposed to RUN them? Was I supposed to import them into a schema? Sr DBA R sh...
dbrat.blogspot.com
Adventures In DBAsitting: What-What © Duplicate Clone using RMAN
http://dbrat.blogspot.com/2012/06/what-what-duplicate-clone-using-rman.html
What-What © Duplicate Clone using RMAN. Seriously, a duplicate clone using RMAN is about the most fun anyone can do with a database. why? Because it's EASY. It WORKS. It never ever goes WRONG. So here's what to do. step by step. Refreshing a test database from a production database using RMAN duplicate (UNIX SYSTEM). Verify Server name Database name and Database version on both production and test sides. Check mount point of TARGET (PRODUCTION) and AUXILIARY (DEV/TEST) databases. Instance name @ hostname.
dbrat.blogspot.com
Adventures In DBAsitting: April 2011
http://dbrat.blogspot.com/2011_04_01_archive.html
PANIC TIME or OMG HE'S LEAVING IN 7 DAYS! So I have seven days. What do we do? Imports/Exports. Tuning. Partition maintenance. Architecture advice. Moving databases. Working with upgrades. Running scripts in Production. Reports. And this is just the stuff I know about. I'm sure it will be JUST FINE. In the meantime, I'm getting over a horrible cold and swigging down Sarah Silverman orange Cold/Flu relief cough syrup. Subscribe to: Posts (Atom). PANIC TIME or OMG HES LEAVING IN 7 DAYS! The Tom Kyte Blog.
