Tuesday, February 03, 2015

How do I remove the cached username and password from SQL Management Studio?

You may have your reasons to want to remove the cached username and password from the SQL Management Studio e.g. before handing your laptop to someone else.

The step to remove will require deleting a file but differs depending on the version of SQL Management Studio you are using.

SQL Server Management Studio 2014
Delete C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin

SQL Server Management Studio 2012
Delete C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

SQL Server Management Studio 2008
Delete C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

SQL Server Management Studio 2005
Delete C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

One good news is as of SQL Server Management Studio 2012, you may delete an entry by using the tool itself without the need to delete a file. To delete, you will need to click on the 'Server name' dropdown in the 'Connect to Server' dialog. Move your mouse or use your keyboard arrow key to highlight the server to remove followed by hitting on the 'Delete' key on your keyboard. This is so convenient!

Thursday, December 11, 2014

Infographics: When should we use JPEG, GIF and PNG?

Monday, December 08, 2014

The side-effects of young children using mobile / handheld devices

In current generation where penetration rate of mobile devices is high, we see many including young children often using mobile devices while travelling, in school or even before bedtime. A fact sheet published on Zone'in advised infants aged 0-2 years should not have any exposure to technology, 3-5 years be restricted to one hour per day, and 6-18 years restricted to 2 hours per day.


The fact sheet researched on areas:
  • Technology Use: usage statistics; technology addiction prevalence
  • Physical Impairments: developmental delay; obesity, cardiovascular disorders and diabetes; movement deprivation, sensory overstimulation, elecrtromagnetic radiation, sleep disruption
  • Mental Disorders: human detachment and mental illness; psychotropic medication, restraints, and seclusion rooms, touch deprivation, pornography and risky behavior
  • Social Disorders: communication, aggression and declining empathy,
  • Academic Decline: attention deficit; illiteracy, education technology;
  • Implications and Solutions: costs, technology screening an management, playgrounds as epicenter for child development and learning

Tuesday, December 02, 2014

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
  1. Shut down FortiClient from the system tray.
  2. Run net stop fortishield on command prompt.
  3. Run msconfig.
  4. On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.
  5. Run services.msc on command prompt to open up show all available services.
  6. Look for FortiClient Service Scheduler. Switch Startup type to Manual.
  7. Restart your computer.
FortiClient should not be running automatically the next time round. Hope it helps.

Tuesday, November 25, 2014

An interesting perspective on Responsive Web Design and getting it right

An article on the Smashing Magazine has an interesting perspective on what is responsive web design and how to actually get it right. Taking note on the performance is the right approach.

» You May Be Losing Users If Responsive Web Design Is Your Only Mobile Strategy | Smashing Magazine

Blog Archive

Related Posts Plugin for WordPress, Blogger...