Installing SQL Server 2017 Reporting Services

With SQL Server 2017, Reporting Services is a separate install. Download install from Microsoft site. https://www.microsoft.com/en-us/download/confirmation.aspx?id=55252 After you have installed it, you will need to configure it via Report Server Configuration Manager. Once configured, you will be able to access SSRS via link http://server01/ReportServer.

SQL Server Named Pipes

After SQL Server install, need to enable Named Pipes in order to be accessible from SQL Server Management Studio. Go to SQL Server Configuration Manager to enable Named Pipes and TCP/IP. Also need to restart services.

SVN – Checkout Process

Check out a working copy from a repository. Select folder and checkout. Map repository folder to a local folder on your computer. All files folders will be copied over to your local folder. The folder will be marked with a green checkout icon. You can now edit files and commit changes back to repository.

XCOPY

The xcopy command is a Command Prompt command used to copy one or more files and/or folders from one location to another location. The xcopy command, with its many options and ability to copy entire directories, is similar to, but much more powerful than, the traditional copy command. The robocopy command is also similar to the xcopy command but has even more... » read more

NOLOCK

What does the SQL Server NOLOCK hint do? The NOLOCK hint allows SQL to read data from tables by ignoring any locks and therefore not being blocked by other processes. This can improve query performance, but also introduces the possibility of dirty reads. Issues with NOLOCK We mentioned above how you can get dirty reads... » read more