SQL Server 2008 Turbocharging the Database

TedKummert,corporatevicepresident,DataandStoragePlatformDivision

Untilrecently,CareGroupstruggledtokeepupwiththechallengeofauditingits3。

5millionpatientrecords,whichconstituteabout2terabytesofinformation。

Whenthecompanyheardaboutthenewauditing,securityandmanagementfeaturesofSQLServer2008,itdecidedtobeginupgradingitsnearly400databasesevenbeforetheproductwasformallyreleased。

TheenhancedauditingtoolsinSQLServer2008enableustotrackallchangestotablesandotherdataelementsinoursystem,AyadShammout,leadtechnicaldatabaseadministratoratCareGroup,toldthePASSSummitattendees。

Withelectronicmedicalrecords,wecantbedownforevenasecond;physiciansandnursesneedtheabilitytoimmediatelyaccessthedatabaseatalltimes。

SQLServerhasprovenitselfabletomeetthesedemands。

Likesomanyenterprises,CareGrouphasdiscoveredthatupgradingtoSQLServer2008isasmartITinvestmentInfact,sincethedebutofSQLServer2008inAugust,customershavedownloadedmorethan1millioncopiesofthesoftwareplatform。

Thousandsofcustomersandpartnersacrossawiderangeofindustriesarealreadyusingittobuildmission-criticalapplications。

CostSavingsAreJusttheBeginning

ASeptember2008studycommissionedbyMicrosoftandconductedbyForresterConsulting,TotalEconomicImpactofSQLServer2008Upgrade,discussesthepotentialfinancialbenefitsthatenterprisesmightrealizebyupgradingtoSQLServer2008。

Thestudyconcludes:SQLServer2008offersmanyfeaturesthatimprovetheperformance,administration,integration,securityandavailabilityofSQLServerdatabases。

Inaddition,itincreasestheproductivityofDatabaseAdministratorsanddevelopers。

Lookingatonecustomersexperience,ForresterfindsthatthebenefitsofupgradingtoSQLServer2008includedeliminatingtheneedforadditionalstorage,third-partysoftwareandadditionalITemployees。

Usersalsobenefittedfrombetteruserproductivity,higherdatabaseperformanceand,andenhanceddatasecurity。

Basedondatasuppliedbythecustomer,Forresterdeterminesthatupgradinghasdeliveredarisk-adjustedreturnoninvestmentof162percent。

TedKummert,corporatevicepresidentoftheDataandStoragePlatformDivisionatMicrosoft,reinforcedthispointduringhisaddresstothePASScommunityonWednesday。

Kummertnotedthatnoothervendoroffersafullyintegrateddataplatformwithrichfunctionalityoutoftheboxforsuchalowprice。

Inadifficulteconomicclimatelikeours,softwarepurchasingdecisionscanhaveasignificantimpactonanorganizationsabilitytogetbetterresults,optimizeexistinginfrastructure,maximizeefficiency,increaseproductivityandcutcosts,Kummertsaid。

TheenhancementsandnewcapabilitiesengineeredintoSQLServer2008enableapplicationstorunbetterandreducetheamountoftimeITprosneedtospendmanagingthem。

SQLServer2008isanintegrateddatamanagementandbusinessintelligence(BI)platform。

Thismeansthatdataisintegrated,cleansed,aggregated,stored,madeaccessibletoasuiteofenterprisereportingandanalyticstools,anddeliveredthroughMicrosoftOffice。

WethinkofitasSQLServer2008turbochargingyourdata,convertingitfromacommodityintoapowerfuldriverofbusinessdecisions,saidKummert。

LookingAhead

KummertexplainedthatMicrosoftsgoalistodeliveradataplatformthatmeetstheneedsofdatabaseadministrators,developersandenduserstodayandtomorrow。

Hesaidthecompanyscontinuingdevelopmentworkisfocusedonfourmainareas:enterprisedataplatform,platformforalldata,dynamicdevelopmentandpervasiveinsight。

InanoverviewofMicrosoftscurrentandfuturedataplatforminvestments,Kummerthighlightednewfeaturesandreleasescustomerscanexpectoverthenext24to36months。

Enterprisedataplatform。

MicrosoftcompletedtheacquisitionofDATAllegroinSeptember,andiscurrentlyworkingonaproject,code-namedMadison,thatwillenablemassivelyparallelprocessingforSQLServer。

Madisonwillallowcustomerstoscaleouttheirdatawarehousestohundredsofterabytes。

MicrosoftwillbeginpreviewingMadisonwithinthenext12months,withfullproductavailabilityscheduledforthefirsthalfof2010。

Inaddition,inconjunctionwiththereleaseofWindowsServer2008R2,thecompanyisworkingwithhardwarevendorsHP,IBMCorp。

andIntelCorp。

tosupportupto256logicalprocessors。

Thegoalistotakeadvantageofhardwareinnovationsforgreaterscalability。

AtPASS,Microsoftpreviewednewinvestmentsinapplicationandmulti-servermanagement。

Theabilitytocentrallymanageapplicationsandinstances,andhavegreaterinsightsintoresourceutilization,willenableorganizationstooptimizehardwareinvestmentsandmanagemoreefficientlyatscale。

Thiscollectionofinvestmentswillgivecustomerstheabilitytoconsolidatemoredatasourceswhilemaintainingsimilarorimprovedperformanceandscalability,andistargetedforreleaseaspartofSQLServer,code-namedKilimanjaro,inthefirsthalfof2010。

Platformforalldata。

Asapplicationdatabeginstoincludenotonlywordsandnumbersbutalsosightsandsounds,Microsoftisevolvingitsdataplatformtogobeyondrelationaldata,beyondonlineanalyticalprocessing(OLAP),totrulysupportallofthedatatypesofthefuture,includingspatial(geographic)data。

Dynamicdevelopment。

InOctober,Microsoftannouncedthesecondcommunitytechnologypreview(CTP)ofadistributed,in-memoryapplicationcachingplatform,code-namedVelocity,thatincreasestheperformanceofapplicationsbymovingthedataoutofthedatastoreandclosertotheapplicationinthemiddletier。

Velocitywillbeshippedforfreeasanout-of-bandreleaseinthesummerof2009。

MicrosoftalsoannouncedlastmonththeavailabilityofthefirstCTPofSyncFrameworkv2。

ThisversionoftheSyncFrameworkmakesiteveneasiertoaddsynchronizationcapabilitiestocustomstoresorapplications,improvessupportforfilteringandothercomplexsynchronizationproblems,andincludesbuilt-insupportforsynchronizingapplicationswithLiveMesh,MicrosoftSQLDataServicesandalldevicesthatplugintoWindows7。

Pervasiveinsight。

Microsoftiscreatingtoolsandanintegratedinfrastructurethatenablemoreemployeestomakebetter,fasterdecisionsbyunlockingthepowerofBI。

AsrevealedduringtheOctoberMicrosoftBusinessIntelligenceConference,thenewKilimanjaroreleasewillbeabigsteptowardthatgoal。

KilimanjarowilldeliverBI-focusedcapabilitiesdesignedtoempowertheenduser,suchasasetofself-serviceanalysisandreportingtoolscode-namedGemini。

Geminiwillallowuserstoaccess,aggregate,slice,diceandreportondatawithouthavingtolearnspecializedBIskills。

ByreducingusersdependenceonIT,Geminiwillenablemoreemployeestocreateandshareuser-generatedBIcontentandwillgiveITprofessionalsmoretimetoprovidestrategicvaluetotheirbusinesses。

KilimanjaroandGeminiwillbeavailableinthefirsthalfof2010,withpreviewsstartingwithinthenextyear。

AScale-OutDistributedDatabaseintheCloud

Asthedatabasecontinuestoevolve,Microsoftisextendingitsdataplatformvisiontothecloudtomakeusersdataavailableandaccessible,anyplace,andanytime。

OneofMicrosoftsnewestapproachestodatamanagementinthecloudisMicrosoftSQLServices,asetofWeb-basedservicesthatextendsthecapabilitiesofSQLServertothecloud。

PartofMicrosoftsrecentlyannouncedAzureServicesPlatform,SQLServicesincludescapabilitiesthatwillletusersperformrelationaldatabasequeries,reporting,analyticsandintegration,andsynchronizedatawithmobileusers,remoteofficesandbusinesspartners。

ThefirstsuchserviceisSQLDataServices(SDS),arelationaldataservicedesignedforenterprisedevelopersandserviceprovidersthatneedahighlyscalable,easilyprogrammableandcost-effectivedatabaseasaservicewithrobustrelationalqueryprocessingcapabilities。

SDSisbuiltonSQLServertechnologiesforsecurity,availabilityandmanageability。

MicrosoftannouncedatthePASSSummitthatapublicCTPofSDSisnowavailable,andthatusersnolongerneedaninvitationcodetoaccesstheservice;theycansimplygototheSQLDataServicesMSDNsitetogetlogincredentials。

SomecustomersarealreadyusingthebetaversionofSDS。

OneoftheseisNeoGeo,adeveloperofdatabasesystemsandotherstoragesolutionsbasedinGermany。

OneofitsproductsistheneoMediaCenter,a。

NETapplicationforstoringandmanagingdigitalmediaassets。

NeoGeowaslookingforthemostscalableandcost-effectivestoragesolutionsforitscustomersanddecidedoncloud-basedrelationalstorageusingSDS。

Welikehoweasyitistoscalestoragecapacityupordowndependingontheneedsofourcustomers,saidMarcHoeppner,managingdirectorofNeoGeo。

Inaddition,wereabletodevelopstoragesolutions50percentfasterthanwecouldbefore,andourdeploymentandoperationalcostsaremuchlower,asavingswecanpassalongtoourcustomers。

AnotherenterprisemakinguseofSDSisInfosysTechnologiesLtd。

aconsultingandinformationtechnologyservicescompanywithofficesaroundtheworld。

InfosyswasdevelopingaservicethatwouldletautomobiledealersshareinformationoninventoriesandotherresourcesviatheWeb,andchosetobuilditontheSQLDataServicesplatform。

GoingwithanInternet-baseddatabasemadeitmucheasiertodeployournewserviceandaddnewautodealerslater,andmeanszeromaintenanceforourcustomers,saidJitendraPalThethi,principalarchitect,Infosys。

Plus,wecaneasilyreplicatethesamesortofsolutionforotherverticalindustries。

MicrosoftplanstosharethesecustomerstoriesandmanymoreatthePASSCommunitySummitoverthenextthreedays。

Inaddition,300SQLServerdatabasedevelopmentengineerswillbeonhandtohearattendeestories,answerquestions,andprovideexpertinsightintocustomersmostchallengingdatamanagementissues。

SaidKummert,Thevoicesofourcustomersandpartnersguideourdevelopmentstrategy。


亚博体育app能提现吗