SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

When tuning SQL Server performance, consider the CPU's clock speed, core count, and cache size. These factors directly affect how quickly the server can perform calculations and process transactions.

Neither of which were good solutions. Now, the DBA can create a role, which has read/write access on every DB on the server, or any other custom server wide role. 5. Enhanced Auditing Features -- ...

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

For roles other than running SQL Server, it’s worth checking the matrix of which server roles can be upgraded from Server 2012 and which will need to be migrated to new hardware running the new OS.