THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » SSDT   (RSS)
Showing page 2 of 3 (29 total posts)
  • SSDT gets some small enhancements for SQL Server 2014

    Release-to-manufacturing of SQL Server 2014 was announced today and with it comes some welcome news about some small enhancements to SSDT: The SSDT team has been heads down getting our SQL Server 2014 release ready to go.  However we've made time to make some targeted improvements in this area.  In our upcoming release for SQL Server ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 18, 2014
  • Schema Compare or Publish [SSDT]

    Yesterday on Twitter Ryan Desmond asked Is there a good read for #SSDT regarding deploying changes via schema compare vs solution deployment? I don’t know of any article that covers this so in this blog post I offer my opinion on the subject. First some background. When building databases offline using the database project type (.sqlproj) ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 19, 2013
  • June 2013 release of SSDT contains a minor bug that you should be aware of

    I have discovered what seems, to me, like a bug in the June 2013 release of SSDT and given the problems that it created yesterday on my current gig I thought it prudent to write this blog post to inform people of it. I’ve built a very simple SSDT project to reproduce the problem that has just two tables, [Table1] and [Table2], and also a ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 1, 2013
  • Connected development in SSDT versus SSMS

    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. SSOX provides some really cool capabilities that are not in SQL Server Management ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 19, 2013
  • Deployment of client-specific database code using SSDT

    Yesterday I attended SQL Saturday 194 in Exeter for which many people deserve credit but especially the organisers Jonathan Allen & Annette Allen and the sponsors Fusion-IO, Confio Software, Nexus, Big Bang Data Company, Purple Frog Systems, Redgate, idera, Pluralsight, Jurys Inn Exeter & Wrox.  I gave a ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 10, 2013
  • Which version of SSDT Database Projects do I have installed?

    I'm afraid I can no longer commit to keeping this page up to date given the rapid cadence of releases and the fact that I am no longer an active user of SSDT. If someone wishes to pick up the mantle please let me know and I shall link to your page.  SQL Server Data Tools (SSDT) is released on a very regular cadence (note that I’m talking ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 8, 2013
  • Responses to SSDT questions

    My recent article Get to Know SQL Server 2012's SQL Server Data Tools prompted two questions to come to me via email and in the interests of sharing knowledge via search engines I thought I would answer them here rather than by simply replying by email (I hate that so much useful information gets trapped inside closed inboxes). Question: How ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 11, 2013
  • Get to Know SQL Server 2012's SQL Server Data Tools [article published]

    I recently wrote an article on SQL Server Data Tools for SQL Server Magazine and it has now been published online at Get to Know SQL Server 2012's SQL Server Data Tools. In the article I offer my thoughts and opinions on SQL Server Data Tools as it exists in SQL Server 2012. Note that the article refers to SSDT database projects only, there ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 9, 2013
  • “Add as object” or “Add as script”? [SSDT]

    In SQL Server Data Tools (SSDT) one way to create a new object is to right click on a folder in Solution Explorer and point to Add. Doing so will display this menu: A number of options are offered for creating a brand new object (“function”, “table”, “stored proc” etc…) and one of them is “Script”. If your preference is to handcraft the DDL ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 4, 2013
  • Warning! Publish may fail on creation of a FOREIGN KEY constraint and then immediately succeed [SSDT]

    I have stumbled across a nuance of SSDT that other users should be cognizant of. I published an SSDT database project onto an existing database that already had data in it but that Publish operation failed: The error message was: (10036,1): SQL72014: .Net SqlClient Data Provider: Msg 547, Level 16, State 0, Line 1 The ALTER TABLE ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 3, 2013
Privacy Statement