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: 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: 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...
  • Blog Post: Visual Studio Team System 2008 Database Edition Power Tools

    The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team System 2008 Database Edition. The Power Tools for 2008 contains all the functionality we shipped in 2005 plus: Command line SQL Static Code Analysis execution through MSBuild, this was the biggest customer...
  • Blog Post: Lorem ipsum

    This morning I received email from the owner of the DbProGenerators project on CodePlex announcing the availability of the LoremTextGenerator, which is a data generator that creates Lorem ipsum texts. Please check out the CodePlex project site at http://www.codeplex.com/DbProGenerators for more details...
  • Blog Post: Self Referencing

    Lately we have been getting questions about self-referencing database calls. What I mean with that is that you are referencing SQL objects using a 3-part name while referencing objects that reside inside your current database context. For example: 1: use Northwind 2: go 3: 4: SELECT * FROM Northwind...
  • Blog Post: Is DesignDB In Use?

    When Visual Studio Team System Database Edition opens a design-time validation database, it acquires an exclusive application lock on the DesignDB database using the following code. 1: EXEC @rc = sp_getapplock N 'TSDATA' , N 'Exclusive' , N 'Session' , 0, N 'dbo' ; A side effect of acquiring the...
  • Blog Post: Cleaning up DesignDB Leftovers

    In the " DesignDB Location " blog post I described where the design-time validation database are created. The attentive reader would have wondered when design-time validation database file get cleaned up, since we create them at project creation time and attach or re-create at project open time. So when...
  • Blog Post: DesignDB Location

    As you might know Visual Studio Team System Database Edition uses a local SQL Server database instance to validate the correctness of the code inside the database project. When you create a project a local scratch database is create for validation purposes, when you close project the database gets detached...
  • Blog Post: Visual Studio Team System 2008 Database Edition

    Now that Visual Studio 2008 is available, the question arises what has changed for Visual Studio Team Edition for Database Professionals in the 2008 edition? Not much is the answer. Since our first release was done completely out-of-band while other teams were actively working on the Visual Studio 2008...
  • Blog Post: The Data Dude Meets Team Build

    At DevConnections and TechEd Europe every attendee has been receiving a special issue of CoDe Magazine , featuring " Data Programmability ". In this issue you will find an article on how to get started with Team Build and VSDBPro, please check out http://www.code-magazine.com/Article.aspx?quickid=990712152...
  • Blog Post: External Changes...

    What happens when you make changes outside the scope of your project? What if you edit a file inside Notepad or sync your source code from your SCC system, either from the command line or from the VS IDE? Most users assume that the project automatically get updated as soon as the file is save on the...
  • Blog Post: Visual Studio Team System 2008 - Team Suite Beta 2

    Visual Studio 2008 beta 2 is now available! The Visual Studio Team System 2008 - Team Suite now includes Visual Studio Team Edition for Database Professionals. The 2008 version is based on the Service Release 1 bits of VSDBPro. The only two additional changes on top of SR1 are that it is included in...
Page 1 of 1 (23 items)