DataDisk
only search DataDisk

Previous Document Updates

Date
Document
Change Type
Category
Notes
25/05/2012
New
MySQL
In this section I cover privileges and privilege levels, securing at the operating system level, data securing and encrypting MySQL connections to the database
25/05/2012
New
MySQL
A section on how to use Explain to optimize SQL queries
18/05/2012
New
MySQL
I cover benchmarking and profiling using utilities such as benchmark, mysqlslap, sysbench, mysqltuner, mysqlreport, mk-query-profiler and mysqldumpslow
04/05/2012
New
MySQL
How to configure the various replication configurations, master/slave, master/multi-slave, master/relay, master/master and circular
03/05/2012
New
MySQL
I discuss horizontal, vertical, range, list, hash and key partitioning, i also have a section on merge tables
02/05/2012
New
MySQL
I Discuss what makes up a user account, access control lists, how to reset the root password and debugging user account problems.
29/04/2012
New
MySQL
I cover backing up and recovery in this section using tools like mysqldump, select into outfile, mk-parallel-backup, snapshotting, mysqlhotcopy. I also explain how to perform point-in-time recovery using mysqlbinlog.
27/04/2012
New
MySQL
This section covers caching within the MySQL server, how to enable, tune and monitor it
26/04/2012
New
MySQL
A section on tuning the MySQL during the build phase
20/04/2012
New
MySQL
I cover how transactions work within MySQL and the isolation levels, I also look at locking and deadlocks.
28/03/2012
New
MySQL
A brief section on MySQL views, creating , altering and dropping
22/03/2012
New
MySQL
I explain how to use triggers, stored procedures, stored functions and events
19/03/2012
New
MySQL
I cover the different index types that MySQL uses, and explain why we use indexes
13/03/2012
New
MySQL
I explain the various data types and creating tables, I also discuss how to optimize the table and a number of maintenance tasks regarding tables
29/02/2012
New
MySQL
I cover the MySQL deviations and extensions from the standard SQL
21/02/2012
New
MySQL
This is a introduction into MySQL covering the storage engines and how to access MySQL
12/11/2011
New
Oracle
A cheatsheet for Data Guard, covering the common area's and commands used.
12/11/2011
New
Oracle
Lastly in the Data Guard series a troubleshooting guide regarding common problems with Data Guard.
08/11/2011
New
Oracle
A small section covering Data Guard related backups and recovery using RMAN.
07/11/2011
New
Oracle
I show you what methods can be used to failover clients and applications using Transparent Application Failover (TAF), also how to use system events to call failover scripts.
03/11/2011
New
Oracle
I discuss physical standby read-only database, snapshot standby databases, Real Application Testing (RAT) and Active Data Guard.
31/10/2011
New
Oracle
This section covers switchover and failover concepts, flashback and Data Guard, Performing switchover and failover's, the old primary standby, automatic failover (FSFO).
14/10/2011
New
Oracle
I show how to monitor the apply rate, redo applied, transport and apply lag, and show you scripts that you can use to monitor DG, I also show you the data guard utility menu.
06/10/2011
New
Oracle
I cover in detail the SQL Apply process on how it works, monitoring, tuning and troubleshooting and how to create a logical standby database from a physical standby database.
01/10/2011
New
Oracle
I discuss what is involved regarding redo and the components of a physical standby database, i then discuss tools and views for monitoring redo including how to configure statspack , lastly I cover corruption.
14/09/2011
New
Oracle
I introduce you to the broker, what it is and how to configure and use it.
14/09/2011
New
Oracle
I create my first physical standby database using RMAN
14/09/2011
New
Oracle
I show how to setup a Data Guard Virtual Machine environment using VMWare, I create a primary database, physical standby database, logical standby database and a Enterprise Manager/Grid Control server.
24/06/2011
New
Oracle
A brief introduction into Oracle Data Guard, covering the architecture, apply services, protection modes, switchover/failover and management
14/04/2011
New
Virtualization
I cover advanced configuration tools such as Host profiles, vCLI and PowerCLI
13/04/2011
New
Virtualization
I discuss how to install VMware Update Manager (VUM), create baselines and baseline groups, how to scan datacenters, clusters and VM and finally how to stage and apply patches to ESXi servers and VM's
12/04/2011
New
Virtualization
Requirements on how to get FT running, enabling, configuration and testing
11/04/2011
New
Virtualization
A brief section on configuring, testing and monitoring VMware's HA
11/04/2011
new
Virtualization
Configuring, testing and configuring ILO/RAC/IMM/DRAC cards for DPM are all covered
08/04/2011
New
Virtualization
Covering DRS configuration, testing and DRS options and viewing faults and previous history
08/04/2011
New
Virtualization
Covering vMotion, storage vMotion and Cold migration
07/04/2011
New
Virtualization
I cover vCPU and memory, performance charts, alarms and events, resource management and resource pools
07/04/2011
New
Virtualization
Very brief discussion on VMware security, covering roles, user and datastore access
04/04/2011
New
Virtualization
I have added a brief section onto my virtual machine section covering cloning to template, convert to template and Cloning, I also cover the new exporting to OVF format
01/04/2011
New
Virtualization
I cover creating a virtual machine and how to administer it, installing the guest OS and VMware tools, snapshotting and lastly P2V conversions.
30/03/2011
New
Virtualization
I cover controllers, local, SAN and iSCSI storage, VWare File System (VMFS) and Viewing storage via vCenter and vSphere client
26/03/2011
New
Virtualization
I cover standard and distributed networking (vSwitches, DvSwitches and Port Groups)
24-03-2011
New
Virtualization
Brief section on how to install ESXi server, vSphere client and vCenter
24-03-2011
New
Virtualization
I have setup my own test environment so that I can test and play around with many of the VMware features.
24-03-2011
New
Virtualization
I have been working on a VMware ESXi server project, so this was a good opportunity to create web section on the VMware ESXi server and VMware features (vMotion, DRS, HA, DPM, etc)
12-01-2011
New
Unix
I have had the chance to play around with Red Hats multipathing using a IBM XIV SAN, also configured it use a DR SAN.
13-12-2010
New
SAN
Network Interfaces, Routing, Hosts and DNS, VLANs, Interface Groups, Diagnostic Tools
10-12-2010
New
SAN
NetApp file access covering NFS, CIFS, FTP and HTTP
08-12-2010
New
SAN
NetApp block access covering iSCSI, FC, LUN's , iGroups, LUN Mapping, Snapshots and Cloning
08-09-2010
New
SAN
Quick and dirty NetApp cheatsheet, this will be updated frequently
07-09-2010
New
SAN
This is a very heavy section which covers: storage, disks, aggregates, flexvolumes, traditional volumes, flexcache volumes, flexclone volumes, qtrees, quotas and more
27-08-2010
New
SAN
NetApp architecture discussing Hardware, software, SAN terminology, NetApp terminology
27-08-2010
New
SAN
Short Introduction to NetApp
22-07-2010
New
Unix
AIX Logical Volume Manager cheat sheet
21-07-2010
update
Unix
Obtained a IBM 9114-275 so updated my Unix cheat sheet guide with common AIX commands
15-07-2010
New
Unix
Working on some DL380 servers needed to know how to re-enable failed disks, etc
05-07-2010
update
Unix
Added Debian to my Unix command cheat sheet guide
13-04-2010
New
MaxDB
diagnostic files locations, X_CONS and Xinstinfo
13-04-2010
New
MaxDB
Indexes, optimizer, caches and analysis tools (database analyzer, resource and command monitor, EXPLAIN statement)
10-04-2010
New
MaxDB
Installation, Configuration, Backups, Recovery, snapshots and consistency checks
24-03-2010
New
MaxDB
Short section on the interaction between SAP and MaxDB
23-03-2010
New
Oracle
A quick and dirty Oracle RAC cheat sheet
23-03-2010
New
Oracle
Adding and removing nodes from a RAC cluster
20-03-2010
New
Oracle
Performance issues, node eviction, debugging CRS and GRD, general troubleshooting
18-03-2010
New
Oracle
Introduction, Ping, Past Images (PIs), Cache Fusion I and II, cache fusion in operation
17-03-2010
New
Oracle
cache coherency, resources and enqueues, GES, Global locks, Messaging and GCS
10-03-2010
New
Oracle
Workload partitioning, wait events, enqueues, AWR and cluster interconnect are all discussed
04-03-2010
New
Oracle
Details on backup basics, instance recovery, crash recovery and cache fusion
26-02-2010
New
Oracle
Basic administration of Instances, nodes, CRS, OCR, services
18-02-2010
New
Oracle
RAC Installation using ISCSI and Oracle Enterprise Linux
18-02-2010
New
Oracle
RAC architecture, introduction, components, clusterware, kernel components and processes
12-02-2010
New
Solaris
A quick and dirty cheat sheet on Solaris ZFS
11-02-2010
New
Oracle
This is a introduction about HA, Clustering and the original RAC - Oracle Parallel Server
09-02-2010
update
Unix
I have create a simple LVM cheat sheet to compliment my other LVM task sheet
06-02-2010
New
MaxDB
I cover a lot of material here, architecture, livecache, parameters, users, dba tools
06-02-2010
New
MaxDB
An introduction to the SAP MaxDB database
21-01-2010
Updated
Cluster
I have combined the 3.1 and 3.2 version common tasks into one document
20-01-2010
Updated
Cluster
I have updated my existing Sun Cluster cheat sheet to contain both versions 3.1 and 3.2
10-01-2010
New
Cluster
How to setup a Sun Cluster 3.2 on a laptop using VMWare
10-01-2010
New
Cluster
Introduction to Sun Cluster 3.2
10-09-2009
New
EJB 3
Identification, SOAP message, WSDL, JAX-WS
08-09-2009
New
EJB 3
I discuss a number of topics relating to migrating EJB 2 to EJB 3
02-09-2009
New
EJB 3
Entity Locking, JDBC layer, Database operations, Querying, Caching, Component performance, Clustering
22-08-2009
New
EJB 3
Design Patterns (Presentation, Persistence and Application), Session beans and helper classes
14-08-2009
New
EJB 3
Application Packaging, Class Loading, Deployment descriptors v Annotations
12-08-2009
New
EJB 3
Query API, JPQL, Native SQL queries
05-08-2009
New
EJB 3
EntityManager introduction, entity lifecycle, entitymanager instances, managing persistence operations, lifecycle listeners, best practices
24-07-2009
New
EJB 3
Impedance mismatch, Mapping objects, mapping entities, secondary tables, primary keys, mapping entities relationships, mapping inheritance
17-07-2009
New
EJB 3
Domain Models, Entity Relationships, Entity Annotations
09-07-2009
New
EJB 3
EJB Transactions, Container-Managed and Bean-Managed Transactions, EJB Security
02-07-2009
New
EJB 3
EJB Internals, Dependency Injection and JNDI, Interceptors, Timer Services
24-06-2009
New
EJB 3
Messaging concepts, JMS, MDB annotations, lifecycle and best practices
18-06-2009
New
EJB 3
Session bean anatomy, lifecycles, stateless, stateful, differences between stateless and stateful, performance impact
11-06-2009
New
EJB 3
Basic introduction into EJB 3 with code examples of the three types of beans: Session, MDB and Entity
06-06-2009
New
JSP
Basic Patterns and an introduction to Struts 1
05-06-2009
New
EJB 3
EJB Overview, EJB Types, Inside EJBs, Unit Testing
05-06-2009
New
EJB 3
Discuss EJB (Session, MDBs and Entities), Persistence, Transactions, Security, etc
24-05-2009
New
JSP
Filters, Request Filters, Response filters/wrappers
23-05-2009
New
JSP
Authentication, Authorization, Data Confidentiality and Integrity
22-05-2009
New
JSP
Deployment, WAR files, Welcome and Error pages, Mime Mapping
20-05-2009
New
JBoss
Running Multiple Instances, Unwanted Services, JSP Compilation
19-05-2009
New
JBoss
Hardware, JVM and JBoss tuning
17-05-2009
New
JSP
Tag Files, Simple Tags, Classic Tags, Body Tags, Tag working together, Simple and Classic Key Differences
15-05-2009
New
JSP
Discuss the JSP Standard Tag Library, (if, forEach, choose, remove, set, import, url, catch, etc), customer tags library
13-05-2009
New
JBoss
HTTP load balancing, HTTP session replication, cluster session EJBs, clustering entities, clustering JNDI
12-05-2009
New
JBoss
Clustering technology, load balancing, setting up a cluster, JBoss cluster architecture and JBoss cache.
07-05-2009
New
JBoss
Developing Web Services, Bottom-up/Top-down approaches, JBoss Annotations, Securing Web Services, Encrypting a SOAP Message
04-05-2009
New
JSP
Bean Attributes, Standard Actions, Expression Language (EL), EL Functions, JSP Include
30-04-2009
New
JBoss
JMS, Message-Driven Bean (MDB), Message-Driven POJO, JBoss Messaging
28-04-2009
New
JBoss
Session beans, Hibernate, EJB configuration, EJB Containers, Entity Persistence, JMX Service Objects, Transport Protocol, Securing EJB and EJB Comms
21-04-2009
New
JBoss
Authentication, Authorization and Encrypted Communications
19-04-2009
New
JSP
JSP variables, declaration, expressions, comments, Introduction to Expression Language (EL) and Actions
17-04-2009
New
JBoss
Deployment Descriptor files, Key files and directories, virtual hosts, HTTP and AJP Connectors, Valves
15-04-2009
New
JBoss
JBoss SX framework, Secure Communications, SSL-aware security domains, login modules
13-04-2009
New
JBoss
Understanding deployment, application packages, deployers, classloading, deploying miscellaneous applications, deploying a hibernate archive
05-04-2009
New
JBoss
Installation, Directory Structure, Server Configurations, Boot Sequence, Logging, System Properties
04-04-2009
New
JSP
Sessions, Cookies, URL Rewriting, HttpSession milestones, Listeners
03-04-2009
New
JBoss
An introduction to JBoss application server, the architecture, JMX, MBeans, Microcontainer
30-03-2009
New
Tomcat
Best practices, tomcat error messages, JVM tuning and Tomcat tuning
29-03-2009
New
JSP
Discuss ServletContext, Init parameters, attributes, SingleThreadModel
26-03-2009
New
Tomcat
Performance testing Tomcat using JMeter
26-03-2009
New
Tomcat
Discussing logging within Tomcat using log4j and JULI
25-03-2009
New
Tomcat
Tomcat Clustering, In-Memory, File-based and JDBC-based persistent managers
22-03-2009
New
Tomcat
Monitoring and Managing Tomcat with JMX also discuss MBeans and how to use Manager JMX proxy and JConsole.
21-03-2009
New
JSP
Servlets Life Cycle, HTTP Methods, Request and Response Objects
21-03-2009
New
JSP
A mini tutorial on MVC (Model View Controller)
19-03-2009
New
Tomcat
Virtual Hosts (IP-Based and Named-Based) and discussing tuning and security within virtual hosts.
18-03-2009
New
Tomcat
Tomcat security (securing JVM, Policy files, Realms, SSL, DefaultServlet, restricting hosts)
17-03-2009
New
Tomcat
Tomcat and JDBC connectivity
14-03-2009
New
JSP
Containers, URL mapping, MVC introduction and how JEE fits into this
13-03-2009
New
JSP
HTML, URL, CGI, Java Servlets and JSPs are discussed
13-03-2009
New
Tomcat
Tomcat and Apache interaction (AJP Connector, Tomcat Workers, SSL and Load Balancing)
12-03-2009
New
Tomcat
I discuss the HTTP Connectors and touch on performance Tuning the Connectors
10-03-2009
New
Tomcat
Java and Tomcats class loaders
09-03-2009
New
Tomcat
Using Tomcat's Administration Manager and how to use HTTP commands to manage Tomcat
05-03-2009
New
Tomcat
I discuss the Web application directory structure and describe how the web.xml file is configured
03-03-2009
New
Tomcat
I discuss some of the advanced features of Tomcat access logs, single sign-on, request filtering, persistent session management, JDBC, JNDI, JavaMail and Lifecycle listeners
26-02-2009
New
Tomcat
I explain what the main files in Tomcat do server.xml, context.xml, web.xml, tomcat-users.xml, catalina.properties and catalina.policy
25-02-2009
New
Tomcat
I explain how Tomcat works
25-02-2009
New
Tomcat
How to install the JVM and Tomcat, I also explain the APR, directory structure and troubleshooting tips
25-02-2009
new
Tomcat
A brief introduction to Tomcat Web applications
25-02-2009
New
Tomcat
A brief introduction to Tomcat
18-02-2009
New
Tomcat
A new guide on Tomcat/Apache 6
18-02-2009
New
JBoss
A new guide on JBoss AS 5
18-02-2009
New
JSP
A new guide on JSP, Servlets and Java Web Services
22-12-2008
New
Exim
Quick and dirty cheat sheet for Exim
18-12-2008
New
Exim
Step by step guide on how to decrypt the runtime configuration file.
10-12-2008
New
Exim
Log files, log formats, Exim utilities, Hints database
10-12-2008
New
Exim
using Exim's commandline option (testing, debugging, queue runner, daemon, etc)
09-12-2008
New
Exim
Touching on the smaller subjects in exim - security, privileged users, timestamps, pool space, SMTP banners
04-12-2008
New
Exim
Discussing how Exim's lists work (Domain, Hosts and Address)
03-12-2008
New
Exim
String operations, text substitution, conditional expansion, lookup expansion, extracting fields, testing string substitution
02-12-2008
New
Exim
Short introduction into Exim's lookup methods (lsearch, partial-lsearch)
02-12-2008
New
Exim
Discussing submission mode, header lines, Rewriting addresses
01-12-2008
New
Exim
How Exim verifies addresses
01-12-2008
New
Exim
Explaining how Exim's ACLs work
26-11-2008
New
Exim
Discussing messages checks locally and remotely and rate controls.
24-11-2008
New
Exim
Delivery errors, remote, local and the retry rules.
23-11-2008
New
Exim
Explain the processes that Exim uses, daemon, reception, queue runner and the delivery processes
20-11-2008
New
Exim
Discussing user, system and .forward file filters
19-11-2008
New
Exim
Discussing the transport types and options
18-11-2008
New
Exim
Discuss the generic transport options available to exim
14-11-2008
New
Website
This a complete copy of my website that you can download and browse offline, it was suggested to me by a regular visitor to my website. It can be handy if you don't have access to the internet when trying to resolve a problem i.e customers site. I will try and keep this updated monthly.
14-11-2008
New
Exim
Discussing the router types and options
13-11-2008
New
Java
Bit Manipulation using bitwise AND, inclusive OR and exclusive OR , one's complement and the bit shifting
13-11-2008
New
Java
Vector, Stack, Dictionary, Hashtable, Properties, Random Classes
11-11-2008
New
Exim
Discuss the generic router options available to exim
11-11-2008
New
Java
Introduction to Remote Method Invocation
10-11-2008
New
Exim
A guide on how to configure and administer the Exim SMTP mail server, this will be updated over the coming weeks
07-11-2008
New
Java
Linked Lists, stacks, queues and trees
06-11-2008
New
Java
A start on Java networking, I hope to expand on this in the very near future
05-11-2008
New
Java
A simple guide on how to use images, audio and video in Java, I hope to extend on this further with the Game programming documentation I will be writing
04-11-2008
New
Solaris
I have had to upgrade a number of Solaris hard disks from 18GB to 146GB, here is my solution
29-10-2008
New
Oracle
Oracle 11g - regexp_count, regexp_instr, regexp_like, regexp_replace, regexp_substr
29-10-2008
New
Oracle
Short introduction into SQL (DDL, DML, DQL and DCL)
28-10-2008
New
Oracle
basics, getters and setters, static member methods, comparing objects, inheritance and polymorphism
28-10-2008
New
Oracle
Using C and Java Libraries
27-10-2008
New
Oracle
dbms_pipes, dbms_alerts
26-10-2008
New
Oracle
Dynamic SQL - NDS, DBMS_SQL Package
26-10-2008
New
Perl
The Perl debugger
26-10-2008
New
Perl
Require function, $#<array>, Alternative delimiters, Back quotes
24-10-2008
New
Perl
A start on OOP in Perl
23-10-2008
Update
Oracle
Complete makeover, now have DML, DDL, Compound, Instead-of, System trigger sections.
20-10-2008
New
Oracle
CLOB, NCLOB, BLOB and BFILES
17-10-2008
New
Perl
Referencing scalars, arrays, hashes and subroutines.
16-10-2008
Update
Oracle
complete makeover for this subject plus added some 11g stuff (new set operators)
10-10-2008
New
Perl
System Function, Working with sockets, Unix V IPC Operations
10-10-2008
New
Perl
File and Directory access commands (pipes, chdir, seek and tell, chmod, chown, etc)
10-10-2008
New
Perl
How to read from files and write to files
09-10-2008
New
Java
A start on the Java Layout Managers (basic only, Advanced to follow)
09-10-2008
New
Java
Introduction to basic Java Graphical User Interfaces (GUI)
09-10-2008
Update
Oracle
updated alot of the cursor stuff
07-10-2008
New
Java
How to use Java Graphics and the Java2D API
07-10-2008
Update
Oracle
Updated the symbol and function selection, added quoting alternative, also corrected some typo's
05-10-2008
n/a
Update
WebSite
Added a favicon to my website
05-10-2008
New
Perl
Introduction into Perl's associative arrays
04-10-2008
New
Perl
Manipulating arrays, lists and associative arrays
02-10-2008
New
Java
Open, read, writing and closing files - sequential and random access
28-09-2008
New
Perl
chop, chomp, scalar, oct, hex and Pack
27-09-2008
New
Perl
Eval, fork, system, die, warn exit, etc functions
23-09-2008
New
Java
Thread States, synchronizing, Thread Interaction
18-09-2008
New
Java
Inner Classes, Method-Local inner classes, Anonymous classes, Static Nested classes
18-09-2008
New
Java
toString(), overriding equals() and hashCode(), Collections, Garbage collector
16-09-2008
New
Java
String and StringBuffer class, Math Class, Wrapper Class and Equals.
15-09-2008
New
Java
Introduction into Java Object-Oriented Programming
14-09-2008
New
Perl
Using write and printf perl functions
14-09-2008
New
Perl
Beginning guide to Perl lists and arrays
12-09-2008
New
Perl
Defining, invoking, References, Return values, etc
12-09-2008
New
Perl
Single-line conditional statements, looping and goto statement
10-09-2008
New
Java
Exception handling and Assertions
10-09-2008
New
Java
If, if-else, while, loops, etc
09-09-2008
New
Java
Fundamentals of Operators and Assignment
07-09-2008
New
Perl
Pattern-Matching, special characters, pattern-matching options
06-09-2008
Update
Perl
Added Escape Sequences, Perl Operators, Precedence Order
06-09-2008
New
Perl
Finishing off the Perl Operators
05-09-2008
New
Perl
Introduction of scalar values - integer, floating-point, character, etc
04-09-2008
New
Java
Declarations and Modifiers, Declaration Rules, Interface Implementation
03-09-2008
New
Java
Keywords, data types, Variables, Arrays
01-09-2008
Amendment
Oracle
Having just restored and recovered a database, I have changed my notes as I had some many errors, goes show don't believe all that you read.
01-09-2008
New
Java
Introduction to Java Application and Applet Programming
30-08-2008
New
Perl
Scalar Variables, Arithmetic Operators, Conditional Loops
30-08-2008
New
Perl
Obtaining and Running a perl program
30-08-2008
New
Perl
Needed my own Perl guide (will be adding to this on a weekly basis)
29-08-2008
New
Solaris
Finally created my own ODS web page (just the basics)
28-08-2008
New
Oracle
Startup/Shutdown commands, operation modes, obtaining basic oracle information
26-08-2008
New
Java
A Start on documenting the Java programming course I have recently completed
26-08-2008
Amendment
Oracle
typo's