Feeds

Microsoft measures up

A meter is a meter is a meter. Not

Choosing a cloud hosting partner with confidence

4326 is an example of a Spatial Reference ID (SRID) and the STGeomFromText() method recognizes it and treats the incoming latitude and longitude values appropriately. In past Project Watches, I have suggested that competent IT people could write their own spatial data types, and that's true. However here, in this one method that can recognize and deal with 389 (including WGS 84) different spatial systems, you can see why it would be a great deal of work.

That's the geography related data, then, but what of SQL Server 2008 itself?

Microsoft's approach to security has become very rigorous of late, which is excellent. However, the security policy has clearly not had time to become completely integrated with the rest of the company's policies, as has been highlighted in our work with these core additions to the Microsoft stack.

As an example, Microsoft is keen that we make use of online help - so every time we used the help system Internet Explorer accessed the web. However, by default, the server is configured with IE Enhanced Security Configuration (Esc) set to "on". So all attempts to use the online help system got blocked.

You can, of course, try to add the site to the trusted sites (although this is somewhat tortuous) but it doesn't help because the help system is based upon manifold URLs. So you cannot realistically use the help system unless you disable Esc; which is what we have done. We do understand that you can have Esc "on" for the server and "off" for the workstations but in practice it is still a major inconvenience.

As a side issue, surely anyone who names a security enhancement "escape" either has a very advanced sense of humor or none at all. It is not clear which in this case.

Security aside, where are the stories of smoke, horror and woe in implementing the system on new editions of Microsoft software? You may notice that, so far, I have not said much about how the whole software stack has been running.

Remarkably, this is because - at least until now - the whole stack has been working far, far better than we'd anticipated. We have experienced no catastrophic crashes: neither the SQL Server 2008 database engine nor the Windows Sever 2008 operating system have ever crashed. On two occasions a process crashed in Visual Studio 2008, causing it to run very slowly thereafter. Both times this was cured by the time-honored practice of rebooting the server.

Given that all of the software on the machine is a community technology preview (CTP), and given the hammering it has had, I'm very pleased with this performance. I wouldn't be happy with it in production software but this is CTP. We're using it for development not production and it has proved eminently suitable for the job.®

Follow Register Developer regular Mark Whitehorn next time on Project Watch: Microsoft 2008 as he continues to roll out a spanking-new 1TB database for several thousand users on Microsoft's SQL Server 2008, Visual Studio 2008 and Windows Server 2008.

Secure remote control for conventional and virtual desktops

More from The Register

next story
Netscape Navigator - the browser that started it all - turns 20
It was 20 years ago today, Marc Andreeesen taught the band to play
UNIX greybeards threaten Debian fork over systemd plan
'Veteran Unix Admins' fear desktop emphasis is betraying open source
Sign off my IT project or I’ll PHONE your MUM
Honestly, it’s a piece of piss
Return of the Jedi – Apache reclaims web server crown
.london, .hamburg and .公司 - that's .com in Chinese - storm the web server charts
Chrome 38's new HTML tag support makes fatties FIT and SKINNIER
First browser to protect networks' bandwith using official spec
Admins! Never mind POODLE, there're NEW OpenSSL bugs to splat
Four new patches for open-source crypto libraries
Torvalds CONFESSES: 'I'm pretty good at alienating devs'
Admits to 'a metric ****load' of mistakes during work with Linux collaborators
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.