Feeds

Three short papers about SQL Server

I'll name that instance in one

  • alert
  • submit to reddit

Secure remote control for conventional and virtual desktops

Virtualisation, data networking, enterprise storage, security - and Microsoft SQL Server. The same topics crop up time and again as reader faves in The Reg Library. So here are three of the most popular papers concerned with one aspect of SQL Server or another from the Reg Library.

SQL Server many-to-one protection

This paper from the back-up specialist Double-Take Software heaps faint praise on the named instance architecture of SQL Server 2000 and 2005. Named instances provide complete database isolation while allowing consolidation onto the same server. But it is a bitch for back-ups. Each instance must be maintained separately from the other instances on that server, including service pack updates which must be applied independently of each other. For example, if a server has three named instances, then a new service pack must be applied three times, once for each named instance.

Guess what - Double-Take has a solution to protect the entire database instance. This eliminates manual DBA re-configuration and reduces the downtime experienced during a production failure, according to the company The paper shows you how.

Business Intelligence for the Mid-Market

Business Intelligence (BI) is traditionally seen as viable for the larger enterprise only. But it is now within reach for small and medium sized-businesses, according to this whitepaper commissioned by Microsoft and written by Rod Newing, a computer journalist.

Large corporations have already adopted BI: the earliest adopters gained the greatest advantage, the thesis runs. Now, for very large organisations, the process is returning to stasis. All use BI, so it is more the case that the advantage belongs to those who use it more effectively. So the advantage, in terms of a percentage, has dropped significantly.

The application to smaller businesses is clear, the author argues. Since the take-up has so far been minimal, the initial, huge, competitive advantage is still up for grabs. SAnd the Microsoft pitch? It says Microsoft BI helps contain costs by relieving IT professionals of the need to maintain disparate BI systems. Plus, built on the Microsoft SQL Server 2005 Business Intelligence platform and delivered through the 2007 Microsoft Office system – Microsoft BI is proven and scalable too, the company claims.

McLaren Electronics fuels analysis of Formula One racing data with SQL Server

And lastly, to the most popular case study in the Reg Library, which has nothing to do with the fact that the stud-ee is a sister company of the Formula One race team McClaren.

McClaren Electronic Systems supplies the engine control unit (ECU) that is standardised for all Formula 1 racing cars. The ECU monitors all aspects of the power train components and gathers data from 100-plus sensors in each car. Generating up to one megabyte of data per second, one car’s ECU can gather more than one gigabyte of information from the sensors during a grand prix race.

This is all continuously broadcast in real time back to systems located in the pit-stop garages of each Formula One team. The ECU data collected per car per year (including practice laps and equipment testing) is as much as 2-3 terabytes. But what to do with it all?

This is where SQL Server comes in. After proof of concept testing, McClaren ditched file-based storage in favour Microsoft SQL Server 2008. The company uses the FILESTREAM feature in SQL Server 2008 to store ECU data in a relational database and enable fast retrieval. The paper contains quite a lot of technical information. Glamour and boys' toys aside, this paper is an interesting read. ®

Boost IT visibility and business value

More from The Register

next story
Why has the web gone to hell? Market chaos and HUMAN NATURE
Tim Berners-Lee isn't happy, but we should be
Microsoft boots 1,500 dodgy apps from the Windows Store
DEVELOPERS! DEVELOPERS! DEVELOPERS! Naughty, misleading developers!
Mozilla's 'Tiles' ads debut in new Firefox nightlies
You can try turning them off and on again
'Stop dissing Google or quit': OK, I quit, says Code Club co-founder
And now a message from our sponsors: 'STFU or else'
Apple promises to lift Curse of the Drained iPhone 5 Battery
Have you tried turning it off and...? Never mind, here's a replacement
Uber, Lyft and cutting corners: The true face of the Sharing Economy
Casual labour and tired ideas = not really web-tastic
Linux turns 23 and Linus Torvalds celebrates as only he can
No, not with swearing, but by controlling the release cycle
prev story

Whitepapers

Top 10 endpoint backup mistakes
Avoid the ten endpoint backup mistakes to ensure that your critical corporate data is protected and end user productivity is improved.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Backing up distributed data
Eliminating the redundant use of bandwidth and storage capacity and application consolidation in the modern data center.
The essential guide to IT transformation
ServiceNow discusses three IT transformations that can help CIOs automate IT services to transform IT and the enterprise
Next gen security for virtualised datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.