{"id":2601,"date":"2012-06-26T20:01:05","date_gmt":"2012-06-26T18:01:05","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/"},"modified":"2012-06-26T20:01:05","modified_gmt":"2012-06-26T18:01:05","slug":"stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/","title":{"rendered":"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012"},"content":{"rendered":"<p>Today was the real beginning of the TechEd with several sessions in parallel. So let&#8217;s have a look to what the program was&#8230;<\/p>\n<h3>Keynote: The Cloud OS<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png\" alt=\"intro\" width=\"312\" height=\"233\" \/><\/p>\n<p>This keynote was an overview of 2 themes:<\/p>\n<ul>\n<li>Modern Datacenter with Windows Server 2012 &amp; System Center 2012<\/li>\n<li>Modern apps with Visual Studio 2012<\/li>\n<\/ul>\n<p>This introduction included great demos such as Windows Server 2012 with a performance measure, based on 1000000+ I\/O per second and the power of Extensible Switch.<br \/>\nI have retained one good sentence: \u201cData is King, Knowledge is King\u201d and I\u2019m complete agree with this!:roll:<br \/>\nThen after this starter, I focused my TechEd day between 2 principle technologies:<\/p>\n<ul>\n<li>SQL Server 2012<\/li>\n<li>Windows Server 2012<\/li>\n<\/ul>\n<h3>SQL Server 2012<\/h3>\n<p>The first session I attended to was about an overview of SQL 2012.<\/p>\n<p>In regards of the hands-on I already made on SQL Server 2012 and the information I already grab about it, I didn&#8217;t lean that much new about the product itself. However I will present you the principle of \u201cThe Fantastic 12 of 2012\u201d:<\/p>\n<ol>\n<li>Blazing-Fast performance<br \/>\nWith xVelocity In-Memory Technologies like Column Store Index<br \/>\nYou can see an example in the picture<img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/xvelocity.png\" alt=\"xvelocity\" width=\"400\" height=\"299\" \/><\/li>\n<li>Security &amp; Compliance<br \/>\nWith User-defined roles(See my article <a href=\"\/sql-server-2012-how-to-create-a-server-role\">here<\/a>), Expanded Audit &amp; Filtering<\/li>\n<li>Required 9s &amp; Data Protection<br \/>\nWith Integration services as a server, StreamInsight High Availability and AlwaysOn<br \/>\nComing soon : Support for secondaries in Windows Azures<\/li>\n<li>Flexibility &amp; Choice<br \/>\nWith Common Architecture &amp; app framework, Server Appliance &amp; Private or Public Cloud<\/li>\n<li>Scale on demand<br \/>\nWith Scale-up 640 cores, 4 TB memory, DBC appliance \/ Scale-out Windows Azure SQL Database Federations<\/li>\n<li>Fast time to solution<br \/>\nWith new SSMS &amp; SSDT (SQL Server Data Tool)<\/li>\n<li>Extend any data, anywhere<br \/>\nWith php, Java &amp; linux, Spacial, Sementics Search &amp; FileTable<\/li>\n<li>New Scenarios, unlocked<br \/>\nWith oData, Data Sync, Windows Azure Marketplace<\/li>\n<li>Big Data and Data Warehousing<br \/>\nWith Hadoop in the enterprise, PDW (parallel Data Warehouse), Fast track<\/li>\n<li>Credible, Consistent Data<br \/>\nWith BI Semantic Model, DTS &amp; DQS<\/li>\n<li>Managed Self-Services BI<br \/>\nWith Sharepoint Administration, Import PowerPivot into SSAS, Managed by IT<\/li>\n<li>Rapid Data Exploration<br \/>\nWith Reporting Alerts, Power View<\/li>\n<\/ol>\n<p>That&#8217;s just some mouth-watering new features of SQL Server 2012&#8230;<br \/>\nThe second session about SQL Server 2012 I attended, was an advanced session (level 400) about Auditing in SQL Server 2012.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/audit.png\" alt=\"audit\" width=\"400\" height=\"299\" \/><\/p>\n<p>Very interesting session but it\u2019s a oftenly covered subject. Here just a summary of the most important enhancements:<\/p>\n<ul>\n<li>SQL Audit for all editions<\/li>\n<li>User-Defined Audit<\/li>\n<li>Audit Filtering<\/li>\n<li>Audit Resilience<\/li>\n<\/ul>\n<h3>Windows Server 2012 overview<\/h3>\n<p>Now, let&#8217;s get an eye on Windows Server 2012 and in particular Hyper-V 2012. What&#8217;s news in this version, why and how can I advise my customers to install it?<\/p>\n<p>That was the questions I had when I went to the session on Windows Server 2012 overview\u2026<br \/>\nHere the answers, 3 reasons for the &#8220;Why&#8221;:<\/p>\n<ol>\n<li>Comprehensive Cloud Platform<\/li>\n<li>Cost saving and increased efficiencies (reduce storage cost, multi-server management)<\/li>\n<li>Support for a modern work style (VDI)<\/li>\n<\/ol>\n<h4>Management and automation<\/h4>\n<p>It\u2019s a metro style for the server manager and a good dashboard to manage all servers. On free labs, I play with it and took some pictures<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/serverman2.png\" alt=\"serverman2\" width=\"400\" height=\"299\" \/><\/p>\n<p>The task manager has changed&#8230; Seing the CPU &amp; RAM for a user or a app is pretty funny!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/taskman1.png\" alt=\"taskman1\" width=\"400\" height=\"536\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/taskman2.png\" alt=\"taskman2\" width=\"400\" height=\"299\" \/><\/p>\n<p>Beside that there are more enhancements in regards of management and automation<\/p>\n<ul>\n<li>Role and feature deployement<\/li>\n<li>Integred console<\/li>\n<li>2400 cmdlets<\/li>\n<li>Disconnected Sessions<\/li>\n<li>Windows PowerShell Workflow<\/li>\n<li>Windows PowerShell Web Access<\/li>\n<li>Windows PowerShell ISE (IntelliSence in PowerShell)<\/li>\n<li>Script Sharing<\/li>\n<li>Syntax Simplification and IntelliSence<\/li>\n<\/ul>\n<p><em>GUI is a role and you can switch between core and GUI version easily.<\/em><\/p>\n<p><strong>Storage enhancements:\u00a0 <\/strong><\/p>\n<ul>\n<li>Storage spaces<\/li>\n<li>Files system improvements<\/li>\n<li>Thin provisioning<\/li>\n<li>Cluster Shared Volume<\/li>\n<li>SMB 3.0 for workload<\/li>\n<li>Offloaded data transfer<\/li>\n<li>Transparent failover<\/li>\n<li>NFS Support<\/li>\n<li>iSCSI target<\/li>\n<li>Storage management<\/li>\n<\/ul>\n<p><strong>Networking enhancements:<\/strong><\/p>\n<ul>\n<li>Nic Teaming<\/li>\n<li>Network virtualization<\/li>\n<li>DHCP server failover<\/li>\n<li>Single Root I\/O virtualization<\/li>\n<li>Ressource Metering<\/li>\n<li>Dynamic Virtual Machine Queue<\/li>\n<li>IP Address Management<\/li>\n<li>Quality of Service<\/li>\n<li>BranchCache<\/li>\n<li>SMB Direct and Multichannel<\/li>\n<\/ul>\n<h3><\/h3>\n<h3>Windows Server 2012 Hyper-V<\/h3>\n<p>A few months ago, I presented the new Hyper-V (See <a href=\"\/windows-server-8-hyper-v-30-a-real-step-forward-in-virtualization\">here<\/a>) even if it wasn&#8217;t already named like that.<br \/>\nI will just give you my return about Virtual Machine Mobility.<\/p>\n<p>Live Migration is very easy to use. But be careful when you choose the move option with the three possibilities and then perform the move. It\u2019s done in a few minutes and seems magic!<\/p>\n<p>If the cable is cut or a crash from the destination, what\u2019s happen? No problem, the VM is online on the source and the destination is available only when the full transfer is done and that the VM on destination is started.<\/p>\n<h3>It&#8217;s the end of the day<\/h3>\n<p>So finally we arrived on the end of my first day with already pretty much new information, new features &amp; demos.<br \/>\nHope that I wont get a &#8220;buffer overflow&#8221; during the next days&#8230; \ud83d\ude44<br \/>\nNo! Just play a bit with some fighting robots get you all set for the next days&#8230;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/bots.png\" alt=\"bots\" width=\"400\" height=\"299\" \/><\/p>\n<p>To be continued&#8230;Tomorrow \ud83d\ude00<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today it\u2019s the real beginning of the TechEd with several sessions in parallel.<\/p>\n","protected":false},"author":15,"featured_media":2602,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[99],"tags":[297,295,14,49,143,67,265],"class_list":["post-2601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-availability-groups","tag-hyper-v","tag-i-o","tag-microsoft","tag-monitoring","tag-performance","tag-sql-server-2008"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012 - dbi services | Blog<\/title>\n<meta name=\"description\" content=\"I share or focus my TechEd day between 2 principle technologies: SQL Server 2012 &amp; Windows Server 2012.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012\" \/>\n<meta property=\"og:description\" content=\"I share or focus my TechEd day between 2 principle technologies: SQL Server 2012 &amp; Windows Server 2012.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-26T18:01:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"299\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012\",\"datePublished\":\"2012-06-26T18:01:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/\"},\"wordCount\":815,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/intro.png\",\"keywords\":[\"Availability groups\",\"Hyper-V\",\"I\\\/O\",\"Microsoft\",\"Monitoring\",\"Performance\",\"SQL Server 2008\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/\",\"name\":\"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012 - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/intro.png\",\"datePublished\":\"2012-06-26T18:01:05+00:00\",\"description\":\"I share or focus my TechEd day between 2 principle technologies: SQL Server 2012 & Windows Server 2012.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/intro.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/intro.png\",\"width\":400,\"height\":299},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012 - dbi services | Blog","description":"I share or focus my TechEd day between 2 principle technologies: SQL Server 2012 & Windows Server 2012.","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:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/","og_locale":"en_US","og_type":"article","og_title":"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012","og_description":"I share or focus my TechEd day between 2 principle technologies: SQL Server 2012 & Windows Server 2012.","og_url":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2012-06-26T18:01:05+00:00","og_image":[{"width":400,"height":299,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012","datePublished":"2012-06-26T18:01:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/"},"wordCount":815,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png","keywords":["Availability groups","Hyper-V","I\/O","Microsoft","Monitoring","Performance","SQL Server 2008"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/","url":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/","name":"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012 - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png","datePublished":"2012-06-26T18:01:05+00:00","description":"I share or focus my TechEd day between 2 principle technologies: SQL Server 2012 & Windows Server 2012.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/04\/intro.png","width":400,"height":299},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/stphteched-2012-episode2-u2013-sql-server-2012-a-windows-server-2012\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"St\u00e9ph@TechEd 2012: Episode2 \u2013 SQL Server 2012 &amp; Windows Server 2012"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2601"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2601\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2602"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}