SAN/NAS & VMWare, HyperV

SAN and NAS devices can bring storage to a central managable area, if you have more than one server, you are already on track to the path of creating a your own local cloud computing.

The idea of cloud computing is already quite old, but there seems to be a new rave about it. Cloud computing can very it forms from having everything online and hosted by a third party, or simply having some of your onsite services run on different servers so that if single server goes down, other services continue to run on other hardware.

Having a SAN and a virtualisation setup can significantly reduce your business risk, by ensuring that no single component in your local datacenter (and Datacenter includes that old room you have where you keep the servers).

TenacIT are partners with HP, EMC, Dell, VMWare and Veeam, the leaders in virtualisation hardware and software products.

If you looking for support with your SAN, NAS, or Virtualisation setup, please feel free to contact us. We offer adhoc rates and SLA’s for our customers differing needs.

Every companies needs are different, but the possibilities are infinite to find a perfect solution within your budget.

SYSPRO Finalist for Two American Business Awards

Taken from the Syspro USA website

COSTA MESA, Calif. – May 14, 2010 – SYSPRO, the leading provider of visionary, pragmatic ERP software, has today announced that the company is a double finalist for the 2010 American Business Awards. SYSPRO is recognized in the categories “Most Innovative Company of the Year” and “New Product or Service of the Year.”

The American Business Award, aka “the Stevie AwardTM ,” is the nation’s premier business awards program. All organizations operating in the U.S.A. are eligible to submit. This year more than 2,700 entries from organizations of all sizes and in virtually every industry were submitted for consideration in more than 40 categories.

The newest release of the SYSPRO Enterprise Resource Planning software solution gained SYSPRO recognition in the “New Product of the Year Category.” The new SYSPRO release represents a giant leap forward with new architecture, modules, feature sets, workflow and customization capabilities and groundbreaking user interface enhancements that set a new standard for ease of information access. The release enables mid-market manufacturers and distributors to gain all the benefits of cost-effective, leading-edge business software with phenomenal cost-functionality benefits.

SYSPRO’s finalist status for the “Company of the Year” award was, in part, recognition of SYSPRO’s ‘green’ leadership. SYSPRO President Joey Benadretti notes, “SYSPRO has introduced software that enables mid-range manufacturers and distributors to both ‘green’ and ‘lean’ their operations. We have been so effective in our ‘green’ focus that SYSPRO was the recipient of a State of California Governor’s green award.”

The American Business Award finalist rankings are the newest industry recognitions for SYSPRO. SYSPRO USA was named “2009 Software Company of the Year” by the Technology Council and “2009 Outstanding Private Technology Company” by TechAmerica.

This year’s Stevie Award winners will be announced during an annual gala on Monday, June 21 at the Marriott Marquis Hotel in New York City. More than six-hundred executives from across the U.S.A. are expected to attend. The event will benefit Oceana (oceana.org), the largest international organization focused on ocean conservation.

About The Stevie Awards.

Stevie Awards are conferred in four programs: The American Business Awards, The International Business Awards, the Stevie Awards for Women in Business, and the Stevie Awards for Sales & Customer Service. Honoring organizations of all types and sizes and the people behind them, the Stevies recognize outstanding performances in the workplace worldwide. Learn more about The Stevie Awards at www.stevieawards.com

About SYSPRO

Since its inception in 1978, SYSPRO has been delivering state-of-the-art business solutions to some of the world’s leading companies. As a global leader in the production of world-class ERP software, the company now caters to the specialized needs of 14,000 licensed companies in more than 60 countries worldwide. SYSPRO is marketed globally through regional territory distribution centers and a global reseller network in the US, Canada, Africa, Asia Pacific, Australia and the UK.

SYSPRO is a fully integrated business software solution that provides complete control over the planning and management of all facets of business including accounting, manufacturing and distribution operations in a variety of industries.

Edgeware gets tops Honours at Syspro USA reseller conference

Edgeware, a TenacIT Syspro VAR partner in the USA was awarded top honours in Las Vegas on April 24 2010. On behalf of Edgeware John Angove  and Richard Jenkins received the SYSPRO Gold Partner award for excellence in selling and supporting the SYSPRO product. The award was presented by Joey Benadretti and Brian Stein during the SYSPRO Reseller Conference.

Congratulations to Edgeware for a successful track record in delivering solutions, TenacIT is proud to have helped deliver on some of those projects.
Picture of Edgeware's gold partner award

A thanks from Art @ House Parts

A recommendation from Art @ House Parts, USA

This letter is written in appreciation for the assistance that Matthew provided 5/14/2010.  John Short helped to diagnose that Sysprodb was down.  Matthew helped with the recovery of a backup database and the creation of a new virtual machine.  Matthew was extremely efficient and thanks to him, a crash that could have crippled our business was averted.  Throughout the 3 hours, Matthew was supportive and knowledgeable.  Any system crash is a stressful experience, however Matthew was able to guide us thru the process and he helped to limit the stress.

I wanted to thank Matthew personally for his timely assistance with our recent database problems.

Art Cummings, I.T. Support

House Parts

House Parts Logo

http://www.houseparts.com

479 Whitehall St. SW

Atlanta, GA 30303

(Number Available on request)

SQL server storage principles

An international client of mine had server hard drive failure late last Friday.

The company, albeit large, was running this smaller application, and its SQL server on external hard drive because of previous failure the month before. The hardware was brand new, but workstation grade, not server grade. The management had disallowed any new purchases until the budget would be formally allocated.

Needless to say, the hardware failed, and their management fails to understand that the problem has been created by them. Their IT department requested a letter stating the cases for their management. So here it is:

As discussed, with your agreement, during the recovery of your SQL server, database applications are very hard applications on the wear rates of hard-drives.  Typically hard drives are created for either the workstation (or home user) market, or the server market. Hard drives usually come with warranties ranging from 1 year to 5 years, depending on the design. These warranties usually indicate that their components are of different grade, and that their MTBF (most electronic equipment has a Mean-Time-Before-Failure estimation) is significantly different.

The problem with using workstation grade hard drivers in a database application that server many users, is that the busiest parts of the database will over time usually be located over the same contiguous physical sectors, and these sectors are likely areas for failure. A typical home user might take several years to create the number of reads and writes to a particular sector that a busy database application would cause in just one week.

The risk of data corruption is high. It results in lost data of the past, and labour hours which need to re-occur to re-capture data, as well as reconcile data. In addition, during recovery time, labour hours are lost. Therefore both past work is last, and future work is created, and staff are often demoralised by such an event. There is also the risk of debtors invoice information being lost, and the opportunity for untrustworthy staff to take advantage of a situation where they can see the system might have reconciling difference that need to be written off anyway, the perfect time for theft.

To mitigate the risk  of such failure, two principles are best adhered to, firstly adequate backups (which given the hardware constraints), the best was already being done, and secondly, trying to reduce the requirement for ever needing those backups.

Hard drives are where the information is kept, so it’s best to use server-grade hard drives, which also boast additional speed, as well as server grade architectures for storage, such as RAID 5 or RAID 6 arrays which allow a single (RAID 5) or two (RAID 6) hard drives to fail without losing any data – and without creating any “down-time”. Hard drives are one of the most common failure points because of their mechanical nature, they are “doomed” over time to fail. Using a RAID array, allows a company to mitigate such risk.

SQL functions

It happens all the time, but a client phoned me with an urgent SQL query problem.

Their query was taking way too long to run. Sure, its got millions of records to run through, but it only need to retrieve a small result set, and the WHERE clause was seeking on an indexed fields. Or where they?

A quick look at the query:

Wait… before you read that, the only thing you need to know, if you are putting your index fields inside a function… you are slowing it down. Rather limit the results in a inner query, and filter those further with your functions.

The reason: The query optimiser cannot tell what the outcome of parsing the value through the function will be. So it needs to build a temp table with the parsed values (or some other tedious operation that goes through every single record, instead of selecting only a sub set or rows).

So, functions in a WHERE clause are a bad idea, unless the record set being drawn from is already small.

The code is below. And for a more technical background: see this article http://www.databasejournal.com/features/mssql/article.php/3845381/T-SQL-Best-Practices–Dont-Use-Scalar-Value-Functions-in-Column-List-or-WHERE-Clauses.htm

Bad Query:

DECLARE @fdate as datetime
DECLARE @tdate as datetime
SET @fdate = '2009-10-01'
SET @tdate = '2009-10-31'
SELECT cat.Descrip,

SUM(((invl.Quantity*invl.SellingPrice)-((invl.Discount/100)* (invl.Quantity*invl.SellingPrice)))*invl.tax) As Total

FROM Invoice inv
JOIN InvoiceLine invl ON inv.InvoiceID=invl.InvoiceID
JOIN Products prod  ON invl.ProductID=prod.ProductID
JOIN CategoryForSales cat ON invl.salescat=cat.CategorySalesID
WHERE
  inv.cid=@cid
 AND (convert(varchar(10),inv.InvoiceDate,111)
  between  convert(varchar(10),@fdate,111) AND  convert(varchar(10),@tdate,111))
GROUP BY cat.Descrip

Obviously the user is trying limit the time of the transaction out of the Where clause.
It would have been better in this case to simply set @fdate to the date at 12am, and @tdate set to 23:59.59.998 or 12am of the next day.

DECLARE @fdate as datetime
DECLARE @tdate as datetime
SET @fdate = '2009-10-01 00:00:00.000'
SET @tdate = '2009-10-31 23:59:59.998'
-- OR SET @tdate = '2009-11-01 00:00:00.000'
SELECT cat.Descrip,

SUM(((invl.Quantity*invl.SellingPrice)-((invl.Discount/100)* (invl.Quantity*invl.SellingPrice)))*invl.tax) As Total

FROM Invoice inv
JOIN InvoiceLine invl ON inv.InvoiceID=invl.InvoiceID
JOIN Products prod  ON invl.ProductID=prod.ProductID
JOIN CategoryForSales cat ON invl.salescat=cat.CategorySalesID
WHERE
  inv.cid=@cid  AND inv.InvoiceDate between  @fdate AND  @tdate
  --Hey look how much simpler the where clause looks now... and its that much simpler for the query optimiser too!
GROUP BY cat.Descrip