Welcome to MSDN Blogs Sign in | Join | Help

June 2009 - Posts

Assigning MSBuild Properties to SQLCMD Variables

I am receiving the following question a lot: How do I propagate MSBuild properties to SQLCMD variables. In order to make the Visual Studio 2008 Team System Database Edition GDR release use the data from an MSBuild property inside a SQLCMD variable you Read More...
Posted Sunday, June 21, 2009 4:21 PM by gertd | 1 Comments

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 Read More...
Posted Wednesday, June 10, 2009 5:10 PM by gertd | 2 Comments

System Objects in TEMPDB

Today a user send me a question how to resolve reference of system objects inside tempdb? My first thought was this should get resolved by loading the master.dbschema file. However this did not resolve the issue, so time to ask for an example, which slightly Read More...
Posted Wednesday, June 10, 2009 4:17 PM by gertd | 4 Comments

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 Read More...
Posted Friday, June 05, 2009 3:58 PM by gertd | 5 Comments
 
Page view tracker