|
Misogynist posted:What is a "training database," exactly? My hospital has two environments, the live production environment with actual patients that all of the clinical staff works from. Then we have a testing/training database where we create patients and perform various testing. The test/train database is a mirror copy of the production environment, except its loaded with dummy patients. Feels like the perfect ground to learn how to write queries and reports that can be used in the production environment and be beneficial to the team. Tab8715 posted:I suppose you could accidentally write a query that would return the entire database and that could potentially slow things to a crawl. Yeah, I'm understanding that there is a logical reason to not wanting someone inexperienced touching things. Its just a little frustrating. Oh well, I'll get over it. Hughmoris fucked around with this message at 01:14 on Sep 17, 2014 |
#
?
Sep 17, 2014 01:12
|
|
|
|
| # ? Apr 25, 2024 04:53 |
|
|
Hughmoris posted:I need some opinions here. I work in clinical informatics at a smaller hospital, its a new job that I've been doing for 3 months. I provide solutions and support for our doctors and nurses etc... I'm not a programmer in the least bit but I've been trying to teach myself. I've wrote several small scripts that has made our team's life easier and removed some of the workload. I've been on the other side of a comparable situation twice (sort of, I think...) I'm not a programmer, no one in my company is employed to do any programming. We've had a couple of 'hobbyists' come in and make super spreadsheets full of complex vba etc and both times I highlighted to their managers they are not employed to program poo poo, nor am I a programmer, my boss does not want me spending my time programming and if your member of staff gets hit by a bus and that spreadsheet breaks, you are screwed. Are you ok with that? Both times, the manager in question has basically said 'I'll take the risk because it makes life easier' I'm not exactly sure what you are doing in your job, but if they perceive what you are doing as something that the business will want, that they have to then support but didn't have anything to do with, I can see why they might want to nip it in the bud and say go away. It really depends on if you are supposed to be doing this sort of thing as part of your role and/or have the backing of your superiors to do it. If you are not I think all you can really do is put the appropriate change requests in and let the right people take care of it. (I'm making a lot of assumptions so shoot me down...)
|
|
#
?
Sep 17, 2014 01:14
|
|
|
smokmnky posted:If I don't have PM but would like to abuse your kind offer would that be possible? Post your email and I'll respond as soon as I can. Pretty solid article I just read on LinkedIn. Sound advice even outside of silicon valley... https://www.linkedin.com/pulse/article/20140916165037-106728160-want-to-get-hired-in-silicon-valley-here-s-how?trk=nus-cha-roll-art-title
|
|
#
?
Sep 17, 2014 01:19
|
|
|
Hughmoris posted:As an SQL novice, what are the chances that I'd accidentally write a query using READ-ONLY access and bring down the database? IANADBA, but a lovely select like you're sure to write, on a database that isn't configured "correctly" can block writes for the duration of your select. So it's understandable to keep you out of it. However, if it's not sensitive data, and it's small enough, perhaps they'll set you up with a recent backup and SQL express (assuming mssql) to dick around with.
|
|
#
?
Sep 17, 2014 01:22
|
|
|
Hughmoris posted:My hospital has two environments, the live production environment with actual patients that all of the clinical staff works from. Then we have a testing/training database where we create patients and perform various testing. The test/train database is a mirror copy of the production environment, except its loaded with dummy patients. Feels like the perfect ground to learn how to write queries and reports that can be used in the production environment and be beneficial to the team. Your description helps me understand the situation with the test database. The key part is that, even though this DB isn't in production, people need this up to get their job done. It sounds like if it needs to be restored from backup from any reason, people also lose work. These are the two situations that make DBAs paranoid. This is doubly true for the people who manage them. It's not likely that you'll "bring down" the database, but you can cause some pretty serious performance problems if you don't know what you're doing and inadvertently trigger some full table scans or whatever. Even well-written queries can bring underpowered machines to their knees. There's a couple of things you can do. The first is, if the database is something you can run on your own like SQL Server Express or whatever, see if you can get a dump of the dev database to import into your own SQL Server Express/Oracle Express instance, running on your own personal computer, in exchange for buying a DBA lunch or something. That won't screw anything up, and you'll have all the write access you want. You can also try to make nice with the DBAs at a personal level, and approach them from a mentor/pupil perspective, rather than being all gung-ho about "give me access for no reason." You seem really excited about learning this stuff, and that's awesome, but you're doing it in an environment where people's lives literally depend on system availability, even for test systems. That's going to impact the ways that you're going to be exposed to new technology. You'll need to either make up the difference on your own, or find something else to become invested in that the hospital system is okay with letting you have access to (say, their HIPAA information security guidelines). Vulture Culture fucked around with this message at 01:36 on Sep 17, 2014 |
|
#
?
Sep 17, 2014 01:23
|
|
|
Hughmoris posted:My hospital has two environments, the live production environment with actual patients that all of the clinical staff works from. Then we have a testing/training database where we create patients and perform various testing. The test/train database is a mirror copy of the production environment, except its loaded with dummy patients. Feels like the perfect ground to learn how to write queries and reports that can be used in the production environment and be beneficial to the team. I'm not a SQL server expert but I'm MySQL ok and a read user still has access to create tmp tables which exist in memory. Also a select * from blah can kill a database. Since they have a slave though I don't see what the issue is. Test against the slave. Run queries on master. Seems fine to me.
|
|
#
?
Sep 17, 2014 02:09
|
|
|
Could someone explain to me why a select * from table could potentially hose a whole database? Yea it could lock individual rows but once it's returned it's unlocked and occurs extremely quick. What's the actual technical limitation here?
|
|
#
?
Sep 17, 2014 02:28
|
|
|
Tab8715 posted:Could someone explain to me why a select * from table could potentially hose a whole database? Yea it could lock individual rows but once it's returned it's unlocked and occurs extremely quick. Hardware resources. A query like that on a huge multi-million row table could peg the CPU and/or disks for minutes, making it an effective, if inadvertent, denial-of-service attack.
|
|
#
?
Sep 17, 2014 02:30
|
|
|
SamDabbers posted:Hardware resources. A query like that on a huge multi-million row table could peg the CPU and/or disks for minutes, making it an effective, if inadvertent, denial-of-service attack. What's the correct way to return an entire table?
|
|
#
?
Sep 17, 2014 03:13
|
|
|
Tab8715 posted:What's the correct way to return an entire table? What's the purpose of selecting an entire LARGE table? Personally, I put a limit statement at the end of every query, just in case.
|
|
#
?
Sep 17, 2014 03:24
|
|
|
adorai posted:What's the purpose of selecting an entire LARGE table? Personally, I put a limit statement at the end of every query, just in case. This. Limit 1. Determine the data you want and throw a where clause in.
|
|
#
?
Sep 17, 2014 03:27
|
|
|
Misogynist posted:I'm assuming you're American. If this is the case, it doesn't matter who's out sick or on vacation, you will never directly touch a database with patient data in it until you have the word "database" in your job title. The hospital is under extremely strict HIPAA regulations to restrict access to this data and audit that access regularly. It sucks, but there's good reasons for this. You raise some great points. I guess I'll put SQL goals on the back burner for a while and focus my energies on other things.
|
|
#
?
Sep 17, 2014 03:34
|
|
|
Hughmoris posted:You raise some great points. I guess I'll put SQL goals on the back burner for a while and focus my energies on other things. Here ya go mate http://www.mockaroo.com
|
|
#
?
Sep 17, 2014 03:46
|
|
|
Hughmoris posted:You raise some great points. I guess I'll put SQL goals on the back burner for a while and focus my energies on other things. Don't go that far. SQL is great to know. Too many devs rely on sqlalchemy and it's ruby equivalent(active record?). Seriously. Learn SQL. It's amazing and will save you massive amounts of dev time.
|
|
#
?
Sep 17, 2014 03:54
|
|
|
jaegerx posted:Don't go that far. SQL is great to know. Too many devs rely on sqlalchemy and it's ruby equivalent(active record?). Seriously. Learn SQL. It's amazing and will save you massive amounts of dev time. Sequel is the equivalent (AR is nice, but a monster that's hard to use without the rest of rails). LINQ does some really dumb things, but ORMs (broadly) write better queries than devs. Sad but true. Learning SQL to beat the orm is like learning assembly to beat the compiler: sometimes it happens, but most of the time it's better than you unless you're secretly a DBA
|
|
#
?
Sep 17, 2014 04:17
|
|
|
evol262 posted:Sequel is the equivalent (AR is nice, but a monster that's hard to use without the rest of rails). I started in perl and the php with dev work which was my first attempt at SQL. Luckily my company actually had MySQL come in and do training for the MySQL certs so I got to actually learn how to use SQL. Now I prefer my own syntax rather than sqlalchemy because I know what I want and can use SQL to get the data. It's really just what you want to learn. If you've worked in IT for a few years you're going to be needing something out of an SQL database eventually.
|
|
#
?
Sep 17, 2014 04:27
|
|
|
jaegerx posted:I started in perl and the php with dev work which was my first attempt at SQL. Luckily my company actually had MySQL come in and do training for the I'm not disagreeing that SQL is good to know. I'm arguing that the average developer is better off following ORM koans than writing raw queries, since the average developer doesn't know much about how database engines work, what might trigger a table scan, when you should and shouldn't use unions, when (and how) to write complex joins, etc. A lot of developers used to have raw cursors from VB or use mysql_blah in php. But nobody ever said they were good at it. It's good to know how to pull apart a database and write queries or work around the ORM when you need to. But the ORMs these days are at least as good as the average developer.
|
|
#
?
Sep 17, 2014 04:46
|
|
|
Left work early today to tour the systems at the new job. The IT guy showing me around had an incredibly thick accent and I could only get the gist of what he was saying. They run Active Directory from a Microsoft Managed cloud, no servers on-site whatsoever except a VoIP system called Shortel. He told me they need a ticket system and I said I could set up Spiceworks, then he asked me if I can run it off-site and if it would run on Linux. I told him I'm more comfy with Windows but I could figure it out. The other thing that stood out is that they have this important teleconference between four sites around the world, using a cloud software called Bluejeans, I couldn't quite figure out what the guy was saying the problem was, I guess they mute people's lines but the whole system gets overwhelmed with feedback regardless. Nothing set off any red flags except the IT philosophy there was dead-set against hosting anything on-site if it could possibly be avoided. I get that it's nice to always be able to blame someone else for an outage, but I'm sure there's some performance to be gained by managing certain things locally, or at least money to be saved. Humorous that the server room (really just a single Optiplex running VoIP and a bunch of HP switches) had no active air conditioning, IT was like "yeah I'm glad you noticed that, we're working on it".
|
|
#
?
Sep 17, 2014 04:47
|
|
|
SamDabbers posted:Hardware resources. A query like that on a huge multi-million row table could peg the CPU and/or disks for minutes, making it an effective, if inadvertent, denial-of-service attack. The query causing it? SELECT COUNT(*) FROM hugeasstablethatgrewovertime
|
|
#
?
Sep 17, 2014 05:10
|
|
|
We use bluejeans (as of a few months ago). Haven't seen any feedback problems specific to bluejeans unless you dial into bluejeans from intercall. It's probably normal mic feedback, but the plugin updates... often, and using the newest version helps a lot
|
|
#
?
Sep 17, 2014 05:14
|
|
|
Zero VGS posted:Left work early today to tour the systems at the new job. The IT guy showing me around had an incredibly thick accent and I could only get the gist of what he was saying. They run Active Directory from a Microsoft Managed cloud, no servers on-site whatsoever except a VoIP system called Shortel. He told me they need a ticket system and I said I could set up Spiceworks, then he asked me if I can run it off-site and if it would run on Linux. I find it a little hard to believe they have nothing on-site, how are they authenticating to whatever's hosted? I'd be a little surprised if they aren't on a domain, but maybe they aren't. The shoretel server is just managing the phones which is mostly easy if it's already setup. I don't know a know lot about spiceworks other than it's quite popular.
|
|
#
?
Sep 17, 2014 05:23
|
|
|
Tab8715 posted:I find it a little hard to believe they have nothing on-site, how are they authenticating to whatever's hosted? I'd be a little surprised if they aren't on a domain, but maybe they aren't. Switch, router, firewall, shared key, das internet, firewall, router, switch, domain controller be like, "sup"
|
|
#
?
Sep 17, 2014 05:26
|
|
|
Throw up a copy of SSMS on your laptop and load in AdventureWorks. Explain is your BFF. I love the Stanford class. Learning how to write queries, especially with knowing how indexes work, is fantastic. I'm not sure about how your sec dept handles the HIPPA love, but ours would most definitely not allow a local copy of any db. We get put in time out if we have anything that remotely looks like PHI on local. Also, I apologize if this is a bit scatterbrained, I spent my day having words with Aetna data. 
|
|
#
?
Sep 17, 2014 06:28
|
|
|
MC Fruit Stripe posted:Site2site VPN dat beeyotch -> CLOUD They said they aren't even using site to site VPN, each site VPNs to cloud active directory, and none of the sites can even VPN directly to each other.
|
|
#
?
Sep 17, 2014 13:20
|
|
|
Zero VGS posted:Nothing set off any red flags except the IT philosophy there was dead-set against hosting anything on-site if it could possibly be avoided. I get that it's nice to always be able to blame someone else for an outage, but I'm sure there's some performance to be gained by managing certain things locally, or at least money to be saved. Humorous that the server room (really just a single Optiplex running VoIP and a bunch of HP switches) had no active air conditioning, IT was like "yeah I'm glad you noticed that, we're working on it". Do they have a fileserver/dfs local? What is the internet connection like?
|
|
#
?
Sep 17, 2014 18:31
|
|
|
MC Fruit Stripe posted:Site2site VPN dat beeyotch -> CLOUD Ideally, I think this would work however don't you have to have extremely low latency for authentication? < 30ms? LAN -> WAN -> Hardware VPN -> Internet -> Cloud Service
|
|
#
?
Sep 17, 2014 18:43
|
|
|
There's not really a good thread for this question, so it's going here. Anyone at the Perforce conference in San Francisco this week?
|
|
#
?
Sep 17, 2014 19:22
|
|
|
Tab8715 posted:Ideally, I think this would work however don't you have to have extremely low latency for authentication? < 30ms?
|
|
#
?
Sep 17, 2014 19:58
|
|
|
Hello! I am having of great opportunity in Carlisle, PA for a 6 months contract working as an Sr. Network Engineer! Responsibilities: -Man phones on rotating shift basis -Terminate network cables -Resolve tickets in expedient fashion -Serve as first line of support for end users Requirements: -BS in Computer Science or Electrical Engineering (MS preferred) -Cisco Certified CCNP or higher (Cisco Certified CCIE preferred) Compensation: -1099 -16/hr
|
|
#
?
Sep 17, 2014 20:03
|
|
|
psydude posted:Responsibilities: Hmm, seems like a reasonable entry point for some young kid. psydude posted:Requirements: Oh...
|
|
#
?
Sep 17, 2014 20:05
|
|
|
psydude posted:Hello! I am having of great opportunity in Carlisle, PA for a 6 months contract working as an Sr. Network Engineer! And then they wonder why the job goes unfilled for months. I've been getting spammed a bunch recently for a 6 month VM gig in Rhode Island. I forgot who said it here but basically the more remote the job location the crappier the recruiter/job.
|
|
#
?
Sep 17, 2014 20:07
|
|
|
Misogynist posted:It's going to depend on your application, but as a general rule, no. The network is the network. Your clocks need to be synchronized within ~5m or cryptography doesn't work. Ah, so you'd have to have your on-prem environment sync'd to whatever your cloud service timing is set to.
|
|
#
?
Sep 17, 2014 20:08
|
|
|
psydude posted:Requirements: Nice. Is the $1099 a signing bonus or something?
|
|
#
?
Sep 17, 2014 20:08
|
|
|
Tab8715 posted:Ah, so you'd have to have your on-prem environment sync'd to whatever your cloud service timing is set to. If this is an issue, you should be able to ask customer support which world clock they use for NTP. CLAM DOWN posted:Nice. Is the $1099 a signing bonus or something? Hello friend! Thank you very much for reply. 1099 is without doubt best form of compensation for this position, ensuring you get most monies you are having of earned! -Sandeep Kunash
|
|
#
?
Sep 17, 2014 20:15
|
|
|
psydude posted:Hello friend! Thank you very much for reply. 1099 is without doubt best form of compensation for this position, ensuring you get most monies you are having of earned! Oh my god that's just perfect
|
|
#
?
Sep 17, 2014 20:21
|
|
|
Tab8715 posted:Ah, so you'd have to have your on-prem environment sync'd to whatever your cloud service timing is set to.
|
|
#
?
Sep 17, 2014 20:37
|
|
|
What an exciting week. Somehow cost justified installing 100gig cards into our ASR9922's that connect to the service provider's core, even though our module only does 20gig of traffic over our existing 60gig of uplinks. Never got to install or configure them so this will be cool. I went on something resembling an interview this week. I interviewed with them over a year ago before taking my current position, now they want another stab at me for a position that does so much crap that the title of "senior network engineer" doesn't do it justice. Wasn't really an interview though, just talking about the position and what it entails. Some kind of pre-sales/post-sales/architect position in which I will have my own junior engineer doing all the grunt work but I will be customer facing again, plus I'll be working with a broad range of products instead of silo'ing myself to R&S which is what I mainly have been doing here. Sounds fun but I will have to go back to commuting to mid-town every day instead of my 5 minute commute one town over. At least I will have time to study for the CCIE, something I have a hard time doing unless I'm forced to (eg: Train commute) Benefits and career growth are much better too, gonna have to take it for the growth aspect alone. 
|
|
#
?
Sep 17, 2014 21:05
|
|
|
So we're looking at downgrading our helpdesk software because our current setup is more expensive and more overkill than we really require. We have some vendors showing us there poo poo, and I was going to suggest throwing Spiceworks into the mix and compare them all. I'm under the impression that for basic helpdesk software, they're pretty well regarded. Is that the case?
|
|
#
?
Sep 17, 2014 21:12
|
|
|
Misogynist posted:which is usually "the time it is" I thought it had to be literally exact, the slightest amount of clock drift will potentially break everything. Or is there a little leeway?
|
|
#
?
Sep 17, 2014 21:15
|
|
|
|
| # ? Apr 25, 2024 04:53 |
|
|
Tab8715 posted:I thought it had to be literally exact, the slightest amount of clock drift will potentially break everything. Or is there a little leeway? Depends on the service. Active Directory and the underlying Kerberos require the times be within 5 minutes of each other or poo poo starts breaking. 5 minutes is a ton of leeway in the year 2014.
|
|
#
?
Sep 17, 2014 21:22
|
|