SQL SERVER 2008 NEW FEAT

《SQL SERVER 2008 NEW FEAT》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、SQLServer2008NewFeaturesJeffR.Johnson

2、LeadSQLArchitect–jjohnson@capaxglobal.com

3、973-401-0660AGENDASecurityandDataAuditing4AvailabilityandReliability8Performance10Management13NewDataTypes14DevelopmentEnhancements15Servicebroker20DataStorage21AGENDADataWarehousing/ETL27Reporting31De

4、precation32Q&A33SecurityandDataAuditingTransparentDataEncryptionEncryptionofdataonthediskwhileitremainstransparenttotheapplicationrequestingthedata.StepsCreateaMasterKeyCreateorobtainacertificateprotectedbythemasterkeyCreateadatabaseencryptionkeyandprotectitbythecertificateSetthed

5、atabasetouseencryptionSecurityandDataAuditingTransparentDataEncryptionUsemastergoCreateMasterKeyEncryptionbyPassword=‘mssqlR0cks’GoCreateCertificateTDECertWithSubject=‘TDECertificate’GoCreateDatabaseTDESampleGoUseTDESampleGoCreateDatabaseEncryptionKeyWithAlgorithm=AES_256Encryptio

6、nbyServerCertificateTDECertGoAlterdatabaseTDESampleSetEncryptionOnGoSecurityandDataAuditingExtensibleKeyManagementFeaturesSupportforHardwareSecurityModules(HSM)HSMdevicesstoreencryptionkeysinhardwareorsoftwaremodulesMoresecurebecauseencryptionkeysdonotresidewiththedataHigherperfor

7、manceforhardware-basedencryption/decryptionAdditionalauthorizationcheckSecureencryptionkeydisposalEasierretentionandretrievalTurnonEKMSp_configure‘showadvanced’,1GoReconfigureGoSp_configure‘EKMproviderenabled’,1GoReconfiguregoSecurityandDataAuditingAuditingServerAuditsAuditeventst

8、hathappenattheserverlevel(Login,Logout,Groups,etc….)CREATESERVERAUDIT[LoginAudit]TOAPPLICATION_LOGWITH(QUEUE_DELAY=1000,ON_FAILURE=CONTINUE)GOCREATESERVERAUDITSPECIFICATION[TestServerAudit]FORSERVERAUDIT[LoginAudit]ADD(SUCCESSFUL_LOGIN_GROUP)WITH(STATE=ON)GODatabaseAuditsAuditeven

9、tsthathappenatthedatabaselevel(Schema,Ownership,Data,etc.)CREATEDATABASEAUDITSPECIFICATION[SchemaAudit]FORSERVERAUDIT[SchemaAudit]ADD(SCHEMA_OBJECT_CHANGE_GROUP)WITH(STATE=On)GOAvailabilityandreliabilityHOTSWAPCPUsAddstheabilitytoaddCPUsontheflywhilethemachineisupandrunningAutomat

10、icallyrecognizesadditionalCPUands