Disabled IE9 "Only secure content is displayed" pop up

To Disable/Enable/Prompt the “Only secure content is displayed” message:

1. Start Internet Explorer.
2. On the Tool menu, click Internet Options.
3. Click the Security tab, and then click Custom level.
4. In the Settings box, scroll down to the Miscellaneous section, and under Display mixed content choose from the following options:
   
   Disable, will not display non-secure items.
   Enable, will always display non-secure items without asking
   Prompt, will prompt you when a webpage is using non-secure content

Note: Internet Explorer 9 blocks non-secure content to keep your information safe and is set to Prompt by default. When this setting is set to Enable, Internet Explorer does not prompt you with the "Only secure content is displayed" message even if the webpage is using non-secure elements.

copy paste this from: http://support.microsoft.com/kb/2625928

UNION in SQL Server

Did you know..that..

in SQL if you UNION two queries, and if one of the table is empty, it will work as DISTINCT for the other table..?

^^v 

Julie