Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: December 2009

Reporting Services Licensing

Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple instances on one server? Virtualizing servers on a single server? It can get very confusing, very quickly.

I’m regularly asked by a former students, clients, and people in the Forums…

Read more

11 comments, 1,565 reads

Posted in Joe Webb on 17 December 2009

Locking Scripts

Thanks to everyone who attended my TechNet Thrive! and Nashville SQL Server User Group presentations this week! I hope it was worth your while. As promised, here is the presentation.

And here’s the script I used to review the locks.

–examine the resources
WHEN resource_type =…

Read more

1 comments, 196 reads

Posted in Joe Webb on 11 December 2009

Locking & Blocking

On the gridiron, two opposing teams are contending for one very limited resource, the football. One team has it; the other team wants it. The team that has it, tries very hard to protect it by securing the football and blocking all others from getting to it.

The same can…

Read more

0 comments, 237 reads

Posted in Joe Webb on 8 December 2009