Thursday, 15 March 2012

Free ebook: Introducing Microsoft SQL Server 2012

Friends, the final and complete version of Introducing Microsoft SQL Server 2012, by Ross Mistry (@RossMistry) and Stacia Misner (@StaciaMisner), is now ready as a free download! You can download the PDF version of this title here (288 pages; 10.8 MB).
Introducing Microsoft SQL Server 2012 includes 10 chapters:
1.   SQL Server 2012 Editions and Engine Enhancements
2.   High-Availability and Disaster-Recovery Enhancements
3.   Performance and Scalability
4.   Security Enhancements
5.   Programmability and Beyond-Relational Enhancements
6.   Integration Services
7.   Data Quality Services
8.   Master Data Services
9.   Analysis Services and PowerPivot
10.   Reporting Services

Join the Microsoft India TechEd India 2012 Live

Unable to make it to the tech event of the year? Do
not worry! We’ve got you covered with TechEd Live!
Get a real-time experience of the hottest action at
TechEd India 2012-live streaming of keynote
addresses, demos, technical tracks and more-right
where you are.
A must see for all, including developers and
administrators. Learn about new and exciting
developments in Windows Phone, Windows Azure,
Visual Studio 2011, Windows 8 and other
cutting-edge technologies.
Register now!
Watch TechEd Live unfold!

Saturday, 10 March 2012

How to Enable IE 9 Compatibility View for your whole Web site or for specific Web site directories

Some websites may not behave as expected in Internet Explorer 9.This kind of problem does not occur in earlier versions of IE.

For example, you may experience any of the following symptoms in IE 9 :
  • ·         Text  are in wrong positions ,
  • ·         Some website features does not work,
  • ·         You receive script error messages on some website

To enable Compatibility include the following custom HTTP header for all requests to your site or directory.
X-UA-Compatible: IE=EmulateIE8
To do this in Internet Information Services (IIS) on a Windows server-based Web server, you must either add a custom HTTP response header in IIS or configure the Web.config file for the appropriate directory.
Add the custom HTTP response header in IIS
To add a custom HTTP response header at the website level,at the virtual directory level in IIS, follow the steps for the version of IIS that you are using.

IIS 7 on a Windows Server 2008-based Web server
  1. Start IIS Manager. To do this, click Start, click Run, type inetmgr, and then click OK.
  2. Under Connections, double-click the server that you want, and then double-click Sites.
  3. Click the website, the folder, or the virtual directory where you want to add the custom HTTP response header.
  4. Under <website name> Home, double-click HTTP Response Headers in the IIS section.

    Note The <website name> placeholder refers to the name of the website.
  5. Under Actions, click Add.
  6. In the Name box, type X-UA-Compatible.
  7. In the Value box, type IE=EmulateIE8.
  8. Click OK.

How to add Microsoft Excel Application in Windows 7

  1. Start
  2. Run
  3. mmc -32  or DCOMCNFG -32 or dcomcnfg
  4. File
  5. Add Remove Snap-in
  6. Component Services
  7. Add
  8. OK
  9. Console Root
  10. Component Services
  11. Computers
  12. My Computer
  13. DCOM Config
  14. Microsoft Excel Application

 Step to add:



Right click and select Properties->Select Identity Tab->Select This user and add the Administrator
 accout and password

 Select Security Tab, Under "Launch and Activation Permissions", Choose "Customize", Click "Edit" button, Add the everyone account and add all the Permissions

 Do the same thing in "Access Permissions" and "Configuration Permissions".

Enabling IIS log files on Windows 7

In  IIS 7.5 does not log to files by default, you have to enable the feature manually. In the settings it's called "HTTP logging", here's how to enable it:

If you can't find IIS log files in C:\inetpub\logs you should open your IIS Manager and check if the logging option is present in the IIS menu section (top right in the screenshot).


If you can't find the Logging option, go to: Control Panel\Programs -> Turn Windows Features on or off to enable IIS logging.

I had to close the IIS Manager and open it again for the changes to take effect. Now the IIS should log to C:\inetpub\logs.

After some intense Googling, I was able to find this article by Microsoft: Enable or Disable Logging (IIS 7). It states that logging is enabled by default in IIS 7. This does not seem to be the case on my IIS 7.5 (Windows 7 Enterprise).

Log Files for a Web Site  here