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 5 (42 total posts)
  • Considerations when starting a new SSDT database project

    As you may have realised from much of my blogging over the past year or so I’m an advocate of using SSDT database projects for building database solutions on SQL Server. I have been using SSDT database projects a lot in that time and have come up with a checklist of things to consider when starting a new SSDT database project and I’ll be detailing ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 21, 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
  • SSDT database projects were not always going to output T-SQL…

    Interesting the stuff you pick up from reading forums… “The BATCH seperators [in SSDT deployment scripts] are used to provide scoping when resolving object shapes. SSDT or VSDB scripts for that matter serve a different purpose, they provide the blueprint of the model you want, and do not represent how it will be used to construct the target ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 13, 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
  • Video accompanying my SSDT article is now available

    A couple of weeks ago in Get to Know SQL Server 2012's SQL Server Data Tools [article published] I stated that an article that I wrote about SSDT had been published and was available for reading online at The article has since been updated to include a 10-minute video that I recorded demonstrating some of the ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 28, 2013
  • Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

    Continuous deployment is described by Wikipedia as: Most CI systems allow the running of scripts after a build finishes. In most situations, it is possible to write a script to deploy the application to a live test server that everyone can look at. A further advance in this way of thinking is Continuous Deployment, which calls for the software ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 27, 2013
  • More SSDT naming confusion

    I have blogged previously at SSDT – What’s in a name? about the naming confusion that Microsoft have created by their inconsistent use of the term “SQL Server Data Tools” (SSDT) in SQL Server 2012. Is it a Visual Studio shell incorporating project templates for building databases, SSIS packages, SSAS cubes & SSRS reports? Or is it simply the ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 16, 2013
  • My SQLBits Pre Conference Seminar - SSDT Database projects from the ground-up

    Over the last year or so it will not have escaped my regular readers’ attention that much of my blogging has centred around SSDT database projects. SSDT (and its variously named forebears) is a tool that I have been using in some way, shape or form since 2007 and in that time I have built up what I feel is a sound body of knowledge and experience; ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 15, 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement