ASF Network - IT Solution 4u

Download links for Microsoft SQL Management Studio Express editions

2016-03-01T04:20:00.000-08:00

Download links for Microsoft SQL Management Studio Express editions

created by travisschuur on Sep 11, 2013 4:09 PM, last modified by Adam Gindt on Sep 11, 2013 4:17 PM

Version 1

Often when troubleshooting database related issues for Shavlik Protect you will need to be able to use SQL Server Management Studio. If you have an express edition of SQL installed you will not have management studio by default. Here is a listing of the download links for Microsoft SQL Management Studio Express editions:

2005: http://www.microsoft.com/download/en/details.aspx?id=8961

2008: http://www.microsoft.com/download/en/details.aspx?id=7593

2008 R2: http://www.microsoft.com/download/en/details.aspx?id=22985

2012: http://www.microsoft.com/en-us/download/details.aspx?id=29062

*Note for 2012: Click Download, then ensure to check ENU\x64\SQLManagementStudio_x64_ENU.exe or ENU\x86\SQLManagementStudio_x86_ENU.exe in the download list depending on your system's OS architecture.

These links lead to downloads hosted by Microsoft. Shavlik does not host these downloads in any way or provide support for Microsoft SQL Server. The links are current and last checked as of September 11, 2013.

Running Large Scale Perfomance Tests

2016-03-01T01:30:00.002-08:00

Running Large Scale Tests

BlazeMeter gives you all the resources you need to execute large scale tests 'on the fly'.

This article will show you the steps you should take to run a load test of more than 50K concurrent users.
Quick Overview of the Steps

Write your script
Test it locally with JMeter
Run BlazeMeter SandBox Testing
Setup the amount of Users-per-Engine using 1 Console & 1 Engine
Setup and test your Cluster (1 Console & 10-14 Engines)
Use the Multi Test feature to reach your max CC goal

Step 1 : Write Your Script

There are various ways to get your script:

Use the BlazeMeter Chrome Extension to record your scenario
Use the JMeter HTTP(S) Test Script Recorder. This sets up a proxy so you could run your test through and record everything
Go manually all-the-way and construct everything from scratch. This is more common for functionality/QA tests

If you get your script from a recording (as in steps 1 & 2), keep in mind that:

You'll need to change certain parameters, such as Username & Password, or you might want to set a CSV file with those values so each user can be unique.
You might need to extract elements such as as Token-String, Form-Build-Id and others using Regular Expressions, JSON Path Extractor, XPath Extractor. This will enable you to complete requests like "AddToCart", "Login" and more...See this article regarding these procedures
You should keep your script parameterized and use configuration elements like HTTP Requests Defaults to make your life easier when switching between environments.

Step 2 : Testing Locally With JMeter

Start debugging your script with one thread, one iteration, and using the View Results Tree element, Debug Sampler and Dummy Sampler. Keep the Log Viewer open in case any JMeter errors are reported.
Go over the True and False responses of all the scenarios to make sure the script is performing as you expected.
After the script has run successfully using one thread, raise it to 0-20 threads for ten minutes and check:

Are the users coming up as unique (if this was your intention)?
Are you getting any errors?
If you're running a registration process, take look at your backend - are the accounts created according to your template? Are they unique?
Test statistics on the summary report - do they make sense (in terms of average response time, errors, hits/s)?

Once your script is ready:

Clean it up by removing any Debug/Dummy Samplers and deleting your script listeners
If you use the Listeners (such as "Save Responses to a file"), make sure you don't use any Paths! If it's a Listener or a CSV Data Set Config make sure you don't use the path you've used locally, use only the filename instead (as if it was on the same folder as your script)
If you're using your own proprietary JAR file(s), upload them.
If you're using more than one Thread Group (or not the default one) - set the values before uploading them to BlazeMeter.

Step 3 : BlazeMeter SandBox Testing

If that's your first test, take a look at this article on how to create tests in BlazeMeter.
The Sandbox is actually any test which has up to 20 users, uses only the console, and runs for up to 20 minutes.
The Sandbox configuration allows you to test your script, backend and ensure everything works well.
Here are some common issues you might come across:

Firewall - make sure your environment is open to the BlazeMeter CIDR list and whitelist them
Make sure all of your test files e.g: CSVs, JAR, JSON, User.properties etc. are present
Make sure you didn't use any paths

If you're still having trouble, look at the logs for errors (you should be able to download the entire log).
A SandBox configuration can be:

Engines: Console only (1 console , 0 engines)
Threads: 1 -20
Ramp-up: 300-1200 minutes
Iteration: Test continues forever
Duration: 10-20 minutes

This will allow you to get enough data during your ramp-up period to analyze the results and ensure the script was executed as you expected.
You should also check the Monitoring Report to see how much memory & CPU was used. This should help you with step four.

Step 4 : Setup The Amount Of Users-Per-Engine Using 1 Console & 1 Engine

Now that we're sure the script runs flawlessly in BlazeMeter, we need to figure out how many users we can apply to one engine.
Here is a way to figure this out without looking back on the SandBox test data.
Set your test configuration to:

Number of threads: 500
Ramp-up: 40 minutes
Iteration: forever
Duration: 50 minutes
Use 1 console and 1 engine.

Run the test and monitor your test's engine via the Monitoring Report.
If your engine didn't reach either a 75% CPU utilization or 85% memory usage (one time peaks can be ignored) :

Change the amount of threads to 700 and run the test again
Raise the amount of threads until you get to 1,000 threads or 60% CPU

If your engine passed the 75% CPU utilization or 85% Memory usage (one time peaks can be ignored):

Look at when your test first got to 75% - and see how many users you had at this point.
Run the test again. This time, instead of putting a ramp-up of 500, enter the amount of users you got from the previous test
Set the ramp-up time you want for the real test (5-15 minutes is a great start) and set the duration to 50 minutes.
Make sure you don't go over 75% CPU or 85% memory usage throughout the test

You can also go safer and decrease 10% of the threads per engine.

Multi Location Tests

BlazeMeter uses a variety of cloud providers which have different types of machines and network infrastructures.
For a Multi Location test (CDN test) which runs engines on all of our cloud providers, it's recommended to ensure that every load engine, regardless of the cloud provider, can sustain the load and bring about the desired outcome.

Step 5 : Setup and Test Your Cluster

We now know how many threads we can get from one engine. At the end of this step, we'll know the amount of users one Cluster (test) can get us.
A Cluster is logical container which has one console and 0-14 engines.
Even though you can create a test with more than 14 engines, it actually creates two clusters and clones your test.
The maximum number of 14 engines per console is based on BlazeMeter’s own testing to guarantee that the console can handle the pressure of 14 engine. This creates a lot of data to process.
So, at this step, we'll take the test from step four, and change only the number of engines by raising them to 14.
Run the test for the full length of your final test. While the test is running, go to the Monitoring Report and:

Verify that none of the engines pass the 75% CPU, 85% Memory limit
Locate your console label (to find it, go to the Logs Report -> console’s log and look for its private IP). This should not reach the 75% CPU or 85% Memory limit.

If your console reached that limit - decrease the number of engines and run again until the console is within these limits
By the end of this step, you should know:

The Users per Cluster you'll have
The Hits/s per Cluster you'll reach

For more information about your Cluster's throughput, look at the statistics in the Aggregated Report.

Step 6 : Use the 'Multi-Test' feature to Reach Your Maximum CC Goal

We've got to the final stage!
We know the script is working, we know how many users one engine can sustain, and we know how many users we can get from one Cluster.
Let’s assume these values:

One engine can have 500 users
The cluster will have 12 engines
We aim to test for 50K users

To do this, we'll need to create 50,000 \ (500*12) = 8.3 clusters..
We could go with 8 clusters of 12 engines (48K) and one cluster with 4 engines (the other 2K) - but it's better to spread the load like this:
Instead of 12 engines per cluster, we'll use 10. Therefore, we'll get 10*500 = 5K from each cluster and we'll need 10 clusters to reach 50K.
This helps us as we:

Don't have to maintain maintain two different test types
We can grow by 5K by simply adding the same cluster\test again to the 'Multi Test' configuration (5K is much more common than 6K)

We're now ready to create our final Multi-Test with 50K users:

Select 'Add Multi-Test' (See image no. 1 below)
Add the test that you verified in step five. You can add it by using the Drag-and-Drop feature as many times as you need - it will simply duplicate itself (see image no. 2 below)
You can change the configuration of each test to load from a different region, have a different script/csv/other file, use a different network emulation, different parameters etc.
Your Multi-Test for 50K users is ready to go. Press start on the Multi-Test to launch all tests with 5K users from each one.
The aggregated report of your Multi Test will start generating results in a few minutes. You can also see the results of each individual test by simply opening it's report.

Setup A Multi-Test

Running The Multi-Test

1. After saving the test and pressing the 'play' button, you'll be notified that you're about to launch a new load.
2. You'll also be given the option to select 'Synchronized Start' to ensure that all the servers are up before actually starting the test. This option is useful if you're concerned that some servers or locations are significantly slower than others and you want to synchronize them.
3. After pressing 'Launch Servers', you'll be shown the 'Booting' Window. This shows you the progression of launching the load engines and consoles across the entire Multi Test.
Thats it! Your Multi-Test is up and running!
If you'd like to know how to analyse the Multi Test Report, please check out this article

Convert Data from MySQL into MSSQL

2016-03-01T01:29:00.002-08:00

Convert Data from MySQL into MSSQL The Easy Way (via MS Access)

by azamuddin | posted in: story | 0

Intro:

Sometimes we are facing a situation when we need to migrate our database from MySql into MSSQL. This migration is not as easy as we might think, try to google it, you will understand why. There actually a simple way like using mysql db connector, but in an older version of windows for example windows server 2003, you might get trouble installing this connector due to no ANSI driver found. I haven’t found how to workaround this problem. I’ve been dealing with this task for a whole day, and with the help of my Lord, I finally able to find the solutions at the very end of the day.

Options:

1. Using mysql db connector connector

Problem: ANSI Driver could not be found on windows 2003 (probably on other versions as well)

2. Export .SQL from MySQL with MSSQL support then Import it on MSSQL Management Studio

Problem: The SQL syntax generated by MySQL are not compatible with MSSQL. Resulting query can not be executed.

3. Using Import data from File

3. a. Excel

Problem: Compatibility issues is likely to be found probably because of the nature of Excel that’s not fit to store data especially if you have a binary data.

3. b. CSV

Problem: if you have binary data, the content will ruins the CSV.

3. c. Access

This is the only option that works for me. I’ll explain how to do this.

Solution:

I mention specifically MSSQL on windows 2003, but if you have the same problem in different version of windows, you might try this too. The solution I’ll explain is converting MySQL to MSSQL via Microsoft Access.

Software involved (in my case):

1. Microsoft Access 2013 installed on windows 7 or newest.

2. MySQL DB Connector installed on windows 7 or newest.

Steps Overview:

A. Create DataSource from MySQL;

B. MySQL to MS Access;

C. MS Access to MSSQL.

Steps:

A. Crate DataSource from MySQL

1. on your newest machine, open ODBC from control panel > administrative tools;

2. configure your MySQL connection information;

3. save DSN, example “my_mysql_connection_dsn”.

4. done

B. MySQL to MS Access

1. open blank database on MS Access;

2. click tab “External Data” from the top ribbon;

3. click ODBC Data Sources;

4. select the File DSN and choose your MySQL connection string DSN file (“my_mysql_connection_dsn”);

5. select all the table you want to import from MySQL;

6. when done the selected tables will be populated on your MS Access DB;

7. save the file as MS Access database 2000 – 2003 (.mdb);

8. done.

C. MS Access to MySQL

1. on your MSSQL Management studio, create new database to hold data you want to convert from MySQL;

2. right click that newly created database from the tree menu, choose tasks > import data;

3. on the next wizard, click next then from the Data Source dropdown choose Microsoft Access;

4. then choose the (.mdb) file which previously saved as from part A;

5. follow the wizard and select tables needed to be imported;

6. voila, your tables now are available on MSSQL;

7. done.

*sorry I can’t give you screenshot, the windows server is in my office and I write this at my small room. Hopefully I can update the screenshot later.

Recover Windows Boot Problem

2016-02-29T17:57:00.000-08:00

From : http://www.aitechsolutions.net/winxpnoboot.html

Safe mode boot frozen at mup.sys

The last driver that loaded may be mup.sys. To solve that issue on a number of systems, I performed this manual
restore procedure for the windows XP registry.

Running Chkdsk from the Windows XP Recovery Console

Boot your system from the XP installation CD. If you don't get the choice when you restart with the CD in the drive you may want to check the boot order in your BIOS
It will take some time to load but you should eventually see the XP Setup screen. Press R to enter the Recovery Console
Select your windows installation. Enter 1 or if you have multiple installations select the 1st or default instance of XP which should be the broken one
Supply the administrators password or if you do not know it, just try no password (Enter) which may be the default.
Forgot the administrators password? There are bootable Linux based utilities that can help but be very careful!
One you might try is the NT Password and Registry editor. Please see their site for downloading and support.

(As I understand it a win2K bootable install cd may be used on an XP system and not require a password because of differences in the win 2000 and XP SAM. May be worth exploring as a last resort. Your mileage may vary)

If you don't have your Windows recovery or install disk available there are other methods with their own set of procedures but the theory is the same. The specific procedures on how to use them is beyond the scope of this article which is long enough already! I can however point you to some useful recovery utilities.

Using these windows recovery utilities you can still perform the below tasks to recover your registry after you take into consideration the procedural differences and successfully bring your Windows XP system back to life.

To copy and rename Windows XP registry files you could try the NTFS for DOS utility from a bootable floppy or CD. This utility also has a version of chkdsk to help aid in fixing corruption on the NTFS formatted hard disk.

A utility CD can be had that has both the NTFS for DOS and the Linux based NT Password and Registry editor mentioned above as well as much more. Consider checking out the Ultimate Boot CD for Windows.
Please see the individual sites for downloading and support information.
Run chkdsk /p /r (The /p option forces testing on a non-dirty flagged drive The /r is implied but added for
good measure). If it finds errors it should try to fix them. Re run chkdsk and make sure it comes up clean.

So now you think all is OK since chkdsk "FIXED" the errors and that your good to go, right? Not so fast. It
should have corrected the filesystem's integrity but even with that fixed, corrupted files may still exist. But ...
Exit the recovery console by typing exit at the command prompt and hit enter
Your system should restart automatically. If not hit reset or cycle power
If your system restarts ok now fantastic. The issue was not that serious and chkdsk fixed it! Congratulations!
If unfortunately your system does not come up, you should the follow the restoring XP registry sections below

Restoring the Windows XP registry to a bootable configuration
General instructions and conventions

If your system won't boot successfully, you may have a corrupted registry. The following is the first step in the restoring your windows xp registry procedure that will enable you to boot your system with generic registry information. Note: The following assumes you are using the NTFS filesystem and that your windows directory is C:\WINDOWS. If your are using the FAT32 filesystem, some instructions may not apply or be slightly different. I'll try and note where the differences exist. If your windows directory is different than C:\WINDOWS then substitute the correct value in the following instructions. Also! It is important you type all instructions exactly as shown! Commands you need to type in will be displayed in lower case, a larger font, and a different color. FYI, Windows doesn't really care about case but I will use this convention for clarity. I will prefix commands with the command prompt that includes the current working directory. The Command Prompts will be in upper case as this is how they are displayed. Yours should look the same and we can use this verify you are in the correct directory. Be sure to pay attention to this as working with the command line is not at all forgiving! If for some reason your command prompt doesn't reflect the current working directory, you can try executing this command at the prompt. set prompt $p$g As a FYI, There are ways to automate some of this process and/or read the commands from a text file using the recovery console. I'll leave those options to your imagination or possibly a future article. Let's get started!

Backing up your current primary registry files
- Very Important, Do not skip! -

Boot your system from the XP CD. At the XP Setup screen press R to enter the Recovery Console.
Select the installation you want to work with (Usually 1)
Log on the the desired installation with the administratiors password.
If you don't know the password you can try just hitting Enter.

You should now be at a C:\WINDOWS> prompt.

First we will make a new directory to use for backup and as a scratch area.

At the C:\WINDOWS> prompt enter:

C:\WINDOWS>md mytmp
Use the dir(ectory) command to verify the directory was created (Optional)

C:\WINDOWS>dir m*

Now we'll back up your current configuration(registry). We should not need those files anymore but it's good just to be safe and it's free.

Change your current working directory from C:\WINDOWS to C:\WINDOWS\SYSTEM32\CONFIG.

C:\WINDOWS>cd system32\config

Your command prompt should now be: C:\WINDOWS\SYSTEM32\CONFIG>.

Now we will copy the following 5 registry files.

C:\WINDOWS\SYSTEM32\CONFIG>copy system c:\windows\mytmp\system.bak
C:\WINDOWS\SYSTEM32\CONFIG>copy software c:\windows\mytmp\software.bak
C:\WINDOWS\SYSTEM32\CONFIG>copy security c:\windows\mytmp\security.bak
C:\WINDOWS\SYSTEM32\CONFIG>copy sam c:\windows\mytmp\sam.bak
C:\WINDOWS\SYSTEM32\CONFIG>copy default c:\windows\mytmp\default.bak

Now these files are backed up to \MYTMP. Execute the following dir command to check.

C:\WINDOWS\SYSTEM32\CONFIG>dir c:\windows\mytmp

You should see the five files listed: default.bak sam.bak security.bak software.bak system.bak It wouldn't be a bad idea to compare the file sizes with the originals, that's your choice. To show the file sizes of the originals just execute the dir command.

C:\WINDOWS\SYSTEM32\CONFIG>dir

Restore base registry hive files from original installation

Now we will replace the registry with the base files created\saved during the initial windows XP installation. This will enable us to boot the system normally and access the system restore files. BTW, I know there are some Windows gurus out there that can restore the registry from your last checkpoint using the recovery console without booting Windows XP itself but that is an even more tedious procedure and we want to make this as painless as possible. Besides, If you already know how to do that you are probably not reading this article anyway. Enough digression. Back to business. Your current directory should still be C:\WINDOWS\SYSTEM32\CONFIG. If not make it so! Copy these five files. Make sure you are in the C:\WINDOWS\SYSTEM32\CONFIG Directory and check your spelling! Please, DO Not overwrite any files or folders in the C:\WINDOWS\REPAIR Directory! Also note the single space between the filenames at the end of the following commands. When you get the warning about overwriting the destination file, Press Y to allow it.

C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\repair\system system
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\repair\software software
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\repair\security security
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\repair\sam sam
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\repair\default default

Now we should have good (albeit somewhat generic) registry files back in place.

Change the system date and boot XP with the base registry

Exit the recovery console and restart, Before it boots enter your BIOS setup
Change the date to the previous month. Make note of this date so we can reference it further along in the
process. It will make things easier. I'll explain later
Save and exit BIOS setup

Don't boot the Windows CD. Do a normal non-safe mode boot from the hard drive. Depending on your system you may need to take out the CD from your optical drive. If you followed along precisely, Your previous registry was corrupted, The repair files from you previous windows XP install were in good shape, and of course, there is no other show stoppers here, you should be greeted by something you havn't seen in a while! A Windows XP Welcome screen! You may notice your user ID(s) are not one of the selections. This is because of the generic registry that is loaded. Note: System Restore is turned on by default. The following procedure assumes you have NOT turned off System Restore.

Manually restoring the XP registry from a Restore CheckPoint
Enabling access to restore files

Logon to your system as someone with administrator privliges (administrator is fine)
As mentioned previously, you may be required to re-activate your system so keep your product key handy
If you system restarts or goes back to the logon screen after entering the correct User ID or password your
system may have been affected by some type of malware or virus affecting userinit.exe.
See a related article link on Logon Loops from the Microsoft KB in the right panel.
(This is an old issue but stay tuned, We may add more on this issue later depending on your feedback)

Next we need to change some options so we can access hidden and system files created by System Restore.

Open up windows explorer (Right click start and select explorer)
Click tools, click Folder Options... and under the view tab uncheck the "Hide OS Files" checkbox and
Select/Check the box for "Show hidden files and folders".
Also, If you have XP Pro, scroll down to the bottom and uncheck "Use Simple File Sharing"
Click apply and OK

We'll change these all back later when we're done.

In explorer go to the root of the system drive (C:\ most likely) and open the System Volume Information folder

NOTE: If you can not find this folder then either it is still hidden or System Restore was not enabled on your system prior to the failure. Please recheck you have followed the above procedures to make the folder visible and accessible. If the folder is still not visible then it may not exist and in that case you can not proceed with the restore. Try the below security actions, they may help but if the folder is still not visible it likely does not exist. However, Since the system is now accessible you may want to try backing up your important files and data to restore later as a windows reinstall may be necessary. Help! I get a security error when I try to open the System Volume Information folder

Right click on the System Volume Information folder and select sharing and security...
If you are running XP Pro, skip ahead to the "If you are running XP Pro..."
If you are running XP Home go under the sharing tab and select both checkboxes in the Network
Sharing and Security section and click apply. If you get a warning about filenames over 12 characters
in regard to windows 98/ME, Click Yes, and Click Apply

Skip the next section on XP Pro and continue from the "Now open the System Volume Information folder" step further down the page. If you are running XP Pro follow closely.

Click on the Security tab.
If you don't see the Securiy tab go back to tools, Folder Options and make sure you unchecked Use
Simple File Sharing in the previous step.
Click add and click the advanced button. In the select users and groups box click "Find Now" and
select your user name/RDN from the list at the bottom

Be sure you select a user and not a group. For example, if your user id is administrator, Make sure you select the administrator user (Icon with one head). Do not select the administrators group (Has an icon with two heads).

Click OK, Apply and OK

Extracting registry files from System Restore created CheckPoints

Now open the System Volume Information folder

NOTE: As mentioned previously, If you can not find this folder then either it is still hidden or System Restore
was not enabled on your system prior to the failure. Please recheck you have followed the above procedures
to make the folder visible and accessible.

If the folder is still not visible then it may not exist and in that case you can not proceed with the restore.
However, Since the system is now accessible you may want to try backing up your important files and data
to restore later as a windows reinstall may be necessary.

For those continuing from the previous section - This is where the changed date in the BIOS comes into play!
When we booted Windows with the generic registry it likely created a folder here which would normally be the
newest folder. What it now did was create a folder with the older date you specified. Since we don't want the
restore data from that folder, it is now easier to identify the folder we want to use.
See, there is a method to this tedious madness so hang in there OK !
Open the newest folder named _restore{some hex digits called GUID's}

You should now see a number of folders named RP##. These are Restore Points.

Open the latest Restore Point folder (It may be a different color than the rest)
Open the folder called snapshot
Multi-Select the following "_REGISTRY_MACHINE_" files:
_REGISTRY_MACHINE_SAM
_REGISTRY_MACHINE_SECURITY
_REGISTRY_MACHINE_SOFTWARE
_REGISTRY_MACHINE_SYSTEM
_REGISTRY_USER_.DEFAULT (Note the dot prefix)
Right click on the highlighted files and select copy
Drop\Paste these into the C:\WINDOWS\MYTMP folder we created earlier
Rename these files by deleting off the _REGISTRY_MACHINE_ portion
Note: Do not copy over, rename or modify the files with the *.bak extension in \mytmp you created\saved earlier

For example: _REGISTRY_MACHINE_SAM becomes just SAM Also, don't forget to remove the dot in the name for the .default file!

Exit explorer and restart with the XP CD in your optical drive
Before you boot the XP CD enter the BIOS Setup and correct the date/time!
Save and exit the BIOS, Restart, When promped to boot from CD, Do it!

Import extracted checkpoint registry files into the current active registry

We are going back to the recovery console so we can copy in the extracted registry files to the current active configuration. This needs to be done when windows is not running otherwise they are locked and therefore can't be replaced.

At the XP Setup screen, Press R at the XP setup screen to enter the recovery console
Select the installation you want to work with (Usually 1)
Log on the the desired installation with the administratiors password

Now back at the C:\WINDOWS prompt: Change your current working directory from C:\WINDOWS to C:\WINDOWS\SYSTEM32\CONFIG

C:\WINDOWS>cd system32\config

Your command prompt should now be: C:\WINDOWS\SYSTEM32\CONFIG> Make Sure! Enter each command below and Type Y when prompted to overwrite. Also note the single space between the filenames at the end of the command lines!

C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\mytmp\software software
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\mytmp\system system
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\mytmp\security security
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\mytmp\sam sam
C:\WINDOWS\SYSTEM32\CONFIG>copy C:\windows\mytmp\default default

This Is IT ! The moment we have been waiting for!

C:\WINDOWS>exit

Exit the recovery console and Restart!
As before, You may need to cycle power as ctrl-alt-del may not work

You can remove the XP CD from your optical drive and put it away for safe keeping. Note that during this particular startup Windows needs to rebuild itself and it will take some time so be patient. It is best to wait until most of the major HD activity is finished before you logon. I've seen a non-responsive keyboard issue occur when trying to enter your password. If that happens to you, just give it a minute and try again. Now you should be back at your original configuration with all the applications, settings and updates that were in effect at the time reflected by the selected Restore Point. Congratulations! Great Job! If this somehow is not the configuration you want you can always go back to System Restore in the normal fashion and load a different restore point. You can get there by START>ACCESSORIES>SYSTEM TOOLS>SYSTEM RESTORE and selecting another restore point using the wizard.

Restore security settings for system restore folders

Now, If you have not done so already there are a few items you need to address once you feel all is stable and have restarted a few times. Logon to your system as a user with administration privleges To enhance security: Bring up Explorer (Right Click START), Click on tools, Click Folder Options, Click the View tab 1. Under hidden files and folders, Set the "Do not show hidden files and folders" radio button 2. Make sure there is a check in the "Hide protected operating system files" item 3. (XP Home) While you are still in explorer navigate to the C:\System Volume Information folder, Right click, select Sharing and Security..., In the Sharing, Network and Security section deselect the two checkboxes, Click Apply and OK. or 3. (XP Pro) Navigate to the C:\System Volume Information folder, Right click, select Sharing and Security..., Open the Security tab, Highlight (ONLY) the user (One headed Icon) that was added previously and click the remove button. Please Do Not remove the SYSTEM or Everyone Groups! When you are sure click Apply and OK 4. (XP Pro) Click on tools, Click Folder Options, Click the View tab, Scroll to the bottom and make sure there is a check in the "Use simple file sharing" item

Fall back procedure ( If Needed ONLY ) - Pre-procedure Registry files restore

If for some reason you would need to revert your registry files back to what they were before you started
this procedure, here are the instructions.

NOTE: This is NOT part of the recovery procedure. This process is only be used if you have a specific
reason for example by way of some technical support or other recommendation.
This will revert your system back to the original failed state

Boot your system from the XP CD. At the XP Setup screen press R to enter the Recovery Console.
Select the installation you want to work with (Usually 1)
Log on the desired installation with the administrators password.
If you don't know the password you can try just hitting Enter.

You should now be at a C:\WINDOWS> prompt.

Now we will change to the directory you created in the beginning of the procedure where you had
saved the then current registry. Here we will assume the directory is C:\WINDOWS\MYTMP as per
the procedure described earlier and the files have the recommended .bak extension.

At the C:\WINDOWS> prompt enter:

C:\WINDOWS>cd mytmp
Use the dir(ectory) command to verify the 5 files backed up (*.bak) previously are still there

C:\WINDOWS\MYTMP>dir

We will now copy these saved files to the %windir%\system32\config directory where XP looks for your current registry
Make sure you are in the C:\WINDOWS\MYTMP directory and double check your spelling! Note the single space between the filenames separating the source and target in the following commands. When you get the warning about overwriting the destination file, Press Y to allow it.

C:\WINDOWS\MYTMP>copy system.bak c:\windows\system32\config\system
C:\WINDOWS\MYTMP>copy software.bak c:\windows\system32\config\software
C:\WINDOWS\MYTMP>copy security.bak c:\windows\system32\config\security
C:\WINDOWS\MYTMP>copy sam.bak c:\windows\system32\config\sam
C:\WINDOWS\MYTMP>copy default.bak c:\windows\system32\config\default

Once this is completed you have restored your system back to the original registry state it was in before you started this restore\recovery procedure.

SMS Gateway

2012-08-25T03:24:00.000-07:00

Get you own sms gateway now and SMS messaging can add value to common business applications!

SMS Gateway is a software develop to read information from you database and send info through sms.

SMS Gateway application :: -

Mission critical systems alert message : "Alert! Database server DB02 is not responding!"
Customer information, order status : "Your order no C-G8899 has shipped"
Appointment remainder : "You have an appointment with Dr. Smith tomorrow at 4:45pm"
Production output : “Factory A : 9,897,657, Factory B : 13,900,893”
Marketing tools : "This weekend only - up to 40% off in store"
Revenue Opportunities: Up-to-the-minute info for paid subscribers:

"Today's forecast: A high of about 60 degrees, with light rain in the afternoon....."
"Stock Price Alert: GTRT has dropped below $5.75 a share."
"Breaking News Alert: A three alarm fire is now raging in downtown..."
"Traffic Advisory: A car is blocking the right lane on the northbound 404..."
"You've been outbid on auction no 445311"

PHP Point Of Sales

2012-08-24T18:01:00.000-07:00

PHP Point of Sale
Platform: LAMP
Type: Retailer POS
Description: Web based Point of sale suitable for small and medium stores. It has master database for customer, sales, supply, employee and provides flexible reporting. However being a web based POS it has limited support for POS printer and cashdrawer.

Point of Sale (POS) usually found in shops and restaurants to record everyday sales. PHP POS is a web-based system, no need for special hardware. PHP POS can store all customer records, supplier records and all sales records. Shop manager can view the latest sales information by viewing sales reports online. The system can automatically generate a barcode (image) for each product, it helps to reduce human input error if a barcode reader is available.

Point of Sales

Price:RM 499 or RM 49 monthly

Description:

Free open source point of sales:
Manage your store online -
1. Manage Inventory & Process Sales
2. Multiple Employees
3. Excel Import & Export Capability
4. Customer Tracking
5. Source Code Modification

Try it free here :
http://pembeda.com/pos
login id : pembeda
password : bismillah

2 option to grab :
1. subscription : RM 49 / monthly
2. download & hosted yourself : RM 499 (one time)

To customize, Please contact admin@pembeda.com

source

source2

pembeda.com

2012-08-23T20:52:00.000-07:00

An CSR project by ASF Network. The purpose is to get muslim or man kin in general to get close to alquran their guide to live in this world created by GOD. At the moment this project still in phase 1 and the development still in progress as a lot off module still develop especially 'harfiah' and vocabulary enrichment.

Auto-Identification and Data Collection Gateway

2012-08-23T19:03:00.002-07:00

Take control and reduce cost, start counting you profit by using aidc gateway!

AIDC gateway is a software to read data from a barcode reader through an TCP/IP protocol (LAN network). It can handle multiple scanner and very efficient to capture data from barcode reader.

AIDC Gateway application :: -

Small & Medium Enterprise (SME)
- Inventory Control System - view solution detail
- Asset Tracking System - view solution detail
- Time & Attendance system - view solution detail
- Point of Sales System - view solution detail
- Manufacturing System - view solution detail
Manufacturing

Inventory management
Materials management
Shipping/receiving
Warehouse management
Work-in-Process (WIP) tracking
Asset tracking & management

Warehousing / Distribution

warehouse and supply chain

Transportation / Logistic

Yard Management
Fleet Management
Mobile Dispatch & Delivery
Cross-Docking
Terminal & Distribution Center Operations
Shipping & Railway Operations
GPS
Telemetry
Remote Management
RFID Solutions

Healthcare

Field Service

Retail

Goverment

Inventory and Asset Management
Identification
Administration
Non-Emergency Operations

Education

Student, Staff and Visitor ID Badges
Class Registration
Attendance Tracking
Access Control for Secure Buildings or Rooms
Meal Plan Management
Library Cards and Inventory Management
Electronic Payment Card for Bookstore

Safe Box System

2012-08-22T01:04:00.000-07:00

Safe Box System

Thumb Print Time Attendance

2012-08-22T01:02:00.001-07:00

Thumb Print Time Attendance

2012-08-22T01:02:00.000-07:00

Thumb Print Time Attendance

Parking Attendant System

2012-08-22T01:01:00.000-07:00

Parking Attendant System

Totmato Cart

2012-08-22T00:54:00.000-07:00

There are a lot of choice of opensource cart package, one of the best is tomato cart. It clean and realy focus on cart.

Site Mangement

In addition to the core site management tool, TomatoCart brings forth new ideas such as web mail, maintenance mode and department manager for a better user experience.
Site Management highlights include:

Multi-lingual and Multi-currency support
Separate web mail
Accessibility per role

Catalog Management and Browsing

TomatoCart provides a clear catalog layout, simplifying your work.
Catalog Management and Browsing highlights includes:

Unlimited product categories with images associated
Reviews and Ratings Management
Search Box with Auto Search suggested Terms

Product Management and Browsing

TomatoCart supports sales of both physical and virtual goods. These products are well arranged in various manners.
Product Management and Browsing highlights include:

Four kinds of products supported
Separate price and stock management based on attribute combination
Product image zoom and light box to display large images
Customer Management

TomatoCart provides a lot more than address book and store credits, including quite a few administration tools and customer-generated content.
Customer Management highlights includes:
Support for unlimited customer groups
Add and edit customers in admin panel
Support order discount for each customer group

Order Management

Many additional cases such as printing invoices have been taken into TomatoCart’s consideration.
Order Management highlights include:

Add orders in admin
Print invoices and packaging lists from the order screen
Credit Slip or Store Credit for merchandise return

Payment

People from different countries have different favored payment methods. Just pick the right one for you among the 26 built-in payment methods in TomatoCart.
Payment gateways include:

Amazon IPN
Authorize.net
PayPal

Shipping

TomatoCart provides basic shopping options for customers. You are allowed to choose shipping methods based on zones and set different prices for each.
Shipping methods include:

Flat Rate
Table Rate
USPS

Checkout

Checkout shouldn’t be a big hassle for online shoppers. It is quick and easy with TomatoCart.
Check-out highlights include:

One-Page Checkout
Checkout without accounts
Ajax Shopping Cart

Statistics and Reports

Analytics is the key to knowing what is going on with your website. TomatoCart provides you with a comprehensive report list.
Statistics and Reports highlights include:

Products reports
Order reports
Web Analytics Reports

Promotion tools and SEO

TomatoCart covers nearly all popular and effective promotion tools for online sales. Our SEO tools help bring you good results when customers are searching via search engines.
Promotion tools and SEO highlights include:

Catalog Promotional Discount
Product discounts based on quantity or customer groups
Search Engine Friendly URLs

Content Management System

TomatoCart has a sophisticated CMS. Templates can be switched and modules can be manually organized.
CMS highlights include:

Easily upload and install front end templates
Content module -- Slide Show based on noobSlide slide show component
Box module -- Products Scroller based on noobSlide slide show component

Content Management System

2012-08-22T00:39:00.000-07:00

Joomla 1.5

Joomla 1.5 is the best solution for small and medium enterprise, it has all you want for your business. It can be your portal, your intranet and your sales & makerting tools.

Joomla is used all over the world to power Web sites of all shapes and sizes. For example:

Corporate Web sites or portals
Corporate intranets and extranets
Online magazines, newspapers, and publications
E-commerce and online reservations
Government applications
Small business Web sites
Non-profit and organizational Web sites
Community-based portals
School and church Web sites
Personal or family homepages

Intranet

2012-08-21T21:08:00.000-07:00

Do it you self, practical, no API, raw php, mysql, straight forward ....

Although there are many option to choose for your intranet, but this one is very straight forward php programming, easy and fast to troubleshoot. Basic interface and easy cut and paste programming.

For a basic intranet need, this package is for you, learn and add any module your self and you will be satisfy.

For an practical in house development, this intranet package is a very goo start for you company.

Basic Feature :
1. Tree like menu
2. Users administration
3. Leave application
4. Inventory
5. Sales

Fleet Management System

2012-08-21T00:59:00.000-07:00

Fleet Management System
1. Tyre Tracking
2. Inventory
3. Fleet Management
4. Diesel
5. Revenue

2012-07-20T02:14:00.000-07:00

OrangeHRM offers a complete suite of human capital management / human resource managment tools. This includes employee information management, employee absence management / employee holiday management or employee leave management, recruitment managment, employee performance evaluation and many other HR management tools. Select from a free open source solution or an advanced SaaS / Cloud based HR management system.

Administration Module

The admin module is the central controller of the system where the HR Manager or other appointed personnel perform all system administration tasks. This includes defining organization structure‚ pay scale, maintaining project information and other information that serves as the backbone for the rest of the system. Security issues are taken care of through this module as well by defining user rights and permissions.

Personal Information Management

A complete employee information management system which acts as a central employee database. This enables HR administrators to utilize all employee information productively.

Leave Module

A comprehensive holiday management module‚ with extensive possibilities of defining leave types and more. It caters for all leave application & approval processes and is able to display information on leave entitlement‚ balance‚ history etc.. Thanks to the web-enabled and self-service concepts‚ it significantly streamlines all leave related procedures‚ eliminates paperwork and saves costs.

Time Module

This module automates timekeeping related processes. The offered functionality enhances the organization's performance by eliminating paperwork and manual processes associated with project timekeeping and attendance management. The sophisticated module helps to efficiently organize labor data‚ improve the workforce management and minimize errors in enforcement of company's attendance policies.

ESS Module

Employee self service is a powerful tool providing employees of the company with the ability to view relevant information such as personal information‚ updating personal information with web - enabled PC without having to hassle the HR staff. The functionality of this module spans through the entire system‚ making information available anywhere‚ anytime. Of course all information is subject to company defined security policy‚ where everyone can only view the information he / she is authorized to. Time and cost saving effects from this solution are tremendous.

Recruitment/ Applicant Tracking Module

A comprehensive solution for the entire recruitment process. The module allows HR professionals to streamline the entire applicant tracking process effectively.

Performance Module

Another natural attachment to OrangeHRM. While simplifying the performance review process you can communicate the key performance indicators for each job title allowing the employees to understand and achieve your expectations.

Free Opensource Human Resource System :

1. Try it at http://pembeda.com/hrm
     login id : hrm
     pasword : bismi

2. For Custumize / Online hrm system :
     contact : admin@pembeda.com

source

Lemon POS

2012-07-20T00:57:00.000-07:00

Lemon POS
Type: Retailer POS
Description: Linux based Point of sale for Retailers. It has role based user permission, multiple terminal and support for order cancellation etc.
Platform: Linux

Key Features

Openess.

Lemon is open source and uses open source components. The best advantage of being open source is that you own your information and you are free to move where you want without being tied to a provider.

Other advantage is that it gives you the freedom to study the source code, and if you know how, you can adapt it to your needs, correct bugs you find and help to improve it. And, if you dont know how to do this, you can request features, report bugs, or hire someone to adapt it.

Safer Environment.

Being linux or any unix system the target operating system to run lemon on, makes a safer place for your information against virus attacks, and also lowers the costs in operating system and antivirus licenses.

Single Database, Multiple Terminals.

You can have a single database serving multiple POS terminals. With other comercial products you must pay for each terminal, with lemon you can have as many as you need without worring about license fees for each one.

Vendor's Interface Features

known as “lemon”.

Simple and Appealing.

The Vendor's Interface —lemon— is kept simple for best operation. It can be themed using stylesheets and images to fit your tastes or store image. The tickets printed on modern thermal printers, together with the use of barcode scanners, are a plus for your store presentation, as a result all modern tools used gives a more attractive and professional image of your business to your clients.

Productiveness.

Enter product's code with a barcode scanner to increase vendor productivity.
Enter purchase amount in the same input area, like “100x12345678”, to add many items at a time.
Staying focused the code's inputbox, use the “+” key on the keypad to go enter the payment amount.
Searching for products by description, just press “F3” key to open the sarch panel.
Open a price checker tool to easily know prices for products without adding them to the purchase. And here you can also use the barcode scanner.
Apply occasional discounts —with admin/supervisor permission— to a sale it's breezing.
Suspend and resume sales, to interrupt a sale, start another sale and resume the saved sale later.
A Low Security Mode just for convenience.

Informativeness.

Balance for each vendor at the end of its session.
End of day report directly at the POS terminal.
Taxes are printed on tickets. Per product, and total sale taxes.
Reprint tickets
Extra messages on tickets.

Secureness.

Role based permissions.
Logged important vendor actions: like cash-in/out,cancelling transactions.
Lock screen: for vendor urgent/small absence.

Organization.

Categorized products
Group products (packs)
A grid for showing products with photos. Filter by category,name...
Supports Clients, having their information. Discounts based by client.

Other.

Enter old, non registered in lemon, sales with the “Change Sale Date” button.
Cash flow. Cash-in/Cash-out, money need to enter/leave to/from the cash drawer, in other way than paid money/change given.
Support for a loyalty program, clients accumulate points, based on each product.
Special Orders, this are custom products that are formed of raw products.

Administrative Interface Features

known as “squeeze”.

With squeeze you can manage your store and get valuable information in which base your decisions to improve your business.

ADD UI for squeeze!

Reports

There are on screen and printed reports, information to use for restocking and take decisions for you business health.

Transactions (sales, purchases) per day, month, vendor, terminal, date, status, type...
Balance filtered by vendor, date, amount...
End of day/month.
Low stock products.
Sold out products.
Cash flow, in/out money other than regular sale process.
Special orders.

Inventory Control

Manage your inventory. know what needs to restock, what is not sold, what is most sold.
Register purchases, and autocorrect stock.
Any loss of products or supervising your warehouse? Make stock corrections.
Add product's photo.
Make any group product for promotions or packages.
Create raw products for special orders or custom products.
Categorize your products.
Set product's selling measure.
Assign barcode to products to improve the sale time.

Manage the different information available on database

Modify, add and delete:

Offers or promotions
Vendors
Clients
Categories
Weights/Measures
Ticket Messages

Tested Devices

Most barcode scanners (usb, ps2) are easy to install because they dont need a driver, they act as simple keyboards. Some printers (mainly thermal) are provided with a CUPS driver for unix/linux systems and those printers are already supported in lemon (after installing the driver) by choosing the CUPS printing setting.

Printers

Star Micronics Thermal Printer. Model TSP100 [ TSP143 ]
Star Micronics Matrix Printer. Model SP500 (parallel port, using /dev/lpX port)

Barcode Scanners

Datalogic Barcode Scanner. Model DLC6065-M0

If you use another device, please send an email for adding it here.

Not found what you need?

If you need special features or adaptation to your business, we can work for you. We accept donations for small works that benefit you and the community, but also we can talk about a special work for you. Contact us.

application
source

Auto Mailer

2012-07-16T17:58:00.000-07:00

Free automailer

Make your system life, send information direct from your database to your staff, customer, client.

Features

Mysql database

free application

Multipurpose Barcode Scanning System

2012-06-10T19:04:00.001-07:00

Lowest Cost for High End System

ASF Network - IT Solution 4u

Download links for Microsoft SQL Management Studio Express editions

Download links for Microsoft SQL Management Studio Express editions

Running Large Scale Perfomance Tests

Step 1 : Write Your Script

Step 2 : Testing Locally With JMeter

Step 3 : BlazeMeter SandBox Testing

Step 4 : Setup The Amount Of Users-Per-Engine Using 1 Console & 1 Engine

Multi Location Tests

Step 5 : Setup and Test Your Cluster

Step 6 : Use the 'Multi-Test' feature to Reach Your Maximum CC Goal

Setup A Multi-Test

Running The Multi-Test

Convert Data from MySQL into MSSQL

Intro:

Options:

Solution:

Software involved (in my case):

Steps Overview:

Steps:

Recover Windows Boot Problem

From : http://www.aitechsolutions.net/winxpnoboot.html

Safe mode boot frozen at mup.sys

SMS Gateway

PHP Point Of Sales

pembeda.com

Auto-Identification and Data Collection Gateway

Safe Box System

Thumb Print Time Attendance

Thumb Print Time Attendance

Parking Attendant System

Totmato Cart

Site Mangement

Catalog Management and Browsing

Product Management and Browsing

Customer Management

Order Management

Payment

Shipping

Checkout

Statistics and Reports

Promotion tools and SEO

Content Management System

Content Management System

Intranet

Fleet Management System

Lemon POS

Key Features

Openess.

Safer Environment.

Single Database, Multiple Terminals.

Vendor's Interface Features

Simple and Appealing.

Productiveness.

Informativeness.

Secureness.

Organization.

Other.

Administrative Interface Features

With squeeze you can manage your store and get valuable information in which base your decisions to improve your business.

Reports

Inventory Control

Manage the different information available on database

Tested Devices

Printers

Barcode Scanners

Not found what you need?

Auto Mailer

Multipurpose Barcode Scanning System