1SQLserver原文:SQLserverSQLSQLisStructuredQueryLanguageEnglishacronym,whichmeansfortheStructuredQueryLanguage.SQLlanguageisthemainfunctionofestablishingtieswiththevariousdatabases,forcommunication.InaccordancewithANSI(AmericanNationalStandardsInstitute)requirements,SQLasarelationaldatabasemanagementsystemstandardlanguage.SQLstatementscanbeusedtoimplementawiderangeofoperations,suchasupdatingthedatainthedatabase,extractdatafromthedatabaseandsoon.Atpresent,thevastmajorityofthepopularrelationaldatabasemanagementsystemssuchasOracle,Sybase,MicrosoftSQLServer,Access,adoptedthestandardSQLlanguage.AlthoughmanydatabasesontheSQLstatementfortheredevelopmentandexpansion,butincludingtheSelect,Insert,Update,Delete,Create,andDrop,includingthestandardSQLcommandscanbeusedtocompletealmostallthedatabaseoperations.SQLServerSQLServerisarelationaldatabasemanagementsystem.ItwasoriginallyproposedbyMicrosoftSybaseandAshton-Tatethreecompaniesjointlydevelopedin1988withtheintroductionofthefirstOS/2version.AftertheintroductionofWindowsNTin,MicrosoftandSybaseinthedevelopmentofSQLServeronthesplit,MicrosoftwillmigratetoSQLServeronWindowsNTsystem,focusingonpromotingthedevelopmentofSQLServerversionofWindowsNT.SybaseismorefocusedonSQLServerintheUNIXoperatingsystemapplications.SQLServer2000isMicrosoftLaunchestheSQLServerdatabasemanagementsystem,theinheritedversionofSQLServer7.0versionofthemerits,atthesametimeitincreasesthanmanyofthemoreadvancedfeatures.Goodscalabilitywitheaseofuseandrelatedhighdegreeofsoftware2integration,acrossfromtherunningMicrosoftWindows98laptoprunningMicrosoftWindows2000large-scalemulti-processorserverssuchastheuseofmultipleplatforms.SQLServer2005SQLServer2005isacomprehensivedatabaseplatform,theuseofintegratedbusinessintelligence(BI)toolstoprovideenterprise-classdatamanagement.SQLServer2005relationaldatabaseenginefordataandstructureddatatoprovideamoresecureandreliablestoragefunctionthatallowsyoutobuildandmanagehighavailabilityforbusinessandhigh-performancedataapplications.SQLServer2005dataengineistheenterprisedatamanagementsolutionsforthecore.TheSQLServer2005combinestheanalysis,reporting,integrationandnotifications.Thismakesyourbusinesscanbuildanddeploycost-effectiveBIsolutionsthathelpyourteamthroughtheScorecard,Dashboard,Webservicesanddataapplicationstomobiledevicestoallareasofbusiness.WithMicrosoftVisualStudio,MicrosoftOfficeSystemandthenewdevelopmentkit(includingtheBusinessIntelligenceDevelopmentStudio)toenablethecloseintegrationofSQLServer2005unique.Whetheryou'readeveloper,databaseadministrator,informationworkerordecision-makers,SQLServer2005thatcanprovideyouwithinnovativesolutionstohelpyoubenefitfrommoredata.MicrosoftSQLServer2008SQLServer2008isamajorproductversion,itintroducedmanynewfeaturesandKeyimprovementsmadetodateithasbecomethestrongestandmostcomprehensiveversionofSQLServer.ThearticledescribedindetailinMicrosoftSQLServer2008'snewfeatures,advantagesandfeatures……Microsoft'sdataplatformtomeetthesedataexplosionandthenextgenerationofdata–drivenapplicationsthatdemandandsupportthedataplatformvision:mission-criticalenterprisedataplatform,dynamicdevelopment,relationaldataand3businessintelligence.MicrosoftdataplatformvisionSQLServer'svisionManyfactorshaveledtoanexplosionofinformationstorage.Anewtypeofinformation,suchaspicturesanddigitalvideo,andRFIDtagsobtainedfromthesensorinformation,thecompany'sdigitalinformationintherapidgrowthofthenumber.Compliancewiththenormsandrequirementsofthedevelopmentofglobalization,thesecurityofinformationstorageandareavailableatanytime.Atthesametime,thecostofdiskstoragesignificantlyreducedsothateverydollarinvestedcanstoremoredata.Userstomovequicklyinalargeamountofdatatofindrelevantinformation.Inaddition,onanydevicetheywanttousethisinformation,andplantouseeveryday,suchastheMicrosoftOfficesystemapplications.Theexplosionofdataanduserexpectationsforanincreaseinthemanagementofthecompanyhascreatedmanychallenges.Microsoft?dataplatformvisiontoprovideasolutiontomeettheseneeds,thissolutioniscompaniescanstoreandmanagetheuseofmanydatatypes,includingXML,e-mail,time/calendar,files,documents,geographic,etc.,atthesametimeprovidearichsetofservicestointeractwiththedata:search,query,dataanalysis,reporting,dataintegration,synchronizationandpowerful.Userscanaccessfromthecreationtoarchivetoanydevice,fromdesktoptomobiledevicesTheplatformhasthefollowingcharacteristics:Trusted-allowsthecompanycanbeaveryhighsecurity,reliabilityandscalabilitytoruntheirmostmission-criticalapplications.Efficient-allowsthecompanytoreducedevelopmentandmanagementoftheirdatainfrastructureofthetimeandcost.Intelligence-providesacomprehensiveplatformforusersinyourtimeofneedtosendhimtoobserveandinformation.Atrusted4(A)theprotectionofyourinformationInthepastthebasisofSQLServer2005on,SQLServer2008madethefollowingenhancementstoexpanditssecurity:*SimpledataencryptionSQLServer2008canbetheentiredatabase,datafilesandlogfilesforencryption,withoutrequiringchangestoapplications.Encryptenablecompaniestomeetcompliancewiththenormsandtheirconcernaboutdataprivac