Keep 2 IIS servers in Sync
I use a program called MirrorFolder – it’s not bad for smaller websites, but seems to start choking when the total number of files being replicated gets near or above 100,000. If the servers are 2003/2008 Standard or higher, you can do DFS replication, but if you’re on Web Edition, that’s not available.

View Answer   |  July 28, 2010  2:19 PM
IIS, IIS Server, Load balancing, Network Load Balancing cluster, NLB cluster, Web servers

Suggestions for intranet creation
I’d definitely give Drupal a shot. There’s some modules you can add on which should do about everything you are looking for. Definitely a steeper learning curve than SharePoint, and takes a little more administration overall; but if you can spare the resources I think it’s a good bet.

View Answer   |  July 28, 2010  5:08 AM
HTML, Intranet, Java developers, Open source applications

Alternative for LEFT OUTER JOIN
<pre> <li><ol> <ul></ul></ol></li></pre>

View Answer   |  July 28, 2010  5:06 AM
LEFT JOIN, LEFT OUTER JOIN statement, SQL Left Outer Join, SQL statements

Changing Access form properties within your program.
Use AfterUpdate event procedure in VBA. Check the value in combo box and set for the control property Enable=FALSE, otherwise set Enable=TRUE.

View Answer   |  July 27, 2010  6:36 PM
Access, Access form controls, Access forms, Access Forms Database

Software Testing & Quality Assurance Career Planning
Hi Rg10- I’m not familiar with the CSTE, but outside training is not required to take the ISTQB Foundation test. To pass, you need to be very familiar with the syllabus: http://www.istqb.org/download.htm You can achieve that by self study, but since you don’t have any IT experience, a class would help. With your MCA, it [...]

View Answer   |  July 27, 2010  3:56 AM
Certifications, IT career planning, MCA, Quality Assurance Careers, Software Testing Certification

Help with perl script to add information to AD user profile
Go to Microsoft’s Script Center and review their “scripts in their format which you would see what information you would need to “convert” over to perl script format. <a href=”http://gallery.technet.microsoft.com/ScriptCenter/en-us/site/search?f[0].Type=RootCategory&f[0].Value=activedirectory&f[0].Text=Active%20Directory&f[1].Type=SubCategory&f[1].Value=useraccounts&f[1].Text=User%20Accounts&pageIndex=2″>Microsoft’s Script Center</a> (AD Users Section) <a href=”http://docs.activestate.com/pdk/7.3/VBSPerl_overview.html”>Download VBScript converter</a> Sample command to convert (command line): vbsperl inputfile.vbs > outputfile.pl You can use the GUI if [...]

View Answer   |  July 26, 2010  8:16 PM
Active Directory, Active Directory 2003, Active Directory User Profiles, Perl, Scripting, Scripting languages, Windows 7, Windows 7 in 2010

deploying an application in cloud platform
With regards to making deploying applications in a cloud environment easier, it’s important to note that in a cloud environment your applications need to be connected and deployed to thousands of remote servers. Automated deployment can discover remote servers, whether they are in a private or public cloud, and make them available for deployment within [...]

View Answer   |  July 26, 2010  7:49 PM
ASP, C# .NET, Cloud Computing, Web application deployment

Multiple Names in Excel 2007
<a href=”http://www.mrexcel.com/tip138.shtml”>Removing Duplicates in Excel 2007</a> Hope this helps! -Schmidtw

View Answer   |  July 26, 2010  7:14 PM
excel, Excel 2007, Excel Forms, Excel formulas

Scripting help: folders and permissions
I have just posted a <a href=”http://itknowledgeexchange.techtarget.com/powershell/setting-permissions/ “>PowerShell solution</a>.

View Answer   |  July 26, 2010  2:13 PM
Folder security, Group Policy, Public folder permissions, Scripting, Scripting languages

Protocol analyser/sniffer
I have worked with Ethereal/Wireshark anytime I needed to use a protocol analyser. Pretty simple to setup, install it on the computer you are going to use. Now, if you are just looking to hear whats going on in a certain VLAN, all you have to do is plug it into a switch and configure [...]

View Answer   |  July 26, 2010  12:41 PM
C++, Java, Network protocol analyzers, Protocol analysis

SQL SERVER 2005 Security use Kerberos instead of NTLM
You’ll need to setup an SPN for the service using the SETSPN command on a domain controller.

View Answer   |  July 24, 2010  7:43 PM
Kerberos, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server authentication

How to convert the currency in Indian Value in Excel 2003
Hello, just follow the below : 1. Click Start > Settings > Control Panel > Regional & Language Options 2. Click Regional Options Pane Tab > Customize > Currency 3. Click Currency Symbol and type Rs. (in the box, where $ is shown) 4. Click Apply then OK again Apply and OK and close the [...]

View Answer   |  July 24, 2010  4:28 AM
Conversion functions, Excel 2003 functions, Excel Formatting

URL address greater than 255 characters. How to overcome that limit in ABAP
I found the answer to my own question. There is a demo program called SAPHTML_R3HTTP_DEMO. It uses Screen Painter and Menu painter so you have to remember to take care of those. The bread and butter is the following: FORM load_home_page. DATA: doc_url(1024). *(Build your address here.) CONCATENATE html_control->m_http_htmlviewer (build your address here.) ‘wwwdata/SAPHTML_R3HTTP_DEMO’ INTO [...]

View Answer   |  July 23, 2010  6:43 PM
ABAP-program, BAPI, SAP development, SAP ECC 6.0, URL

Access VBA Code stops at Midnight
Do you have any scheduled tasks or a backup job that starts at that time? Does it disable access? When do they become available again? How are the scripts running? If they are running as a user is that user automatically logged off at midnight?

View Answer   |  July 23, 2010  5:16 PM
Microsoft Access, VBA

File Type Associations in Windows 7
Are you asking for something like the appwiz.cpl or the folders command in WindowsXP/Vista? This is hidden in Windows 7. If you don’t like the control panel route, there is a freeware app called “<a href=”http://www.defaultprogramseditor.com”>Default Programs Editor</a>” that lets you find hidden or unassociated file types and add them, as needed.

View Answer   |  July 23, 2010  4:25 PM
Windows 7, Windows 7 Administration, Windows 7 in 2010, Windows controls

Access form to link to Google Maps
I would get help from Google for this one

View Answer   |  July 23, 2010  3:26 PM
Access, Access 2007, Access 2007 form creation, Access 2007 functions, Access Database, Access Database Design

SQL Server 2005 information
Well first you might want to start with one of the two newer versions of Microsoft SQL Server. You can look at the SQL Server certification exams. They will however require a lot of studying and experience, as will getting any job in the field.

View Answer   |  June 19, 2013  6:41 AM
SQL, SQL Server, SQL Server 2005, SQL Server career advice, SQL Server certifications

unable to telnet to 2950 remotely
You need to specify a password on your VTY interfaces. No IOS based device will let you connect to it remotely without one.

View Answer   |  July 23, 2010  12:41 AM
Default gateway problem, SNMP, Telnet, VCL (Visual Component Library)

Business Case to Upgrade to SharePoint 2010
Managed metadata, better search, better disaster recovery, persistent links to files, more robust architecture and 64 bit hardware that you can amortize as a capital expense over time to start. Best business case though is a specific example or projecft that would be very expensive if you did a competitive analysis but which expense covers [...]

View Answer   |  July 22, 2010  7:33 AM
SharePoint 2007, Sharepoint 2010, sharepoint 2010 Upgrade, Visual Basic

save picture in Word document
Well, you can right-click on the image, select ‘copy’, open PAINT, paste the copied image, and save the file as jpg.

View Answer   |  July 21, 2010  10:31 PM
JPEG, Microsoft Word, Office 2007, Word 2007