{"id":"https://openalex.org/W159920384","doi":null,"title":"Programming SQL Server 2005","display_name":"Programming SQL Server 2005","publication_year":2006,"publication_date":"2006-02-21","ids":{"openalex":"https://openalex.org/W159920384","mag":"159920384"},"language":"en","primary_location":{"id":"mag:159920384","doi":null,"is_oa":false,"landing_page_url":"https://openlibrary.org/books/OL7581037M/Programming_SQL_Server_2005","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"volume":null,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Bill Hamilton","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Bill Hamilton","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5365,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.79769179,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5547000169754028,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.5547000169754028,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.43309998512268066,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.0007999999797903001,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microsoft-sql-server-2005","display_name":"SQL Server 2005","score":0.9990000128746033},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.9039999842643738},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.5950000286102295},{"id":"https://openalex.org/keywords/database-scalability","display_name":"database scalability","score":0.8399999737739563},{"id":"https://openalex.org/keywords/enterprise-application-development","display_name":"enterprise application development","score":0.6620000004768372},{"id":"https://openalex.org/keywords/database-interoperability","display_name":"database interoperability","score":0.6299999952316284},{"id":"https://openalex.org/keywords/database-automation","display_name":"database automation","score":0.5899999737739563},{"id":"https://openalex.org/keywords/c","display_name":"C++","score":0.6060000061988831},{"id":"https://openalex.org/keywords/visual-studio-2005","display_name":"Visual Studio 2005","score":0.9350000023841858},{"id":"https://openalex.org/keywords/database-services","display_name":"database services","score":0.44699999690055847}],"concepts":[{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.832358717918396},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8248512744903564},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.732119619846344},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.7151534557342529},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.701931357383728},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6165720224380493},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.6128349900245667},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5771723389625549},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5522239804267883},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.5414910316467285},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.47110918164253235},{"id":"https://openalex.org/C512115632","wikidata":"https://www.wikidata.org/wiki/Q134067","display_name":"Microsoft Visual Studio","level":3,"score":0.4536818563938141},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4310375154018402},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.39713168144226074},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3475819230079651},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.33169305324554443},{"id":"https://openalex.org/C164554305","wikidata":"https://www.wikidata.org/wiki/Q71550","display_name":"Application server","level":2,"score":0.3075038194656372},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.28094860911369324},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.15215620398521423},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:159920384","doi":null,"is_oa":false,"landing_page_url":"https://openlibrary.org/books/OL7581037M/Programming_SQL_Server_2005","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2515107547","https://openalex.org/W2526355381","https://openalex.org/W631860388","https://openalex.org/W2414406540","https://openalex.org/W21178272","https://openalex.org/W7061617231","https://openalex.org/W2239987096","https://openalex.org/W582070860","https://openalex.org/W2514981893","https://openalex.org/W7048960514"],"abstract_inverted_index":{"SQL":[0,36,52,101,148,151,203,213,237,249,271],"Server":[1,37,53,102,149,152,204,214,250,272],"2005,":[2,215],"Microsoft's":[3,66],"next-generation":[4],"data":[5,32,47,182],"management":[6],"and":[7,27,82,96,111,133,158,167,178,187,196,259,281],"analysis":[8],"solution,":[9],"represents":[10],"a":[11,18,58,229,240],"huge":[12],"leap":[13],"forward.":[14],"It":[15,70],"comes":[16],"with":[17,233,236,278],"myriad":[19],"of":[20,42,65,90,99,113,175,201,211,220,283],"changes":[21,95],"that":[22,162],"deliver":[23],"increased":[24],"security,":[25],"scalability,":[26],"power--making":[28],"it":[29,191],"the":[30,75,91,94,100,108,114,117,136,173,199,244,288],"complete":[31],"package.":[33],"Used":[34],"properly,":[35],"2005":[38,54,139,153,205,251],"can":[39,154,225],"help":[40,155],"organizations":[41],"all":[43,74,209,221],"sizes":[44],"meet":[45],"their":[46],"challenges":[48],"head":[49],"on.":[50],"Programming":[51,202,212],"from":[55],"O'Reilly":[56],"provides":[57],"practical":[59],"look":[60],"at":[61],"this":[62,122,291],"updated":[63],"version":[64],"premier":[67],"database":[68,180],"product.":[69],"guides":[71],"you":[72,143],"through":[73],"new":[76,97,118,245],"features,":[77],"explaining":[78],"how":[79,83,145],"they":[80],"work":[81],"to":[84,146,189,193,207,218,243,261,268],"use":[85],"them.":[86],"The":[87,105,223],"first":[88],"half":[89],"book":[92,224],"examines":[93],"features":[98,110],"Engine":[103],"itself.":[104],"second":[106],"addresses":[107],"enhanced":[109],"tools":[112],"platform,":[115],"including":[116],"services":[119],"blended":[120],"into":[121],"popular":[123],"version.":[124],"Each":[125],"chapter":[126],"contains":[127],"numerous":[128],"code":[129],"samples-written":[130],"in":[131,290],"C#":[132],"compiled":[134],"using":[135],"Visual":[137],"Studio":[138],"development":[140],"environment-that":[141],"show":[142],"exactly":[144],"program":[147],"2005.Programming":[150],"you:Build,":[156],"deploy,":[157],"manage":[159],"enterprise":[160],"applications":[161],"are":[163],"more":[164,253],"secure,":[165],"scalable,":[166],"reliableMaximize":[168],"IT":[169,264],"productivity":[170],"by":[171,231],"reducing":[172],"complexity":[174],"building,":[176],"deploying,":[177],"managing":[179],"applicationsShare":[181],"across":[183],"multiple":[184],"platforms,":[185],"applications,":[186],"devices":[188],"make":[190],"easier":[192],"connect":[194],"internal":[195],"external":[197],"systemsBecause":[198],"goal":[200],"is":[206],"introduce":[208],"facets":[210],"it's":[216],"beneficial":[217],"programmers":[219],"levels.":[222],"be":[226],"used":[227],"as":[228,239,257],"primer":[230,260],"developers":[232],"little":[234],"experience":[235],"Server,":[238],"ramp":[241],"up":[242],"programming":[246],"models":[247],"for":[248,252],"experienced":[254],"programmers,":[255],"or":[256],"background":[258],"specific":[262],"concepts.Any":[263],"professional":[265],"who":[266],"wants":[267],"learn":[269],"about":[270],"2005's":[273],"comprehensive":[274],"feature":[275],"set,":[276],"interoperability":[277],"existing":[279],"systems,":[280],"automation":[282],"routine":[284],"tasks":[285],"will":[286],"find":[287],"answers":[289],"authoritative":[292],"guide.":[293]},"counts_by_year":[],"updated_date":"2026-09-29T14:09:16.559479","created_date":"2016-06-24T00:00:00"}