Tips for performance tuning of databases
Database statistics The most important resource to any SQL optimizer is the statistics collected for different tables within the catalog. Statistics is the information about indexes and their distribution with respect to each other. Optimizer uses this…
Tips for How to write Better Code
Use a Coding Standard It’s easy to write a line of code, unorganized code, but it’s hard to maintain such code. Good code typically follows some standard for naming conventions, formatting, etc. Such standards are nice because they make things…
Tips to avoid JavaScript Mistakes
– You’re Using Global Variables If you’re just getting started with JavaScript, you probably think it’s a great thing that all variables are global. Actually, if you’re just getting started, you might not know what that means. Global variables are…
Tips to protect your site from hackers
Keep software up to date It may seem obvious, but ensuring you keep all software up to date is vital in keeping your site secure. This applies to both the server operating system and any software you may be running on your website such as a CMS or forum.…
Installing Android Studio
Download the Android Studio package from below link. http://developer.android.com/sdk/installing/studio.html Install Android Studio and the SDK tools: Windows: Launch the downloaded EXE file, android-studio-bundle-<version>.exe. Follow the setup…
Top 5 free mobile device emulators for testing your site
A mobile phone emulator lets you check the responsiveness and functionality of the website across different mobile platforms, such as iPhone, iPad, Android and BlackBerry, without actually having the devices in hand. Mobile emulators can help you…
Use Your MAC Without a Mouse-Part2
Use these keyboard shortcuts for Application and other commands. Command+Space — Show or hide the Spotlight search field (if multiple languages are installed, may rotate through enabled script systems) Control+A — Move to beginning of…
Use Your MAC Without a Mouse
Use these “finder” keyboard shortcuts. Command+A — Select all items in the front Finder window (or desktop if no window is open) Option+Command+A — Deselect all items Shift+Command+A — Open the Applications folder Command+C — Copy…
Work on MAC-OSX without using mouse or Touchpad
If you have Universal Access, use these keyboard shortcuts to manipulate your cursor in lieu of using your mouse. To set this up, go to your Universal Access preferences and activate Mouse Keys. 8 — Move Up 2 — Move Down 4 — Move Left 6…
Work with your browser without using mouse
browser without using mouse Use browser shortcuts. Control+I — Open Favorites Control+H — Open History Control+N — Open a new window Control+O — Open another document or webpage Press Alt + letter underlined on toolbar —…