{"id":3441,"date":"2020-11-19T17:39:45","date_gmt":"2020-11-19T22:39:45","guid":{"rendered":"https:\/\/niixer.com\/?p=3441"},"modified":"2020-11-19T17:41:09","modified_gmt":"2020-11-19T22:41:09","slug":"bases-de-datos-con-sql-server","status":"publish","type":"post","link":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/","title":{"rendered":"Bases de datos con Sql Server"},"content":{"rendered":"\n<p>Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD. Consisten en la colecci\u00f3n de datos o informaci\u00f3n interrelacionada relevante a una empresa o prop\u00f3sito, y un conjunto de herramientas para controlar la gesti\u00f3n y el acceso a dichos datos, la mencionada SGBD normalmente se denomina base de datos.<\/p>\n\n\n\n<p>Su objetivo principal es brindar el almacenamiento y recuperaci\u00f3n de datos de forma tanto pr\u00e1ctica como eficiente. Los sistemas de bases de datos se crean para la manipulaci\u00f3n de grandes cantidades de informaci\u00f3n.<\/p>\n\n\n\n<p>La gesti\u00f3n de bases de datos necesita de mecanismos de manipulaci\u00f3n t de estructuras suficientes de almacenamiento de informaci\u00f3n. Dada la gran cantidad de informaci\u00f3n y lo cr\u00edtico o importante de esta, un sistema de base de dato debe proporcionar la fiabilidad adecuada para evitar perdida o robo de la misma.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es Microsoft Sql Server?<\/h2>\n\n\n\n<p>Asimismo, como se indic\u00f3 anteriormente, un pilar fundamental para la creaci\u00f3n, administraci\u00f3n y gesti\u00f3n de bases de datos relacionales (RDBMS), La empresa Microsoft produjo y una herramienta para este objetivo, gestionar bases de datos.<\/p>\n\n\n\n<p>Sql Server, la herramienta de la que hablamos, es un sistema de gesti\u00f3n de bases de datos relacionales (RDBMS) cuyo principal lenguaje de consulta es Transact-SQL. <\/p>\n\n\n\n<p>Una de las aplicaciones de las normas ANSI \/ ISO standard Structured Query Languaje (SQL) o por sus siglas en espa\u00f1ol Lenguaje estructurado de consultas que permite sistematizar infinitas cantidades informaci\u00f3n en archivos cuyo peso resulta peque\u00f1o.<\/p>\n\n\n\n<p>A partir de diversos mecanismos, Sql Server brinda mayor dinamismo y flexibilidad para soportar procesos asociados a datos. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Beneficios de usar SQL SERVER<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Aumenta la agilidad en la transferencia y en la recopilaci\u00f3n de bases de datos.<\/li><li>Genera m\u00faltiples recursos para realizar una correcta extracci\u00f3n, transformaci\u00f3n y tratamiento de la informaci\u00f3n empresarial.<\/li><li>Brinda soporte estrat\u00e9gico para el tratamiento de datos no estructurados en contextos de an\u00e1lisis de productividad, y tambi\u00e9n en torno al comportamiento de los consumidores en la web (anal\u00edtica).<\/li><li>Genera rentabilidad en los departamentos administrativos al disponer de soluciones integrales.<\/li><li>Permite que las empresas crezcan y escalen de forma segura sobre la base de protocolos de seguridad de la informaci\u00f3n.<\/li><li>Realiza indexaciones y gestiona los procesos de modificaci\u00f3n de datos que los colaboradores realizan.<\/li><li>SQL Server ejecuta operaciones de recuperaci\u00f3n y restauraci\u00f3n de informaci\u00f3n mientras las funciones del programa permanecen activadas.<\/li><li>Alta compatibilidad con los entornos de programaci\u00f3n y los lenguajes de Microsoft .NET.<\/li><\/ul>\n\n\n\n<p>Este sistema incluye una versi\u00f3n reducida, llamada MSDE con el mismo motor de base de datos, pero orientado a proyectos m\u00e1s peque\u00f1os. Desde su versi\u00f3n 2005 pasa a ser el SQL Express Edition, que se distribuye en forma gratuita.<\/p>\n\n\n\n<p><strong>Autor<\/strong>:&nbsp;<a href=\"https:\/\/niixer.com\/index.php\/author\/jbenavidesm1\/\">Juan Sebasti\u00e1n Benavides Mart\u00ednez<\/a><\/p>\n\n\n\n<p><strong>Editor<\/strong>:&nbsp; Carlos Pinz\u00f3n<\/p>\n\n\n\n<p><strong>C\u00f3digo<\/strong>: UCP1-4<\/p>\n\n\n\n<p><strong>Universidad<\/strong>:&nbsp;<a href=\"https:\/\/www.ucentral.edu.co\/\">Universidad Central<\/a><\/p>\n\n\n\n<p><strong>Fuentes<\/strong>:<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<pre class=\"wp-block-preformatted\">Hern\u00e1ndez, J y Santamar\u00eda J. (2008). <em>SQL SERVER VS MySQL<\/em> [Monograf\u00eda, Administraci\u00f3n de Sistemas de Informaci\u00f3n, I.E.S. San Vicente]. sqlserver.pdf. https:\/\/iessanvicente.com\/colaboraciones\/sqlserver.pdf\n\nGlobalbit. (2019). <em>8 beneficios de Microsoft SQL Server para las empresas y negocios<\/em>. Globalbit. <a href=\"http:\/\/www.globalbit.co\/2019\/05\/21\/8-beneficios-de-microsoft-sql-server-para-las-empresas-y-negocios\/\">http:\/\/www.globalbit.co\/2019\/05\/21\/8-beneficios-de-microsoft-sql-server-para-las-empresas-y-negocios\/<\/a>\n\nGlobalbit. (2019). <em>sql-cover-blog<\/em> [Imagen]. Globalbit. <a href=\"http:\/\/www.globalbit.co\/2019\/05\/21\/8-beneficios-de-microsoft-sql-server-para-las-empresas-y-negocios\/\">http:\/\/www.globalbit.co\/2019\/05\/21\/8-beneficios-de-microsoft-sql-server-para-las-empresas-y-negocios\/<\/a>\n\nSilberschatz, A, Korth, H y Sundarshan, S. (s.f.). <em>FUNDAMENTOS DE BASES DE DATOS<\/em>. McGraw-Hill Interamericana de Espa\u00f1a, S. A. U. https:\/\/d1wqtxts1xzle7.cloudfront.net\/58207512\/Fundamentos_de_Bases_de_datos_Abraham_Silberschatz.pdf?1547787832=&amp;response-content-disposition=inline%3B+filename%3DFundamentos_de_Bases_de_datos_Abraham_Si.pdf&amp;Expires=1605819207&amp;Signature=F7fK1xSaKFYcIfVAkaLCJFF5bkalNULcpymSJdqNxQe0I1Dx-C79T7nip7gM10BM84UOXe77zKgfPWgRwMUjngigquU9InCWrFUG-KWV3a8mVyVssF8j5hnLXDDTm4~KfSGMuibWmhPnsOqGLeqY2maNUHzKcobSbjmyvwJwQWz6ES-9wgXXeK6QuGlgP4lgFrLxqMZB8rLBT-TWgUoQe3PPm~gwJGjrZAv2KndC4-IpUuqDT8jRSiiNL24vtApEg1ZtVnOku5aZcrPmxA7nj44E-d--8daHA6Pikzd3GTAqMDpajNLA1Iu~VNP2nxJmF0RcUcEzyJX3Kqc7IJHusA__&amp;Key-Pair-Id=APKAJLOHF5GGSLRBV4ZA<\/pre>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD. Consisten en la colecci\u00f3n de datos o informaci\u00f3n interrelacionada relevante a una empresa o prop\u00f3sito, y un conjunto de herramientas para controlar la gesti\u00f3n y el acceso a dichos datos, la mencionada SGBD normalmente se denomina baseSeguir Leyendo<\/p>\n","protected":false},"author":29,"featured_media":3446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[30],"tags":[295,692,694],"class_list":["post-3441","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-niixer","tag-bases-de-datos","tag-sql-server","tag-transact-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Bases de datos con Sql Server<\/title>\n<meta name=\"description\" content=\"Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bases de datos con Sql Server\" \/>\n<meta property=\"og:description\" content=\"Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Portal de noticias de tecnolog\u00eda, Realidad Virtual, Aumentada y Mixta, Videojuegos\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/niixer\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-19T22:39:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-19T22:41:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1122\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Juan Sebastian Benavidez Martinez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Juan Sebastian Benavidez Martinez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bases de datos con Sql Server","description":"Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"Bases de datos con Sql Server","og_description":"Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD.","og_url":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/","og_site_name":"Portal de noticias de tecnolog\u00eda, Realidad Virtual, Aumentada y Mixta, Videojuegos","article_publisher":"https:\/\/www.facebook.com\/niixer\/","article_published_time":"2020-11-19T22:39:45+00:00","article_modified_time":"2020-11-19T22:41:09+00:00","og_image":[{"width":1122,"height":500,"url":"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png","type":"image\/png"}],"author":"Juan Sebastian Benavidez Martinez","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Juan Sebastian Benavidez Martinez","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#article","isPartOf":{"@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/"},"author":{"name":"Juan Sebastian Benavidez Martinez","@id":"https:\/\/niixer.com\/#\/schema\/person\/c4a7fe3229d2083479c78ed44df8451c"},"headline":"Bases de datos con Sql Server","datePublished":"2020-11-19T22:39:45+00:00","dateModified":"2020-11-19T22:41:09+00:00","mainEntityOfPage":{"@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/"},"wordCount":498,"commentCount":0,"publisher":{"@id":"https:\/\/niixer.com\/#organization"},"image":{"@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png","keywords":["Bases de datos","Sql Server","Transact-SQL"],"articleSection":["Niixer"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/","url":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/","name":"Bases de datos con Sql Server","isPartOf":{"@id":"https:\/\/niixer.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png","datePublished":"2020-11-19T22:39:45+00:00","dateModified":"2020-11-19T22:41:09+00:00","description":"Actualmente, se conocen los sistemas gestores de bases de datos con siglas SGBD.","breadcrumb":{"@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#primaryimage","url":"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png","contentUrl":"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png","width":1122,"height":500,"caption":"SQLSERVER"},{"@type":"BreadcrumbList","@id":"https:\/\/niixer.com\/index.php\/2020\/11\/19\/bases-de-datos-con-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/niixer.com\/"},{"@type":"ListItem","position":2,"name":"Bases de datos con Sql Server"}]},{"@type":"WebSite","@id":"https:\/\/niixer.com\/#website","url":"https:\/\/niixer.com\/","name":"Portal de noticias de tecnolog\u00eda, ciencia, Android, iOS, Realidad Virtual, Aumentada y Mixta, Videojuegos, computadores, todo lo mas reciente en tecnolog\u00eda","description":"Portal de noticias de tecnolog\u00eda","publisher":{"@id":"https:\/\/niixer.com\/#organization"},"alternateName":"Niixer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/niixer.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/niixer.com\/#organization","name":"Niixer","alternateName":"Niixer.com","url":"https:\/\/niixer.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/niixer.com\/#\/schema\/logo\/image\/","url":"https:\/\/niixer.com\/wp-content\/uploads\/2022\/08\/logo-niixer-sin-fondo-1.png","contentUrl":"https:\/\/niixer.com\/wp-content\/uploads\/2022\/08\/logo-niixer-sin-fondo-1.png","width":140,"height":140,"caption":"Niixer"},"image":{"@id":"https:\/\/niixer.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/niixer\/","https:\/\/www.instagram.com\/niixer.tecnologia\/"]},{"@type":"Person","@id":"https:\/\/niixer.com\/#\/schema\/person\/c4a7fe3229d2083479c78ed44df8451c","name":"Juan Sebastian Benavidez Martinez","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/8cf55f0def2802743824fd647c898644d472431e7a0a3698dcb0439530872bb1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8cf55f0def2802743824fd647c898644d472431e7a0a3698dcb0439530872bb1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8cf55f0def2802743824fd647c898644d472431e7a0a3698dcb0439530872bb1?s=96&d=mm&r=g","caption":"Juan Sebastian Benavidez Martinez"},"sameAs":["http:\/\/www.niixer.com"],"url":"https:\/\/niixer.com\/index.php\/author\/jbenavidesm1\/"}]}},"jetpack_featured_media_url":"https:\/\/niixer.com\/wp-content\/uploads\/2020\/11\/sql-cover-blog.png","_links":{"self":[{"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/posts\/3441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/comments?post=3441"}],"version-history":[{"count":1,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/posts\/3441\/revisions"}],"predecessor-version":[{"id":3447,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/posts\/3441\/revisions\/3447"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/media\/3446"}],"wp:attachment":[{"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/media?parent=3441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/categories?post=3441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/niixer.com\/index.php\/wp-json\/wp\/v2\/tags?post=3441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}