Basically, collation defines the rules for how strings of characters data are stored and compared. Based on the norms of a particular language it will vary. Query conditions will change depending on the language configured. The server collation acts as the default collation for all the system databases and also newly created databases. we can … [Read more…]
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 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…]