i am siva

Empty your memory, with a free()... like a pointer! <br /> The pointer can crash...and can overflow..!

SqlServer

Changing SQL Server Collation After Installation

August 26, 2019

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…]

Posted in: SqlServer Tagged: SqlServer

Change the Default Locations for Data and Log Files in SqlServer

August 26, 2019

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…]

Posted in: SqlServer Tagged: SqlServer

Tags

.NET ASP.NET Azure DevOps C# Design Patterns Dot Net GoF SharePoint SqlServer TFS Visual Studio VS Windows WPF

Categories

  • .NET
  • ASP.NET
  • Azure DevOps
  • C#
  • Design Patterns
  • Dot Net
  • GoF
  • SharePoint
  • SqlServer
  • TFS
  • Uncategorized
  • Visual Studio
  • VS
  • Windows
  • WPF

Archives

  • August 2020
  • August 2019
  • May 2015
  • March 2013

Recent Comments

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2021 i am siva.

    Me WordPress Theme by themehall.com