欢迎来到天天文库
浏览记录
ID:43708125
大小:653.50 KB
页数:33页
时间:2019-10-13
《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
此文档下载收益归作者所有