We have avamar tool taking backups in my environment. The backup plan avamar does is only taking trans backups once a day. I am convincing them to take the trans backup more frequent. But in the meanwhile, I have to deal with large log sizes because of this infrequent trans backups. Hence to redu...
I'm thinking, the point of the transaction log, irrespective of what tool is backing it up, is to allow point-in-time recovery. If you delete that backup, how would you expect to recover to that point-in-time in a DR situation? Second question, what reason do you have to believe that any other backup (log or otherwise) contains the data you have deleted, bearing in mind full or differential backups do not allow point-in-time recovery.
I think
Well, it's one for the vendor really, thinking about it.
Getting redirected to
400 Bad request
Your browser sent an invalid request.
Whenever I try and post the answer... Is this happening to others?
This is for: Add article to transactional publication without generating new snapshot
So I recently started using an MS SQL server for storing data.
The data is basically huge xml files.
I was under time pressure so I just made a table, with an id, some information and then an xml column for the data itself.
Currently, if I want to update a tiny portion of the xml, I need to read all the xml, make the tiny change, and then update all the xml.
Obviously, this isn't great, and now I finally have some time to start reworking the backend.
So I was thinking, since I need to store structured non-recursive tree-like data, would it make sense to look at a document based database instead of a relational database?
@WilliamMariager Is your data genuinely semi-structured or actually pretty structured (in which case consider normalising it into tables as performance will always be faster).
It's pretty structured. It's based on external specifications from something called GS1. I used raw XML so I didn't have to restructure my database when they changed their specs.
@WilliamMariager Guess GS1 is not that dynamic though. Look into .modify (you might find a few examples from someone called wBob or Mikael Eriksson), see if it helps. Otherwise, a kind of normal table structure is probably the way to go. Good luck!
I was worried that going with a table structure would explode. I don't have any experience with databases and having potentially thousands of tables sounded a bit extreme to me. But I admit I didn't check how common it was.
Okay, maybe not thousands. I have 800 classes, which I guess would each translate into a table.
Yeah. So far from speaking with users, I should expect periodic activity. Could be silent for weeks, and then a group of updates and then silent again. It's far from high frequency. Obviously if I get more people using it, the frequency will increase.
I think I'll give .modify a look first. Seems like a simple optimization for now.
Is there anything similar for only reading out part of the xml? Maybe by xpath?
I'll just google it :P Don't want to waste your time. I see that .modify uses DML and XPaths so obviously I can read out parts some way too.
@WilliamMariager Sure. .query returns xml, .value returns scalar values, .nodes returns resultsets etc. I'm pretty sure if you find one of my .modify examples you'll see two or three of them on show.
@ypercubeᵀᴹ yes, instead of having two key/value pairs per row, it only has one, which is certainly slightly different from the OP's table. I would certainly say it's not different in a good way, I think it makes the problem worse, if anything.
It might be better (or more appropriate) if the OP wanted to store menus with arbitrary number of levels. Still, the answer ignore relationships between menu levels and (parent/child) items of different levels, so it wouldn't work as it is..
With the intention of describing how you could do this with a hierarchical key/value pairs table, supporting foreign keys, I've built the following tiny test-bed of code that allows exploring how the structure might work.
Do this in tempdb, to avoid killing anything "interesting":
USE tempdb;
I...
To give you some context, the business I work for an I enjoyed a post-New Year night out, paid for and sponsored by the business as a thank you for the previous year and to get people motivated for 2017. During this, HR themselves took some photographs of the evening, throughout the evening.
Our...
It seems HR wanted him to do just the technical work (of putting the pictures into the screen showing program, app) and he went above and beyond, sharing the files to anyone who asked.
@TomV Yeah, me too.
Usually in Google drive or just emailed and CCed to everyone
although I wasn't there to vouch for it, apparently one of my ancestors came over from Normandy to England in 1066 as one of William the Bastard's generals. There is a town in Normandy that bears my last name; which is where my ancestor apparently lived.
@PaulVargas My platform of choice is Windows; so SQL Server. I'm also really liking SQL Server on Linux lately.
@ypercubeᵀᴹ well, perhaps I'm not a Unix guru, but I've been using it since I was just a wee lad. I suppose I just don't use it enough to know every flavor of every command.
@ypercubeᵀᴹ it seems to me every time you turn around there is a new way of doing something in Linux.
@ypercubeᵀᴹ I doubt it... it's probably just that I don't do it enough to know it like the back of my hand, like I do with Windows.
@ypercubeᵀᴹ to be honest, RedHat is the one I've been using recently, and in my opinion, it's one of the easier ones to get to know. I have used Suse before, and several other variants a long time ago, in a galaxy far far away.
@ypercubeᵀᴹ I must admit, being able to upgrade the kernel while the system is running without any reboot is quite an interesting feat. You can't do that with Windows!
> Instead of typical HTTP requests, the Firebase Realtime Database uses data synchronization—every time data changes, any connected device receives that update within milliseconds. Provide collaborative and immersive experiences without thinking about networking code.
Getting redirected to
400 Bad request
Your browser sent an invalid request.
Whenever I try and post the answer... Is this happening to others?
This is for: Add article to transactional publication without generating new snapshot
With the intention of describing how you could do this with a hierarchical key/value pairs table, supporting foreign keys, I've built the following tiny test-bed of code that allows exploring how the structure might work.
Do this in tempdb, to avoid killing anything "interesting":
USE tempdb;
I...
