T-SQL Skills: Loading Millions Of Rows Of Test Data In Seconds скачать в хорошем качестве

T-SQL Skills: Loading Millions Of Rows Of Test Data In Seconds

Most tools that generate test data do so iteratively. But SQL loves set based operations. With a little T-SQL know how, you can create millions of rows of test data in seconds. You can even leverage public data sources to create more realistic data that conforms to your applications business rules. No third party tools, just a handful of queries. I’m keeping it simple. #sql #csharp #testing #database Blog: https://betterwithcode.com/ LinkedIn:   / jeff-zuerlein-2aa67b7   00:00 Introduction 00:13 Why you should generate test data. 01:11 How much data do you need? 01:48 Fake Data 02:48 Sql loves set based operations. 04:05 Fill the table with fake data. 05:38 Realistic test data 06:23 Populating a parent & child tables. 07:39 Leveraging modulus 08:38 Joining with a case statement. 10:45 Let SQL cook.