Posts
Sort by recent activity
Minimum permissions for AD authentication service account?
I'd like to know the minimum permissions required in AD for the service account that I am using to set up Active Directory Authentication? Can't seem to find this in the documentation anywhere.
Thanks
Extended events - could it be possible to enable per server?
The new deadlock feature is great - but we have a few older boxes (pre- SQL 2012 SP1 CU6 and pre- SQL 2008 R2 SP2 CU12) that are running into this issue (KB 2878139).
To get around this it would be...
After adding VMWare host, no host metrics are displayed and all servers show "connection failed"
I've been running SQL monitor for a while now to monitor a handful of my servers which are VMs.
With the new VM host monitoring feature, I thought I could simply connect to my vcenter in order to s...
Is there any way to publish packages to DLM Dashboard using a custom schema name?
If I have it correct, when you publish a build package to DLM Dashboard, it will name the schema using the nuget package version. Is there any way to change or customise the schema name that will b...
Bogus "add migration script" warning, even when no changes in commit tab
For the last two version I've been seeing a constant warning in SC: "These changes might cause deployment errors or data loss. Make sure a migration script covers the change." Immediately below it ...
How can I force my build to fail when any unit tests fail?
My build definition uses a DLM Automation 2 "Test" step, and is setup to publish results. This all works nice, except I'd like the build to fail if any of the tests fail.
Any suggestions how to ach...
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...