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

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

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

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

Do you feel confident about the security of your database environment? Because databases may contain sensitive or regulated information, critical applications or stored functions, ensuring database ...

Let's break down when it's ideal to use the NOLOCK hint and when you should never use it. As a consultant, I work on wide swaths of database systems, which means I get to see many, many SQL statements ...