serial delays in SQL Server 2005s release. So its nice to see those efforts and delays reap such benefits.
Security at the database level has been virtually ignored in the past as enterprises instead focused on securing the network level, but thats been changing of late. Database security is a hot market right now, and Forrester Research analyst Noel Yuhanna told me hes getting plenty of inquiries from clients who are looking to lock down their databases.
"We definitely have seen a demand for encryption of data at this level, driven by industries such as financial institutions as well as other insurance- and health-related industries," he said.
The feedback Ive received from SQL Server 2005 beta testers is that native encryption at the database level will make a huge difference.
For example, currently, a company like TSYSthe worlds largest third-party credit-card processorhas up to now been using third-party encryption products from vendors such as Protegrity Inc. and/or Application Security Inc. However, the introduction of native encryption in the database will mean that the encryption overhead will be handled by the database product itself. That means that native encryption buys you a lot of CPU power to handle your overhead, Technology Director Tim Kelly told me.
Microsofts Rizzo did concede that encryption comes at a pricea performance price, naturally. Kelly reports that speed and capacity thus far arent showing up as issues, however, and that the encryption has been "very well-engineered."
Of course, TYSYS is the epitome of the kind of company you want to see lock down their database tables beyond airtight. Take those credit-card numbers and vacuum-tube them, indeed. With the coming of native encryption, the company plans a lot more database encryption, whereas before, like many enterprises, it focused on encrypting traffic.
Its a big win also for Long and Foster, a real estate company that covers the seven-state Mid-Atlantic region. Long and Foster runs almost exclusively on SQL Server for all its applications and has some 120 SQL Server instances. The company, based in Fairfax, Va., has been beta testing SQL Server 2005 some three yearsthats practically since it was barely a glimmer in Tom Rizzos eye.
Native encryption in SQL Server 2005 is going to offload plenty of handholding for the companys eStore project, a spot where all its marketing products and services will be sold online to its 13,000 agents. Senior Manager for E-Commerce and Software Development Lance Morimoto told me that his staff had been developing, managing and running security components itself for the eStorein other words, the group has had a lot more code to maintain than would be optimal.
For insights on security coverage around the Web, check out eWEEK.com Security Center Editor Larry Seltzers Weblog.
When you move from build-your-own or third-party products and into native encryption support, it helps the application development process by giving you less code to maintain. Also, it certainly helps with licensing issues.
Consider the hassle of upgrading, for example. When you have to deploy across a farm of servers, licensing and compatibility issues can bog you down. With everything on SQL Server, were now in a situation where we dont have to maintain and purchase and worry about licensing for all the separate tools and development languages, which is a major relief.
Next Page: The Ferrari-Hyundai Comparison Examined