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 » SSDT   (RSS)
Showing page 2 of 6 (55 total posts)
  • Day 1 – Online and offline (10 days of SSDT)

    SQL Server Data Tools (SSDT) was released in Spring 2012 and I have been using it to build SQL Server databases nearly every day since then. In that time I’ve learnt a lot about how to make best use of the tool and I want to share that experience in a new series of blog posts called “10 days of SSDT”. I shall be publishing a different blog ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 17, 2014
  • Kill all the project files!

    Like many folks I’m a keen podcast listener and yesterday my commute was filled by listening to Scott Hunter being interviewed on .Net Rocks about the next version of ASP.Net. One thing Scott said really struck a chord with me. I don’t remember the full quote but he was talking about how the ASP.Net project file (i.e. the .csproj file) is going ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 14, 2014
  • Want a headless build server for SSDT without installing Visual Studio? You’re out of luck!

    An issue that regularly seems to rear its head on my travels is that of headless build servers for SSDT. What does that mean exactly? Let me give you my interpretation of it. A SQL Server Data Tools (SSDT) project incorporates a build process that will basically parse all of the files within the project and spit out a .dacpac file. Where an ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 8, 2014
  • 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
  • Don’t learn SSDT, learn about your databases instead

    Last Thursday I presented my session “Introduction to SSDT” at the SQL Supper event held at the offices of 7 Digital (loved the samosas, guys). I did my usual spiel, tour of the IDE, connected development, declarative database development yadda yadda yadda… and at the end asked if there were any questions. One gentleman in attendance (sorry, can’t ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 11, 2013
  • SSDT gotcha – Moving a file erases code analysis suppressions

    I discovered a little wrinkle in SSDT today that is worth knowing about if you are managing your database schemas using SSDT. In short, if a file is moved to a different folder in the project then any code analysis suppressions that reference that file will disappear from the suppression file. This makes sense if you think about it because the ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 10, 2013
  • Learn from me about SSDT in London, March 2014

    Microsoft released SQL Server Data Tools (SSDT) along with SQL Server 2012 in the Spring of 2012. Since then I’ve noticed an upward tick in both the number of organisations that are using SSDT and the number of questions that are getting asked about it on forums. There is some confusion about what SSDT actually is (Microsoft hasn’t helped there), ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 5, 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
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement