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 » Datadude   (RSS)
Showing page 1 of 2 (13 total posts)
  • 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
  • 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
  • Implementing SQL Server solutions using Visual Studio 2010 Database Projects – a compendium of project experiences

    Over the past eighteen months I have worked on four separate projects for customers that wanted to make use of Visual Studio 2010 Database projects to manage their database schema.* All the while I have been trying to take lots of notes in order that I can write the blog post that you are reading right now – a compendium of experiences and tips ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 1, 2012
  • 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
  • Maintaining version history in your database using Visual Studio 2010

    I have written a few blogs lately explaining how my current project is employing the use of datadude (aka the database development tools in Visual Studio 2010) in order to manage our database code, deployment of that code and also testing of it. In this blog post I’m going to share a little technique that we use in order to store a version history ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 19, 2010
  • Enforcing naming conventions using database unit testing

    My naming convention obsession Anyone that has ever worked with me will tell you that I am a stickler for naming conventions. I have a somewhat obsessive reputation for it; I can’t help it – I seem to have a deep seated uncontrollable desire to ensure that every object in my database(s) is/are named consistently (is there anyone else out there ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 5, 2010
  • Experiences from writing sp_CascadingDataViewer – DB unit testing and code distribution

    Its now been a month since I introduced sp_CascadingDataViewer and I wanted to take the opportunity to talk about a couple of my experiences while writing it.   SQL Server needs packages Version 1 of sp_CascadingDataViewer is an 899 line stored procedure (view the code at changeset 58999), that’s a lot of code and much of it is repeated. I ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 18, 2010
  • Some thoughts on Visual Studio database references and how they should be used for SQL Server BI

    Over the past few weeks I have been making heavy use of the Database tools in Visual Studio 2010 (formerly known as datadude, DBPro, VSTS for Database Professionals or one of a plethora of other names that it has gone by over the past few years) and one of the features that has most impressed me has been database references.   Database ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 14, 2010
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement