Kirill Kravtsov

icon location Victoria, BC icon location DBA who is passionate about automation, which usually transpires as some form of Powershell/Python/SQL scripting. dbops maintainer. dbatools major contributor.

Results 44 comments of Kirill Kravtsov

v5: BeforeEach/AfterEach -Context?

Nice! thanks @nohwnd, looking forward to v5

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

I see why the error is happening, but I cannot repro on my end just yet. Setting connection string in Connect-DbaInstance on line 368 https://github.com/sqlcollaborative/dbatools/blob/a31bb64188af7e4bbdfdc6b32820ef2f36915c80/functions/Connect-DbaInstance.ps1#L368 is indeed happening prior to...

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

Okay, updated my repo to recent version, can 100% repro now on both windows and sql auth.

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

@potatoqualitee PR is ready, was able to fix it without too much fuss, but there are still some concerns about other two parameters that might not work properly with SqlCredentials

[Bug] Displays 'null' instead of 0.

Any chance there is an update on this?

Journaling to a single DB, when working with multiple DB

I'm not sure if something like this would be possible. Your workaround seems to be a way to go if you want to achieve something like this. Seems like theoretically...

Repeatable migrations

Now that I have a working example of an enhanced table, I would like to get more input on how you envision this working. Currently, there is already an option...

Repeatable migrations

The more I look at it, the more I think that this functionality would benefit the module greatly, perhaps offering a third potential pipeline scenario that supports modified files. It...

Change the SchemaVersions location to another instance

Hello, thanks for the feature idea. When you say "move the SchemaVersions table to another location", do you mean move it into a different table within the same database? Or...

Change the SchemaVersions location to another instance

There are two major issues related to this functionality: 1. Switching context is something only SQL Server is doing. Other supported DBMS will require a separate connection, which the DbUp...