Archive for November, 2012

HP I/O Accellerator Card – Test

November 16th, 2012 No comments

This week i had the honor to test a G2-Series HP I/O-Accellerator Card.
Installation and Post-Configuration of the card is very easy. So you could go ahead immediately with testing these Hot Stuff.

We configured the card to 50% Performance, so we loosed 50% of the available space on the I/O-Card. But for our reasons, to put the TEMPDB of MS SQL-Server 2008 R2 and an Archive log of an ERP-System database on it, shoud this be space enough.

So here are the test results. I don’t wan’t to comment to much. Look at the results. They are self explaining. Read more…

Enumerate Database-Role Membership

November 12th, 2012 No comments

Hey Guy’s

here i am with my 1st SQL-Server Post!

If you want to know the membership of a database role, to what other database roles the role
belongs to, i have a good satatement for you.