Change the Default Locations for Data and Log Files in SqlServer

By Default in SqlServer, new database files are being created and stored in %Program Files%\Microsoft SQL Server\MSSQLXXX.MSSQLSERVER\MSSQL\DATA. This path can be changed to desired or configured path. To change Data and log files path Connect to SqlServre using SSMS Select connected Server and then Properties From Server properties –> Select Page (left side) –> Database … [Read more…]

TFS 2015 or Azure DevOps Pipeline Build Definition – setting output location

TFS 2013 Build Definition has an Output Location option (AsConfigured, PerProject, SingleFolder) but this option is not available in the later version. TFS 2013 is XAML based build definition, later versions new build definitions are added like vNext/YML. So in TFS 2015 or later versions if we use vNext/YML build definition this option is no … [Read more…]