{"id":41921,"date":"2017-04-21T00:00:00","date_gmt":"2017-04-20T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/administrirovanie-sql-servera-razrabot"},"modified":"2020-02-18T13:44:41","modified_gmt":"2020-02-18T10:44:41","slug":"administrirovanie-sql-servera-razrabot","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","title":{"rendered":"Administrarea serverului SQL: dezvoltare, securitate, creare BD","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

SQL Server<\/strong> \u2013 un produs unic, capabil s\u0103 func\u021bioneze cu un volum imens de baze de date informa\u021bionale, \u00eendepline\u0219te func\u021bii de programare \u0219i administrare.<\/span><\/p>\n

Administrarea serverului SQL presupune dezvoltarea sistemului de baze de date informa\u021bionale, crearea unui sistem de securitate, formularea bazei de date \u0219i a obiectelor, facilit\u00e2nd accesul utilizatorilor la informa\u021biile disponibile \u00een baz\u0103. <\/span>
\nAdministratorul creeaz\u0103 periodic copiile de siguran\u021b\u0103, verific\u0103 integritatea sistemului de informa\u021bii, controleaz\u0103 volumul permis al fi\u0219ierelor informa\u021bionale \u0219i jurnalului de tranzac\u021bii.<\/span><\/p>\n

BD \u2014 o colec\u021bie denumit\u0103 de componente interconectate<\/span><\/strong><\/p>\n

Aceast\u0103 baz\u0103 este gestionat\u0103 de un sistem special, care reprezint\u0103 un complex de limbaje \u0219i instrumente software ce \u00eei men\u021bin actualitatea \u0219i organizeaz\u0103 o c\u0103utare rapid\u0103 a informa\u021biilor dorite. <\/span>
\nStructurarea BD<\/span>
\nPentru a organiza o baz\u0103 de date informa\u021bional\u0103 de calitate, administratorul trebuie s\u0103 abordeze cu responsabilitate, s\u0103 studieze \u00een detaliu numeroase op\u021biuni de utilizare a informa\u021biilor disponibile, s\u0103 prevad\u0103 integrarea probabil\u0103 cu alte sisteme \u0219i accesul, precum \u0219i, prin utilizarea tehnologiilor moderne, s\u0103 fac\u0103 modific\u0103rile necesare \u00een sistem.<\/span><\/p>\n

Administrarea SQL server<\/a> se realizeaz\u0103 \u00een dou\u0103 versiuni.<\/span><\/strong><\/p>\n

Prima \u2013 fi\u0219ier-server, \u00een care baza de date este localizat\u0103 pe fi\u0219ier-server<\/a>, acesta asigur\u0103 stocarea bazei de date informa\u021bionale \u0219i accesul la ea de c\u0103tre clien\u021bii care lucreaz\u0103 pe diferite computere. Procesarea se efectueaz\u0103 pe sta\u021biile de lucru, unde sunt transmise fi\u0219ierele bazei de date. Pe computerele personale ale clien\u021bilor exist\u0103 un sistem de management care proceseaz\u0103 informa\u021biile transmise.<\/span>
\nVersiunea client-server, pe l\u00e2ng\u0103 p\u0103strare, efectueaz\u0103 procesarea \u00eentregului volum de date. Cererea trimis\u0103 pentru execu\u021bie, generat\u0103 de client, provoac\u0103 c\u0103utarea \u0219i extragerea informa\u021biilor necesare. Informa\u021biile sunt transportate prin re\u021bea de la server la client.<\/span>
\nClient-server const\u0103 din dou\u0103 p\u0103r\u021bi: partea client \u0219i partea server.<\/span>
\nPartea client este situat\u0103 pe computerul personal, av\u00e2nd func\u021bii de asigurare a interfe\u021bei grafice.<\/span>
\nPartea server este localizat\u0103 pe un server dedicat<\/a> \u0219i contribuie la asigurarea separ\u0103rii informa\u021biei, gestion\u0103rii bazei de date informa\u021bionale, serviciilor de administrare \u0219i m\u0103surilor de securitate. <\/span>
\nSistemul client-server este caracterizat prin utilizarea unei abord\u0103ri lingvistice speciale, care structureaz\u0103 cererile \u0219i ofer\u0103 instrumente eficiente pentru accesul la baza de date.<\/span><\/p>\n

 <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

SQL Server \u2013 un produs unic, capabil s\u0103 lucreze cu cantit\u0103\u021bi uria\u0219e de baze de date, \u00eendepline\u0219te func\u021bii de programare \u0219i administrare. Administrarea serverului SQL presupune dezvoltarea unui sistem de baz\u0103 de date, crearea unui sistem de securitate, elaborarea bazei de date \u0219i a obiectelor, permi\u021b\u00e2nd accesul utilizatorilor la informa\u021biile disponibile \u00een baz\u0103.<\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":1016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-41921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Administrare pl\u0103tit\u0103 a serverelor SQL de c\u0103tre speciali\u0219tii no\u0219tri | ProHoster","description":"SQL Server este un produs unic, capabil s\u0103 func\u021bioneze cu un num\u0103r enorm de baze de date, execut\u00e2nd func\u021bii de programare \u0219i administrare.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47 \u041f\u043b\u0430\u0442\u043d\u043e\u0435 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 SQL \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u043d\u0430\u0448\u0438\u043c\u0438 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u0430\u043c\u0438 | ProHoster","og:description":"SQL Server \u2013 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442, \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 \u043e\u0433\u0440\u043e\u043c\u043d\u044b\u043c \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e\u043c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f.","og:url":"https:\/\/prohoster.info\/ro\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2017-04-20T21:00:00+00:00","article:modified_time":"2020-02-18T10:44:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"41921","title":"\ud83e\udd47 Administrare pl\u0103tit\u0103 a serverelor SQL de c\u0103tre speciali\u0219tii no\u0219tri | #site_title","description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-22 15:36:49","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 00:08:31","updated":"2026-02-22 15:36:49","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/41921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=41921"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/41921\/revisions"}],"predecessor-version":[{"id":162054,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/41921\/revisions\/162054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media\/1016"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=41921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=41921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=41921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}