Feeds

Microsoft measures up

A meter is a meter is a meter. Not

Boost IT visibility and business value

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.

Build a business case: developing custom apps

More from The Register

next story
KDE releases ice-cream coloured Plasma 5 just in time for summer
Melty but refreshing - popular rival to Mint's Cinnamon's still a work in progress
Leaked Windows Phone 8.1 Update specs tease details of Nokia's next mobes
New screen sizes, dual SIMs, voice over LTE, and more
PEAK LANDFILL: Why tablet gloom is good news for Windows users
Sinofsky's hybrid strategy looks dafter than ever
Fiendishly complex password app extension ships for iOS 8
Just slip it in, won't hurt a bit, 1Password makers urge devs
Mozilla keeps its Beard, hopes anti-gay marriage troubles are now over
Plenty on new CEO's todo list – starting with Firefox's slipping grasp
Apple: We'll unleash OS X Yosemite beta on the MASSES on 24 July
Starting today, regular fanbois will be guinea pigs, it tells Reg
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
prev story

Whitepapers

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.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.