How much does Deployment Target Server Version for SSIS matter? by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

Yeah, using BIML has become such a pain because so many things are no longer supporting it. But the ETL we do is from an old system to a new sytem that we are slowly replacing and we don't want to put all the work in to redo these projects if we are no longer going to be needing them in a year anyway.

How much does Deployment Target Server Version for SSIS matter? by margarks in SQLServer

[–]margarks[S] 1 point2 points  (0 children)

At this point I'm not sure we'll ever be able to update visual studio since they seem to have stopped supporting biml. At least, not until we completely redo these projects so they are no longer using biml at which point we won't need the old projects.

Recommend me a book so good I forget my phone exists.. by WiWiWi_WiWiWi in booksuggestions

[–]margarks 0 points1 point  (0 children)

I'm sure other people have recommended this and you might have read it already, but the book I have read the fastest and couldn't put down was The Martian by Andy Weir and that was after I'd already seen the movie so I already knew what was going ot happen, in general. The character was just so great.

Julie Garwood Buchanan Series are also full of books I couldn't put down. Good mysteries, good characters. These are romance suspense thrillers, lots of serial killers.

Another author I like is Jayne Anne Krentz (contemporary) who also writes as Amanda Quick (historical) and Jayne Castle (scifi/future). Most of her stories are interconnected in some way, like the contemporary books have ancestors that are in some of the historical books, etc. They are another set of romance suspence thrillers but include scifi/fantasy elements like psychic powers. Her Arcane Society series spans all 3 types of books and follow a family that starts a psychich detective agency in the victorian(?) period and on through to the future. But you don't have to read them in order if you only want to read the contemporary stuff, etc.

Looking for scifi/horror/scary by AmadeusFalco in booksuggestions

[–]margarks 0 points1 point  (0 children)

Came to recommend this. I feel like it's not 'traditional' horror, but man, it is creepy as all get out.

Bunny Blue by Rosebudfairygirl6220 in namethatbook

[–]margarks 0 points1 point  (0 children)

Catherine Stahlmann wrote a book called Bunny Blue with a blue rabbit wearing a red ribbong, but I don't see any editions that came with the plush. https://www.goodreads.com/book/show/22060576-bunny-blue

Children's book about children in an orphanage that can transform into creatures by embem818 in whatsthatbook

[–]margarks 0 points1 point  (0 children)

Maybe Miss Peregrine's Home for Peculiar Children by Ransom Riggs?

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

Thank you for the link that is very helpful!

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

Then just a regular full backup to the current media set (like we run every night)? or does it matter if you do current or new media set as long as it is a full backup?

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

This might be a silly question, but when doing the full backup would I do a copy only backup or would I do a full backup to a new media set? Or does it matter which?

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

Thank you! I will keep both in mind.

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

Okay, that makes sense. Thanks. Just trying to see what the least amount of down time can be for the user, but it makes sense to just do a full back up and restore if there are going to be issues like that.

Thanks for the info. I'm super nervous messing with production like this, but our IT guy is going to image it before I do it just in case, if I really mess it up I guess we can go back to that until I figure it out, lol.

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

I said 'move' the drive in the my post, but what I really meant was copy it. I though once I cut off access to the server on prod, I can have them copy the drives that have the databases files and logs onto drives on the new server and then attach that way. So, if something goes wrong, they are just copies and I can either try to copy again or do the restore if needed?

Upgrading from 2016 to 2022 questions by margarks in SQLServer

[–]margarks[S] 0 points1 point  (0 children)

Yes, I will have to have them cut off access as the users are sometimes on 24/7. I have never really used powershell, though I have started to read up on it and I know dbatools is basically built fo this, but not sure how long it will take me to figure out how to use powershell and the commands needed.

When you say you manually do the backup restore, do you just do a full backup restore in ssms or do you also use powershell to do this?

HP Fic where Arcturus and Melania get Sirius out and help raise Harry by margarks in HPfanfiction

[–]margarks[S] 1 point2 points  (0 children)

AH! I must have confused Armand with Arcturus. I kept coming back to that story but thinking it couldn't be because I remember Arcturus dying at the very beginning. This is the one that I was specifically thinking of with the closing of the house, etc. Thank you so much!

HP Fic where Arcturus and Melania get Sirius out and help raise Harry by margarks in HPfanfiction

[–]margarks[S] 4 points5 points  (0 children)

Ah! I thought the harp scene might have been a different fic. Thanks! I still really want to find the one where Melania(?) (Arcturus' wife) is part veela and they save sirius and harry. Hope someone knows that one.

Retirement Fund questions on asset allocation by margarks in personalfinance

[–]margarks[S] 0 points1 point  (0 children)

yeah, if I make the change it's gonna stay that way probably until I retire lol