Browse by Tags
All Tags »
DB Dude (
RSS)
What has changed for Visual Studio Team Edition for Database Professionals (aka VSDB, DB Dude) in the 2008 edition? Installation: No more additional setup. In Visual Studio Team System 2008 VSDB completely integrated in the standard setup, so no more additional downloads. All you have to do is to make sure the Team Database Edition option is checked in the features to install window. The database project functionality is only available in two of the Visual Studio Team System SKU's: Visual Studio...
I uploaded my presentation and demo, done in DevAcademy2 . Now you can download, use and review it. Presentation - DEV215 Integrating Databases Into ALM Demo - DEV215 Integrating Databases Into ALM
What is the difference between the "Refresh" button in "Solution Explorer" and the "Synchronize" button in "Schema View? I posted an explanation about it. Read it here .
I built a big DB Dude project from MSBuild command line and got a timeout error. MSBUILD : Build error TSD158: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The default timeout for query execution is 60 seconds and stored in the registry. We can extend the query timeout by changing these values. The registry entries are: HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\DBPro\Database\QueryTimeoutSeconds HKEY_CURRENT_USER\Software...
Power Tools that extend the functionality of Visual Studio Team Edition for Data Professionals is now available. The tool includes: Dependency Viewer More refactoring support Extended Data Generation New MSBuild Tasks T-SQL Static Code Analysis Schema Manager API Read Gert's post for a more detailed explanation. Download the tool from here .
The Data DUDE team announced that Visual Studio Team Edition for Database Professionals Service Release 1 is ready for consumption! To summarize the knowledgebase article, the following features have been added: Cross-database references: You can reference objects within different databases by using database project references or by referencing a database metafile (.dbmeta). Improved SQL Server file groups support: You can define files within file groups as database project properties instead of...
Yesterday I gave a session about Team System For Database Professionals in the Are you Ready 2008 event. The audience had good time and went away with valuable knowledge about Team System For Database Professionals . You can find the slide decks from the session here . If you have any feedback about the lecture, I'd like to hear it! Enjoy!
Why output script from VSTS for Database pro failed to execute in Management Studio? Database pro output scripts are valid t-sql syntax, but remember: Database pro uses SQLCMD to deploy databases. How can you make it run? In Management Studio you need to swap into SQLCMD mode. Tthrough the Query -> SQLCMD Mode menu. Click the red exclaimation icon in your toolbar.
When you create your DB Dude project and try to build and deploy the project to the client's sandbox at the first time, you suddenly get the error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections." This error occurred because the networking protocols are disabled by default in SQL Server Express. In order to solve this problem...
A lot of users feel confused about the installation requirements of VSTS for DB Professionals (DB Pro). "Team Suite or other product must be installed before Db Pro" as the ReadMe file says. The requirements of VSTS for Database Professionals are: Visual Studio Professional Edition/Visual Studio Team Suite. Team Edition for Database Professionals is available as a separate product; however, to evaluate the Team Edition for Database Professionals Trial you must first install the Visual Studio 2005...
When deploying test data to database (such as your sandbox database) with triggers, you need that the triggers will be disabled before generating test data and then re-enabled after the data has been appropriately generated. I wrote two scripts for this issue: DisableTriggers.sql , EnableTriggers.sql . Execute this T-Sql before deploying test data: DisableTriggers.sql IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N '#AllTriggers' ) AND type in (N 'U' )) DROP TABLE #AllTriggers...
What does error message TSD4001 means? Or TSD3025? How can you filter out db dude's warning messages? A great list that summarizes and explains the warning and error messages of db dude and the way to filtering warning messages, you can find at gert's post. Check it out.
First of all, an introduction - a new blog by Maor David . Maor is an experienced .NET architect, developer and ALM specialist. Maor has recently implemented DB Dude of 3 customers sites and I hope that he will find the time to blog about it. I believe hsi new blog will be a very intresting place to track. Another blog, by Guy Kolbis is a mixture of .NET and advanced ALM Testing posts. Guy is a our web, load and stress specialist and has recently performed some complicated performance labs for our...
One of our customers implemented DB Dude as part of the development cycle. The customer had the following requirements from the data generation: The data must be closer as possible to the production environment data (remote machine). The data generation has to be fast - generate only new data when deployment occur. The Data generation plan which supplied with the Db Dude is a great utility but the customer has ~1000 tables , ~10K columns and to create data generation plan that answers these requirements...