{"id":"https://openalex.org/W24189673","doi":null,"title":"Microsoft SQL Server 2008 R2 Unleashed","display_name":"Microsoft SQL Server 2008 R2 Unleashed","alternate_titles":[],"publication_year":2010,"publication_date":"2010-09-16","ids":{"openalex":"https://openalex.org/W24189673","mag":"24189673"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:1521186","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1521186","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W24189673"],"child_works_count":0,"type":"article","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":"https://openalex.org/A5027465384","display_name":"Ray Rankins","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Ray Rankins","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081734442","display_name":"Paul Bertucci","orcid":"https://orcid.org/0000-0001-8676-4156","observed_orcids":["https://orcid.org/0000-0001-8676-4156"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Paul Bertucci","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021080396","display_name":"Chris Gallelli","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Chris Gallelli","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5041098663","display_name":"Alex T. Silverstein","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Alex T. Silverstein","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":2.9824,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.91998029,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":98},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.926800012588501,"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.926800012588501,"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.06379999965429306,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.0026000000070780516,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql-server-management-studio","display_name":"SQL Server Management Studio","score":0.8629999756813049},{"id":"https://openalex.org/keywords/powershell","display_name":"PowerShell","score":0.7689999938011169},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.8709999918937683},{"id":"https://openalex.org/keywords/data-backup-and-recovery","display_name":"data backup and recovery","score":0.7699999809265137},{"id":"https://openalex.org/keywords/database-replication","display_name":"database replication","score":0.7609999775886536},{"id":"https://openalex.org/keywords/stored-procedures","display_name":"stored procedures","score":0.6439999938011169},{"id":"https://openalex.org/keywords/precipitating-factors","display_name":"precipitating factors","score":0.9700000286102295},{"id":"https://openalex.org/keywords/database-clustering","display_name":"database clustering","score":0.6679999828338623},{"id":"https://openalex.org/keywords/database-mirroring","display_name":"database mirroring","score":0.9990000128746033},{"id":"https://openalex.org/keywords/policy-based-management","display_name":"policy-based management","score":0.8489999771118164},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.968999981880188},{"id":"https://openalex.org/keywords/t-sql","display_name":"T-SQL","score":0.9750000238418579},{"id":"https://openalex.org/keywords/linq-to-sql","display_name":"LINQ to SQL","score":0.972000002861023},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.6259999871253967},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.9900000095367432},{"id":"https://openalex.org/keywords/data-encryption","display_name":"data encryption","score":0.5320000052452087},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.5989999771118164},{"id":"https://openalex.org/keywords/high-availability","display_name":"high availability","score":0.7940000295639038},{"id":"https://openalex.org/keywords/performance-tuning","display_name":"performance tuning","score":0.6430000066757202},{"id":"https://openalex.org/keywords/integration-services","display_name":"integration services","score":0.6570000052452087},{"id":"https://openalex.org/keywords/reporting-services","display_name":"reporting services","score":0.7979999780654907},{"id":"https://openalex.org/keywords/analysis-services","display_name":"Analysis Services","score":0.9929999709129333}],"concepts":[{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.8048365116119385},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7704335451126099},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.7347641587257385},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.7308216691017151},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.7221957445144653},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6531744003295898},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.6222553253173828},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.5640241503715515},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5593121647834778},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5506030917167664},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.49226418137550354},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.4916589856147766},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.46475592255592346},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.4477890133857727},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.442979097366333},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.35711830854415894},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.3189396858215332},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.21360266208648682},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:cds.cern.ch:1521186","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1521186","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:24189673","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/Microsoft-SQL-Server-2008-Unleashed/dp/0672330563","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/W7002307558","https://openalex.org/W6987386381","https://openalex.org/W2311240161","https://openalex.org/W2278095558","https://openalex.org/W7067816757","https://openalex.org/W637012668","https://openalex.org/W7030266174","https://openalex.org/W2291696994","https://openalex.org/W2493056297","https://openalex.org/W193899367"],"abstract_inverted_index":{"Microsoft":[0,191,346,362,368,431,459],"SQL":[1,19,37,48,72,104,131,171,192,204,210,258,264,293,347,359,363,369,428,451,460,463],"Server":[2,20,38,73,105,132,172,193,205,211,259,265,294,348,360,364,370,429,461,464],"2008":[3,21,39,41,173,194,206,465],"R2":[4,25,322,466],"Unleashed":[5],"Ray":[6,334],"Rankins":[7],"Paul":[8,373],"Bertucci":[9],"Chris":[10,396],"Gallelli":[11],"Alex":[12,410],"T.":[13,411],"Silverstein":[14,412],"Includes":[15],"full":[16],"coverage":[17,26,46],"of":[18,47,155,312,337,357,376,384,399,419,426,450],"in":[22,386,404],"addition":[23],"to":[24,36,59,235,253,267,297,304],"This":[27],"is":[28,355,413],"the":[29,110,190,214,261,286,310,446],"industrys":[30],"most":[31,112,311],"comprehensive":[32],"and":[33,40,53,62,67,76,87,96,114,117,121,136,145,158,163,199,219,229,233,238,246,256,270,282,299,307,317,330,345,354,367,393,408,416,430,442],"useful":[34],"guide":[35],"R2.":[42],"It":[43],"presents":[44],"start-to-finish":[45],"Servers":[49],"core":[50],"database":[51,99,230,244,387,405],"server":[52],"management":[54],"capabilities,":[55,116],"plus":[56],"complete":[57],"introductions":[58],"Integration,":[60],"Reporting,":[61],"Analysis":[63,313],"Services,":[64,314,316,340,402],"application":[65],"development,":[66],"much":[68,187],"more.":[69],"Four":[70],"expert":[71],"administrators,":[74],"developers,":[75],"consultants":[77],"have":[78],"packed":[79],"this":[80,186],"book":[81,183,447],"with":[82,209,242,285,343],"real-world":[83],"information,":[84],"tips,":[85],"guidelines,":[86],"samples":[88],"drawn":[89],"from":[90],"their":[91],"own":[92],"extensive":[93],"experience":[94,385],"creating":[95],"managing":[97,414],"complex":[98,113],"solutions.":[100,433],"Writing":[101],"for":[102,170,349],"intermediate-to-advanced-level":[103],"professionals,":[106],"they":[107],"focus":[108],"on":[109,129],"products":[111],"powerful":[115],"its":[118],"newest":[119,197],"tools":[120,157],"features.":[122],"For":[123],"example,":[124],"youll":[125],"find":[126],"invaluable":[127],"information":[128,159],"administering":[130],"more":[133,207,279,350,380],"efficiently,":[134],"analyzing":[135],"optimizing":[137,276],"queries,":[138,277],"implementing":[139],"data":[140,326],"warehouses,":[141],"ensuring":[142],"high":[143,394],"availability,":[144],"tuning":[146,455],"performance.":[147],"The":[148],"accompanying":[149],"CD-ROM":[150,434],"contains":[151],"an":[152],"extraordinary":[153],"library":[154],"practical":[156],"including":[160],"sample":[161],"databases":[162,443],"all":[164],"code":[165],"examples.":[166],"Whether":[167],"youre":[168],"responsible":[169],"analysis,":[174],"design,":[175,388],"implementation,":[176],"support,":[177],"administration,":[178,406],"or":[179],"troubleshooting,":[180],"no":[181],"other":[182,247],"offers":[184],"you":[185],"value.":[188],"Understand":[189],"environment,":[195],"R2s":[196],"features,":[198],"each":[200],"editions":[201],"capabilities":[202],"Manage":[203],"effectively":[208],"Management":[212,252],"Studio,":[213],"SQLCMD":[215],"command-line":[216],"query":[217],"tool,":[218],"Powershell":[220],"Efficiently":[221],"manage":[222,283],"security,":[223],"users,":[224],"backup/restore,":[225],"replication,":[226,390],"Database":[227,377],"Mail,":[228],"objectsfrom":[231],"tables":[232],"indexes":[234],"stored":[236],"procedures":[237],"triggers":[239],"Increase":[240],"availability":[241],"clustering,":[243],"mirroring,":[245],"features":[248],"Use":[249,263],"new":[250,287,321],"Policy-Based":[251],"centrally":[254],"configure":[255],"operate":[257],"throughout":[260],"organization":[262],"Profiler":[266],"capture":[268],"queries":[269],"identify":[271],"bottlenecks":[272],"Improve":[273,325],"performance":[274],"by":[275],"design":[278],"effective":[280],"databases,":[281],"workloads":[284],"Resource":[288],"Governor":[289],"Develop":[290],"applications":[291],"using":[292,328],"2008s":[295],"enhancements":[296],"T-SQL":[298],"SQLCLR,":[300],".NET":[301,432],"integration,":[302,392],"LINQ":[303],"SQL,":[305],"XML,":[306],"XQuery":[308],"Make":[309],"Integration":[315],"Reporting":[318],"Servicesespecially":[319],"Microsofts":[320],"reporting":[323],"improvements":[324],"security":[327],"Column-level":[329],"Transparent":[331],"Data":[332],"Encryption":[333],"Rankins,":[335],"president":[336,398],"Gotham":[338],"Consulting":[339,401],"has":[341,379],"worked":[342],"Sybase":[344,358],"than":[351,381],"23":[352],"years":[353,383],"coauthor":[356],"Unleashed,":[361,366],"2000":[365],"2005":[371],"Unleashed.":[372],"Bertucci,":[374],"founder":[375],"Architechs,":[378],"30":[382],"architecture,":[389],"tuning,":[391,407],"availability.":[395],"Gallelli,":[397],"CGAL":[400],"specializes":[403],"programming.":[409],"principal":[415],"chief":[417],"architect":[418],"Unified":[420],"Digital":[421],"Group,":[422],"LLC,":[423],"a":[424],"developer":[425],"custom":[427],"includes:":[435],"15":[436],"additional":[437],"chapters":[438],"Code":[439],"samples,":[440],"scripts,":[441],"utilized":[444],"within":[445],"Free":[448],"version":[449],"Shot":[452],"(performance":[453],"&":[454],"software)":[456],"Category:Database":[457],"/":[458],"Covers:Microsoft":[462],"User":[467],"Level:IntermediateAdvanced":[468]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W24189673","counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":5}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
