My blog about SQL Server
This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your Sysprep server or You want to change from the default instance Continue reading Changing SQL Server name
SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version. SQL folks in general, usually don’t take them as handy, or maybe are not aware of them enough. But the reports are really Continue reading The standard SQL Server reports
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is the same – https://msdn.microsoft.com/en-us/library/dd207003.aspx. When you install a SQL Server instance you should check the collation for the instance which you Continue reading Rebuilding the system databases
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice for configuring a fresh instance, unless there are some very special Continue reading Mandatory Sql Server properties to configure on a new instance