Search results matching tag 'Visual Studio'http://www2.sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Visual+Studio&orTags=0Search results matching tag 'Visual Studio'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Getting Started with SSIS: SSDT-BIhttp://www2.sqlblog.com/blogs/andy_leonard/archive/2015/01/07/getting-started-with-ssis-ssdt-bi.aspxWed, 07 Jan 2015 12:01:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:56894andyleonard<a mce_href="http://sqlblog.com/blogs/andy_leonard/SNAG-0023_6508755C.jpg" href="http://sqlblog.com/blogs/andy_leonard/SNAG-0023_6508755C.jpg"><img width="244" height="146" title="SNAG-0023" align="left" style="margin:0px 8px 8px 0px;border:0px currentColor;border-image:none;padding-top:0px;padding-right:0px;padding-left:0px;float:left;display:inline;background-image:none;" alt="SNAG-0023" border="0" src="http://sqlblog.com/blogs/andy_leonard/SNAG-0023_thumb_31CECCA4.jpg"></a>
<p>SQL Server Data Tools – Business Intelligence (SSDT-BI) is a rich Integrated Development Environment (IDE). It is a version of Microsoft Visual Studio, and you can tell by looking at the title bar when you open SSDT-BI. Click on the image to enlarge and you will see “Microsoft Visual Studio” right there in the title bar.</p>
<p>If the Start Page does not display, you can open it by clicking View—&gt;Start Page. There are several useful links here. Once you begin developing SSIS projects, the list of Recent Projects will populate, providing a handy way to open the last thing you were working on. There are also links to help you get started developing using the Visual Studio Shell (Integrated) IDE.</p>
<p>Let’s build an SSIS project!</p>
<p>&nbsp;</p>
<p>Click the New Project link on the Start Page to open the New Project window:</p>
<p><a mce_href="http://sqlblog.com/blogs/andy_leonard/SNAG-0025_712C8034.jpg" href="http://sqlblog.com/blogs/andy_leonard/SNAG-0025_712C8034.jpg"><img width="244" height="157" title="SNAG-0025" style="border:0px currentColor;border-image:none;padding-top:0px;padding-right:0px;padding-left:0px;display:inline;background-image:none;" alt="SNAG-0025" border="0" src="http://sqlblog.com/blogs/andy_leonard/SNAG-0025_thumb_60B69FEA.jpg"></a></p>
<p>Click to enlarge the image and you will see several project templates listed beneath the Business Intelligence virtual folder. For SSIS development, select the template named “Integration Services Project”. In the Name textbox, type a name for your project: LoadStageDatabase. Note the solution is also named LoadStageDatabase. When you enter a name for your SSIS project, SSDT-BI automatically copies the Project name to the Solution name. You can decouple the Project and Solution names by typing in the Solution name textbox. Click the Ok button to create the SSIS project and solution:</p>
<p><a mce_href="http://sqlblog.com/blogs/andy_leonard/SNAG-0026_402F6038.jpg" href="http://sqlblog.com/blogs/andy_leonard/SNAG-0026_402F6038.jpg"><img width="244" height="146" title="SNAG-0026" style="border:0px currentColor;border-image:none;padding-top:0px;padding-right:0px;padding-left:0px;display:inline;background-image:none;" alt="SNAG-0026" border="0" src="http://sqlblog.com/blogs/andy_leonard/SNAG-0026_thumb_48B55033.jpg"></a></p>
<p>Package.dtsx is created along with the project and solution. The Getting Started window also opened providing links to articles to help you get started developing SSIS packages. Feel free to click these links to learn more about SSIS development.</p>
<p>Click the Save button to save your SSIS project. </p>
<p>You’ve just created an SSIS project!</p>
<p>Learn more: <br><a target="_blank" mce_href="http://www.linchpinpeople.com/create-first-ssis-project/" href="http://www.linchpinpeople.com/create-first-ssis-project/">Watch the video!</a><br><a target="_blank" mce_href="http://www.linchpinpeople.com/tag/ssis/" href="http://www.linchpinpeople.com/tag/ssis/">Linchpin People Blog: SSIS</a> <br> <a target="_blank" mce_href="http://www.sqlservercentral.com/stairway/72494/" href="http://www.sqlservercentral.com/stairway/72494/">Stairway to Integration Services</a><br><a target="_blank" mce_href="http://quizegg.com/q/91510" href="http://quizegg.com/q/91510">Test your knowledge</a></p>Weekend reading: Microsoft/Oracle and SkyDrive based code-editorhttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2013/06/23/weekend-reading-microsoft-oracle-and-skydrive-based-code-editor.aspxSun, 23 Jun 2013 21:53:27 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:49798jamiet<p>A couple of news item caught my eye this weekend that I think are worthy of comment.</p> <h2>Microsoft/Oracle partnership to be announced tomorrow (24/06/2013)</h2> <p>According to many news site Microsoft and Oracle are about to announce a partnership (<a title="http://www.theregister.co.uk/2013/06/21/oracle_partnership_strategy/" href="http://www.theregister.co.uk/2013/06/21/oracle_partnership_strategy/" target="_blank">Oracle set for major Microsoft, Salesforce, Netsuite partnerships</a>) and they all seem to be assuming that it will be something to do with “the cloud”. I wouldn’t disagree with that assessment, Microsoft are heavily pushing Azure and Oracle seem (to me anyway) to be rather lagging behind in the cloud game. More specifically folks seem to be assuming that Oracle’s forthcoming 12c database release will be offered on Azure.</p> <p>I did a bit of reading about Oracle 12c and one of its key pillars appears to be that it supports multi-tenant topologies and multi-tenancy is a common usage scenario for databases in the cloud. I’m left wondering then, if Microsoft are willing to push a rival’s multi-tenant solution what is happening to its own cloud-based multi-tenant offering – <a href="http://msdn.microsoft.com/en-us/library/windowsazure/hh597452.aspx" target="_blank">SQL Azure Federations</a>. We haven’t heard anything about federations for what now seems to be a long time and moreover the main Program Manager behind the technology, <a href="http://www.linkedin.com/in/cihangirb" target="_blank">Cihan Biyikoglu</a>, recently left Microsoft to join Twitter. Furthermore, a Principle Architect for SQL Server, Conor Cunningham, recently presented the opening keynote at SQLBits 11 where he talked about multi-tenant solutions on SQL Azure and not once did he mention federations. All in all I don’t have a warm fuzzy feeling about the future of SQL Azure Federations so I hope that that question gets asked at some point following the Microsoft/Oracle announcement.</p> <hr /> <h2>Text Editor on SkyDrive with coding-specific features</h2> <p><a href="http://liveside.net/" target="_blank">Liveside.net</a> got a bit of a scoop this weekend with the news (<a href="http://www.liveside.net/2013/06/22/exclusive-skydrive-com-to-get-web-based-text-file-editing-features/">Exclusive: SkyDrive.com to get web-based text file editing features</a>) that Microsoft’s consumer-facing file storage service is going to get a new feature – a web-based code editor. Here’s Liveside’s screenshot:</p> <p><img src="http://liveside.net/wp-content/images/2013/06/Monaco-Text-Editor.png" width="700" height="300" /></p> <p>I’ve long had a passing interest in online code editors, indeed back in December 2009 I wondered out loud on this blog site:</p> <blockquote> <p><em>I started to wonder when the development tools that we use would also become cloud-based. After all, if we’re using cloud-based services does it not make sense to have cloud-based tools that work with them? I think it does. <br /></em><a href="http://sqlblog.com/blogs/jamie_thomson/archive/2009/12/06/project-houston.aspx" target="_blank"><em>Project Houston</em></a></p> </blockquote> <p>Since then the world has moved on. Cloud 9 IDE (<a title="https://c9.io/" href="https://c9.io/">https://c9.io/</a>) have blazed a trail in the fledgling world of online code editors and I have been wondering when Microsoft were going to start playing catch-up. I had no doubt that an online code editor was in Microsoft’s future; its an obvious future direction, why would I want to have to download and install a bloated text editor (which, arguably, is exactly what Visual Studio amounts to) and have to continually update it when I can simply open a web browser and have ready access to all of my code from wherever I am. There are signs that Microsoft is already making moves in this direction, after all the URL for their new offering Team Foundation Service doesn’t mention TFS at all – my own personalised URL for Team Foundation Service is <a href="http://jamiet.visualstudio.com">http://jamiet.visualstudio.com</a> – using “Visual Studio” as the domain name for a service that isn’t <em>strictly speaking</em> part of Visual Studio leads me to think that there’s a much bigger play here and that one day <a href="http://visualstudio.com">http://visualstudio.com</a> will house an online code editor.</p> <p>With that in mind then I find Liveside’s revelation rather intriguing, why would a code editing tool show up in Skydrive? Perhaps SkyDrive is going to get integrated more tightly into TFS, I’m very interested to see where this goes.</p> <p>The larger question playing on my mind though is whether an online code editor from Microsoft will support SQL Server developers. I have opined before (see <a title="http://sqlblog.com/blogs/jamie_thomson/archive/2010/01/12/the-sql-developer-gap-warning-rant-coming-up.aspx" href="http://sqlblog.com/blogs/jamie_thomson/archive/2010/01/12/the-sql-developer-gap-warning-rant-coming-up.aspx" target="_blank">The SQL developer gap</a>) about the shoddy treatment that SQL Server developers have to experience from Microsoft and I haven’t seen any change in Microsoft’s attitude in the three and a half years since I wrote that post. I’m constantly bewildered by the lack of investment in SQL Server developer productivity compared to the riches that are lavished upon our appdev brethren. When you consider that SQL Server is Microsoft’s third biggest revenue stream it is, frankly, rather insulting. SSDT was a step in the right direction but the hushed noises I hear coming out of Microsoft of late in regard to SSDT don’t bode fantastically well for its future.</p> <p>So, will an online code editor from Microsoft support T-SQL development? I have to assume not given the paucity of investment on us lowly SQL Server developers over the last few years, but I live in hope!</p> <hr /> <p>Your thoughts in the comments section please. I would be very interested in reading them.</p> <p><a href="http://twitter.com/jamiet" target="_blank">@Jamiet</a></p>Connected development in SSDT versus SSMShttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2013/03/19/connected-development-in-ssdt-versus-ssms.aspxTue, 19 Mar 2013 16:28:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48314jamiet<p>When you install the database projects template of SSDT you get SQL Server Object Explorer (SSOX) installed as well. SSOX is a pane within Visual Studio and is the main enabler of the Connected Development experience that the SSDT team have attempted to provide.</p> <p><a href="http://sqlblog.com/blogs/jamie_thomson/SNAGHTML15dc3f62_18DB391E.png"><img title="SNAGHTML15dc3f62" style="border-top:0px;border-right:0px;border-bottom:0px;border-left:0px;display:inline;" border="0" alt="SNAGHTML15dc3f62" width="335" height="118" src="http://sqlblog.com/blogs/jamie_thomson/SNAGHTML15dc3f62_thumb_0C6D15F5.png"></a></p> <p>SSOX provides some really cool capabilities that are not in SQL Server Management Studio (I hope to blog about them in the near future). In theory these capabilities make it possible for a database developer to spend all their time in SSDT (i.e. Visual Studio) thus making SSMS a pureplay DBA tool (this does of course depend on your definition of both a database developer and a DBA, but I’m not getting into that debate here).</p> <p>With that in mind I have spent a few days trying to work without SSMS, preferring to live wholly inside Visual Studio instead. By and large I was able to do everything I needed to do from within Visual Studio however there were a few nuances about the experience that kept pushing me back to SSMS, I detail those nuances below.</p> <p>&nbsp;</p> <hr> <h3>Server groups</h3> <p>SSOX combines the functions of SSMS’s Object Explorer and Registered Servers pane. I don’t mind either way of working but it does mean that there is no ability to group servers in SSOX like you can in the Registered Servers pane</p> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_568820DA.png"><img title="image" style="border-left-width:0px;border-right-width:0px;border-bottom-width:0px;display:inline;border-top-width:0px;" border="0" alt="image" width="244" height="97" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_4E907E78.png"></a>&nbsp;<a href="http://sqlblog.com/blogs/jamie_thomson/image_0977B142.png"><img title="image" style="border-left-width:0px;border-right-width:0px;border-bottom-width:0px;display:inline;border-top-width:0px;" border="0" alt="image" width="244" height="230" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_6C8E8C6C.png"></a> </p> <h3>F6</h3> <p>In SSMS I regularly use the F6 keyboard shortcut to jump between the query, results &amp; messages panes of a query window. No such keyboard shortcut exists in SSDT and they’ve already canned <a target="_blank" href="https://connect.microsoft.com/sqlserver/feedback/details/780990/ssdt-f6-to-move-between-panes-in-a-query-window#tabs">my request on Connect to get this fixed</a> (even though it laughably has status “closed as fixed”).</p> <p>&nbsp;<i>UPDATE: See the comments below where Brett Gerhardi informed me of a different keyboard shortcut that does the same thing as F6. Actually its not quite the same, if you have multiple resultsets in your results pane then the behaviour is slightly different to F6 in SSMS - but that's not an issue you'll hot frequently.</i></p> <h3>Change Connection</h3> <p>The context menu in SSMS provides the ability to change a connection as well as connect and disconnect:</p> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_72693005.png"><img title="image" style="border-left-width:0px;border-right-width:0px;border-bottom-width:0px;display:inline;border-top-width:0px;" border="0" alt="image" width="546" height="115" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_11ABD6D9.png"></a> </p> <p>SSDT doesn’t have change connection and believe me, you don’t know how much you use a feature until its not there:</p> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_09B43477.png"><img title="image" style="border-left-width:0px;border-right-width:0px;border-bottom-width:0px;display:inline;border-top-width:0px;" border="0" alt="image" width="438" height="58" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_28F6DB4A.png"></a> </p> <p>There’s also no hotkey to jump to “Connection” on the context menu like there is in SSMS (“C”) and I find that annoying too.</p> <p>&nbsp;</p><hr>Those were the main annoyances that forced me back to SSMS. The lack of F6 was a major bugbear for me as I am a big keyboard shortcut junkie. If such things don’t bother you then you may be able to live in Visual Studio quite happily. If you have any similar experiences to share I’d be keen to read them.<p>&nbsp;</p> <p><a target="_blank" href="http://twitter.com/jamiet">@Jamiet</a></p>Undoing a change will now undo a check-out in Visual Studio 2012http://www2.sqlblog.com/blogs/jamie_thomson/archive/2013/01/26/undoing-a-change-will-now-undo-a-check-out-in-visual-studio-2012.aspxSat, 26 Jan 2013 22:41:12 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47327jamiet<p>In my blog post <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/10/18/sql-server-devs-what-source-control-system-do-you-use-if-any-answer-and-maybe-win-free-stuff.aspx" target="_blank">SQL Server devs–what source control system do you use, if any? (answer and maybe win free stuff)</a> of 18th October 2012 I complained about one aspect of Source Control in Team Foundation Server (TFS) that infuriates me:</p> <blockquote> <p><em>…there are aspects to TFS source control that annoy me day-in, day-out. Chief among them has to be the fact that it uses a file’s read-only property to determine if a file should be checked-out or not and, if it determines that it should, it will happily do that check-out on your behalf without you even asking it to. I didn’t realise how ridiculous this was until I first used SVN about three years ago – with SVN you make any changes you wish and then use your source control client to determine which files have changed and thus be checked-in; the notion of “check-out” doesn’t even exist. That sounds like a small thing but you don’t realise how liberating it is until you actually start working that way.</em></p> </blockquote> <p>This evening I have been noodling around in Visual Studio 2012 and noticed that this behaviour has changed, as I shall now demonstrate. I opened an XML file (an <a href="http://sqlblog.com/blogs/jamie_thomson/archive/2012/05/09/publish-profile-files-in-sql-server-data-tools-ssdt.aspx" target="_blank">SSDT Publish Profile file</a> as it happens) that was checked into TFS Source Control:</p> <blockquote> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_49480522.png"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_7922A6E3.png" width="785" height="187" /></a></p> </blockquote> <p>I made a change to the file and instantly it got checked-out:</p> <blockquote> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_2C7E6A40.png"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_156FE904.png" width="799" height="196" /></a></p> </blockquote> <p>I then simply hit CTRL+Z to reverse the change I had made earlier and CTRL+S to save. At that instant the earlier check-out was reversed:</p> <blockquote> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_6F99C2A0.png"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_2693A0DA.png" width="803" height="220" /></a></p> </blockquote> <p>Finally…TFS Source Control now determines whether any changes have actually occurred before considering the file “checked-out”. I know this seems like a really minor change but I promise you, it delights me – especially given I use TFS so much (not through choice I might add).</p> <p>Perhaps this new behaviour is common knowledge in the TFS fraternity but it was news to me so I figure it might be news to some of you too. Hopefully I’m not the only one that is suitably enamoured upon learning about it.</p> <p>Note that I am using Visual Studio 2012 and <a href="http://tfs.visualstudio.com/" target="_blank">Team Foundation Service</a>.</p> <p><a href="http://twitter.com/jamiet" target="_blank">@Jamiet</a></p>Highlight Word add-in for Visual Studio 2010 [SSDT]http://www2.sqlblog.com/blogs/jamie_thomson/archive/2012/09/19/highlight-word-add-in-for-visual-studio-2010-ssdt.aspxWed, 19 Sep 2012 11:56:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45272jamiet<p>I’ve just been alerted by my colleague Kyle Harvie to a Visual Studio 2010 add-in that should prove very useful if you are an SSDT user. Its simply called <a target="_blank" href="http://visualstudiogallery.msdn.microsoft.com/4b92b6ad-f563-4705-8f7b-7f85ba3cc6bb/">Highlight all occurrences of selected word</a> and does exactly what it says on the tin, you highlight a word and it shows all other occurrences of that word in your script:</p> <blockquote> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_07C7270D.png"><img 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;" title="image" border="0" alt="image" width="623" height="263" src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_332B4807.png"></a></p> </blockquote> <p>There’s a limitation for .sql files (<a target="_blank" href="http://visualstudiogallery.msdn.microsoft.com/4b92b6ad-f563-4705-8f7b-7f85ba3cc6bb/view/Reviews">which I have reported</a>) where the highlighting doesn’t work if the word is wrapped in square brackets but what the heck, its free, it takes about ten seconds to install….install it already!</p> <p><a target="_blank" href="http://twitter.com/jamiet">@Jamiet</a></p>DAX editor for SQL Serverhttp://www2.sqlblog.com/blogs/davide_mauri/archive/2011/11/23/dax-editor-for-sql-server.aspxWed, 23 Nov 2011 06:58:10 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39948manowar<p>One of the major criticism to DAX is the lack of a decent editor and more in general of a dedicated IDE, like the one we have for T-SQL or MDX.</p> <p>Well, this is no more true. On Codeplex a very interesting an promising Visual Studio 2010 extension has been released by the beginning of November 2011:</p> <p><a title="http://daxeditor.codeplex.com/" href="http://daxeditor.codeplex.com/">http://daxeditor.codeplex.com/</a></p> <p>Intellisense, Syntax Highlighting and all the typical features offered by Visual Studio are available also for DAX.</p> <p>Right now you have to download the source code and compile it, and that’s it!</p>SQL Server 2012 : The Data Tools installer is now availablehttp://www2.sqlblog.com/blogs/aaron_bertrand/archive/2011/11/21/sql-server-2012-the-data-tools-installer-is-now-available.aspxMon, 21 Nov 2011 15:18:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:39908AaronBertrand<p>Last week when RC0 was released, the updated installer for "Juneau" (SQL Server Data Tools) was not available. Depending on how you tried to get it, you either ended up on a blank search page, or a page offering the CTP3 bits. Important note: the CTP3 Juneau bits are not compatible with SQL Server 2012 RC0.</p><p>If you already have Visual Studio 2010 installed (meaning Standard/Pro/Premium/Ultimate), you will need to install <a href="http://www.microsoft.com/download/en/details.aspx?id=23691" title="http://www.microsoft.com/download/en/details.aspx?id=23691" target="_blank">Service Pack 1</a> before continuing. You can get to the installer simply by opening Visual Studio, going to File &gt; New &gt; Project, and then choose the option "SQL Server" that appears under the "Other Languages" category (not the "SQL Server" option that appears under the "Database" category):</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/rc0_juneau_1.png" height="454" width="704">&nbsp;</p></blockquote><p>When you click OK, you will get another dialog that prompts you to install SQL Server Data Tools:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/rc0_juneau_2.png" height="260" width="476">&nbsp;</p></blockquote><p>When you click Install, your web browser will be launched on the <a href="http://msdn.microsoft.com/en-us/data/hh297027" title="http://msdn.microsoft.com/en-us/data/hh297027" target="_blank">Data Tools "Get Started" page</a>. There you will see a link to "Download SQL Server Data Tools" which will launch or download SSDTSetup.exe:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/rc0_juneau_3.png" height="182" width="669">&nbsp;</p></blockquote><p>At this point I would close Visual Studio 2010, because you'll probably be prompted to close it anyway. </p><p>As usual you'll be prompted with a security warning:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_4.png" height="294" width="413">&nbsp;</p></blockquote><p>Next you'll need to agree to the lengthy license terms and conditions:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_5.png" height="549" width="789">&nbsp;</p></blockquote><p>Next it will download LoaclDB (the new dev/Express runtime) and install. For me on multiple installs the Installation Progress bar held at 99% for a noticeable amount of time:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_6.png" height="550" width="789">&nbsp;</p></blockquote><p>With a little bit of luck you should end up at the "Success" screen:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_7.png" height="549" width="789">&nbsp;</p></blockquote><p>Now you can open Visual Studio directly (or from the "SQL Server Data Tools" menu item under All Programs &gt; Microsoft SQL Server 2012 RC0. Choose File &gt; New &gt; Project and again choose "SQL Server" under "Other Languages." The option depicted above has changed to "SQL Server Database Project":</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_9.png" height="453" width="705"><br></p></blockquote><p> Click OK. You will find a Toolbox and a familiar Object Explorer on the left, where you can easily create new objects:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_8.png" height="359" width="343">&nbsp;</p></blockquote><p>And now you can go to town developing your project. I haven't tried upgrading a project from CTP3 or from a previous version of "Data Dude." You're on your own there, sorry. <br></p><p>As an aside the "other" SQL Server option under "Database" contains all the old project types that you may not want to use anymore. I hope they straighten this out and consolidate by RTM:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/11/juneau_10.png"><br></p></blockquote><p>If you already had Juneau CTP3 installed, you should be able to install SQL Server Data Tools CTP4 as an upgrade by simply downloading the updated SSDTSetup.exe from the <a href="http://msdn.microsoft.com/en-us/data/hh297027" title="http://msdn.microsoft.com/en-us/data/hh297027" target="_blank">"Get Started" page</a>. You may still need to install Visual Studio 2010 Service Pack 1 prior to doing so. For what it's worth, I completely removed SQL Server 2012 CTP3 and Juneau CTP3 before attempting to install the updated bits. If you try an upgrade and come across any issues, please let me know. <br></p><p>You may be wondering why the versioning seems out of cadence - SQL Server is at RC0 while Juneau is at CTP4. This is because SQL Server is feature complete and an upgrade to RTM will now be supported. Juneau is not quite complete (there are still some pending changes before RTM); the naming remains CTP so that folks do not get the impression that an upgrade to RTM will be supported.<br>&nbsp;<br></p>Confirmed: Juneau is in the next version of Visual Studiohttp://www2.sqlblog.com/blogs/jamie_thomson/archive/2011/09/20/confirmed-juneau-is-in-the-next-version-of-visual-studio.aspxTue, 20 Sep 2011 21:32:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:38615jamiet<p>Its no great secret that Juneau, a collection of features in the forthcoming SQL Server codenamed Denali, will be in the next version of Visual Studio but its nice to have it confirmed all the same. I have installed the first publicly available drop of that next version (known as Visual Studio 11 Developer Preview, download from <a href="http://msdn.microsoft.com/en-us/windows/hardware/hh454873" target="_blank">here</a>) that was released at last week's <a href="http://www.buildwindows.com/" target="_blank">BUILD </a>event and sure enough the Juneau stuff is right there. Here’s some screenshots:</p> <p>Note the presence of Juneau in the About dialog:</p> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_1526A594.png"><img src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_7DABF162.png" title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" alt="image" border="0" width="542" height="382"></a></p> <p>Here’s the new Juneau table designer:</p> <p><a href="http://sqlblog.com/blogs/jamie_thomson/image_50B68E87.png"><img src="http://sqlblog.com/blogs/jamie_thomson/image_thumb_4FDE289D.png" title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" alt="image" border="0" width="544" height="324"></a></p> <p>OK, so this isn’t really news (unless you didn’t already know about it) however what <i>is </i>of interest is that this is the Express Edition of Visual Studio. This bodes well for full release – Juneau needs to be available to as many folks as possible which means not making it exclusive to the Ultimate Edition.</p> <p><a href="http://twitter.com/jamiet" target="_blank">@jamiet</a></p>SQL Server v.Next (Denali) : Putting Juneau CTP3 over Juneau CTP2http://www2.sqlblog.com/blogs/aaron_bertrand/archive/2011/07/14/sql-server-v-next-denali-putting-juneau-ctp3-over-juneau-ctp2.aspxThu, 14 Jul 2011 22:04:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36953AaronBertrand<p>Okay, I'll be the first to admit, I tried to install CTP3 on a machine without first cleaning up the CTP2 bits. My primary motivation was to be able to query the catalog views to detect any metadata changes that I hadn't already talked about here. As you might have guessed, this experiment did not go well.</p><p>In a couple of cases I have installed CTP3 quite cleanly on new VMs. I haven't installed Juneau yet on those, because I'm a little nervous about what exactly that will do to Management Studio... and I need at least one VM where I can rely on full functionality there. I'm getting there, but I wanted to address the case where CTP2 *was* installed.<br></p><p>In cases where I would prefer to keep my existing VM (which has various other ongoing work other than Denali, making it infeasible to roll back to some snapshot), I've resorted to removing every single CTP1 or CTP2 piece of software using Programs and Features (nee Add/Remove Programs). Once I had removed CTP2 completely, I ran a repair of CTP3. I then realized that I didn't have Management Studio (because the complete removal of CTP2 included shared features such as client tools). So I ran setup again, adding the Management Tools and a few other odds and ends to the instance.<br></p><p>Now, with all traces of CTP2 gone (including Juneau), and a now functional CTP3 and Management Studio, I thought it was time to install Juneau. No problem, I go for the web installer, located here:</p><blockquote><p><a href="http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10" title="http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10" target="_blank">http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10</a> <br></p></blockquote><p>Unfortunately, all signs indicate that this is going to try to install CTP2: </p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau_ctp3_1.png" border="0" height="519" width="590"></p><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau_ctp3_2a.png" border="0" height="480" width="700"><br></blockquote><p>Fellow MVP Juan Alvarado pointed me to the registry key that was causing this problem (thanks Juan!). It is one of the things that the CTP2 of Juneau did not clean up through the normal uninstall process. The key is:</p><blockquote><p>HKEY_LOCAL_MACHINE\Software\Microsoft\WebPlatformInstaller\ProductXmlLocation\</p><p><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau_ctp3_3.png" height="211" width="477">&nbsp;</p></blockquote><p>It will have a value of some folder on your machine (I changed the value to foo because my path was really long)... just change the name of the key to something else, or delete it entirely, and run the web installer again. You should see the right platform now:</p><blockquote><p><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau_ctp3_4.png" height="542" width="639">&nbsp;</p><p><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau_ctp3_5.png" border="0" height="480" width="700">&nbsp;</p></blockquote><p>I can't fault the team for this problem at all. I shouldn't expect CTPs to remove cleanly, and should know not to put CTPs on important machines or VMs that can't just be rebuilt as needed. </p><p>Ultimately, what you *REALLY SHOULD* be doing is installing CTP3 (both engine components and add-ons like Juneau) in a clean virtual machine. But I know how it is, it isn't always practical to dedicate an OS this way. So hopefully this helps some of you work around the issue.</p><p>In addition, I am in no way guaranteeing that Juneau will *work* - just that you should be able to get it installed. Once it's installed, I'm afraid you're on your own. If it doesn't work correctly, please read the previous paragraph.<br></p><p>&nbsp;<br></p>SQL Server v.Next (Denali) : Juneau CTP3 is now available!http://www2.sqlblog.com/blogs/aaron_bertrand/archive/2011/07/13/sql-server-v-next-denali-juneau-ctp3-is-now-available.aspxWed, 13 Jul 2011 13:32:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36879AaronBertrand<p>SQL Server Developer Tools (SSDT) - code-named "Juneau" - is now available. Many (including myself) believed that Juneau was simply a part of BIDS in CTP3, but after trying to use Juneau-specific functionality that this was not the case. As indicated on the <a title="http://msdn.microsoft.com/en-us/data/tools.aspx" target="_blank" href="http://msdn.microsoft.com/en-us/data/tools.aspx">Developer Tools page</a>, and <a title="http://blogs.msdn.com/b/ssdt/archive/2011/07/13/juneau-is-finally-out-to-the-public.aspx?utm_source=feedburner&amp;utm_medium=feed&amp;utm_campaign=Feed%3A+ssdtblog+%28SQL+Server+Developer+Tools+Team+Blog%29" target="_blank" href="http://blogs.msdn.com/b/ssdt/archive/2011/07/13/juneau-is-finally-out-to-the-public.aspx?utm_source=feedburner&amp;utm_medium=feed&amp;utm_campaign=Feed%3A+ssdtblog+%28SQL+Server+Developer+Tools+Team+Blog%29">on the SSDT blog</a>, you can download Juneau now through a Web Platform Installer. </p><p>According to <a title="http://msdn.microsoft.com/en-us/data/hh297027" target="_blank" href="http://msdn.microsoft.com/en-us/data/hh297027">this page</a>, if you're already using Visual Studio Professional, you need to install <a title="http://www.microsoft.com/download/en/details.aspx?id=23691" target="_blank" href="http://www.microsoft.com/download/en/details.aspx?id=23691">Visual Studio 2010 SP1</a> *FIRST* (though if you've installed Denali, you've probably already done this), otherwise your shell gets downgraded to only have Juneau functionality - at least that's how I've read it. In any case, suggest being up to date on Windows Updates and make sure that SP1 is installed before installing Juneau. You'll also want to be sure you install the CTP3 version of Juneau on a machine that has never had a previous version of Juneau installed - even a proper add/remove does not truly get rid of all of the pieces, and you're likely to end up with a quite crippled installation. All the more reason to use a VM for Denali stuff, since it is easy enough to throw away and re-create those.<br></p><p>You can start the Web Platform Installer by clicking on the following link:</p><blockquote><p><a title="http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10" target="_blank" href="http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10">http://www.microsoft.com/web/gallery/install.aspx?appid=JUNEAU10</a> </p></blockquote><p>First, you'll be asked by Internet Explorer if you're sure you want the Web Platform Installer to go about its business:</p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-00a.png"></blockquote><p>Then you'll be asked again, if you have UAC enabled:</p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-00b.png"></blockquote><p>&nbsp;Once you allow the program to run, you will see this introductory screen:<br></p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-01.png"></blockquote><p>It says the download size is 8.51 MB, but that is a lie. To see the true download size, click on the "Items to be installed" link in the bottom left corner. You will see something like this:<br></p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-02.png"></blockquote><p>My first observation here was that the local database runtime actually points to the SQL Express installer. It is not supposed to be a standalone instance, and it's interesting that they are finding a way to make Express support non-Express features that Juneau will have to support (e.g. partitioning).</p><p>When you click Install, you will be prompted (of course) to accept a license agreement. This screen also shows a summary of the items that are going to be downloaded and installed. You can click on the individual links to download each package and install them yourself, but I recommend against that because some need to be laid down in a specific order.<br></p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-03.png"></blockquote><p>&nbsp;Once you accept, installation will begin. This took a surprising amount of time on my system (equipped with 8GB RAM and an SSD), even after all the downloading had finished.<br></p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-04.png"></blockquote><p>(A funny observation here: this is my laptop, which I use for presenting, and it is yet another example where dialogs are not tested at non-default font settings - I have my fonts set to 125%, and the text no longer fits within the dialog.) <br></p><p>Depending on the state of your system (including Windows Updates), you can expect several reboots to be required during the installation of various Juneau prerequisites. If you have any failures installing the dependencies (which will prevent Juneau itself from being installed), you can try running their installers manually by clicking on the download links in the failure dialog - just make sure you run the Juneau installer last. I had a heck of a time installing the .NET Framework 4.0 update from <a title="http://support.microsoft.com/kb/2468871" target="_blank" href="http://support.microsoft.com/kb/2468871">KB #2468871</a> using the Web Platform Installer, but after running the EXE from the KB article manually, I finally had success:</p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-05.png"></blockquote><p>I then re-applied <a title="http://www.microsoft.com/download/en/details.aspx?id=23691" target="_blank" href="http://www.microsoft.com/download/en/details.aspx?id=23691">Visual Studio 2010 Service Pack 1</a> (again), just to be on the safe side. Of course I had to clear out some space first, as this is on a tight SSD - the SP1 installer apparently needs close to 6 GB free just to run.</p><p>So now when I launch my BIDS shortcut, this is the splash screen I see:</p><blockquote><img src="http://bertrandaaron.files.wordpress.com/2011/07/juneau-06.png"></blockquote><p>Once I opened Juneau, my experience with connecting to a server and performing various operations has not been great, so I'll leave my evaluation and description of those things for another post.</p><p>&nbsp; <br></p>