dsquery group -name “” | dsget group -members | dsget user -fn -ln -samid Read more →
Author: Peter
How to give an IIS app pool folder permissions
Add the local account for the app pool using, for example, IIS AppPool\ASP.NET V4.0 Read more →
Compare XML in Powershell
Compare 2 files and get line number $abc = gc .\z.txt | %{$i = 1} { new-object psobject -prop @{LineNum=$i;Text=$_}; $i++ } $cde = gc .\x.txt | %{$i = 1} { new-object psobject -prop @{LineNum=$i;Text=$_}; $i++ } Compare-Object $abc $cde -Property Text -PassThru -IncludeEqual Read more →
Find user name from domain id
dsquery user -samid <id> or dsquery * -filter “samaccountname=<id> Read more →
Find domain id from user name
dsquery user domainroot -name “name”* | dsget user -samid Read more →
AD Distribution Group or Security Group
dsquery group domainroot -name | dsget group -secgrp Read more →
Limit users who can log in using Remote Desktop
By default, all Administrators can log in to Remote Desktop. If you have multiple Administrator accounts on your computer, you should limit remote access only to those accounts that need it. If Remote Desktop is not used for system administration, remove all administrative access via RDP and only allow user accounts requiring RDP service. For Departments that manage many machines… Read more →
Find domain group membership
gpresult /V Read more →
Benefits of an Enterprise Data Dictionary
source An established data dictionary provides numerous benefits for Federal Student Aid: - Improved data quality: Labelling information consistently, with agreed-upon definitions for data elements and a common set of properties for each data element, makes systems and data analysis easier and business intelligence more effective because of access to high data quality information in the EDD. - Easy access… Read more →
Tips for Sql query performance
The following are a list of good practices I follow when querying large sets of data. SELECT * Avoid selecting all columns from a table. Queries should explicitly list each column it requires Changing column definitions on the underlying tables can have an adverse effect on dependencies such as views, name clashes etc Avoid reading and returning unnecessary data Can… Read more →