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,... Continue Reading →
Enumerate Database-Role Membership
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. SELECT dbrole1.name AS dbrole1_name , dbrole1.principal_id , dbrm.role_principal_id , dbrole2.name ... Continue Reading →