If you cant see...

SQL Server gradually grabs RAM as it needs it to run queries, etc. It does not release RAM until you cycle the service or the OS tells it to...

Find a SQL Saturday (Or SQL Saturday BI Edition) in your area and go to those! Best way to get good training at really low prices.

Another good starting point in Microsoft Virtual Academy (ITS FREE!)

http://www.microsoftvirtualacademy.com/product-training/sql-server

You wont have enough information to pass the MCSA exams by just watching these, but its a great start to introduce...

This was reposted this morning. It may help http://www.sqlservercentral.com/articles/Stairway+Series/72460/

I have created something with powershell that first pulls all of the users on both the server and the instance and put those into separate tables. Then I have...

Does the account you are running this under (probably your personal AD account) have database access required to do the restore? You would think if it was a permission or...

SAP is usually stored in a SQL Server or Oracle database. As long as you have the drivers installed (If it is on Oracle) on the SSRS machine, you...

Correct if their account is removed or locked the job will fail. We set all of our...

I think this should work - I would test on a test system first to make sure replication comes back up.

Pause Replication

Detach Database

Move .MDF/.LDF file to new drive

Reattach Database

Start Replication

There are a few ways to do this and really depends on the task at hand.

SQL Server Reporting Services is a great tool that will make graphs and reports...

First do you have SSMS installed on the same box you are trying to run this from? SSMS installs the snapin, but without SSMS installed the snapin does not...

This may have to do with how AD tokenizes the windows credentials and passes it to the next server. For whatever reason it seems the remote server can not...

I assume you are trying to use active directory to do this? I have had similar issues and usually has to do with AD Distribution Controllers not being up...

If you want to use visual studio 2012 you can download the SSDT installer here:

http://www.microsoft.com/en-us/download/details.aspx?id=36843

This is not included with typical SQL Server Installations.