December 11, 2017 at 8:46 am
ThomasRushton - Friday, December 8, 2017 2:12 AMPhil Parkin - Thursday, December 7, 2017 2:08 PMSteve Jones - SSC Editor - Thursday, December 7, 2017 1:58 PMThat or see if I can get into SQLGrillen.Is that a geeky barbecue event?
Yup. Databases, Bratwurst & Beer. http://sqlgrillen.de/
Glad you cleared that up. I thought you were referring to my interview techniques. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2017 at 8:49 am
jasona.work - Monday, December 11, 2017 8:41 AMThom A - Monday, December 11, 2017 8:11 AMARGH!!!!!!!! Why does our Tester have access to test automation scripts on our Live Application Environment?! She just set off the out of hours, weekly BULK INSERT process; the one that wipes the entire back end database and rebuilds it from the text based mainframe! ARGH!Guess I'll watch some Netflix for the next 3 hours..? -_-
I'd trade you, but you don't want my systems...
The Devs have db_owner to the ***Production*** databases they're responsible for.
We've tried to get it stepped back to no more than reader, but they sometimes need to correct end-user mistakes (incorrect values, like qty 100 instead of 10 sort of thing)
And, technically, our area doesn't "own" the databases or applications, we make them aware of the risks, so...
Heh, I dunno... I'd love a back end data system that wasn't designed and hasn't been updated since the 1980's. All those posts JC makes about COBOL ring pretty well with our application, and (unfortunately) it's reflected in the SQL Server back end.
With the Devs, couldn't they, therefore, have db_reader and db_writer then? They'd be able to run UPDATE statements then at least, and no one could be "accidentally" silly enough to DROP the database. 🙂
I've raised my concerns with the Boss. We have Dev and UAT environments, so she should be using those. It's not her fault, she's doing what she'd been told; "replicate these scripts in the new automation tool and test them". What they didn't tell her was "WHATEVER YOU DO, DON'T TEST THIS ONE DURING WORKING HOURS!!!". Hopefully they'll move her to the other environments, as if she breaks them then we just restore them back; that's what they're designed for! ^_^
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 11, 2017 at 8:54 am
jasona.work - Monday, December 11, 2017 8:41 AMThom A - Monday, December 11, 2017 8:11 AMARGH!!!!!!!! Why does our Tester have access to test automation scripts on our Live Application Environment?! She just set off the out of hours, weekly BULK INSERT process; the one that wipes the entire back end database and rebuilds it from the text based mainframe! ARGH!Guess I'll watch some Netflix for the next 3 hours..? -_-
I'd trade you, but you don't want my systems...
The Devs have db_owner to the ***Production*** databases they're responsible for.
We've tried to get it stepped back to no more than reader, but they sometimes need to correct end-user mistakes (incorrect values, like qty 100 instead of 10 sort of thing)
And, technically, our area doesn't "own" the databases or applications, we make them aware of the risks, so...
Heh... technically, you DO own the databases. If you don't think so, wait until some goofball makes a costly error. Although they may be unsuccessful in their attempt if you've documented your warnings to management, the initial thought will be to blame the DBAs.
I also don't know if you get audited but we do shine a bit on audits because no change (even to data) can be made without a "ticket", reviewed code to make the change (and checked into SVN for traceability), and a DBA will deploy the code. No one can deploy their own code, either. Even I can't make a change without following the process.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2017 at 9:03 am
Jeff Moden - Monday, December 11, 2017 8:54 AMEven I can't make a change without following the process.
I reckon that should be don't rather than can't!
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
December 11, 2017 at 9:05 am
Phil Parkin - Monday, December 11, 2017 9:03 AMJeff Moden - Monday, December 11, 2017 8:54 AMEven I can't make a change without following the process.I reckon that should be don't rather than can't!
And I'd reckon you're reckoning is right or Jeff would have a day of reckoning. 😉
I'm in the same boat because I put myself there. Yes, I can deploy changes without owner approval, but I won't.
December 11, 2017 at 9:24 am
Jeff Moden - Monday, December 11, 2017 8:54 AMjasona.work - Monday, December 11, 2017 8:41 AMThom A - Monday, December 11, 2017 8:11 AMARGH!!!!!!!! Why does our Tester have access to test automation scripts on our Live Application Environment?! She just set off the out of hours, weekly BULK INSERT process; the one that wipes the entire back end database and rebuilds it from the text based mainframe! ARGH!Guess I'll watch some Netflix for the next 3 hours..? -_-
I'd trade you, but you don't want my systems...
The Devs have db_owner to the ***Production*** databases they're responsible for.
We've tried to get it stepped back to no more than reader, but they sometimes need to correct end-user mistakes (incorrect values, like qty 100 instead of 10 sort of thing)
And, technically, our area doesn't "own" the databases or applications, we make them aware of the risks, so...Heh... technically, you DO own the databases. If you don't think so, wait until some goofball makes a costly error. Although they may be unsuccessful in their attempt if you've documented your warnings to management, the initial thought will be to blame the DBAs.
I also don't know if you get audited but we do shine a bit on audits because no change (even to data) can be made without a "ticket", reviewed code to make the change (and checked into SVN for traceability), and a DBA will deploy the code. No one can deploy their own code, either. Even I can't make a change without following the process.
Yeah, we've got something of a weird environment...
I have no direct control over backups and have to put in tickets to another area to get changes made / restores run (trying to change this one)
The example I use for how the responsibility breaks down tends to be, we're a hosting service that provides the underlying SQL Server, but what they do with their data is not our problem (unless they need a restore / out-of-schedule backup / QA refresh) done. The problem is, it's been this way since well before I started, so there's a lot of "institutional inertia" resisting any change (think about the tank picture I linked to last week. Now think about trying to push that tank, by yourself, wearing roller skates on ice...)
As for auditors, while we have to deal with them roughly every 3 years or so, they follow the DISA STIG checklists like a bible and because we're not involved in the application side of things, we're not responsible for how the appdevs push code out...
Dumb, yes, but hey, you know who I work for Jeff...
December 11, 2017 at 9:44 am
jasona.work - Friday, December 8, 2017 4:43 PMSigh...
I'm happy in my current job, so what did I do?
Started watching the National Geographic special from a while back, Mars. Well, it has plenty of shots of various SpaceX facilities, etc.Which led me to visit the SpaceX careers page...
To see that they're looking for a SQL DBA for the Hawthorne, CA facility...So...
Tempting...(Except I really, really, really, really don't want to live in CA for various reasons which I'm not going into here)
*sigh*
Maybe when I get bored with my current job, they'll still be in the market.
Maybe they will allow you to work remotely?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
December 11, 2017 at 10:09 am
WayneS - Monday, December 11, 2017 9:44 AMjasona.work - Friday, December 8, 2017 4:43 PMSigh...
I'm happy in my current job, so what did I do?
Started watching the National Geographic special from a while back, Mars. Well, it has plenty of shots of various SpaceX facilities, etc.Which led me to visit the SpaceX careers page...
To see that they're looking for a SQL DBA for the Hawthorne, CA facility...So...
Tempting...(Except I really, really, really, really don't want to live in CA for various reasons which I'm not going into here)
*sigh*
Maybe when I get bored with my current job, they'll still be in the market.Maybe they will allow you to work remotely?
That might be an option, but half the fun of working someplace like that would be to be able to walk over to the shop floor and chat with the folks working on the rockets and such...
Get hands-on with a Dragon capsule, stick your head in the bell of a Falcon rocket, that sort of thing...
(Yes, I'm a space geek...)
(/me hops on USAJobs to see if NASA is in the market for a DBA)
December 11, 2017 at 10:34 am
Phil Parkin - Monday, December 11, 2017 9:03 AMJeff Moden - Monday, December 11, 2017 8:54 AMEven I can't make a change without following the process.I reckon that should be don't rather than can't!
Heh... correct! 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
December 11, 2017 at 10:56 am
Ed Wagner - Monday, December 11, 2017 9:05 AMPhil Parkin - Monday, December 11, 2017 9:03 AMJeff Moden - Monday, December 11, 2017 8:54 AMEven I can't make a change without following the process.I reckon that should be don't rather than can't!
And I'd reckon you're reckoning is right or Jeff would have a day of reckoning. 😉
I'm in the same boat because I put myself there. Yes, I can deploy changes without owner approval, but I won't.
He he, according to some, changes are for the greater go(o)d, make them and things will (read should) get better:w00t:
😎
December 11, 2017 at 12:31 pm
Does anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file allocation size was set to 128MB. As you can guess, a 3TB array ran out of space quite rapidly after I copied a large volume of small files over. Support says it's "by design". Not sure how it can be, the box says it can hold about 2.7M photos, however, at 128MB each, that storage can't hold much more than 8,000 files... Heh.
Sending the one I have back for a refund once the factory reset is down, but the external HDD is getting very old, so little concerned it could fail some time in the not too distant future. O.o
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 11, 2017 at 1:01 pm
Thom A - Monday, December 11, 2017 12:31 PMDoes anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file allocation size was set to 128MB. As you can guess, a 3TB array ran out of space quite rapidly after I copied a large volume of small files over. Support says it's "by design". Not sure how it can be, the box says it can hold about 2.7M photos, however, at 128MB each, that storage can't hold much more than 8,000 files... Heh.Sending the one I have back for a refund once the factory reset is down, but the external HDD is getting very old, so little concerned it could fail some time in the not too distant future. O.o
Thom, if you're interested I have an older 4-bay (non-hot swap) NAS with a couple 1TB drives I'd be willing to sell...
Synology CS407e
December 11, 2017 at 1:08 pm
jasona.work - Monday, December 11, 2017 1:01 PMThom A - Monday, December 11, 2017 12:31 PMDoes anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file allocation size was set to 128MB. As you can guess, a 3TB array ran out of space quite rapidly after I copied a large volume of small files over. Support says it's "by design". Not sure how it can be, the box says it can hold about 2.7M photos, however, at 128MB each, that storage can't hold much more than 8,000 files... Heh.Sending the one I have back for a refund once the factory reset is down, but the external HDD is getting very old, so little concerned it could fail some time in the not too distant future. O.o
Thom, if you're interested I have an older 4-bay (non-hot swap) NAS with a couple 1TB drives I'd be willing to sell...
Synology CS407e
Shipping to the UK would (possibly) cost an arm and a leg. Plus you probably don't have a 3 pin socket lead. 🙂
I'm actually looking for something with a minimum of 3TB storage. If it's 4 Bays with 4 x 1TB HDDs, I could get a 4TB Raid 0, however, I'm also looking for the redundancy (I've had the pain of a HDD failure in the past when I wasn't replicating, and a lot wasn't recoverable).
Thank you for the kind offer though. :blush:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 11, 2017 at 1:40 pm
Thom A - Monday, December 11, 2017 1:08 PMjasona.work - Monday, December 11, 2017 1:01 PMThom A - Monday, December 11, 2017 12:31 PMDoes anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file allocation size was set to 128MB. As you can guess, a 3TB array ran out of space quite rapidly after I copied a large volume of small files over. Support says it's "by design". Not sure how it can be, the box says it can hold about 2.7M photos, however, at 128MB each, that storage can't hold much more than 8,000 files... Heh.Sending the one I have back for a refund once the factory reset is down, but the external HDD is getting very old, so little concerned it could fail some time in the not too distant future. O.o
Thom, if you're interested I have an older 4-bay (non-hot swap) NAS with a couple 1TB drives I'd be willing to sell...
Synology CS407eShipping to the UK would (possibly) cost an arm and a leg. Plus you probably don't have a 3 pin socket lead. 🙂
I'm actually looking for something with a minimum of 3TB storage. If it's 4 Bays with 4 x 1TB HDDs, I could get a 4TB Raid 0, however, I'm also looking for the redundancy (I've had the pain of a HDD failure in the past when I wasn't replicating, and a lot wasn't recoverable).
Thank you for the kind offer though. :blush:
You're quite welcome
And yeah, I don't have the right socket lead, but you could do a 4x 1TB drives with redundancy (so you'd get 3TB)
Good luck in your hunting!
December 11, 2017 at 7:26 pm
Thom A - Monday, December 11, 2017 12:31 PMDoes anyone use a NAS at home? Anyone able to recommend an affordable 2 Bay for home use? I recently picked one up, and (for some reason) the minimum file allocation size was set to 128MB. As you can guess, a 3TB array ran out of space quite rapidly after I copied a large volume of small files over. Support says it's "by design". Not sure how it can be, the box says it can hold about 2.7M photos, however, at 128MB each, that storage can't hold much more than 8,000 files... Heh.Sending the one I have back for a refund once the factory reset is down, but the external HDD is getting very old, so little concerned it could fail some time in the not too distant future. O.o
I'm thinking about getting this one: https://www.amazon.com/NETGEAR-ReadyNAS-Performance-Processor-RN42200-100NES/dp/B015S0Y50C/ref=sr_1_2_sspa?s=pc&ie=UTF8&qid=1512679433&sr=1-2-spons&keywords=NAS&th=1
And here are some drives to put into it: https://www.amazon.com/s/s/ref=sr_nr_p_n_feature_three_br_0?fst=p90x%3A1%2Cas%3Aoff&rh=n%3A1292110011%2Ck%3Assd%2Cp_n_feature_three_browse-bin%3A6797522011&keywords=ssd&ie=UTF8&qid=1512680537&rnid=6797515011
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 15 posts - 60,631 through 60,645 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply