This has details about installing and using LocalDB http://msdn.microsoft.com/en-us/library/hh510202.aspx

Ther are no documented restrictions I have sen on connecting to databases created before SQL2012, so you should be OK to use...

You should not put any user tables or other items in the master database. Use your own database for your own items.

Also it is worth looking at SQL 2012...

IE tends to work with Report Manager, but most other browsers do not. Some browsers will show the Report Manager window but will not render a report.

Microsoft has no...

It is worth looking at Ola Hallengren's index maintenance routines at http://ola.hallengren.com/.

This checks statistics so that only those indexes that need rebuilding get processed. This can cut...

All I can say is that I have done this many times and it should work.

If you want to use Filestream you will need to install KB 937444,...

Take a look at this link, it covers a lot of the background about using AWE: http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20Memory%20Management

You cannot put a table into P2P until it exists on all P2P nodes. This means you must run the table create script on all the nodes, and only...

You need to install .Net 3.5 SP1 on Windows 8 before you can install any version of SQL Server. You need the special install media for Windows 8 found...

We run all our production web and SQL servers virtualised and get good performance out of them. You just need to make sure the virtual servers have access to...

If you are just doing a lift and shift, then the starting point for the new box is to make it the same capability as the old box.

CPU...

This was something said to me by someone who has work with MS...

Also, remember that if you create a SQL SP WITH ENCRYPTION, anybody who can get access to the SP can decrypt it. You may as well keep the SP...

If you buy your licenses via a Microsoft licensed reseller, then talk to them. Their advice should be free as part of their service to you.

They may not always...

Yes, it is expected that SQL 2005 SMO will have problems connecting to SQL 2012. You need to upgrade to a newer version.

If you know that the input is in English, add a token to the input in the form LANG:ENU, use a different language code with documents you know are in...