Pluralsight com Developing and Deploying SQL Server ISV Applications 視頻教學 英文教學版     軟體簡介:   LearnhowtoproperlymakeuseofSQLServerinyour applications,avoidingcommondesign,security,coding, performance,andinstallationproblems,applicablefor developerscreatingapplicationsthatuseSQLServer2005onward. Therearemanyimportantconsiderationswhencreatingand deployinganapplicationthatusesSQLServerfordatastorage, whetheryouworkforalargeorsmallISV,andarecreatinga complexorsimpleapplication.It'scriticalthatyour applicationperformswellunderload,keepstheuserdata secure,andisabletobeinstalledandupgradedeasily.This courseexplainsalltheseconsiderationsusingalayered approachthattiesintostagesinthedevelopmentlifecycle.The coursebeginsbyexaminingdatabasedesignandschema considerations,plusgeneralbestpracticesaroundsecurity usingroles,logins,andusers.Itthenexplainsand demonstratesnumerousaspectsofT-SQLcodingwherechoicescan bemadetomakethecodeandapplicationmoreefficient,and avoidcommonperformancepitfalls.Applicationandcodetesting isthenaddressed,alongwithfiguringoutthehardware, software,andSQLServerrequirementsthatmustbecommunicated totheusers.Thecourseendsbywalkingthroughthedeployment phase,includingcommonSQLServeranddatabaseconfiguration optionsthatmustbechangedorleftasthedefaultvalue,and explaininghowtoensurethatapplicationanddatabaseupgrades runsmoothly.Thiscourseisperfectfordeveloperswhoare involvedinthedevelopmentlifecycleofapplicationsthatuse SQLServerfordatastorage.Theinformationinthecourse appliestoallversionsfromSQLServer2005onward.