Friday, May 31, 2013

Please add your CFUG to the Adobe map!

Where is your CFUG?

I have been to NYCFUG , SFCFUG & the Twin Cities ColdFusion User Group & none are on the map!

See map here

Linux Basement 80

Please watch me in Linux Basement

Wednesday, May 15, 2013

Back up MS SQL via ColdFusion

Have you ever needed to back up a client's remotely hosted MS SQL Database?

Ray Camden has a script for MySQL here is mine for MS SQL

Monday, May 6, 2013

Select only records with valid e-mail addresses from a table

Ok, doing some hired gun work. The client wants the record set returned from a query to have only valid e-mails.

The gist includes fully working CFML that demonstrates this example.

The core of this is the isValid function. In this case it is used to validate an e-mail address

isValid('email', email) email, the second one, is a filed in the table.

The code also adds a column to the record set with QueryAddColumn and then does a query of queries to get only valid e-mail addresses

Some good comments, if you use underscore or mySQL...
Thanks Russ & Timothy Leach

SELECT `email`
FROM `users`
WHERE `email`
REGEXP '[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}'
GROUP BY `email`

SQL Server would have to be something like:
WHERE email like '[a-z,0-9,_,-]%@[a-z,0-9,_,-]%.[a-z][a-z]%'

Wednesday, May 1, 2013

NYC Unix Gig

Req.#: 14955
Job Title: SME,Infrastructure QA/Controls Job Type: Consulting
Duration: 4 months Business: Education/University
Location: New York, NY

Project Description:
Our direct client has an opening for the SME of Infrastructure Quality Assurance/Controls position reporting into the AVP of Internal IT Controls. The position will be responsible for day to day monitoring to ensure that the company's central IT infrastructure operation complies with its policies, procedures, and standards defined for various technology platforms. 

More specifically, the responsibilities are as follows:
Ensure ongoing monitoring for adherence to Standard Operating Environment procedures for Operating Systems, Middleware, Web Infrastructure and Databases.
Review and provide input into the design of Standard Operating Environment procedures.
Function as a source of knowledge on IT infrastructure and IT infrastructure quality assurance standards; build relationships with internal teams and external providers.
Foster progressive improvement IT infrastructure Standard Operating Environments in conjunction with quality assurance best practices.
Facilitate improvement of the IT infrastructure Change Management and Configuration methodology.
Regularly perform reviews of Change and Configuration Management processes for IT infrastructure components to validate compliance. Document non-compliance and escalate as appropriate.
Periodically perform reviews of provisioning and deprovisioning of privileged user ids.
Keep current with security trends in the IT infrastructure area (through the Security Team and other methods) and identify steps needed in order to stay current.
Ensure that core infrastructure components have fundamental documentation (architecture diagrams, configuration specifics, design documents etc.).
Ensure that key roles are documented for each infrastructure service area and that the segregation of roles is in place.
Review efforts to remediate access to sensitive data within the IT infrastructure.
Ensure that each IT Infrastructure area is in compliance with established standards.
Assist the infrastructure team with audit preparation and support, conduct pre-audits.
Ensure that estimation/resource utilization methodology is in place for all infrastructure components and that it is consistent across different infrastructure areas within company.
Work with appropriate counterparts to assist with planning for and implementation of agreed ITIL processes.

Minimum qualifications:

5+ years of IT infrastructure management experience. 
10+ years of hands on IT infrastructure experience 
Excellent communication and relationship management skills. 
Expert ability to analyze and interpret technical data. 
Experience with complex systems integration. 
Experience working with a culturally diverse team. 

Preferred qualifications:

In depth knowledge of Operating Systems (e.g. Linux, Solaris), Middleware (e.g. Tomcat, Apache, Web Logic), Databases (e.g. Oracle, Sybase) 
Demonstrated IT architecture experience
Demonstrated IT Infrastructure quality assurance experience
ITIL experience.

Required Skills:
5 years of IT Infrastructure management experience,
10+ years of hands on IT infrastructure experience,
Excellent communication & relationship mgmt skills,
Expert ability to analyze and interpret tech. data,
Experience with complex systems integration,
Experience working with a culturally diverse team.

Optional Skills:
Demonstrated IT Architecture experience,
Demonstrated IT Infrastructure Quality Assurance,
ITIL experience,
Knowledge of Operating Systems- Linux, Solaris,
Knowledge of Middleware- Tomcat, Apache, Web Logic,
Knowledge of Databases- Oracle, Sybase
Please remember that you can earn up to a $1500.00 referral fee for every I.T. professional you refer and that we place with one of our clients. Be sure to check our web site www.designstrategy.com for a complete list of our current consulting and permanent opportunities.

Thanks,
888 425 2404 ext 4313

Tony Dalmau
Office: 908-709-9800 x4313
Email: tonyd@designstrategy.com

Exceptional People, Innovative Solutions