SQL server 2012 best practices
Posted on 2014-09-18
Hello my dear experts :)
I was wondering if anyone can tell me a couple of best practices for Microsoft SQL server 2012.
I am planning a SQL farm for multi tenant Xenapp deployment and would like to know general guidelines for security and performance best practices and also scalability issues or general guidelines for SQL scalability (multiple VMs running the same database (or multiple databases).
I know the basic stuff like creating separate accounts for every sql service, separate the OS, Database and Log disks, use windows authentication instead of SQL "sa" account and change the default sql port.
I would like to know for other best practices or setup settings to mind during installation. For example is it better to place multiple instances on one server or install multiple sql servers (VMs), what is better in terms of scalability and security?
I wouldn`t mind links for further investigations cause I am already googleing around so im just asking for extra input and advices.
Thanks in advance.