in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Tips and Tricks » Data Dude (RSS)

Browse by Tags

  • Deploying a database solution in Visual Studio Database Professional - Tip

    I really like the database projects in visual studio however there are a few bug bears that really annoy me. This post is about deploying a solution. When working in development i have the project set to build the delpoy script and to deploy it. Whats annoying is that I prefer to work in the schema view...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jan 18 2010

  • XML Schema Collection in Database Professional Project

    If you are wanting to use schemas in your database using database professional then it is not that obvious. You can add XML SCHEMA COLLECTIONs but where do they do to. They are tuck away in the programability node under types, not the most obvious location. Secondly if you create schemas using the ADD...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 14 2010

  • Data Dude : Database Documentor

    If you want to document your database you've got to see Gert Drapers on Channel9. Data Dude is answering so many of those questions/challenges I've been trying to solve for database builds over the past decade. I am so pleased to see the database references in the service release and the dependecy...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Aug 16 2007

  • Free 2GB SQL Server USB Keys

    We are holding the next UK SQL User group meeting in Central London on the 26th April from 6pm - 9pm (later if you fancy a drink) The eveneing will have a SQL event and BI event running side by side with 8 presenters and loads of giveaways including t-shirts, books and USB keys. If you want to learn...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 29 2007

  • Variable substitution in Data Dude Scripts

    One of the great aspects of Data Dude is that it uses SQLCmd to run the scripts. This means that it can use the variable substitution. One gotcha however is that Data Dude tries to be clever and validate your code before the substiution. This means something like. if exists (select 1 from $(databasename...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Nov 30 2006
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems