Monday, 27 October 2008

Rapid Recovery - The core benefits & improved R.O.I

RapidRecovery, a business continuity service is the latest innovation from Quantix. Here are just some of the core benefits that come with the service:

Recovery Time of Minutes – If in the unfortunate event that you have a disaster, the 1st thing you would think about it is how long will it take to get the lost data back? With the RapidRecovery service from Quantix, this can be in minutes. RapidRecovery is able to monitor devices at all times and so if there was a failure, you would know about it straight away and take the necessary action to rectify the problem.

Snapshots – Although RapidRecovery is not intended as a replacement for local back-up tapes, RapidRecovery still has the capabilities to retain several images allowing roll back to past images. When replicating customer systems, RapidRecovery allows roll back to a previous time which improves the resiliency of server recovery.

Wide range of operating systems supported – The core rapid recovery platform is able to support a wide range of operating systems such as Windows server 2003, 2003 R2 Enterprise, standard, web, small business server, Enterprise 64 or standard x64. As well as Windows 2000 advanced server, server or small business servers with service pack 4 and the update rollup package. RapidRecovery can also be extended to support Linux if required.

Private Data Link – The RapidRecovery platform is set up via a provisioned private link into the Quantix Datacenter. This ensures that all the data transfer between the datacenter and the customer network is private and sensitive data will not be replicated over the internet.

Quantix Team – Quantix has over 20 accredited engineers who manage and implement the RapidRecovery system are specialists in their fields and have years of experience in managing some of the world’s largest organisations. The consultants deploy the whole RapidRecovery system including implementation and testing of Private Data Link, documentation of live server environment, set up of GEM Monitoring for pre-emptive action and early warning system.

This is just part of what the Quantix team can offer as part of the RapidRecovery solution. Already working with large organisations, Quantix has got the full expertise resources in place implementing core disaster recovery strategies.

To find out more about the RapidRecovery platform, please visit the Quantix website or call one of our consultants on 0115 983 6200

Disaster Recovery - Are you prepared?

Many businesses see Disaster Recovery as a costly insurance policy and don’t really see any benefits until a disaster occurs. This unfortunately is the view that some businesses take when assessing their Disaster Recovery practice, resulting in businesses opting for a less efficient business continuity plan due to the cost implications.

Quantix have started to change this view through the introducing their own Business Continuity solution called RapidRecovery, which in comparison to more traditional DR solutions can be significantly cheaper and provide a greater Return on Investment for Disaster Recovery budgets.

RapidRecovery is delivered as a Managed Service and is fully maintained by a significant team of accredited engineers on a 24x7 basis. Once installed, businesses have the benefit of a flexible and low cost access to the RapidRecovery platform which provides full replication of the IT environment.

It is important that businesses make use of innovative IT solutions in order to drive down operational costs and benefit from the latest technological improvements. Quantix does just this with RapidRecovery, it is a solution that is pushing the boundaries of business continuity and making IT decision makers think twice about how they spend their budgets.

If you would like to know more about the RapidRecovery solution please visit the Quantix website or call us on 0115 983 6200

Friday, 24 October 2008

Microsoft issues emergency security patch

URGENT: Critical Security Update from Microsoft

Microsoft has just released (October 23 2008) an out of band, security update to address a critical situation which could allow a remote attacker to take over Windows computers without any user interaction.

This security up date is released out of the current cycle of security patch updates, which proves the severity of the issue. The issue itself affects the server service. The malware could allow an attacker to execute some arbitrary code using a specially crafted remote procedure call request.

Microsoft have said "This security update resolves a vulnerability in the Server service that affects all currently supported versions of Windows," said Christopher Budd, a MSRC security program manager. Windows XP and older versions are rated as 'Critical' while Windows Vista and newer versions are rated as 'Important.' Because the vulnerability is potentially wormable on those older versions of Windows, we're encouraging customers to test and deploy the update as soon as possible."

Microsoft has said that the vulnerability is quite severe and can affect every version of the windows operating system.

Microsoft has identified the malwares used in these attacks as: "TrojanSpy:Win32/Gimmiv.A" and "TrojanSpy:Win32/Gimmiv.A.dll.".

To learn more, please visit the Microsoft website.

Friday, 22 August 2008

Sql Server 2008 - Quantix Ensures UK Businesses Reap Benefits

Quantix, provider of enterprise applications support and managed services, today announced its professional support of the recently launched Microsoft SQL Server 2008. The new version of Microsoft's acclaimed data management and business intelligence platform is designed to provide a productive and intelligent platform necessary for business-critical applications.

SQL Server 2008 has been developed to help organisations manage any data, any place and any time. From storing structured, semi-structured and unstructured documents, such as images and music within the database, SQL Server 2008 delivers a rich set of integrated services from querying, searching, synchronising, reporting and analysing data. Organisations can now store and access data within their largest servers all the way down to desktops and mobile devices, enabling the business to have control over critical data, no matter where it is stored.

The new Sql Server 2008 includes improved Business Intelligence tools (SSIS, SSRS & SSAS), improved security, reliability and scalability for your business.

If you would like more information on Quantix's Sql Server portfolio or any of our Microsoft Technologies, please visit the Quantix website or call us on 0115 983 6200.

Thursday, 15 May 2008

Quantix - SSIS script - Set variable at run time with a script task

For all the SSIS Developers out there this has been niggling me for sometime, so I thought I'd share this information with you,

To set a variable in the script task, here are two methods you can use.


Method 1

This method involves using the LockOneForWrite method in the VariableDispenser class. The advantage to this method is it allows for you to read and write to the variables at runtime without having to use the ReadOnlyVariables and ReadWriteVariables options in the Script task. The price of that though is that you have to write quite a bit more code. In the following example, I’m going to open the AlertAdmin variable for writing and then set it to the boolean value of True.

Public Sub Main()
Dim vars As Variables
Dts.VariableDispenser.LockOneForWrite("AlertAdmin", vars)
vars("AlertAdmin").Value = True
Dts.TaskResult = Dts.Results.Success
End Sub



Method 2

The second method is typically what I would recommend using just for simplicity. In this method, you would open the Script task and before clicking on Design Script, you must add the name of the variables to the ReadOnlyVariables or ReadWriteVariables properties of the script task. This is done by simply typing the name of the variable with no parentisis or namespace (e.g. @[User::strVariable] is written in this specific text box as strVariable). If you have more than one variable you wish to be available in the Script task, you can seperate them with commas. If you do not set this, you will not see an error at design time but at run time, you’ll receive the error shown below:
The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.


at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index)
at ScriptTask_8693feb81f2d4b7b8a26ae87a8a5f960.ScriptMain.Main() in dts://Scripts/ScriptTask_8693feb81f2d4b7b8a26ae87a8a5f960/ScriptMain:line 19

With the variables now being passed in, you can perform the same type of action as I showed in the earlier script in a single line (the second line shown below). The locking is done by the Script task UI.


Public Sub Main()
Dts.Variables("AlertAdmin").Value = True
Dts.TaskResult = Dts.Results.Success
End Sub

The ReadOnlyVariables and ReadWriteVariables options are available to you in the Expressions tab too if the variable name that you wish to pass in is unknown or dynamic. There are other ways to set the variables of course. Most tasks have hooks into the variables like the Execute SQL task.


Enjoy -

Robert....
Quantix