Wednesday, August 13, 2014

HOW TO FIX: Audio/Sound not working in Chrome Browser

Last few weeks, I had an issue of hearing no sound from CHROME browser. So, I did following steps to fix this.

Step 1:

1. Close Chrome and open it again.
2. Go to Chrome Plugins page (chrome://plugins/)
3. Click "+Details" in right hand side to view the plugin details in detail.
4. You could see of two plugin under Adobe Flash Player. In that, Disable the Pepper Flash.
5. Close the browser and open it again. See audio works. if still not working, follow Step 2.




Step 2:

1. Open Internet Explorer.
2. Go to Tools -> Internet Options.
3. Click Advanced Tab and Click Reset Button
4. In Reset Internet Explorer Settings window, Click Reset Button.
4. Open Chrome browser, See Audio Works.

Tuesday, July 08, 2014

SOLUTION: SQL Server Management Studio 2012 Hangs after Opening Database Objects like Stored Procedure in Query Window

Today, I have started to experience that SQL Server Management Studio 2012 starts hanging after opening the stored procedure in Query Window. Here is the solution to fix this.


1. Close All Instances of SSMS 2012

2. In Run Command, type "%AppData%\Microsoft\SQL Server Management Studio" and it will open a folder like "C:\Users\{User Name}\AppData\Roaming\Microsoft\SQL Server Management Studio".

3. Rename the "11.0" folder to "11.0.Issue"

4. Open SSMS 2012 and new folder "11.0" would be created in the above path.

5. Open database objects like SP and don't see any hanging in SSMS 2012.

SOLUTION: Keyboard Shortcut not working in SQL Server Management Studio 2012

Today, I have started to experience that keyboard shortcuts not working in SQL Server Management Studio 2012. Here is the solution to fix this.


1. Go to Tools  --> Options
2. Select Environment --> Keyboard
3. In Right hand side, click RESET button.
4. Then, Keyboard shortcut works.