Find the last time a database was accessed

select d.name, x1 =
(select X1= max(bb.xx)
from (
select xx = max(last_user_seek)
where max(last_user_seek) is not null
union all
select xx = max(last_user_scan)
where max(last_user_scan) is not null
union all
select xx = max(last_user_lookup)
where max(last_user_lookup) is not null
union all
select xx = max(last_user_update)
where max(last_user_update) is not null) bb)
FROM master.dbo.sysdatabases d
left outer join
sys.dm_db_index_usage_stats s
on d.dbid= s.database_id
group by d.name

PostgreSQL install failed with “Installation may not complete correctly. The database cluster initialization failed.”

After the install of PostgreSQL 8.4.5 should be done I got the following error:
Installation may not complete correctly. The database cluster initialization failed.

The services was not installed.
The solution is simple.

1. Manually create the directory structure from PostgreSQL. In my case D:\PostgreSQL\8.4\data
2. Allow full access to all users ( including “postgres” user) on “Postgres Folder”.
3. Make “postgres” user as the owner of the data directory….

After this install PostgreSQL 8.4.5 and the installation should work like a charm.

Microsoft SQL Server Management Studio 2005 is to slow

In a corporate environment it is not uncommon for Microsoft SQL Server Management Studio (SSMS) for SQL Server 2005 to take over 45 seconds to start as well as lags and delays when opening various windows and dialog boxes from within the application. If you are experiencing this issue, then a quick fix is to add an entry in your HOSTS. file that points crl.microsoft.com to 127.0.0.1

  1. Exit SSMS
  2. Press the keys [Win] + [R]
  3. Enter the following..
    notepad %systemroot%\system32\drivers\etc\hosts.
  4. Append the following..
    127.0.0.1    crl.microsoft.com
  5. Save the file.
  6. Start SSMS (ah! much better)

The reason why it is slow is because .Net Runtime tries to contact crl.microsoft.com to ensure that the certificate in various .Net packages that were shipped with SSMS is valid.
If you are behind a firewall/proxy as is the usual case then there is no direct route out to the internet to crl.microsoft.com to validate the certificate(s) and it eventually times out. The wait for the time out causes the delay for each and every package it checks.

With the change to the HOSTS. file, you are forcing the certificate checks to crl.microsoft.com to route to the local host which immediately fails and the certificate checks are ignored.

SQL Server Management Studio may also be configured to use online help recourses, while the host computer may not have access to the online resources.

First Step:

  1. Go to “Start” -> “Programs” -> “Microsoft SQL Server 2005”.
  2. Open “SQL Server Management Studio”.
  3. Navigate to “Tools”  -> “Options” -> “Help” -> “Online”.
  4. Mark the checkbox “Try local first, not online”
  5. Press on “Ok” button.
  6. Restart SQL Server Management Studio”.

Tip: In some cases you may need to disable “Check for publishers certificate revocation” option under the Internet Explorer -> “Internet Options” -> Advanced”.

Second Step:

  1. Go to “Start” -> “Programs” -> “Microsoft SQL Server 2005”.
  2. Open “SQL Server Error and Usage Reporting”
  3. Uncheck the following checkboxes:
    a.”Send error reports for all components and instances of SQL 2005 to Microsoft or your corporate error reporting server.”
    Note: Using local “corporate error reporting server”, may require to enable this feather.
    b. “Send feather usage reports for all components and instances of SQL 2005 to Microsoft.”
  4. 4. Press on “Ok” button.

Troubleshooting SQL Server 2005 “No global profile is configured…”

1. Open Management Studio
2. Expand Management
3. Right click on Database Mail
4. Select Configure Database Mail
5. In the Welcome to Database Mail Configuration Wizard, click Next6. In Select Configuration Task window, select Manage Profile Security
7. In Manage Profile Security window, make sure you have a profile that is selected as default.
8. Click Finish
9. Retest

ASP.NET 2.0 not registered in IIS

When ASP.NET is installed on your computer but not registered in your IIS you probably installed .Net before IIS.
This is easily repaired with the following command

“%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe” -i