<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://geeks.ms/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>geeks.ms : SQL Server &amp;quot;Denali&amp;quot;, CodePlex</title><link>http://geeks.ms/blogs/johnbulla/archive/tags/SQL+Server+_2600_quot_3B00_Denali_2600_quot_3B00_/CodePlex/default.aspx</link><description>Etiquetas: SQL Server &amp;quot;Denali&amp;quot;, CodePlex</description><dc:language /><generator>CommunityServer 2008.5 SP1 (Build: 31106.3070)</generator><item><title>AdventureWorks for SQL Server Denali CTP1</title><link>http://geeks.ms/blogs/johnbulla/archive/2011/01/31/adventureworks-for-sql-server-denali-ctp1.aspx</link><pubDate>Tue, 01 Feb 2011 03:07:00 GMT</pubDate><guid isPermaLink="false">2a2e7ade-7474-448b-9de5-1515d8bb7d1b:188226</guid><dc:creator>johnbulla</dc:creator><slash:comments>0</slash:comments><wfw:commentRss xmlns:wfw="http://wellformedweb.org/CommentAPI/">http://geeks.ms/blogs/johnbulla/rsscomments.aspx?PostID=188226</wfw:commentRss><comments>http://geeks.ms/blogs/johnbulla/archive/2011/01/31/adventureworks-for-sql-server-denali-ctp1.aspx#comments</comments><description>&lt;p&gt;&lt;iframe scrolling="no" frameborder="0" src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fgeeks.ms%2Fblogs%2Fjohnbulla%2Farchive%2F2011%2F01%2F31%2Fadventureworks-for-sql-server-denali-ctp1.aspx&amp;amp;layout=standard&amp;amp;show_faces=true&amp;amp;width=450&amp;amp;action=like&amp;amp;colorscheme=light&amp;amp;height=80" style="width:450px;height:80px;overflow:hidden;"&gt;&lt;/iframe&gt;&lt;/p&gt;
&lt;p&gt;&lt;img height="84" width="240" src="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/SQL_5F00_Server_5F00_Denali_5F00_thumb_5F00_13060AB9.png" border="0" style="background-image:none;border-right-width:0px;padding-left:0px;padding-right:0px;display:inline;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;padding-top:0px;" alt="" /&gt;&amp;nbsp; &lt;img height="78" width="279" src="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_46635270.png" alt="image" border="0" title="image" style="border-right-width:0px;display:inline;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;" /&gt;&lt;/p&gt;
&lt;p&gt;Hola Amig@s:&lt;/p&gt;
&lt;p align="justify"&gt;Esta versi&amp;oacute;n est&amp;aacute; dedicada a las bases de datos de ejemplo AdventureWorks que se incluyen en Microsoft&amp;reg; SQL Server con nombre c&amp;oacute;digo &amp;quot;Denali&amp;quot;, Community Technical Preview 1 (CTP1). Esta versi&amp;oacute;n utiliza el AdventureWorks2008R2, AdventureWorksDW2008R2 y bases de datos de muestra. Estas se han actualizado a &amp;quot;Denali&amp;quot; versi&amp;oacute;n CTP1&lt;/p&gt;
&lt;p align="justify"&gt;Estas bases de datos no se puede instalar en cualquier versi&amp;oacute;n de SQL Server que no sean de SQL Server con nombre c&amp;oacute;digo &amp;quot;Denali&amp;quot; CTP1.&lt;/p&gt;
&lt;p align="justify"&gt;&lt;strong&gt;Requisitos previos:&lt;/strong&gt;&lt;/p&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;div align="justify"&gt;&lt;/div&gt;
Microsoft SQL Server &amp;quot;Denali&amp;quot; CTP1 debe estar instalado. &lt;/li&gt;
&lt;li&gt;Full-Text search debe estar habilitado. &lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;&lt;strong&gt;Instalaci&amp;oacute;n de AdventureWorks2008R2 OLTP:&lt;/strong&gt;&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Haga clic &lt;a target="_blank" href="http://msftdbprodsamples.codeplex.com/releases/view/55330#DownloadId=165399"&gt;aqu&amp;iacute;&lt;/a&gt; para descargar el archivo de datos &lt;em&gt;AdventureWorks2008R2&lt;/em&gt;.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Leer y aceptar el acuerdo de licencia.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Buscar una ubicaci&amp;oacute;n en su servidor local y guardar el archivo de datos.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Desde SQL Server Management Studio, ejecute el siguiente c&amp;oacute;digo: &lt;br /&gt;
&lt;div class="wlWriterEditableSmartContent" id="scid:812469c5-0cb0-4c63-8c15-c81123a09de7:293613bd-d9ec-421b-ab53-bf5e55d04211" style="padding-bottom:0px;margin:0px;padding-left:0px;padding-right:0px;display:inline;float:none;padding-top:0px;"&gt;
&lt;pre class="sql"&gt;CREATE DATABASE AdventureWorks2008R2
ON (FILENAME = &amp;#39;&amp;lt;drive&amp;gt;:\&amp;lt;file path&amp;gt;\AdventureWorks2008R2_Data.mdf&amp;#39;) 
FOR ATTACH_REBUILD_LOG ;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;/ol&gt;
&lt;p&gt;&lt;a href="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_38FBBB0F.png"&gt;&lt;img height="251" width="528" src="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_thumb_5F00_256E5B6E.png" border="0" style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:block;float:none;margin-left:auto;border-top:0px;margin-right:auto;border-right:0px;padding-top:0px;" alt="" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Instalaci&amp;oacute;n de AdventureWorksDW2008R2 Data Warehouse:&lt;/strong&gt;&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Haga clic &lt;a target="_blank" href="http://msftdbprodsamples.codeplex.com/releases/view/55330#DownloadId=165405"&gt;aqu&amp;iacute;&lt;/a&gt; para descargar el archivo de datos &lt;em&gt;AdventureWorksDW2008R2&lt;/em&gt;.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Leer y aceptar el acuerdo de licencia.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Buscar una ubicaci&amp;oacute;n en su servidor local y guardar el archivo de datos.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;
&lt;div align="justify"&gt;Desde SQL Server Management Studio, ejecute el siguiente c&amp;oacute;digo:
&lt;div class="wlWriterEditableSmartContent" id="scid:812469c5-0cb0-4c63-8c15-c81123a09de7:609e276c-f26f-414c-8a05-af26d709a534" style="padding-bottom:0px;margin:0px;padding-left:0px;padding-right:0px;display:inline;float:none;padding-top:0px;"&gt;
&lt;pre class="sql"&gt;CREATE DATABASE AdventureWorksDW2008R2
ON (FILENAME = &amp;#39;&amp;lt;drive&amp;gt;:\&amp;lt;file path&amp;gt;\AdventureWorksDW2008R2_Data.mdf&amp;#39;)
FOR ATTACH_REBUILD_LOG ;&lt;/pre&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;/ol&gt;
&lt;p&gt;&lt;a href="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_4C78F4E3.png"&gt;&lt;img height="251" width="528" src="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_thumb_5F00_23FA12CF.png" border="0" style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" alt="" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;a href="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_1C21FA60.png"&gt;&lt;img height="398" width="431" src="http://geeks.ms/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/johnbulla/image_5F00_thumb_5F00_53F43E83.png" border="0" style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:block;float:none;margin-left:auto;border-top:0px;margin-right:auto;border-right:0px;padding-top:0px;" alt="" /&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Saludos,&lt;/p&gt;

&lt;p&gt;&lt;a href="http://www.addthis.com/bookmark.php?v=250&amp;amp;pub=johnbulla" class="addthis_button"&gt;&lt;img height="16" width="125" src="http://s7.addthis.com/static/btn/v2/lg-share-en.gif" alt="Bookmark and Share" style="border-right-width:0px;border-top-width:0px;border-bottom-width:0px;border-left-width:0px;" /&gt;&lt;/a&gt;&lt;/p&gt;&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://geeks.ms/aggbug.aspx?PostID=188226" width="1" height="1"&gt;</description><category domain="http://geeks.ms/blogs/johnbulla/archive/tags/AdventureWorks/default.aspx">AdventureWorks</category><category domain="http://geeks.ms/blogs/johnbulla/archive/tags/CodePlex/default.aspx">CodePlex</category><category domain="http://geeks.ms/blogs/johnbulla/archive/tags/SQL+Server+_2600_quot_3B00_Denali_2600_quot_3B00_/default.aspx">SQL Server &amp;quot;Denali&amp;quot;</category><category domain="http://geeks.ms/blogs/johnbulla/archive/tags/Denali/default.aspx">Denali</category></item></channel></rss>