|Database Administration:||Tuesday, 26-Jul-2016 11:00:44 CDT|
Database Administrator Tools
DBA Scripts - Shell - SQL ScriptsExport and import compressed files in Oracle.
Extract DDL SQL from Oracle export script
Oracle8.0.5 SQL to create instance
Oracle SQL to check DDL change time
Wrap sqlplus with ksh.
SQL Database examples for relational algebra.
Shell script to find missing file references in tags.
ColdFusion SQL string in cfquery tag single quote problem and workaround.
Perl scripts to extract rows or columns from many Excel spreadsheets.
Security check for Oracle default user passwords
Script to Convert Oracle, Informix schemas to other RDBMS.
Oracle rman to Veritas backup and recover 8.1
How To: Export from Access Database No mouse clicks!
SQL script using Oracle date functions to create a time dimension.
Index attribute order and cardinality Oracle script.
Oracle script to find bad index design
Informix or Oracle referential constraint graph in SQL/AWK/shell
Informix SPL converts datetime to Visual Basic integers.
Match Informix session to Baan bshell
Oracle/Baan, match database session to Baan bshell.
Unix Shell and Awk ScriptsA ksh - awk script search cgi Shell can do anything, even CGI.
Unix Statistical Spam Filter Works
(with the spamfilter script, now with self updating whitelist)
Shell script to restart Baan license server
Unix script to find processes over time limit.
Other Topics of InterestStop Ayd Mill Road Freeway
Backup site to Stop Ayd Mill Road Freeway because of MNDOT harassment
MPLS Minneapolis School Board Election 2006-Candy, Soda Pop In Elementary Schools.
MPLS Minneapolis School Board elections 2004
David Jennings Minneapolis School Superintendent Destroys Schools
Comics store, buy back issue comic books for sale
Comics for sale online. Comic shop, buy comic books for sale
Used Books for sale online. Buy Books for sale
Used Books for sale online on facebook. Buy Books for sale
Used books for sale online. Buy used books for sale
Used books for sale online, buy used books for sale
Friends of the Parks, St Paul, Ramsey County. Give a Tree to your park. Donate Memorial Tribute Trees
Database Administration and SQL scripts
Database Administration and SQL scripts
Latin scientific plant name pronunciation guide
Database, Systems and Software Articles
Latest ArticlesNew MNsure.org Articles Mar 31, 2014
MNsure Enrollment Lags Compared To Successful State Exchanges.
MNsure User Interface Fixes to Up Enrollment.
MNsure PR Propaganda Misdirection.
MNsure Redsigned to use Prescreening.
Media ignores MNSure story: People reject for profit insurance for single payer plans.
MNSure.org Bait and Switch and 1 In 5 Stuck In System. Updated March 9, 2014.
MNSure.org Security Problems.
MNSure.org, Poor Web Site Performance, Lags Compared To Other States.
DBA - Database ManagementDatabase Management: Quick Dirty DB Tuning performance tuning.
O'Reilly Onlamp Database Tuning
Database Management: RDBMS optimizer and performance
Database Management: Performance and Data Loading
Baan index performance, oxymoron!
Database tools: OLTP Reports Cheap, quick, database report tool.
Database Management: Metadata Why it is needed.
ERP Administration: SAP, Baan, PeopleSoftERP SAP Baan PeopleSoft, Oracle: administration, implementation, analysis, testing, and scripts
Architecture & Database Design ArticlesUse Case for Database Design Modeling Includes DDL implemented in Postgresql
Web Portals are bogus projects
Design Reference Books
National Security Analyzed
Distributed Systems and Terror
Design for database administration.
Design for system administration.
Use software packages correctly.
Nasdaq failure shows WorldCom problem
Internet ArticlesWEBTV, World's worst user interface?
Simple Web Design
Another look at Nielsen and Web Design.
Nostalgia Zone Web Design III
Nielsen - Norman web design of Nostalgiazone.com
FCC, Patents and DMCA Crush New Economy
My telephone answering machine sucks, what to do about it. Less is more usable.
Unix Spam Filter revisited after a year of use.
Government Systems and Data- List of articles on Voting, election manipulation,vote fixing, election fraud.
Minnesota's Big Brother CriMNet Database Audit Program audit papers over problems.
Minnesota's Big Brother CriMNet Database Public data in private paramilitary control is dangerous.
Minnesota's CriMNet Connected GangNet Database Theft, Thugs, Money, Drugs, Biggest Gang is Sherrif Fletcher's.
MNDOT Funds Junk Science Studies on how to manipulate Environmental Impact Statementes ( EIS )
Why All Nuke Plants Will Explode.
Why earthquakes in Haiti and Japan killed so many people
Transportation Systems and Transit UsabilityList of Transit Articles:
- Transit usability and transportation systems articles.
Database Project Management and Software Engineering ArticlesManaging Software Vendors, Software Engineering, Project Management
All articles © Steven Hauser
This page is about the practical application of imperfect software in a real world. ERP (Enterprise Resource Planning) applications like Baan, SAP, Peoplesoft, and other packages that run on RDBMS (Relational Database Management Systems) are examined from the point of view of a DBA (database administrator.) It is also about SQL scripting and database administration, Informix, Oracle, DB2 and Postgresql are the products I prefer.