How can I convert the final integer of a bitwise OR back to it's original set of integers that the bitwise OR operation was applied to?
For example if I have the following set of bit values: {0, 1, 2, 4, 8, 16} and if I have the bitwise OR generated value of 11 then I would like to convert that ...
seems like you already have all the information you need - and i know you're a smart guy, so asking such a specific question makes it too niche. it's not generalizeable to anyone but you at any time except for right now
However, I don't see how laying out my whole infrastructure and reasons for not backing up the databases with the existing solution (monetary values) is going to increase the probability of an answer.
you don't have to back up your laptop or local VMs, (although there's no reason not to if you're building your environment the same there as in prod) - but if it's a shared environment then it gets the shared environment treatment
Personally I think that dev should be as flexible as possible to satisfy dev requirements. Integration testing and subsequent test environments should be close to prod.
you don't have to back up your laptop or local VMs, (although there's no reason not to if you're building your environment the same there as in prod) - but if it's a shared environment then it gets the shared environment treatment
If you have the money / resource the throw at it, despite it not being a business or architectural requirement - great! A lot of organisations like to run inherently lean processes which for me don't fit in that bucket.
"keep track" isn't hard though. Devise your 3/4 off the shelf patterns
that's what I've done
Then when a new system comes in, just pick up the appropriate pattern based on SLA
Flexibility is good too
I see the benefits don't get me wrong, but I tend to come at this from a standpoint of what's the MVP for this service, rather than trying to reduce overhead in the testing / dev process
Automated test suites as an example are another way around these issues.
Low overhead, high return in integration test scenarios
There really is no correct answer though. It's a business decision ultimately
The counter point of your argument Peter is that resource consumption increases. More backup space needed, better IOPS on shared storage needed etc
What's the point of backing up a test system? The only use I have ever seen is taking a database snapshot after the initial restore from a real backup so the test environment can be easily reset.
@Johnakahot2use What do you mean by "pseudo backup"?
Backup to NUL? Copy only backup?
The main reason I can see to maintain FULL recovery is to ensure test has similar performance characteristics to production and doesn't sneakily take advantage of optimizations not present on prod. That all assumes the hardware is the same too.
Few places I have seen could afford to have prod-spec hardware for test and dev
Phillip Joel Hughes (30 November 1988 – 27 November 2014) was an Australian Test and One Day International (ODI) cricketer who played domestic cricket for South Australia and Worcestershire. He was a left-handed opening batsman who played for two seasons with New South Wales before making his Test debut in 2009 at the age of 20. He made his One Day International Debut in 2013.Hughes scored his first Test century in March 2009, aged 20, in his second Test match for Australia, opening the batting and hitting 115 in the first innings against South Africa in Durban. This made Hughes Australia's youngest...
He was an Australian cricketer who died after getting injured from a bouncer.
Today I wanted to define a uuid of value 00000000-0000-0000-0000-000000000000. Being a SQL Server man, I'd usually...
select cast(0x0 as uniqueidentifier);
...but I'm in postgres world now so I whipped out a sensible...
select cast('\x00'::bytea as uuid);
ERROR: cannot cast type bytea to u...
@PaulWhitesaysGoFundMonica A backup to disk with a retention policy of 24 hours. Just to keep the TLog at bay.
@TomV-TeamMonica Me neither
only just got back from a meeting with the tax department regarding the 99% ad hoc queries
@PaulWhitesaysGoFundMonica I defined it in my question as: In the process of implementing the SIMPLE Recovery Model in our test environment I thought about implementing a pseudo-backup procedure similar to the production environment instead. The idea would be to keep the user databases in the FULL Recovery Model and perform backups (preferably using Ola Hallengren's backup script) similar to the productive environment, which would retain the backup files for a maximum of 24 to 48 hours .
he's gotten a bit snippy with me before when i've asked him to expand on things so i'm kind of just doing the leg work now to figure out why his answer is right and what links / code samples i can add to a supplementary answer before accepting his answer
like ... it looks like \dCS(+) lists "friendly" datatype names, but the underlying data comes from pg_proc -> pg_type & pg_type doesn't have those names
--echo-all doesn't reveal a SQL query like SMO->Profiler (in SQL Server world) does so i don't know where the word "bigint" is coming from when the underlying typname is "int8"
A recent Tweet from @StackOverflow on Twitter said:
Announcing our new reactions feature, available today on Stack Overflow for Teams for Basic and Business tiers, and coming to Enterprise in 2020.
New ways of saying 'thanks' will be coming to the Stack Exchange network next year, too. ...
I have a question about my Database Administrators Stack Exchange post: MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!
I tried to use the tag windows-server-2019 but it does not exist. I would like to propose creating it. I can't do this o...