Database Administrator Tools
DBA Scripts - Shell - SQL Scripts
Mar 11, 2008
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.
Export 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.
Unix Shell and Awk Scripts
A 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 Interest
Stop 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 Old Comics, Comic Books For Sale NostalgiaZone Comic Store
St Paul Audbon Society - birding birders bird watching
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
More links
|
Database, Systems and Software Articles
Latest Articles
New! August 25, 2008
Bike Lockers Unusable for Bicycle Parking an Exercise in Transit Usability for Metro Transit Mineapolis - St. Paul
NexTrip Satellite GPS Useless for Transit Usability for Metro Transit Mineapolis - St. Paul
Bike Training and Transit Usability.
Increased Costs of Fuel Affects Transit Usability.
Bicycle Prices, Usability and Commuting.
New! April 2, 2008
- List of articles on Voting, election manipulation,vote fixing, election fraud.
- How to Manipulate the Minnesota Optical Scan Voting and Pass a Postelection Audit With ES&S Scanners, Did It Already Happen?
- A list of transit usability articles All the transit articles in a single list.
Government Systems and Data
- Hennepin County: Public Vote Test Reveals Vulnerabilities and Point to State Wide Voting Manipulation Risks.
Ramsey County Elections Public Test of Vote System Fails, Does Not Test Final Vote Count
How to: Election Fixing and Vote Fraud, Part 1, Motivation and actors.
How to: Election Fixing and Vote Fraud, Part 2, Targets and Methods
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.
MNDOT Funds Junk Science Studies on how to manipulate Environmental Impact Statementes ( EIS )
DBA - Database Management
O'Reilly Onlamp Database Tuning
Database Management: Quick Dirty DB Tuning performance 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, PeopleSoft
ERP SAP Baan PeopleSoft, Oracle: administration, implementation, analysis, testing, and scripts
Architecture & Database Design Articles
Use 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 Articles
WEBTV, 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.
Transportation Systems and Transit Usability
Check the List of Transit Articles:
- Complete list of transit usability and transportation systems articles.
Database Project Management Articles
New! Feb 29, 2008
Managing Software Vendors, Software Engineering Still Happens
Outsource IT services, great for CIO
How to Choose ERP Contractors
Capability Maturity Model
Project Planning Tips
Basic Software Engineering
Managing short term consultants.
Where is the Hollywood Agent?
|