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 →
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
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.
Today i searched for a way, again, how to export each of my contacts in an MS Outlook PST-Folder into a vCard (.vcf) format. Because Outlook doesn't offer any internal routines to export vCards and the WWW doesn't offer any suitable freeware, too, i made up my mind and a simple vCard export method was... Continue Reading →