I generate my databases on the fly while using Active Record. Every time I start a new project and fire up the app to auto-gen the SQL Express DB I get this error: Failed to generate a user instance of SQL Server due to failure in retrieving the user’s local application data path. Please make…
Category Archives: SQL Server
DB2 / SQL SERVER 2005 / .NET
For those of you who are lucky enough to work with DB2 and .NET, you’re probably already aware that you can run into some issues if you’re not using the correct DB2 Driver. I’ve been writing some SSIS packages that move some data from a DB2 environment into a SQL Server 2005 Database. I also had to…
Returning XML Data as a Record Sets through the CLR in SQL Server 2005
The Problem I needed to write something like this … SELECT * FROM CustomerTest WHERE Customer_Id = 1; The data returned needed to return the row as well as the data inside of the XML Column in that row, in the same set. (The data in the XML column needed to be returned as sets of…
Blogs, Podcasts and Screencasts
UPDATE: I added the publications I also read at the bottom. I’ve been asked what blogs I read, podcasts I listen to and screencasts I watch. So here’s a comprehensive list for ya’ll. Blogs (in no particular order) Scott Hanselman Jeff Atwood Martin Fowler Jeremy D. Miller K. Scott Allen Mads Kristensen Sahil Malik Roy…
Simplifying Database Modeling in Visio 2002/2003 through SQL Generation
During the development of any new greenfield project you’re going to probably need to interact with a datastore. From my experience, 8 out of 10 times this is going to be a database acting as the datastore, and in my case, it’s normally SQL Server. Database Modeling When in the design phase we’re modeling….
