{"id":203090,"date":"2023-06-16T10:52:44","date_gmt":"2023-06-16T10:52:44","guid":{"rendered":"https:\/\/datascientest.com\/?p=203090"},"modified":"2023-11-09T13:51:59","modified_gmt":"2023-11-09T13:51:59","slug":"microsoft-sql-server-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir","title":{"rendered":"Microsoft SQL Server : Tout ce qu&rsquo;il faut savoir"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"203090\" class=\"elementor elementor-203090\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-87328aa e-flex e-con-boxed e-con\" data-id=\"87328aa\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-14b99bc elementor-widget elementor-widget-heading\" data-id=\"14b99bc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Microsoft SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle d\u00e9velopp\u00e9 par Microsoft. Depuis sa cr\u00e9ation en 1989, SQL Server a \u00e9volu\u00e9 pour devenir une v\u00e9ritable plateforme d'informations d'entreprise pour servir un large \u00e9ventail d'applications. Il est dot\u00e9 d\u2019un ensemble d\u2019outils permettant la gestion et l\u2019administration d\u2019une base de donn\u00e9es, la programmation \u00e0 travers T-SQL (Transact-SQL), sa propre impl\u00e9mentation du langage SQL, la Business Intelligence et l'analyse des donn\u00e9es ainsi que le d\u00e9veloppement d\u2019applications.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d58a7f6 e-flex e-con-boxed e-con\" data-id=\"d58a7f6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1920e98 elementor-widget elementor-widget-text-editor\" data-id=\"1920e98\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">SQL Server est <strong>compatible avec plusieurs langages de programmation<\/strong>, tels que C#, Java, <a href=\"https:\/\/datascientest.com\/python-tout-savoir\">Python<\/a> et <a href=\"https:\/\/datascientest.com\/langage-r-tout-savoir\">R<\/a>, et avec les syst\u00e8mes Windows et Linux et peut \u00eatre d\u00e9ploy\u00e9 sur site et dans le cloud.<\/span><\/p><p><span style=\"font-weight: 400;\">SQL Server existe sous forme de plusieurs \u00e9ditions dont notamment :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Enterprise :<\/b><span style=\"font-weight: 400;\"> utilis\u00e9 dans les grandes entreprises. Il fournit une s\u00e9curit\u00e9 haut de gamme, des analyses avanc\u00e9es, un apprentissage automatique, etc.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Standard :<\/b><span style=\"font-weight: 400;\"> appropri\u00e9 aux applications de niveau interm\u00e9diaire et <\/span><span style=\"font-weight: 400;\">aux datamarts<\/span><span style=\"font-weight: 400;\">.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server WEB :<\/b><span style=\"font-weight: 400;\"> con\u00e7u pour les h\u00e9bergeurs Web.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>D\u00e9veloppeur SQL Server :<\/b><span style=\"font-weight: 400;\"> principalement utilis\u00e9 pour la construction d&rsquo;applications, le test et la d\u00e9monstration.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Express :<\/b><span style=\"font-weight: 400;\"> version gratuite destin\u00e9e aux applications \u00e0 petite \u00e9chelle.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f98a8d9 e-flex e-con-boxed e-con\" data-id=\"f98a8d9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3122d6f elementor-widget elementor-widget-heading\" data-id=\"3122d6f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Les composants et services cl\u00e9s de SQL Server<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-afd1fc1 elementor-widget elementor-widget-text-editor\" data-id=\"afd1fc1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SQL Server est un SGBD (Syst\u00e8me <\/span><span style=\"font-weight: 400;\">de Gestion de Bases de Donn\u00e9es) <\/span><span style=\"font-weight: 400;\">client\/serveur dont les principaux composants et services sont :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Moteur de base de donn\u00e9es :<\/b><span style=\"font-weight: 400;\"> ce composant constitue le noyau du SGBDR (<\/span><span style=\"font-weight: 400;\">Syst\u00e8me <\/span><span style=\"font-weight: 400;\">de Gestion de <a href=\"https:\/\/datascientest.com\/bases-de-donnees-relationnelles\">Bases de Donn\u00e9es Relationnelles<\/a>)<\/span><span style=\"font-weight: 400;\">. Il g\u00e8re les op\u00e9rations de stockage, de r\u00e9cup\u00e9ration et de modification des donn\u00e9es, ainsi que l&rsquo;ex\u00e9cution des requ\u00eates SQL.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Serveur SQL :<\/b><span style=\"font-weight: 400;\"> ce service d\u00e9marre, arr\u00eate, interrompt et poursuit une instance de Microsoft SQL Server.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Agent SQL Server :<\/b><span style=\"font-weight: 400;\"> il joue le r\u00f4le de planificateur de t\u00e2ches. Il permet de planifier et d&rsquo;automatiser l&rsquo;ex\u00e9cution de t\u00e2ches r\u00e9currentes dans SQL Server, telles que les sauvegardes, les importations\/exportations de donn\u00e9es ou l&rsquo;ex\u00e9cution de proc\u00e9dures stock\u00e9es<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Navigateur SQL Server :<\/b> une solution logicielle d&rsquo;aide \u00e0 la gestion des instances SQL Server. Il permet aux utilisateurs de se connecter et d&rsquo;interagir facilement avec leurs bases de donn\u00e9es SQL Server. Il simplifie les t\u00e2ches administratives telles que l&rsquo;interrogation des bases de donn\u00e9es, la gestion de la s\u00e9curit\u00e9 et la surveillance des performances du serveur.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb03ce5 elementor-widget elementor-widget-image\" data-id=\"cb03ce5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/sql-server.png\" class=\"attachment-full size-full wp-image-203114\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/sql-server.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/sql-server-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/sql-server-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-010a79b elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"010a79b\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-engineer\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Tout ma\u00eetriser sur SQL Server<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3473aad e-flex e-con-boxed e-con\" data-id=\"3473aad\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-68ef3fa elementor-widget elementor-widget-heading\" data-id=\"68ef3fa\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Les principaux outils de SQL Server<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b99c3c9 elementor-widget elementor-widget-text-editor\" data-id=\"b99c3c9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Bien que sa fonction principale soit celle d&rsquo;un SGBDR, SQL Server<\/span> <span style=\"font-weight: 400;\">est dot\u00e9 d&rsquo;une intelligence int\u00e9gr\u00e9e \u00e0 travers une gamme d\u2019outils de veille \u00e9conomique, d\u2019analyse et de g\u00e9n\u00e9ration de rapports, dont les principaux outils sont :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Management Studio (SSMS)<\/b><span style=\"font-weight: 400;\"> : c&rsquo;est l&rsquo;outil principal pour la gestion et l&rsquo;administration de SQL Server. Il permet d&rsquo;effectuer des t\u00e2ches telles que la cr\u00e9ation et la modification de bases de donn\u00e9es, la conception de tables, l&rsquo;\u00e9criture et l&rsquo;ex\u00e9cution de requ\u00eates SQL, la gestion des utilisateurs et des autorisations, la configuration des serveurs, etc.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Data Tools (SSDT) <\/b><span style=\"font-weight: 400;\">: il s\u2019agit d\u2019un environnement de d\u00e9veloppement int\u00e9gr\u00e9 (IDE) utilis\u00e9 pour cr\u00e9er, d\u00e9ployer et g\u00e9rer des projets de base de donn\u00e9es SQL Server. Il fournit des fonctionnalit\u00e9s pour la conception de sch\u00e9mas de bases de donn\u00e9es, la cr\u00e9ation de proc\u00e9dures stock\u00e9es, de fonctions, de vues, de d\u00e9clencheurs, etc. SSDT est int\u00e9gr\u00e9 \u00e0 Visual Studio.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Configuration Manager<\/b><span style=\"font-weight: 400;\"> : cet outil permet de g\u00e9rer les param\u00e8tres de configuration du serveur SQL Server. Il permet de d\u00e9marrer, arr\u00eater et configurer les instances de serveur SQL, de g\u00e9rer les protocoles r\u00e9seau, les services, les alias de connexion, etc.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Profiler<\/b><span style=\"font-weight: 400;\"> : un outil de surveillance et de d\u00e9bogage qui permet de capturer et d&rsquo;analyser les \u00e9v\u00e9nements qui se produisent sur un serveur SQL. Il permet de suivre les <a href=\"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre\">requ\u00eates SQL<\/a>, les performances du serveur, les erreurs, les d\u00e9clencheurs, etc.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Integration Services (SSIS)<\/b><span style=\"font-weight: 400;\"> : c\u2019est un outil d&rsquo;int\u00e9gration de donn\u00e9es qui permet de cr\u00e9er et de g\u00e9rer des flux de travail d&rsquo;extraction, de transformation et de chargement (<a href=\"https:\/\/datascientest.com\/extract-transform-load-tout-savoir\">ETL<\/a>). Il facilite l&rsquo;importation, l&rsquo;exportation et la transformation de donn\u00e9es entre diff\u00e9rentes sources et destinations.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Analysis Services (SSAS)<\/b><span style=\"font-weight: 400;\"> : l\u2019outil de traitement analytique en ligne (<a href=\"https:\/\/datascientest.com\/olap-tout-savoir-sur-cette-puissante-organisation-des-bases-de-donnees\">OLAP<\/a>). Il <\/span><span style=\"font-weight: 400;\">fournit des fonctionnalit\u00e9s d&rsquo;analyse et d\u2019exploration de donn\u00e9es et d&rsquo;apprentissage automatique.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Reporting Services (SSRS)<\/b><span style=\"font-weight: 400;\"> : cet outil de cr\u00e9ation et de gestion de rapports bas\u00e9s sur des donn\u00e9es provenant de diff\u00e9rentes sources <\/span><span style=\"font-weight: 400;\">inclut notamment l&rsquo;int\u00e9gration avec <a href=\"https:\/\/datascientest.com\/hadoop\">Hadoop<\/a><\/span><b>.<\/b><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>SQL Server Command Line Utilities<\/b> : SQL Server fournit des utilitaires en ligne de commande tels que SQLCMD et BCP (Bulk Copy Program) pour l&rsquo;ex\u00e9cution de scripts SQL, l&rsquo;importation et l&rsquo;exportation de donn\u00e9es en masse, la gestion des bases de donn\u00e9es, etc.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f1be795 e-flex e-con-boxed e-con\" data-id=\"f1be795\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2e553f8 elementor-widget elementor-widget-heading\" data-id=\"2e553f8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Pour conclure<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bf88d7e elementor-widget elementor-widget-text-editor\" data-id=\"bf88d7e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SQL Server est un syst\u00e8me de gestion de bases de donn\u00e9es populaire et performant sous Windows. Il inclut des outils pour la <a href=\"https:\/\/datascientest.com\/business-intelligence\">Business Intelligence<\/a> et la transformation de donn\u00e9es brutales en informations exploitables, adapt\u00e9s aux projets d\u00e9cisionnels. C&rsquo;est un syst\u00e8me con\u00e7u pour mettre en place des applications de management, des <a href=\"https:\/\/datascientest.com\/data-warehouse-2\">Data Warehouses<\/a> et des applications analytiques complexes et optimis\u00e9es. La configuration, la maintenance et la mise \u00e0 jour sont faciles gr\u00e2ce \u00e0 des outils conviviaux. Enfin, SQL Server peut g\u00e9rer de nombreuses bases de donn\u00e9es simultan\u00e9ment.<\/span><\/p><p><span style=\"font-weight: 400;\">Bien qu\u2019il soit disponible en version gratuite (<\/span><b>SQL Server Express<\/b><span style=\"font-weight: 400;\">),<\/span> <span style=\"font-weight: 400;\">il impose l\u2019acquisition de licences pour le d\u00e9ploiement d\u2019une application professionnelle.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7320206 elementor-widget elementor-widget-text-editor\" data-id=\"7320206\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si vous souhaitez en savoir plus sur les bases de donn\u00e9es, n\u2019h\u00e9sitez pas \u00e0 <strong>consulter notre formation de Data Engineer<\/strong>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc08205 elementor-widget__width-initial elementor-widget elementor-widget-video\" data-id=\"dc08205\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/_kZKaG3ZOnM&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-01be363 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"01be363\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-engineer\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir la formation Data Engineer<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-99d1dae e-flex e-con-boxed e-con\" data-id=\"99d1dae\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b7c75bb elementor-widget elementor-widget-html\" data-id=\"b7c75bb\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Les composants et services cl\u00e9s de SQL Server\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"SQL Server est un SGBD (Syst\u00e8me de Gestion de Bases de Donn\u00e9es) client\/serveur dont les principaux composants et services sont : Moteur de base de donn\u00e9es : ce composant constitue le noyau du SGBDR (Syst\u00e8me de Gestion de Bases de Donn\u00e9es Relationnelles). Il g\u00e8re les op\u00e9rations de stockage, de r\u00e9cup\u00e9ration et de modification des donn\u00e9es, ainsi que l'ex\u00e9cution des requ\u00eates SQL.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Les principaux outils de SQL Server\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Bien que sa fonction principale soit celle d'un SGBDR, SQL Server est dot\u00e9 d'une intelligence int\u00e9gr\u00e9e \u00e0 travers une gamme d\u2019outils de veille \u00e9conomique, d\u2019analyse et de g\u00e9n\u00e9ration de rapports, dont les principaux outils sont : SQL Server Management Studio (SSMS) : c'est l'outil principal pour la gestion et l'administration de SQL Server. Il permet d'effectuer des t\u00e2ches telles que la cr\u00e9ation et la modification de bases de donn\u00e9es, la conception de tables, l'\u00e9criture et l'ex\u00e9cution de requ\u00eates SQL, la gestion des utilisateurs et des autorisations, la configuration des serveurs, etc. SQL Server Data Tools (SSDT) : il s\u2019agit d\u2019un environnement de d\u00e9veloppement int\u00e9gr\u00e9 (IDE) utilis\u00e9 pour cr\u00e9er, d\u00e9ployer et g\u00e9rer des projets de base de donn\u00e9es SQL Server. Il fournit des fonctionnalit\u00e9s pour la conception de sch\u00e9mas de bases de donn\u00e9es, la cr\u00e9ation de proc\u00e9dures stock\u00e9es, de fonctions, de vues, de d\u00e9clencheurs, etc. SSDT est int\u00e9gr\u00e9 \u00e0 Visual Studio.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Microsoft SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle d\u00e9velopp\u00e9 par Microsoft. Depuis sa cr\u00e9ation en 1989, SQL Server a \u00e9volu\u00e9 pour devenir une v\u00e9ritable plateforme d&rsquo;informations d&rsquo;entreprise pour servir un large \u00e9ventail d&rsquo;applications. Il est dot\u00e9 d\u2019un ensemble d\u2019outils permettant la gestion et l\u2019administration d\u2019une base de donn\u00e9es, la programmation [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":203092,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft SQL Server : Tout ce qu&#039;il faut savoir<\/title>\n<meta name=\"description\" content=\"Microsoft SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle d\u00e9velopp\u00e9 par Microsoft. Les d\u00e9tails dans cet article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server : Tout ce qu&#039;il faut savoir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-16T10:52:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:51:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/Illu_BLOG__SQL_serv.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1025\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\",\"name\":\"Microsoft SQL Server : Tout ce qu'il faut savoir\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-06-16T10:52:44+00:00\",\"dateModified\":\"2023-11-09T13:51:59+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Microsoft SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle d\u00e9velopp\u00e9 par Microsoft. Les d\u00e9tails dans cet article.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft SQL Server : Tout ce qu'il faut savoir","description":"Microsoft SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle d\u00e9velopp\u00e9 par Microsoft. Les d\u00e9tails dans cet article.","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:\/\/datascientest.com\/microsoft-sql-server-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Microsoft SQL Server : Tout ce qu'il faut savoir","og_url":"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-06-16T10:52:44+00:00","article_modified_time":"2023-11-09T13:51:59+00:00","og_image":[{"width":1025,"height":563,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/Illu_BLOG__SQL_serv.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir","url":"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir","name":"Microsoft SQL Server : Tout ce qu'il faut savoir","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-06-16T10:52:44+00:00","dateModified":"2023-11-09T13:51:59+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Microsoft SQL Server est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle d\u00e9velopp\u00e9 par Microsoft. Les d\u00e9tails dans cet article.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/203090"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=203090"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/203090\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/203092"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=203090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=203090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=203090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}