Home of the Data Dude

Welcome to the blog where the DataDude talks about SQL Server Data Tools and Visual Studio Database Projects

Browse by Tags

Tagged Content List
  • Blog Post: DefaultDataPath

    VSDB uses the the ($DefaultDataPath) SQLCMD variable to represent the location where you would place your data and log file of your database. The deployment engine sets the value of SQLCMD variable by querying SQL Server using the following query: 1: DECLARE @ value nvarchar(512), 2: @rc int...
  • Blog Post: SQL Server 2008 R2

    Now that SQL Server 2008 R2 November CTP is available, I found some time to install it and test the existing Visual Studio 2008 Team System Database Edition GDR R2 release with it. The only thing that is really different from a SQL Server point of view besides two changes to the SQL parser, is that the...
  • Blog Post: NESQL Presentation – Declarative Database Development

    Last week, September 10, I was invited by the New England SQL Server User Group to present about my favorite topic “ Declarative Database Development ”. I posted the slides of the presentation at DBProj.com . GertD @ www.DBProj.com
  • Blog Post: MyDevConnections Volume 2 issue 1

    The DevConnections conference organization (Tech Conferences Inc.), just released the latest issue of the magazine accompanying the conferences, named: MyDevConnections . In this edition (volume 2, issue 1) you will find an article that I wrote about “Declarative Database Development – Define What You...
  • Blog Post: VSDB 2008 Version Numbers

    We frequently get asked how to identify the version a user is running with, so here is the list of Visual Studio Team System 2008 Database Edition releases. The information is retrieved using Help => About Microsoft Visual Studio inside the Visual Studio shell (devenv.exe). Alternatively you can copy...
  • Blog Post: Assigning MSBuild Properties to SQLCMD Variables

    I am receiving the following question a lot: How do I propagate MSBuild properties to SQLCMD variables. In order to make the Visual Studio 2008 Team System Database Edition GDR release use the data from an MSBuild property inside a SQLCMD variable you need to do three things: Add the variable to the...
  • Blog Post: DBSchema file for SQL LiteSpeed XP’s

    Based on a customer request I created a .dbschema file which contains the definitions of all the extended stored procedures used by SQL LiteSpeed 5.0 that live inside the master database. Since schema import does not import the definition of extended stored procedures, the user could no resolve the reference...
  • Blog Post: Declarative Database Development

    Define What You Want, Not How You Get There!   If Not Exists… Database development is many aspects behind in comparison to regular application development. If you look how database development is integrated with regular application development or development processes it becomes even more obvious...
  • Blog Post: RTM of VSDB 2008 GDR R2

    The QFE rollup release for the Visual Studio Team System 2008 Database Edition GDR release is now available. You can download the SETUP.EXE from the regular location. ( http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed ) If you have the VS2008 RTM version of...
  • Blog Post: DBProj.com

    Some of you already know or noticed through sites like LinkedIn or Facebook that per the beginning of this month I started in a new role inside Microsoft. I moved in to an Software Architect role, working on the new Directory Services stack. Hence I needed a new place to publish my DataDude contributions...
  • Blog Post: More Team Developer + Data Edition Merge Information

    Per October 1st 2008 MSDN subscribers who own or buy a new Visual Studio Team System Developer license are entitled to also install the Visual Studio Team System Database Edition, and  MSDN subscribers who own or buy a new Visual Studio Team System Database Edition license are entitled to install...
  • Blog Post: Team Developer + Team Data = Team Developer!

    In today's press release titled: " Visual Studio 2010 and .NET Framework 4.0 Overview " we announced the merge of the Developer Edition and Database Edition SKU's.   Better Together – Visual Studio Team System Development Edition and Database Edition In recognition of the increased...
  • Blog Post: Trace Helper

    This is the last part of the 3 part diagnostics series. This part will introduce you to a little helper utility that I wrote to make configuring the diagnostics and tracing options a lot simpler and more accessible. As discussed in the previous two blog posts in this series: Diagnosing Problems and Event...
  • Blog Post: Event Monitor

    In part 2 of diagnosing problems I want to introduce you to an other build-in diagnostics tools that we might ask you to run with tracking down problems, the "event monitor". The event monitor is one of those tools that we use during development of the product for troubleshooting problems during...
  • Blog Post: Some recent VSDB Articles

    Jeff Levinson recently wrote a great article in Visual Studio Magazine covering the upcoming GDR release: Introducing the VSTS Database Edition GDR and Jeffrey Juday just published an article on Developer.com about Database Unit Testing: Introducing Visual Studio Team System 2008 Database Unit Testing...
  • Blog Post: DataDude Goes Multi-Platform

    Yesterday, during Bill Gates his Tech Ed keynote , Brian Harry had the honor to show the first glimpse of the results of our partnership with IBM, DB2 support inside Visual Studio Team System Database Edition. As you might know or have read in one of my previous blog posts, we are changing the underlying...
  • Blog Post: Channel 9 VSDB 2008 GDR Interview

    We just released a new Channel 9 interview that covers the Visual Studio Team System 2008 Database Edition GDR functionality that we introduced today. http://channel9.msdn.com/posts/briankel/New-GDR-Announced-for-Visual-Studio-Team-System-2008-Database-Edition/ -GertD
  • Blog Post: VSTS 2008 Database Edition GDR June CTP

    Today, at Tech*Ed 2008 Developer, we announced the immediate availability of the first public CTP of the Visual Studio Team System 2008 Database Edition GDR. GDR stands for General Distribution Release. The GDR will be an out-of-band release enabling support for SQL Server 2008. It also introduces the...
  • Blog Post: Tech·Ed 2008 Developers

    In case you are coming to the Developer edition of Tech·Ed next week, we have a lot of exiting things for you. As you can see below there are many sessions, hosted in both the developer and database tracks. Breakout sessions, chalk talks, panel discussions and hands-on lab, all covering Visual Studio...
  • Blog Post: MSDB Reference Projects

    The reference projects needed to resolve objects that reside inside an MSDB database have been posted on the MSDN Code Gallery site. You can find them on: http://code.msdn.microsoft.com/dbpromsdbsamples We did not post .dbmeta files but stub projects, because .dbmeta files require the collation to match...
  • Blog Post: Command line SQL Static Code Analysis

    We have had a lot of requests from users asking us to make T-SQL Static Code Analysis available at build time and from the command line. The latest Visual Studio Team System 2008 Database Edition Power Tool release, adds this ability to the product through a new MSBuild task. In this blog post I will...
  • Blog Post: Database Compatibility Level

    VSTS-DB, both the 2005 and 2008 version, makes an assumption with regards to database compatibility levels, which can cause problems in certain use cases. The assumption is that the DesignDB instance used for validation of the schema inside the project is set to a 80 compatibility level when using a...
  • Blog Post: File Bound Generator

    An other new addition to the Visual Studio Team System 2008 Database Edition - Power Tools release is the File Bound Generator. This data generator grovels through files inside a directory or optionally through its subdirectories, based on some search filter you provide and loads the content of the file...
  • Blog Post: Apply Test-Driven Development to your Database Projects

    This months issue of MSDN Magazine features a great article about how to use and extend Database Unit Testing written by Jamie Laflen who is the developer and tech lead in my team responsible for Database Unit Testing, Data Generation, SQL Code Coverage and Build & Deploy. So this information comes...
  • Blog Post: Data Generation Wizard

    One of the new features in the Visual Studio Team System 2008 Database Edition - Power Tools release is the addition of the Data Generation Wizard. The Data Generation Wizard is an item template wizard that allows you to create and configure a data generation plan by pointing it at an existing database...
Page 1 of 2 (32 items) 12