« Lamb in wolves skin | Main | SQL Server 2008: Day 0 »
SQL Server 2008
By farseeker | August 11, 2008
Straight off the press and into my hot little hands is an MSDN copy of SQL Server 2008 Developer Edition. As soon as the installation for it finishes downloading a massive update for Visual Studio 2008 (! I know) I’ll (probably, if I can be bothered) post my findings here.
One of the most promising features that I’m looking forward to is the ability to put users into pools, and restrict system utilisation to those in the pool. This is going to be invaluable for us because there’s always one or two people on any given day who run something on the wrong index and bring the server to a halt. Sure this is possibly poor development on our behalf (and sometimes SQL Server’s index selections are off with the fairies), but it’ll be nice to see some server-side ability to stop this behaviour halting the system for others.
Also (although I personally don’t use it), apparently Reporting Services is very, very different.
Topics: General | 3 Comments »
August 11th, 2008 at 2:43 pm
Forgive my ignorance: but couldn’t you just restrict what user could do what and when by permissions or something?
August 11th, 2008 at 3:08 pm
Your ignorance is forgiven. Yes we could restrict it, but only to a certain extent.
1) We’re lazy
2) There’s a few hangovers in our system from when we ran on an ISAM database, which we don’t have the time or budget to work around
3) What the user is doing isn’t technically illegal, if they need the report they’re running then they need that report. We can’t take that report away from them, but we can ensure that that report doesn’t impact the other users on the system
4) The management won’t pay for it
5) SQL Server 2008 includes this functionality at the backend, which is a much more sensible place to put it, and given we’re under maintenance it’s a free upgrade
August 11th, 2008 at 4:02 pm
Thanks for clarifying