A few weeks ago, my colleagues had a spotlight on the common .NET logging library NLog (http://nlog-project.org). This specific class library, provides a lot of functions, methods and classes, to perform logging actions in .NET applications, assemblies, etc. in a very professional way. You can decide what you log, where you log (file, database, mail, console, etc...),... Continue Reading →
If you are a database admin or developer you always should know and take care about, where tables are stored, how much space they consume and how data grows in the tables. One of the golden rules in SQL-Server database development is not to use the PRIMARY file group as the default location for user-tables in your... Continue Reading →
A few days ago, we had mysterious issues with one of our Windows Server 2008 R2 SP1 machines. The problem was noticed, because an information popped up in the system tray, of other terminal servers, that the Remote Desktop Licensing Service is not available on the network. The source server of the problem was found... Continue Reading →
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 →
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
, dbrole2.name AS dbrole2_name
FROM sys.database_principals AS dbrole1
JOIN sys.database_role_members AS dbrm
ON dbrm.member_principal_id = dbrole1.principal_id
JOIN sys.database_principals AS dbrole2
ON dbrole2.principal_id = dbrm.role_principal_id
WHERE dbrole1.name LIKE 'myRole%'
ORDER BY dbrole1.name ASC
I always recommend colleagues to read and watch the thread on sysadminslive.com about the Facebook IT Mangement and Operations strategy. Because the using good tools and ideas to observe there system. Take a look at yourself: http://www.sysadminslife.com/linux/facebook-ein-blick-hinter-die-kulissen-und-in-das-komplexe-system
Hey Folks! currently i'm on the way to deploy a Windows Server 2008 R2 terminal server farm. One server is already up and running productive and the other is one step before going online. I work a lot of with GPO's and user roaming profiles, to ensure to have excatly the same configuration on the... Continue Reading →
Soluto (www.soluto.com) It's an Awesome Tool, to Speed Up Your System Boot, Fix System Slowdowns Sound's very interesting and i'll give them a try. found via Lifehacker (http://tinyurl.com/26py4s2)...
Discovered via Daniel Melanchton's Technet Blog This is really a nice Tool to find existing Group Policies easily. The Group Policy Search Thank's Daniel for that helpful information.