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 ...

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.

Securing your network goes beyond your hardware or software firewalls. You must define the role of each server and then implement delta security policies to protect your services.

MORE FROM EDTECH: 4 steps to lower your risk with a SQL server 2014 migration. SQL Server’s End of Life Puts the Spotlight on Database as a Service Many IT managers are already looking at the ...

SQL Trace is the heart of SQL Server 2000’s auditing capabilities. In fact, Microsoft resurrected SQL Trace, which had been downplayed in SQL Server 7.0, specifically to facilitate auditing.

Here's how to apply a server role, along with a brief description of the multiple roles that can be chosen.

Microsoft says customizing Windows Server 2008 should help businesses, but bill for a single-purpose server is unlikely to be less.