However, the Compatibility Level property for that database remains at the release it was upgraded from. For instance, if you copy a SQL 2000 database to SQL Server 2008, the new copy is an upgrade to ...

This excerpt from the upcoming book, SQL Server 2008 Administration in Action, introduces the role of service-level agreements (SLAs) as part of a DBA's overall strategy to maintaining reliable ...

Database performance can be a complex and difficult task, but there are some high-level maxims that can help to sim­plify optimizing the performance of your databases and applica­tions. Let’s look at ...

Establishing agreed upon services levels for database applications is of the utmost importance for assuring that performance meets required criteria. Without pre-determined, negotiated service level ...

Microsoft recently published a new version of its service-level agreement (SLA) for Azure SQL Database, adding uptime perks for organizations that use the "Business Critical" tier. If organizations ...

Commentary - Data encryption has become a necessary component to most enterprise data security strategies. Enterprises can no longer rely on basic authentication and access control tools to protect ...