Test Data

External Article

10 tips for Test Data Management success

  • Article

What are the challenges to implementing a successful test data management strategy? In our recent webinar ‘Harnessing the Power of Test Data Management: Strategies for Success’, Redgate’s Steve Jones was joined by Hamish Watson (DevOps Consultant) and Daniel Watkins (Director/Principal Consultant) to talk all things TDM and how to implement it efficiently and effectively. Here are 10 key tips and takeaways from their conversation in a short blog post.

2024-08-16

External Article

Redgate recommended in Bloor Test Data Management market update

  • Article

Last year, Redgate announced the launch of their latest in test data management (TDM) technology – Redgate Test Data Manager. This year, they’re proud to have been recommended in Bloor’s 2024 Test Data Management Market Update! This paper highlights the increasing adoption of TDM technology among enterprise organizations and offers insight into the trends and approaches to look out for when looking for a TDM solution.

2024-07-10

External Article

Concepts and Issues in Test Data Generation

  • Article

Data generation is the science and art of providing data for database development work that is as realistic and controllable as possible. The skills of generating realistic data are an essential part of being a database developer. It is important: you need plenty of data of exactly the right type, size and verisimilitude

2024-07-01

External Article

What is subsetting, what are the advantages, and how does it make test data management easier?

  • Article

As data grows and databases become larger and more complicated, data
subsetting provides a method of working with a smaller, lighter copy of a
database to make development and testing faster and easier.

In this article, James Hemson poses the questions; what exactly is data subsetting, how and why are developers using it – or not using it, and
what’s prompting conversations about it?

2023-12-11

SQLServerCentral Editorial

Creating Test Data

  • Editorial

This editorial was originally published on Jan 9, 2020. It is being re-run as Steve is out of town. Test data is hard to come by, and I agree with Brent Ozar: " I get so frustrated when I hear trainers/presenters/bloggers/idealists talk about how developers should be using purpose-built-from-scratch data sets with no real customer […]

5 (1)

You rated this post out of 5. Change rating

2023-06-07 (first published: )

482 reads

Blogs

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

Read the latest Blogs

Forums

MEMORYBROKER_FOR_RESERVE experience

By tony28

Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...

Moving Database Files

By Ahr Aitch

I just learned that my database was created on my C:\ drive in the...

Migrate MSSQL to MYSQL - Different Servers

By cajun_sql

I am needing to migrate a MSSQL db to MySQL, on a different server...

Visit the forum

Question of the Day

Mixed Backups

I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).

BACKUP DATABASE [complex]
    FILE = N'thirdone'
 ,  FILE = N'thirdtwo'
 ,  FILEGROUP = N'second' 
 TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' 
 WITH NOFORMAT, NOINIT,  NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

See possible answers