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: 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: FIX: Blank Unit Test Designer Problem

    If you are running in to the following problem when creating unit tests when using database projects, there now is a fix! Consider the following scenario, you have you database project (.dbproj) open and requesting the creation of a Database Unit Test by right clicking on for example a stored procedure...
  • Blog Post: VSTSDB Blog Site

    The Visual Studio Team System Database Edition team has created a new blog site to keep you informed and update about the latest developments. Please check out: http://blogs.msdn.com/vstsdb Thanks, -GertD
  • 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: Data Generator for SQL Server Sparse Columns

    Genevieve, tester on the “DataDude” team, has created a new Data Generator which allows you to populate a random set of sparse columns through the use of an XML column set column. She posted it on the VS Code Gallery, http://code.msdn.microsoft.com/columnsetgenerator . -GertD PS: Dank je wel Genevieve...
  • Blog Post: Final Language Release of the GDR

    Today we released the last language, Russian, of the planned localized versions of Visual Studio Team System 2008 Database Edition GDR. This brings the total count to 10 (including English). You can download the Russian edition of the GDR from the following location: http://download.microsoft.com/download...
  • Blog Post: File Level Build Warning Suppression in the GDR

    One of the small, but hard to discover new features in the GDR release is the ability to suppress warnings at the file level. Just to be very clear, this is suppression of build level warnings, not of static code analysis or deployment warnings! Imagine you have a procedure that references a temp table...
  • Blog Post: Two more languages released

    Yesterday we released two more languages of the Visual Studio 2008 Team System Database Edition GDR release, Simplified Chinese and French in addition to the six languages we released on December 19th 2008. Chinese (Simplified) (zh-CN) http://download.microsoft.com/download/2/2/2/2223ECF9-7485-4A0B-8928...
  • Blog Post: Creating T-SQL Static Code Analysis Rules

    One of the new features in the GDR release is that you can create your own T-SQL Static Code Analysis rules. This post will guide you through creating your first rule.   Step 1: Create a new Class Library project Inside Visual Studio 2008 create a new "Class Library" project, you can use...
  • Blog Post: GDR VPC's

    We just released a new set off VPC's for Visual Studio 2008 Team Suite (including TFS) which now have the Visual Studio 2008 Team System Database Edition GDR bits installed. These VPC's provide an easy way to test out the GDR release. There is a Virtual PC and Hyper-V based image. For details check out...
  • Blog Post: Handling of COMMENTS in the GDR

    In the GDR you will mainly find large improvements, but it is not everything is better. One area where we regressed functionality is the deployment of comments inside T-SQL procedures, triggers,  functions etc. With the move to a true and only model based system, objects that are stored in dbo.syscomments...
  • Blog Post: GDR Language Releases

    Today, we released 6 additional languages of the Visual Studio 2008 Team System Database Edition GDR! Chinese (Traditional, Taiwan) http://download.microsoft.com/download/1/9/D/19D1CB8C-82A8-4736-AFF4-51F2E343A312/Readme.mht http://download.microsoft.com/download/1/9/D/19D1CB8C-82A8-4736-AFF4-51F2E343A312...
  • Blog Post: Troubleshooting SETUP

    This post dives in to how to troubleshoot problems when installing the Visual Studio Team System 2008 Database Edition GDR .   Prerequisites Before installing the GDR, please check the prerequisites! Visual Studio Version & Edition: First check if you have the right Visual Studio version and...
  • Blog Post: Visual Studio Team System 2008 Database Edition GDR - RTM

    Finally the moment is there, the final version of the Visual Studio Team System 2008 Database Edition GDR has been released to the web. Although the name "GDR", which stands for "General Redistribution Release", implies otherwise, this really is a complete new release, based on a...
  • Blog Post: New VSDB Blog

    Patrick Sirr , one of the key developers in our team started his own blog. If you want to learn about automating the project system using DTE, please check it out. His first three articles are covering: Importing multiple scripts using DTE Schema Compare using DTE Data Compare using DTE Yes, Patrick...
  • Blog Post: PDC Session Now Online

    The PDC session "TL45 Microsoft Visual Studio Team System Database Edition: Overview", which I presented last Monday is now available for online viewing on Channel9. The video is stream can be found on: http://channel9.msdn.com/pdc2008/TL45/ and I uploaded the slide deck to my SkyDrive: TL45_Drapers...
  • Blog Post: The GDR RC Is Here!

    During my session at PDC I announce the immediate availability of the Release Candidate (RC) of Visual Studio Team System 2008 Database Edition GDR. We are going through the last stages of the development process and we are getting ready to release. This release candidate is the first step towards the...
  • Blog Post: Partial Projects

    The Visual Studio Team System 2008 Database Edition GDR release introduces two new ways on how to share information between projects, partial projects and composite projects. This blog post will go in to how to use partial projects, composite projects will be discussed in a later post. When we started...
  • Blog Post: Model Collation vs. Database Collation

    When you are using the latest CTP of the GDR release, you might have noticed that we introduced a new collation, named the "model collation". However if you go to the Database.sqlsettings file, which contains all the database properties, you will also find the "Database collation"...
  • Blog Post: VSDB @ PDC2008

    If you happen to go to PDC this year, you might want to check out session TL45, " Microsoft Visual Studio Team System Database Edition: Overview ". The title might not sounds that interesting but this session will be 100% dedicated to the Visual Studio Team System 2008 Database Edition GDR...
  • 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: Visual Studio Team System 2008 Database Edition GDR September CTP

    The Visual Studio Team System 2008 Database Edition GDR September CTP is now available for download. This is the last CTP, we started our final descend, we will publish a public RC (release candidate) when it is ready, followed by the RTM release. The upcoming RC (release candidate) will be a "go...
Page 1 of 3 (70 items) 123