MileIQ in Office 365

This is a new feature that Microsoft has announced for US, UK and Canada Business Premium customers. It basically helps to track your miles on the road that you have used for customer visit, partner meetings or trade conference by using your on car. This data also can be used tax deduction or expense reimbursement.

How to Install Netfx3

Property Owner is not available for Database

No matter which version of SQL server you are using, When DB owner is deleted you cannot look DB’s properties.

Error Message

Cannot show requested dialog.

Additional information:

Cannot show requested dialog. (SqlMgmt)

Property Owner is not available for Database ’[ ]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

(Microsoft.SqlServer.Smo)

Solution is easy that change the owner using this query

Use DATABASENAME

Exec sp_changedbowner “USERNAME”

You have to run this for each DB

SQL 2008 R2 installation

I am trying to install Microsoft System Center Configuration Manager 2012 and Operation Manager 2012. These products need a database called SQL Server. New features of the latest version of SQL Server database engine has been introduced.

What’s New (Database Engine)

Some topics are below

• Manageability Enhancements (DB Engine)
• Scalability and performance Enhancements

• Security Enhancements

• The Database size for SQL Server Express edition has been increased to 10 GB

• Encrypting Connections to SQL Server (more information KB258858)