THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » sql server » SSDT   (RSS)
Showing page 1 of 2 (20 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
  • Dacpac braindump - What is a dacpac?

    In this week’s earlier blog post First release of my own personal T-SQL code library on Github I talked of how one could use a dacpac to distribute a bunch of code to different servers. Upon reading the blog post Jonathan Allen (of SQL Saturday Exeter fame), with whom I’ve been discussing dacpacs with on-and-off recently, sent me this email: ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 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?

    SQL Server Data Tools (SSDT) is released on a very regular cadence (note that I’m talking about the database projects part of SSDT, this is nothing to do with SSIS/SSAS/SSRS). Since the first release in March 2012 there have been releases in September 2012, November 2012, & December 2012. I personally have found it difficult to keep track of ...
    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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement