Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag Test Data Rss

   Items 1 to 12 of 12   

Anonymous reality!

Create anonymous test data using real values. No more Mickey Mouse and Paul McCartney!   Read more...
By John Fielding 2015/08/07 | Source: | Category: test data
Rating: |  Discuss |   Briefcase | 993 reads

Data Sample Scripter

Generates code for INSERTs as well as generating data form tables for INSERT. Will also find and script all dependencies recursively, present all scripts in dependency order, and generate a reverse-dependency order set of conditional DELETE statements.  Read more...
By SQLEmil 2015/07/06 | Source: | Category: unit testing
Rating: (not yet rated) |  Discuss |   Briefcase | 930 reads

Managing Test Data as a Database CI Component - Part 2

Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.  Read more...
By Additional Articles 2015/06/12 | Source: SimpleTalk | Category: continuous integration
Rating: (not yet rated)  Rate this |   Briefcase | 2,493 reads

Managing Test Data as a Database CI Component - Part 1

Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.  Read more...
By Additional Articles 2015/02/16 | Source: SimpleTalk | Category: test data
Rating:  Rate this |   Briefcase | 7,142 reads

Generating Dummy Data

A quick and easy way to generate test data for load testing.  Read more...
By Jamie Ingram 2013/08/22 | Source: | Category: cross join
Rating: |  Discuss |   Briefcase | 7,825 reads

Generating Test Data: Part 2 - Generating Sequential and Random Dates

Part two of this fantastic series from Jeff Moden looks at generating date data, something which can be handy for any number of testing purposes.  Read more...
By Jeff Moden 2012/04/25 | Source: | Category: test data
Rating: |  Discuss |   Briefcase | 5,393 reads

Generating Test Data: Part 1 - Generating Random Integers and Floats

Learn how you can easily generate large amounts of test data efficiently in this new series from Jeff Moden. Part 1 covers integers and floating point values.  Read more...
By Jeff Moden 2012/03/26 | Source: | Category: data generation
Rating: |  Discuss |   Briefcase | 7,399 reads

Generating SQL Server Test Data with Visual Studio 2010

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...
By Additional Articles 2010/12/31 | Source: | Category: test data
Rating:  Rate this |   Briefcase | 5,543 reads

Generate Lots of Test Data with CROSS JOIN

“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...
By Joe Webb 2009/10/19 | Source: | Category: blogs
Rating:  Rate this |   Briefcase | 2,349 reads

Create Sample Data Script

in this scripts there are two methods of creating sample data for a gambling application. i have used both cursors and loops.  Read more...
By Chris Morton 2008/10/10 | Source: | Category: cursors
Rating: |  Discuss |   Briefcase | 615 reads

Test Data Generation with Data Dude

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...
By Additional Articles 2008/01/09 | Source: SQL Server Universe | Category: data dude
Rating:  Rate this |   Briefcase | 3,427 reads

Performance Tuning: Concatenation Functions and Some Tuning Myths

Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.  Read more...
By Jeff Moden 2008/01/01 | Source: | Category: test data
Rating: |  Discuss |   Briefcase | 15,779 reads
   Items 1 to 12 of 12   
data generation (3)    
random numbers (3)    
abs() (2)    
checksum() (2)    
rand() (2)    
advanced querying (1)    
blogs (1)    
cartesian product (1)    
code generator (1)    
continuous integration (1)    
cross join (1)    
cursors (1)    
data dude (1)    
performance tuning (1)    
random dates (1)    
t-sql (1)    
unit testing (1)    
user defined function (udf) (1)    
visual studio (1)    
while loop (1)