Patrick Sirr's Blog

DataDude Notes

  • Patrick Sirr's Blog

    Using T4 Templates with Visual Studio 2010 Database Projects

    • 5 Comments
      I had a request to update my Visual Studio 2008 GDR Database projects CRUD generator to Visual Studio 2010. Not much has changed except for some references and directory locations. The flow of the add-in is identical to the 2008 version. Below...
  • Patrick Sirr's Blog

    Database Project Extensibility – Merge Table and View Scripts

    • 1 Comments
      In this blog I’ve created a project feature extension to combine Table and View child scripts into the script that defines the parent object. For example, constraints or extended properties for a table. Some developers like to have all the T-SQL...
  • Patrick Sirr's Blog

    Template Driven Sql Generation Updated for Visual Studio 2010

    • 2 Comments
    More than a year ago I presented a simple template processor for Visual Studio 2008 Database Projects. This add-in gives you the ability to write Transact-SQL in a simple template form with embedded SQLCMD variables. It’ll turn --* CREATE TABLE [dbo]...
  • Patrick Sirr's Blog

    Converting .dbp files to .dbproj files

    • 0 Comments
    With the release of Visual Studio 2010 Beta 2, database projects with the .dbp extension are deprecated. There are several ways to convert your project manually Import Script. Unfortunately this will shred your scripts for schema objects and move any...
  • Patrick Sirr's Blog

    Interesting Memory Leak in .Net 3.5 Binary Deserialization

    • 5 Comments
    Recently I was analyzing an application written in managed code for memory problems.  In managed code a common cause of eating up memory is statically allocated objects which are not nulled out after they are no longer needed. In the application...
  • Patrick Sirr's Blog

    Sample Visual Studio 2008 Fonts and Color Provider

    • 0 Comments
    Adding a new Font and Color category to the Visual Studio Options dialog is, admittedly, a little tricky. There are several services your package must proffer, an interface you must implement and registry keys you must provide (one of them very poorly...
  • Patrick Sirr's Blog

    Template Driven Sql Generation

    • 9 Comments
    Recently Duke Kamstra and I demonstrated how you can use Visual Studio 2008 Database and Server projects to deploy Sql Server permission objects to your various Sql Server instances. It’s common to develop on a local box with admin rights, and then restrict...
  • Patrick Sirr's Blog

    Using T4 Templates with GDR Database Projects

    • 15 Comments
    For this blog I’ve developed an add-in for General Distribution Release (GDR) for Visual Studio Team System 2008 Database Edition projects (better known as “Data Dude”) which will generate Create, Read, Update and Delete (CRUD) stored procedures for a...
  • Patrick Sirr's Blog

    Navigating the Data Dude Object Model

    • 2 Comments
    In this blog I’ll introduce you to the basics of navigating the General Distribution Release (GDR) for Visual Studio Team System 2008 Database Edition object model. I’ve wrapped it all into an add-in so you can step through the code and extend it as you...
  • Patrick Sirr's Blog

    Database Project Import Scripts Add In

    • 3 Comments
    In this blog I’ll introduce you to the Import Scripts add-in to the General Distribution Release (GDR) for Visual Studio Team System 2008 Database Edition. With this add-in Visual Studio can import multiple scripts to populate a target database project...
  • Patrick Sirr's Blog

    Data Compare DTE Commands

    • 6 Comments
    In this blog I’ll lead you through the various parameters for the “Data.NewDataComparison” command available in the General Distribution Release (GDR) for Visual Studio Team System 2008 Database Edition. This command launches the Visual Studio Data Compare...
  • Patrick Sirr's Blog

    Schema Compare DTE Commands

    • 6 Comments
    In this blog I’ll lead you through the various parameters for the “Data.NewSchemaComparison” command available in the General Distribution Release (GDR) for Visual Studio Team System 2008 Database Edition and Visual Studio 2010 Beta 2.  This command...
  • Patrick Sirr's Blog

    Importing Multiple Scripts using DTE

    • 8 Comments
    We have had a lot of requests from folks that would rather not go through the Import Script Wizard when they have multiple T-SQL source scripts. Fortunately Visual Studio provides the ability to execute parameterized commands by using the Design Time...
Page 1 of 1 (13 items)