Posts
Sort by recent activity
Job Duration Unusual alert does not fire until job complete?
I discovered the hard way today that the Job Duration Unusual alert seems to only fire once the long-running job has completed or been manually stopped. Really??
This is an issue, and defeats a maj...
Error trying to use .sqlgen file with Test step
I just installed DLM Automation 2, and I'm running into some trouble with the Test step.
For the purpose of my tests, I have to populate the test DB with some reference data which I am trying to do...
Existing Data Source and Foreign Keys
As part of my test setup I need to import 8 or 10 "reference" tables, which have foreign key relationships between them.
How can I set it up so that it generates in a logical order such that the re...
Deploying modified UDF that is referenced by a constraint
We have a lot of table check constraints where the validation logic is encapsulated in a scalar UDF. In order to successfully deploy changes to such objects, it is necessary to first drop the refer...
SC not recognising "release candidate" migration scripts
I've downloaded the SQL Source Control 5 release candidate and have saved a data-only migration script.
So far, branching and merging looks promising: I was able to checkin my script to the dev bra...
Ability to "record" unit tests?
I've been looking around for a product that can "record" and script out a tSQLt test.
But i have not even found a mention of anything like what I'm looking for.
Basically, I imagine building a quer...
Set up migration scripts to work with branching
Hi, I'm trying to understand how migration scripts need to be configured in order to work with the following scenario:
In TFS, my branching structure is as follows:- Production (Rev. 1000)
- De...
Schema not being recognized on different server
I have a production database on server A and an exact clone of it on server B (SQL Compare shows all objects identical with zero objects excluded).
Yet DLM dashboard is not recognizing these two da...
Extreme server log growth with "decrypt encrypted objects"
I am new to SQL compare and was trying it out using the default project options when I noticed that every compare operation was adding ~400 MB to my error log file. Looking in the logs there were t...
Support for Analysis Services
As mentioned in this post a while back, it would be a welcome enhancement if SQL Source Control supported SSAS databases.
I envision being able to check in the SSAS db from SSMS.
Any plans in this ...