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 1 of 3 (28 total posts)
  • 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 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
  • 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
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement