As a database developer or tester sometimes you need to have production like data in your environment for your development or testing, but you cannot have the production data because of security and privacy issues. So how you can generate test data or replicate similar data as in production for your development or test environment?
2010-12-31
5,955 reads
This article demonstrates how to manage database projects with Visual Studio 2010.
2010-10-15
4,254 reads
we normally do development on the development box; then during the build preparation we compare the development database with the QA/UAT/Production database to identify differences and generate schema objects for synchronization or incremental deployment scripts. How we can compare schema objects between databases and generate synchronization or incremental deployment scripts?
2010-08-27
4,519 reads
Caught in between upgrades, new author Mohan Jumar has an interesting article. Using Visual Studio 2005 to save packages in an SSIS 2008 package store.
2009-08-13
4,964 reads
Part 4 of this series from Drew Salem shows how you build a report in Visual Studio.
2009-06-29
7,503 reads
With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.
2009-06-24
5,311 reads
Learn about Microsoft Visual Studio Team System 2008 for database professionals, a useful tool for database development with Microsoft SQL Server.
2009-02-27
4,544 reads
In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.
2008-01-24
3,280 reads
Public access gives the user what ever permissions are assigned to the public role.You can have one database owner, but many people in the dbo group. dbo's have full access to the database in question.
2005-05-18
2005-04-27
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers