Monthly Archives: August 2014

GPG error NO_PUBKEY

I am getting W: GPG error: http:// archive.canonical.com quantal Release: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 40976EAF437D05B5 NO_PUBKEY 3B4FE6ACC0B21F32 The fix: sudo apt-key adv –recv-keys –keyserver keyserver.ubuntu.com 40976EAF437D05B5

Posted in Uncategorized | Comments Off on GPG error NO_PUBKEY

How to find missing indexes in SQL Server

This works in SQL Server 2005 or better. SELECT * FROM sys.dm_db_missing_index_details Too easy! See this link for more information.

Posted in Microsoft | Comments Off on How to find missing indexes in SQL Server