Microsoft® SQL Server® 2012 Bible

827 Chapter 31: Managing Data in Windows Azure SQL Database 31 The bcp utility is fl exible and powerful, and you can apply a lo ...

828 Part V: Enterprise Data Management FIGURE 31-19 Using bcp to export data from the on-premises Contact table. After you type ...

829 Chapter 31: Managing Data in Windows Azure SQL Database 31 alter table tablename drop column rowguid FIGURE 31-20 Using bcp ...

830 Part V: Enterprise Data Management which are offered as free functionality for the low cost of your database; hard to do in ...

Part VI Securing Your SQL Server IN THIS PART Chapter 32 Authentication Types in SQL Server Chapter 33 Authorizing Securables Ch ...

c32.indd 832c32.indd 832 7/31/2012 10:01:02 AM7/31/2012 10:01:02 AM http://www.it-ebooks.info ...

833 CHAPTER 32 Authentication Types in SQL Server IN THIS CHAPTER Understanding SQL Server Authentication Types Understanding Ad ...

834 Part VI: Securing Your SQL Server You may also check the Authentication mode under the SQL Server properties in SQL Server M ...

835 Chapter 32: Authentication Types in SQL Server 32 FIGURE 32-2 SQL Server LoginMode registry key. Additionally, you can use P ...

836 Part VI: Securing Your SQL Server Best Practice When changing to SQL authentication and Windows Authentication mode, always ...

837 Chapter 32: Authentication Types in SQL Server 32 SQL authentication has several advantages: ■ Backward compatibility for ap ...

838 Part VI: Securing Your SQL Server SQL authentication is available only for backward compatibility and should be used only if ...

839 Chapter 32: Authentication Types in SQL Server 32 Best Practice If Kerberos implementation is necessary, avoid the use of un ...

c32.indd 840c32.indd 840 7/31/2012 10:01:03 AM7/31/2012 10:01:03 AM http://www.it-ebooks.info ...

841 CHAPTER 33 Authorizing Securables IN THIS CHAPTER Building Permission Chains Understanding Object Ownership and Security Usi ...

842 Part VI: Securing Your SQL Server Ownership chains are great for developing tight security in which users execute stored pro ...

843 Chapter 33: Authorizing Securables 33 Securables Permissions The database user can be granted granular permission to specifi ...

844 Part VI: Securing Your SQL Server a login is granted such rights. As a result, this is a prime way that attackers would seek ...

845 Chapter 33: Authorizing Securables 33 ■ (^) DRI (References): The right to create foreign keys with DRI. ■ Execute: The righ ...

846 Part VI: Securing Your SQL Server Granting Object Permissions with Code Setting an object’s permission is the only security ...