Posts
Sort by recent activity
Dilemma with SCA and VS 2019 T-SQL Editor
Greetings,I am having a dilemma using VS 2019 with SCA add-on.I am trying to figure out a way to use SCA, along with the VS T-SQL Editor effectively, since SCA gets complicated if you start changin...
SQL Data Generator hanging when generating data
I was working with SQL Data Generator 3 and as of a few days ago, whenever I try to generate data for a table it takes an EXTRAORDINARILY LONG amount of time to generate just a few rows. It's taki...
Generating data for large databases
Greetings,
I am trying to generate a large data set and it is taking many hours in SQL Data Generator to generate a 20 million row table. Any suggestions to speed this up?
Generate data for derived column
Greetings,
I need to populate test data for certain columns which are derived from other columns in the same table. What is the best way to do this?
For example, I have a column that is derived by...
Data Exhausted error in IronPython script
Greetings,
I am trying to populate a complex FK scenario with the Python script below and am getting the error 'Data exhausted for field 'TenantId''.
Can anyone tell me what I'm doing wrong?
def ma...
SQL Test showing success for test that has failed.
Greetings,
I just started using SQLTest and tSQLt. I have a test that fails when I run it from the SSMS Query Window, but it displays a green checkmark on the SQL Test UI.
This is the code of the ...
SQL Source Control 3 with encrypted SQL objects
Greetings,
I am using encrypted SQL Server objects (views, to be specific) and I don't see a way to be able to use these with SQL Source Control. Is there an option out there that enables the decr...
SQL Data Generator 3 not generating random data
Greetings,
I was trying to generate some random test data for a BI solution (star schema) which had 1 fact table and about 7 dimensions. The generator was generating random data for all but 2 of t...