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 Data Tools   (RSS)
Showing page 2 of 3 (27 total posts)
  • 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 http://www.devproconnections.com/. 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
  • 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
  • Big label generator

    Sometimes I write blog posts mainly so that I can find stuff when I need it later. This is such a blog post. Of late I have been writing lots of deployment scripts and I am fan of putting big labels into deployment scripts (which, these days, reside in SSDT) so one can easily see what’s going on as they execute. Here’s such an example from my ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 26, 2012
  • Highlight Word add-in for Visual Studio 2010 [SSDT]

    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 Highlight all occurrences of selected word 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: There’s a ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 19, 2012
  • New version of SQL Server Data Tools is now available

    If you don’t follow the SQL Server Data Tools (SSDT) blog then you may not know that two days ago an updated version of SSDT was released (and by SSDT I mean the database projects, not the SSIS/SSRS/SSAS stuff) along with a new version of the SSDT Power Tools. This release incorporates a an updated version of the SQL Server Data Tier Application ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 16, 2012
  • Bitmask data insertions in SSDT Post-Deployment scripts

    On my current project we are using SQL Server Data Tools (SSDT) to manage our database schema and one of the tasks we need to do often is insert data into that schema once deployed; the typical method employed to do this is to leverage Post-Deployment scripts and that is exactly what we are doing. Our requirement is a little different though, our ...
    Posted to Jamie Thomson (Weblog) by jamiet on June 11, 2012
  • Smart defaults [SSDT]

    I’ve just discovered a new, somewhat hidden, feature in SSDT that I didn’t know about and figured it would be worth highlighting here because I’ll bet not many others know it either; the feature is called Smart Defaults. It gets around the problem of adding a NOT NULLable column to an existing table that has got data in it – previous to SSDT you ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 31, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement