database

There are 3 entries for the tag database

Creating Custom SQL CLR User-Defined Types

Since SQL Server 2005 .Net developers and DBAs have had the ability to create custom SQL CLR types. It wasn't until recent I found a few uses for them. Not only did I find a use for them but a DBA who is a team member did as well. If you would like more information about SQL CLR types or are new to them start by reading the introduction here. What follows is a walk through from start to finish creating a user-defined type (UDT). The project source code is available at the end of the article. Maintaining Data Integrity One of the advantages of SQL...

posted @ Monday, October 29, 2007 5:46 PM | Feedback (5)

Scripting Database Creation and Fake Data Generation From Data Dude Without Data Dude Installed

I have Data Dude (aka, Visual Studio for Database Professionals) installed on my local machine. However, my other team members don't have Data Dude installed. They are running Visual Studio Team System for Developers. This puts us all in a quandary. For example, if I update the database with Data Dude, how do the other developers get the latest updates installed to their local sandbox? Better yet, how do they generate fake data for the database when they don't Data Dude installed? This is supposed to be addressed in future versions of Data Dude but I needed something now. Here is...

posted @ Thursday, August 30, 2007 5:21 PM | Feedback (0)

Part 2: Leveraging Workflow Foundation - Invest in Your Workflow Infrastructure

In Part 1 of Leveraging Workflow Foundation we discussed how Workflow Foundation is just an API. Since APIs don't provide business value out of the box, it is important engineers exploring Workflow Foundation for the first time approach it in the same manner they would any API: write once, run everywhere. In other words, instead of building out the workflow components for one application, look at it from the 10,000 feet view. This is of course going to take more time than one might originally think so be sure to allow for this in development time. We'll look at the basics engineers starting with Workflow Foundation will need to think about...

posted @ Monday, May 28, 2007 12:00 PM | Feedback (13)