Sql-server – Installing SQL Server Tools

99% of the time, the asp.net session state database does not warrant FULL recovery and transaction log backups. In fact, it usually doesn't warrant any backups at all. I'd favour a script to recreate it over taking backups.

NB: Be wary of folk sneaking persistent objects in to your state database. Lock 'em out.

If your SQL Server isn't clustered, you have the option of targeting tempdb for state storage as an alternative to a persistent database, so it's treated as truly disposable.

Assuming your usage is typical and recovery of the data isn't required either:

• Switch to SIMPLE recovery model.
• Follow Kimberly Tripp's suggested route for shrinking the log.

Or, if you aren't clustered go the tempdb route and drop your state database, by re-running aspnet_regsql with the option -sstype t.

No, you do not have to buy a VS licence to use SSDT or SSDT-BI, you have the licence for the services (IS, AS, RS) if you have a SQL Server licence. SSDT and SSDT-BI are just tools to use those services.

You can freely download SSDT and SSDT-BI from Microsoft:

• SSDT: http://msdn.microsoft.com/en-us/data/hh297027 (for SQL Server Database projects)
• SSDT-BI: https://www.microsoft.com/en-us/download/details.aspx?id=36843 (for SSIS, SSAS and SSRS projects)

Edit It is not required to preinstall any kind of VS, the will install the VS Shell if it is not installed.

Note You can install BIDS/SSDT-BI using the SQL Server installer, but it contains the version which was available when the installer built (mostly hardly outdated).