TL;DR: Jenkins supports pipelines from code. Make your build, test and deploy pipeline in code and you are not dependent on a specific CD tool. If you can do it from the command line and with API's you can combine and chain any tool or test-step. Use Pipelines as Code!

Is it possible to automate this complete process?

Probably, but not out of the box with some clicks in a UI. Worst case you need to write some custom code or shell/bat-scripts to tie everything together in Jenkins. This makes Jenkins very flexible, if you can do it on the commandline you can do it in Jenkins.

• Example of running sh/bat scripts in Jenkins: https://www.jenkins.io/doc/pipeline/tour/running-multiple-steps/
• Both XRay and Jira have an API, which you can call from your command line scripts, with curl for example. Check out the XRay API Import Execution Results REST documentation.

Can this also be done via Python?

Same as above, if you can do it on the command line you can do it in Python with subprocess. Also Postman has a command line interface, maybe check out the Newman examples: https://learning.postman.com/docs/running-collections/using-newman-cli/command-line-integration-with-newman/

Is this only possible via Junit?

No, I don't see what JUnit has to do with it, the tool examples you give don't need the JUnit test-runner to run. Maybe using standard Jenkins steps you want to use JUnit test result output format which those tools support. XRay supports JUnit reports as does Postman, so it might make importing results easier. You could also use the Postman JSON output and rewrite it to a XRay JSON import, or parse the Postman JSON with code and call the XRay API.

Other reads:

• https://www.thoughtworks.com/radar/techniques/pipelines-as-code

I've followed https://ajstorm.medium.com/installing-db2-on-your-coffee-break-5be1d811b052 and I was able to install DB2 on Docker.

I now would like to import a https://dataedo.com/kb/databases/db2/sample-databases to play with.

So I open IBM Data Studio, I right click on the instance > New database... , I fill up with my user name and password but then an error appears:

The system cannot verify the instance that you specified. Either enter a valid instance name or click on the button next to the Instance name field and select one from the list. com.ibm.datatools.adm.explorer.ui.model.InstanceException: An internal error occurred during: "Verifying instance db2inst1 in system 192.168.1.44.".

If I expand the error for more details I see:

'Verifying instance db2inst1 in system 192.168.1.44.' has encountered a problem.

An internal error occurred during: "Verifying instance db2inst1 in system 192.168.1.44.".

An internal error occurred during: "Verifying instance db2inst1 in system 192.168.1.44.".

com.ibm.db2.das.core.DasMessageIdentifier (initialization failure)

A dive in the official documentation brings me to https://www.ibm.com/support/pages/db2-installation-completes-error-error-occurred-while-creating-instance-db2inst1-return-code-1 but I don't think that could be the problem.

What intrigues me is the 'dot' (.) after the IP address. Could this be the error?

Or is there any other way to import a sample database from IBM Data Studio?

You already have foreign key in your inventory table (referencing company table), so I am going to assume you want to add foreign key to already existing table. You can do that like this:

ALTER TABLE Inventory_Asset
ADD CONSTRAINT FK_Inventory_Asset_asset
FOREIGN KEY (asset_id) REFERENCES dbo.Asset (asset_id)

I have a table of people (authors), and columns for Year_of_Birth and Year_of_Death. These are integers, as I wish to be able to compute things like current_age and age_at_death and age_when_first_published etc.

1. Clearly living authors do not have an Year_of_Death.

2. I don't have any birth/death information for at least some authors.

3. I have only a range of dates for some authors (eg, born 1560-1564)

4. For some authors, I don't yet have the information, but will fill in the columns in due course.

At the moment, these are all represented as NULL values.

My question is: Is there a best practice for distinguishing these potentially different column states?

For example, if I set living authors Year_of_Death as (say) 9999, and wrote a function to return current year in an age calculation when the year of death value is 9999, would that seem really hacky? (I really don't expect my database to last 7,977 years...)

Also, if I've searched for birth/death info and can't find it, and coded that as (say) 9998, I would at least know an attempt has been made, and could distinguish those rows from rows where I haven't yet looked for the data.

Or would a better solution be to add another column that codes e.g.'Living, Unknown, range x...y, Unsearched' to avoid polluting my year column with synthetic values?

Thanks for any pointers!

No, I'm afraid not. Creating a table requires a schema modification lock, which isn't with compatible anything, not even a schema stability lock which is used when doing read uncommitted.

You most likely have to take a step back and re-think your approach. I.e.,create the table before the transaction.

I have a large database, about 6Gig in size , its a .bacpac file and I want to copy it to Azure. I am using SSMS and selecting "Import Data-tier Application". It takes a very long time and i get an error "System out of memory exception"

How can I transfer the database to Azure ?

I have probably found the cause and it's a weird edge case.

I have the cts (from proxmox) running on lvm instead of lvm-thin. And had a backup job using snapshot for the database every 4 hours. My guess is that since snapshot was unavailable it froze the ct for the backup and somehow mariadb did not like that.

I have now changed that to a backup once a day with the shutdown option.

Dynamic quorum and dynamic witness are abilities of the WSFC to dynamically adjust the vote of the nodes and witness to prevent unnecessary failovers.

Where can I check whether the WSFC configuration is configured such that it performs dynamic quorum and dynamic witness?

Recently i have discovered (i have to premit i am not a DBA) that there is the possibility to configure a timeout into SQL Serve property (which apply to all DB into the SQL Server instance) :

Ignoring the fact that the picture display a 0 timeout (i am experimenting, it will not be the final configuration); i am confused, because i know that the timeout should be configured into the client that connect to SQL Server instance (both connection and command timeout).

Now i wonder what happening if a SQL Sever configuration say that the timeout is 10 minutes and a client connect with a connection string of 20 minutes (both command and connection). Which timeout is applied?

Why is max dop related the number of NUMA nodes?

Accessing memory on the NUMA node that the threads are running on is somewhat faster than accessing memory on other NUMA nodes. And parallel plans will run on a single NUMA node if it has enough cores (aka schedulers).

So it's a nice compromise to enable parallel queries while limiting their system-wide impact and promoting efficient query execution.

It's not at all mandatory, however, as you may have jobs that need MAXDOP 0. Also remember you can override the server MAXDOP at the database, workload group, or query level.

There is not a value that is good, or bad, for a query. It completely depends on what the query is doing. SELECT * from a table without a WHERE clause from a table with billions of rows will have a very high level of I/O. Whereas, SELECT ID from a table with a WHERE clause on the ID column and a clustered index on the ID column will have about as low a level of I/O as it's possible to get. Neither is right or wrong and there's not a >42 is bad kind of measure here.

Instead, you have to look at the query and what it's doing. Then, look at the execution plan to see how the query is being resolved.

In this case, you have a table scan, meaning it's a heap with no clustered index, even though there are clear WHERE clause values that could use an index to find data. So either the heap doesn't haven any nonclustered indexes, or, the nonclustered indexes it has, don't support the query. Does this mean there is excessive I/O going on? Yeah, probably.

Additionally, you have a nonclustered index in use, skypipeline_eventid, but it's not a covering index because then you have an RID lookup (another heap table). Is this excessive I/O? Yeah, probably.

In general, the vast majority of your tables should have clustered indexes. Indications are, this database has none, or few (sample size of 2 ain't exactly dispositive). Without clustered indexes on the column(s) that define the most commonly used path to the data, you're doing nothing but table scans all over the place. So, yeah, you're probably experiencing excessive I/O.