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 » Datadude   (RSS)
Showing page 1 of 2 (18 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
  • 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?

    I'm afraid I can no longer commit to keeping this page up to date given the rapid cadence of releases and the fact that I am no longer an active user of SSDT. If someone wishes to pick up the mantle please let me know and I shall link to your page.  SQL Server Data Tools (SSDT) is released on a very regular cadence (note that I’m talking ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 8, 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
  • “Add as object” or “Add as script”? [SSDT]

    In SQL Server Data Tools (SSDT) one way to create a new object is to right click on a folder in Solution Explorer and point to Add. Doing so will display this menu: A number of options are offered for creating a brand new object (“function”, “table”, “stored proc” etc…) and one of them is “Script”. If your preference is to handcraft the DDL ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 4, 2013
  • SQL Server Data Tools does support required variables

    Over the past few years of using datadude (aka DBPro aka Visual Studio Database Projects) I have fallen prey to a peculiar little nuance – if you forget to supply a value for a sqlcmd variable then it will simply use a default and often that is not the desired behaviour. Hence why yesterday I submitted the following suggestion to ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 12, 2012
  • Thoughts on Test Driven Database Development

    Test-Driven Development (TDD) is a software development practise that has been around for a few years. Wikipedia describes it as: Test-driven development (TDD) is a software development process that relies on the repetition of a very short development cycle: first the developer writes a failing automated test case that defines a desired ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 26, 2012
  • Workaround for datadude deployment bug - NullReferenceException

    I have come across a bug in Visual Studio 2010 Database Projects (aka datadude aka DPro aka Visual Studio Database Development Tools aka Visual Studio Team Edition for Database Professionals aka Juneau aka SQL Server Data Tools) that other people may encounter so, for the purposes of googling, I'm writing this blog post about it. Through my own ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 21, 2011
  • Building a database installer with WiX, datadude and Visual Studio 2010

    Today I have been using Windows Installer XML (WiX) to build an installer (.msi file) that would install a SQL Server database on a server of my choosing; the source code for that database lives in datadude (a tool which you may know by one of quite a few other names). The basis for this work was a most excellent blog post by Duke Kamstra entitled ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 10, 2011
  • Generate multiple SqlCmdVars files in your database projects

    Earlier today I was doing a little work using datadude/DBPro/Visual Studio Database Tools/pick your name and had a need to write a Powershell script that I think might be useful to other folks so I’m sharing it here. Often when you’re putting together database projects you will have a need for multiple .sqlcmdvars files – one for each environment ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 19, 2011
1 2 Next >
Privacy Statement