Feeds

SQL Server 2008 moves on, wants to stay friends

It’s not you, it’s the BI and database engine

Beginner's guide to SSL certificates

The options for what to include in a stack are many and direct comparisons are difficult. Although it is tempting to deploy the Express edition of SQL Server 2008 on cost grounds - it's free - the Web edition is optimized for web-based scenarios. But, and here's the catch: it isn't free.

Engine of change

So what's new in the database engine itself? The resource governor is all-new. This tool lets you allocate available resources into pools. This allows jobs to be grouped depending on their importance and allocated to a resource pool, which in turn enables jobs that need to be completed rapidly (like loading data) to be given more resources than less time-critical tasks. The resource governor is also a useful aid to monitoring resource usage.

Data compression is also a new and welcome addition in these days of burgeoning data volume. Row and page compression are both supported: row compression stores fields using a variable width format thus reducing the bytes needed to store compressible data, and page compression is similar except that it compresses the rows on a page. There is inevitably a performance hit during compression when writing and de-compression when reading, but Microsoft said the reduced disk I/O counterbalances the compression times and even improves query performance.

Transparent Data Encryption (TDE) is another new feature and can be implemented at the engine level, meaning you can protect an entire database without having to change anything in the applications.

SQL Server's database mirroring abilities have been enhanced to make them faster and easier to use. Mirroring transfers log files between servers in order to improve fail-over times when the standby server is called into play. The ability is further improved by log stream compression (another newbie) that speeds up the mirroring process.

The implementation of a new spatial data type is significant because it allows geographical data to be handled and manipulated elegantly. Using this data type it is possible to find, for instance, how many contacts are within a 50-mile radius of your offices - and much more.

SQL Server 08 gauge control

All new: gauge control displays data in a range of flavors

I have written extensively in Project Watch about making use of this feature to plot locations on a map.

The backup system has been rewritten and now delivers a huge improvement in performance, linear scalability and the ability to handle an analysis services database of more than a terabyte. The new backup can usefully replace raw file system copying so that the ability to run in parallel with other operations, amongst other benefits, can be felt. Equally good news is that backup compression is supported in 2008.

Protecting users from Firesheep and other Sidejacking attacks with SSL

Next page: New reporting rules

More from The Register

next story
New 'Cosmos' browser surfs the net by TXT alone
No data plan? No WiFi? No worries ... except sluggish download speed
'Windows 9' LEAK: Microsoft's playing catchup with Linux
Multiple desktops and live tiles in restored Start button star in new vids
iOS 8 release: WebGL now runs everywhere. Hurrah for 3D graphics!
HTML 5's pretty neat ... when your browser supports it
'People have forgotten just how late the first iPhone arrived ...'
Plus: 'Google's IDEALISM is an injudicious justification for inappropriate biz practices'
Mathematica hits the Web
Wolfram embraces the cloud, promies private cloud cut of its number-cruncher
Mozilla shutters Labs, tells nobody it's been dead for five months
Staffer's blog reveals all as projects languish on GitHub
SUSE Linux owner Attachmate gobbled by Micro Focus for $2.3bn
Merger will lead to mainframe and COBOL powerhouse
iOS 8 Healthkit gets a bug SO Apple KILLS it. That's real healthcare!
Not fit for purpose on day of launch, says Cupertino
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.