SQL Server arrangement check checklist

What are things I need to take into consideration when I need to install SQL Server (2005/2008) on a new web server?

  • Storage space arrangement
  • TempDB
  • Security

What are some usual blunders made because procedure?

0
2019-05-04 15:36:28
Source Share
Answers: 3

I generally revoke the VIEW ANY DATABASE approval. By doing this each customer can just see the data sources they have the ability to accessibility (it additionally aids streamlining the checklist in SQL Server Management Studio) :

USE master
REVOKE VIEW ANY DATABASE FROM PUBLIC
GO
0
2019-05-08 22:33:41
Source

Not crime to Brent Ozar, yet Chad Boyd additionally has a great collection of SQL lists :

The collection lists, specifically, are very useful.

0
2019-05-08 16:46:21
Source
0
2019-05-08 03:02:25
Source