Imagine the scenario that you application has just been deployed into production environment and SQL Server is extremely slow consuming too many resources. Sometimes a single store procedure can be easily identified by looking into DMV’s or just profiler...

Trying to install SQL Server 2008 on a non English OS and setup is being blocked by this rule, however looking to performance counters everything looks fine. On Operating Systems pt-PT (Portuguese) setups is trying to look for HKEY_LOCAL_MACHINE\SOFTWARE...

Trying to install SQL Server 2008 on a standalone environment using an administrator account and getting an access denied? The problem could happen in case you have removed Local Administrator from ‘Debug privileges’ on local security policies or just...