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 » SSDT   (RSS)
Showing page 2 of 5 (47 total posts)
  • 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
  • Creating your own SQL snippets in SSDT

    SQL Server Data Tools (SSDT) has a neat feature where you can add snippets into your scripts via the right-click context menu: I’m finding it very useful indeed. The same feature exists in SQL Server Management Studio (SSMS) as well by the way: One thing I really wanted to be able to do was create my own snippets for SSDT and I ventured to ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 22, 2013
  • Detecting Database Drift using SSDT

    One of the nice things about doing user group presentations is that when you’re putting the presentation together you invariably learn about features that were previously unbeknown to you; so it proved as I stumbled upon SSDT’s database drift detection features while researching material for my forthcoming pre-conference seminar SSDT from the ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 4, 2013
  • SSDT naming confusion cleared up. Somewhat.

    In March 2012 I published SSDT - What's in a name? where I lamented the mistakes that Microsoft made in the naming of SQL Server Data Tools. …official documentation stating that SSDT includes all the stuff for building SSIS/SSAS/SSRS solutions (this is confirmed in the installer, remember) yet someone from Microsoft tells him ''SSDT ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 3, 2013
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement