Posts
Sort by recent activity
Misleading suggestions against comments and stored proc parameters
Has any one else seen misleading suggestions against comments and parameters when using v10.11.9.27382?I'm seeing "UPDATE statement without WHERE or INNER JOIN clause" underneath comments and some ...
SQL Snapper - Minimum files required to work on client machine
During yesterday's webinar SQLSnapper was mentioned. I've used SQL Compare for nigh on 10 years and had never heard of it but it sounds like the ideal tool for us to do a confidence check on a sche...
AbortOnWarningLevel Options in Sync-DatabaseSchema
I recently had to delete some columns from a table that were no longer required.The loss of data from those columns wasn't an issue as the columns were not in use.Our powershell script failed with ...
'Cannot find SQL Release on your Octopus Tentacle' after Octopus Deploy migrated to another server
We are in the process of retiring an old server and therefore moving Octopus Deploy to a new server.We're a small organisation so have Octopus Deploy and SQL Server on the same box.Our old server h...
Add a db (which already has tSQLt installed) to SQL Test
I hadn't used SQL Test since installing it on my latest laptop.I restored my development database, which already contains tSQLt into an instance and I can do all my normal development activities wi...
Invoke-DlmDatabaseSchemaValidation - object does not exist or is invalid for this operation
We are trying to do an upgrade of our CI process with a new server.Our existing CI process that uses Jenkins with SQLCI works fine but is using an old version of DLM Automation.At present we are tr...
Temporarily getting back Tab History after deactivating the licence
Rather stupidly I deactivated the licence on a machine when I was migrating the licence to a new laptop.The machine with the deactivated licence had some open tabs that hadn't been saved anywhere e...
DLM Dashboard Identifies changes but they cannot be acknowledged
We've been doing a lot of work to apply some standards to our database.This has resulted in a (planned) drift of 463 objects.DLM Dashboard can identify the type of objects changed and the number of...