Date Added: Mar 2010
Securing a database is a difficult task and most efforts typically focus on locking down the server while still allowing authorized connections to occur. Application developers need to be security conscious also, not only because applications can be a target of attack, but also because applications can facilitate the further lockdown of the server. In this podcast, Il-Sung Lee and Raul Garcia discuss some of the considerations that both the application developer and the database administrator should consider to help increase data security. Topics they discuss include securing the network channel, using proper authentication, new authorization features introduced in Microsoft SQL Server 2005, execution contexts, database encryption, and common errors and problems related to Microsoft SQL Server security.