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?   Read more...

“Joe Test” “Joe Test2? “Joe Test3? “Arrgh! There has got to be a better way to create some test data!” Ever had that conversation...  Read more...

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...

The Visual Studio 2005 Team Edition for Database Professionals (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us.  Read more...

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...