Feeds

SQL Server 2008 moves on, wants to stay friends

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

Combat fraud and increase customer satisfaction

New reporting rules

Major changes are evident in Reporting Services, to the point of being an entirely new tool. The familiar tools are still in evidence, namely:

  • Report Builder (used primarily by IT people to create report models for business users) remains much as it was in 2005
  • Report Designer, running within Visual Studio and aimed at the IT professional, has been upgraded

New, though, is the 2008 Report Builder for the power users, supplied as a web download. A stand-alone product, it offers all the layout features of Report Designer with an Office 12 ribbon interface.

There are new controls for displaying data in reports: one is the Gauge. Perfect for displaying a single value, a range of gauges is also useful for comparing several values. A variety of gauge types is available, with pointers, sliders or simply showing a value.

The Tablix control is for rather more complex data than that served by gauges. It combines the abilities of the existing Table, List and Matrix controls and gives much greater control over layout.

New chart types include polar, shape and range, and multiple data series can now be displayed on more than one axis and the scale breaks on the axis are customizable.

Integration Services has acquired a Data Profiling Task that facilitates an understanding of the distribution of data in the source systems that feed into a data warehouse. Previously this has been gained the hard way by issuing multiple queries to ascertain the domain and distribution of values. The new Data Profiler is a data-flow task that lets you define the information you require: eight profiles are included.

SQL Sever 08 data flow task

Graphically speaking: a data-flow task on display

Stack pack

So how has Microsoft packaged this little lot? The complete SQL Server - with all the features described plus the BI tools - is Enterprise edition, available for 32- and 64-bit systems. The Standard edition comes with a subset of features and BI tools targeting departmental users and the online transaction processing (OLTP) systems of small- to medium-sized enterprises (SMEs).

There are also Workgroup, Web, Compact and Express editions. This last is available for free download and ideal for the small business considering a move to a client-server. The Express edition is also more than capable of producing desktop and small server applications, and can be used commercially. For comparison between editions go here.

In summary, then, SQL Server 2008 has some nice features and is a database that I shall certainly be using more of. Microsoft's also put another component piece in to the game to counter the open-source stack. But it'll cost you and it's late to the game. Were these refinements and new features worth the price of delay? That'll all depend on your requirements and your point of view.®

Combat fraud and increase customer satisfaction

More from The Register

next story
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Oh no, Joe: WinPhone users already griping over 8.1 mega-update
Hang on. Which bit of Developer Preview don't you understand?
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Ditch the sync, paddle in the Streem: Upstart offers syncless sharing
Upload, delete and carry on sharing afterwards?
New Facebook phone app allows you to stalk your mates
Nearby Friends feature goes live in a few weeks
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
prev story

Whitepapers

SANS - Survey on application security programs
In this whitepaper learn about the state of application security programs and practices of 488 surveyed respondents, and discover how mature and effective these programs are.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.