Friday, 14 April 2017

Flapjack recipe

6oz butter or margarine
3oz demerara sugar
3 tablespoons of syrup (use plenty)
8oz quick cook rolled oats
Pinch of salt

Melt the fat in a saucepan, over a gentle heat.
Mix in sugar and syrup.
Mix in oats and salt.
Stir well and put into a greased tin and press down.
Bake for 30 - 35 minutes in the centre of the oven at 375°F (this might be abit too hot).

When cooked, leave to stand for a few minutes, then cut across into squares.

Leave in tin until cold.

Tuesday, 14 March 2017

TED Talk - 10 ways to have a better conversation

https://m.youtube.com/watch?v=R1vskiVDwl4

Celeste Headlee

1) don't multi-task - be present | in that conversation moment | don't be half-in the conversation
2) don't pontificate - enter every conversation assume that you have something to learn | everyone you will every meet knows something you don't | always be prepared to be amazed.
3) use open-ended questions
who
what
where
when
why
how
what was that like | how does that feel
4) go with the flow (let thoughts enter your mind, and let them go again)
5) if you don't know - say that you don't know | err on the side of cautioni
6) don't equate personal experience with their's | it's not a competition | it's not the same | all experiences are individual | it's not about you
7) try not to repeat yourself
8) stay out of the weeds - people don't care about names / dates / detials | people care about you, what you like, what you have in-common
9) listen - listening is the most important skill - if your mouth is open, you're not learning | no man ever listened his way out of a job
10) be brief - be a mini-skirt - short | to the point - summaries | be interesting, be long-enough to cover the subject.

Saturday, 18 February 2017

ZappySys SSIS Tasks - Importing data from SQL SERVER into Redshift


Recently, I've been using AWS (Amazon Web Services), primarily using the Redshift database as the platform for a Data Warehouse.
One of the challenges has been how to automate the data load from SQL SERVER, to Redshift.
There's various best practices - one of those is to store flatfile data in S3, prior to ingesting this into Redshift via the Redshift COPY command.
S3, or AWS S3 is a "simple storage service" offered by Amazon - the data is stored in "the cloud".
AWS offers AWS CLI (command line interface) to help achieve this task.
A rough guide would be to perform the following tasks
  1. Using SSIS (SQL SERVER INTEGRATION SERVICES) to read data from SQL SERVER, and create flatfiles.
  2. Using AWS CLI, push this data into an S3 bucket.
  3. Within Redshift - issue the COPY command, to pull the data from S3 into a Redshift table
  4. Optionally, issue another S3 command and move the files into an "Archive" folder - for better house keeping.
To achieve these 4 steps could be time consuming to automate.

This is where ZappySys comes in to help streamline this process, and cut out hours of development.
"ZappySys is a USA based software development company. 
We specialize in Data integration, Business Intelligence, 
Cloud computing and .Net Application Development."

In a nut-shell - ZappySys have developed SSIS task addon's that perform many different tasks - the one that's important for this import into Redshift is the Redshift Data Transfer task.
SSIS AWS Redshift Connector
This is equivalent to the SSIS Data Flow Task (DFT), but makes the whole process of connecting to the AWS account, Redshift cluster / database, using S3 as a flatfile staging environment a piece of cake.


SSIS Amazon AWS Redshift Data Transfer Task - Load from local file


Zappy even have recorded a straight-forward video on how to use this task to speed up the implementation.


Here's some more details (from http://zappysys.com/ to help summaries what they have to offer)

Why SSIS PowerPack?
  • Coding free, drag and drop high performance suite of Custom SSIS Components and SSIS Tasks
  • Used by many companies around the globe
  • Compatible with SQL Server 2005,2008, 2008 R2, 2012, 2014 and 2016
  • Support for 32bit and 64bit Server/Desktop OS
  • Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
  • No license needed if you are developing/testing in BIDS/SSDT
  • Rapid update cycle and prompt support (See what’s new). We will help you over phone, web meetings and via email.
  • 30 days money back guarantee if not satisfied for whatever reason.

SSIS Integration Packs

SSIS Integration Pack offers cost effective way to accomplish your specific integration need. Click on the following link to find out more about each integration pack.

SSIS Tasks\Components by Category

Monday, 26 December 2016

VAG DPF Diesel particulate filter

Copied from SeatCupra.net

http://www.seatcupra.net/forums/showthread.php?t=263734



VAG DIESEL PARTICULATE FILTERS

Courtesy of David Bodily Volkswagen Technical Support Specialist

Diesel Particulate Filter (DPF)


Detailed below is important information outlining the function and features of the Diesel Particulate filter which all members of your team need to be aware of.

Diesel particulate filters are becoming more commonplace on diesel engines, particularly sizes 2.0L upwards. This is in order to reduce the exhaust emissions as required by European legislation.

The prime reason for a DPF is to reduce particulate matter entering the atmosphere. Particulate matter is found in the form of soot, which is produced during diesel combustion. The DPF traps most of the soot which would normally travel down the exhaust and into the atmosphere. The DPF can hold a certain amount of soot, but not a huge quantity and therefore it needs to go through a process called ‘regeneration’ in order to clear the soot loading. When the soot goes through a ‘regeneration’ process it will be converted to a much smaller amount of ash. The ash is non-removable. There are two types of ‘regeneration’, passive and active.

During long motorway journeys, passive regeneration will occur. This needs no intervention from the engine control unit. Due to the raised exhaust temperatures on a long journey (temperatures between 350 and 500°C), the procedure occurs slowly and continuously across the catalytic-coated (with platinum) DPF. The catalytic-coated DPF is situated close to the Engine, therefore the exhaust gas temperature is high enough (500°C) to ignite the soot particles. Due to this soot is burned-off and is converted into a smaller amount of ash.

Active ‘regeneration’ is when the ECU intervenes when the soot loading in the DPF is calculated to be 45%. The procedure lasts for about 5 – 10 minutes. Specific measures are taken by the ECU to raise the engine exhaust temperature to above 600°C, these include switching off the exhaust gas recirculation and increasing the fuel injection period to include a small injection after the main injection. The soot particles are oxidised at this temperature.

The ECU will trigger a regeneration process, if for some reason this is aborted, ie. customer slows down, stops etc, the process will be resumed when regeneration conditions are once again met, above 60km/h (38mph). This will continue for 15 minutes.

If after 2 attempts of 15 minutes, a successful regeneration has not been possible, the loading will increase. At 50% soot loading, the ECU will continue to maintain maximum exhaust temperatures of 600°C to 650°C to cause a regeneration process. The system will try to run a regeneration process for 15 minutes. If unsuccessful, the system will repeat this process for a further 15 minutes, if still unsuccessful, the DPF light on the driver display panel will then be lit.

The owners handbook states, the DPF symbol lights up to indicate that the diesel particulate filter has become obstructed with soot due to frequent short trips. When the warning lamp comes on, the driver should drive at a constant speed of at least 60 km/h for about 10 minutes. As a result of the increase in temperature the soot in the filter will be burned off. If the DPF symbol does not go out, the driver should contact an authorised Volkswagen repairer and have the fault rectified.

At 55% soot loading the DPF light is lit on driver display panel. At this point the customer should follow the advice in the handbook. If they ignore this information and continue driving the vehicle until the soot loading reaches 75% without successful regeneration, additional warning lamps will light up. At this point the customer will also be complaining of lack of power, etc.

At 75%, regeneration is still possible with the use of the VAS tester. Only when the loading is above 95%, is it necessary to replace the DPF unit.


Operating Status System Response


45% DPF Load Level 1
Normal Regeneration

50% DPF Load Level 2
Regeneration at maximum exhaust temperatures

55% DPF Load DPF lamp
Regeneration from 60 km/h onwards
("See operating manual")

75% DPF Load DPF, SYS and MI lamp
Torque limitation, EGR deactivation,

Regeneration via VAG tester only
95% DPF Load Replace the DPF Unit



The Warranty department has confirmed that if there is no fault on the vehicle and DPF regeneration has been unsuccessful due to the customers driving style and the customers failure to comply with the instructions in the handbook, DPF replacement will not be paid for by warranty.


Common causes for complaint


• Frequent short journeys – Regeneration conditions are not met.
Not recommended for sale in the Channel Islands and inner city driving.

• Customers who continue to drive the vehicle with DPF light on – Continued
driving with the DPF light on and without successful regeneration results in
excessive soot loading of the DPF, to a point where it is above 95% loaded.
At this point regeneration is not an option and replacement of the DPF is
necessary.

• Fault 18434 particle filter bank 1 malfunction – Common fault code. This does
not only relate to the DPF itself, but the entire exhaust gas handling system. This
can be caused by defective temperature sensors, pressure sensors, additive
system components (if applicable), poor connections, wiring issues, etc.



Important Information

• Before diagnosing a problem vehicle or attempting to perform an emergency
regeneration, it is important to obtain a full diagnostic log and read out relevant
measured value blocks. These MVB’s contain important information on the
condition of the DPF system and are essential in diagnosing the fault. When the
DPF light is illuminated, it does not necessarily mean that the DPF requires
regeneration. For further advice, please contact Technical Support with the
information from the diagnostic log and MVB data.

• If a problem vehicle arrives with the DPF light, the engine management light and
the emissions light on. If during your diagnosis and reading of relevant MVB’s,
you find that the soot loading exceeds 75% (but is still below 95%), an
emergency regeneration procedure must be performed with the VAS tester.
Further to this, the customer needs to be educated. They need to understand
why the lights have appeared on the dash panel. Their attention needs to be
brought to the owners handbook instructions, so that they are aware of what the
DPF light means and what to do when it appears. This should prevent
unnecessary repeat visits for regeneration purposes.


I have also found that as the car gets older 30K+ miles, you will notice that the regeneration takes place more often. 


ALWAYS, check your oil before any long journey, as DPF regeneration can use a fair bit of oil.



Some questions and answers that may help;


Question: The glow plug symbol is flashing. Why? What should be done?

Answer: 
The DPF regeneration has not been completed during normal driving and now DPF has reached its maximum saturation at which it can still be regenerated. The limit value depends on variant and Model Year, but is in the range of 105% - 125%.Possible causes for this are:

a.) Frequent short distance journeys, i.e. high soot loading while at the same time regeneration of the DPF does not take place because the conditions necessary were not fulfilled.

b.) Frequent interrupted regenerations, i.e. the engine was switched off during regeneration. Applies to short journey drivers who have at least fulfilled the conditions for triggering regeneration. If the glow plug light flashes, the vehicle

a.) Engine running since start for longer than 2 minutes.
b.) Calculated saturation higher than 80%.
c.) Coolant temperature over 70°C for at least 2 minutes.
d.) No DPF-relevant faults stored in system.
e.) A defined vehicle speed threshold must have been exceeded (e.g. for >80% loading, 100 km/h)



Question: Under what conditions is regeneration interrupted/ended once it has started?

Answer: Normally when regeneration has been successfully completed, or:

a.) After a maximum regeneration time (20 - 25 min.).
b.) If the engine is switched off or has stalled.
c.) If the engine is left idling for a long time (5 - 10 min.).
d.) If 1000°C is detected by the exhaust temperature sensor.
e.) If during regeneration, a fault is detected on the components relevant for combustion (injection/intake system).

If a regeneration is interrupted once started but before it has been 50% completed, the glow plug lamp flashes on the next engine start (cold or hot) and regeneration begins again once the operating conditions (see 3) have been fulfilled.



Question: How long does complete regeneration take? 

a.) In the most favourable case? b.) In the least favourable case?

Answer: 
a.) Under constant conditions, i.e. the exhaust temperature necessary for regeneration always lies above the required value, for example during motorway/cross-country driving, the average regeneration time is 10 minutes.

b.) Vehicle conditions such as long down-hill descents, frequent driving in the low-load range (city driving, idling) allow the exhaust temperature to fall. If the conditions for triggering regeneration were fulfilled, the active regeneration time can be extended up to 25 minutes (depending on engine type). If complete regeneration is not possible within this period, the regeneration will be interrupted.



Question: How does regeneration affect the oil life?

Answer: On each regeneration or attempted regeneration, a certain diesel fuel amount is injected into the engine oil which reduces the oil life. If the "INSP" light in the instrument cluster comes on, the engine oil is exhausted and must be changed. Failure to do so could damage the engine

Thursday, 27 October 2016

Windows Command Prompt "shortcuts"

%ALLUSERSPROFILE% - Open the All User's Profile
%HomeDrive% - Opens your home drive e.g. C:\
%UserProfile% - Opens you User's Profile
%temp% Opens - temporary file Folder
%systemroot% - Opens Windows folder
Hopefully this should be enough for now. :-)
Run commands
Calc - Calculator
Cfgwiz32 - ISDN Configuration Wizard
Charmap - Character Map
Chkdisk - Repair damaged files
Cleanmgr - Cleans up hard drives
Clipbrd - Windows Clipboard viewer
Cmd - Opens a new Command Window (cmd.exe)
Control - Displays Control Panel
Dcomcnfg - DCOM user security
Debug - Assembly language programming tool
Defrag - Defragmentation tool
Drwatson - Records programs crash & snapshots
Dxdiag - DirectX Diagnostic Utility
Explorer - Windows Explorer
Fontview - Graphical font viewer
Ftp - ftp.exe program
Hostname - Returns Computer's name
Ipconfig - Displays IP configuration for all network adapters
Jview - Microsoft Command-line Loader for Java classes
MMC - Microsoft Management Console
Msconfig - Configuration to edit startup files
Msinfo32 - Microsoft System Information Utility
Nbtstat - Displays stats and current connections using NetBios over TCP/IP
Netstat - Displays all active network connections
Nslookup - Returns your local DNS server
Odbcad32 - ODBC Data Source Administrator
Ping - Sends data to a specified host/IP
Regedit - registry Editor
Regsvr32 - register/de-register DLL/OCX/ActiveX
Regwiz - Reistration wizard
Sfc /scannow - Sytem File Checker
Sndrec32 - Sound Recorder
Sndvol32 - Volume control for soundcard
Sysedit - Edit system startup files (config.sys, autoexec.bat, win.ini, etc.)
Systeminfo - display various system information in text console
Taskmgr - Task manager
Telnet - Telnet program
Taskkill - kill processes using command line interface
Tskill - reduced version of Taskkill from Windows XP Home
Tracert - Traces and displays all paths required to reach an internet host
Winchat - simple chat program for Windows networks
Winipcfg - Displays IP configuration
Management Consoles
certmgr.msc - Certificate Manager
ciadv.msc - Indexing Service
compmgmt.msc - Computer management
devmgmt.msc - Device Manager
dfrg.msc - Defragment
diskmgmt.msc - Disk Management
fsmgmt.msc - Folder Sharing Management
eventvwr.msc - Event Viewer
gpedit.msc - Group Policy (< XP Pro)
iis.msc - Internet Information Services
lusrmgr.msc - Local Users and Groups
mscorcfg.msc - Net configurations
ntmsmgr.msc - Removable Storage
perfmon.msc - Performance Manager
secpol.msc - Local Security Policy
services.msc - System Services
wmimgmt.msc - Windows Management
Shortcuts
access.cpl - Accessibility Options
hdwwiz.cpl - Add New Hardware Wizard
appwiz.cpl - Add/Remove Programs
timedate.cpl - Date and Time Properties
desk.cpl - Display Properties
inetcpl.cpl - Internet Properties
joy.cpl - Joystick Properties
main.cpl keboard - Keyboard Properties
main.cpl - Mouse Properties
ncpa.cpl - Network Connections
ncpl.cpl - Network Properties
telephon.cpl - Phone and Modem options
powercfg.cpl - Power Management
intl.cpl - Regional settings
mmsys.cpl sounds - Sound Properties
mmsys.cpl - Sounds and Audio Device Properties
sysdm.cpl - System Properties
nusrmgr.cpl - User settings
firewall.cpl - Firewall Settings (sp2)
wscui.cpl - Security Center (sp2)
Windows Environment Commands
%ALLUSERSPROFILE% - Open the All User's Profile
%HomeDrive% - Opens your home drive e.g. C:\
%UserProfile% - Opens you User's Profile
%temp% Opens - temporary file Folder
%systemroot% - Opens Windows folder
Wupdmgr - Takes you to Microsoft Windows Update
Thanks to The New Tech for the original forum posting.
Microsoft Office run commands If the Microsoft Office is installed you can use following run commands to run its components:
winword - Microsoft Word
excel - Microsoft Excel
powerpnt - Microsoft PowerPoint
msaccess - Microsoft Access
outlook - Microsoft Outlook
ois - Microsoft Picture Manager
winproj - Microsoft Project

Sunday, 17 April 2016

Baby sleep - tip 1

If the baby is struggling to sleep after being held, a tip is to place a muslin under your T-shirt whilst the baby is being fed.

Then, when the baby is placed in their cot / basket / bed for their sleep, place the muslin in with them at the same time.

The theory is, your scent is transferred to the muslin, so when its placed in with the baby, they can smell the scent, and are tricked into thinking that they're still close to the parent, and feel secure, and so they'll sleep.

Information in this blog is from my own personal experience / observation and only for my own reference.  If you find it useful, then great, buy it shouldn't be considered "gospel", and your own experience may and will differ as each baby / situation is different.

Baby Sleep cycles

Everyone has  sleep cycles.
In babies, these last 45 minutes.

Babies can stir, or wake themselves up in between these cycles, and my squirm, or cry for a few seconds.

This is normal, and shouldn't be concerning.

Leave them alone,  and observe.

The baby will self-settle, and drift back off to sleep.

This self-settling is a crucial, and important skill that all babies need to develop so that they remain calm and relaxed as the grow.

Information in this blog is from my own personal experience / observation and only for my own reference.  If you find it useful, then great, buy it shouldn't be considered "gospel", and your own experience may and will differ as each baby / situation is different.