August 30, 2018 at 1:46 pm
ZZartin - Thursday, August 30, 2018 9:01 AMThought I posted that on this board not editorials, anyways please move it. As for the subject matter in light of things like GDPR and breaches etc, I was interested in what others may or may not have done when presented with situations where they were technically doing something legal but might have rubbed them the wrong way. If that makes you uncomfortable why?
Please, tell us about the time you did something you should not have in a forum that is public and will never truly go away, so that all future employers could see it? Gee, I don't know why that would make anyone uncomfortable.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
August 30, 2018 at 3:28 pm
This is one of the weirdest required skills I've seen in a job posting. They almost mentioned that each employee would need a crystal ball.
- You enjoy the seesaw between slick technical solutions and understanding what a client really wants. The client may tell you to paint the sky blue but you are astute enough in your questioning that you know the client really meant that the sky should look like a sunset.
August 30, 2018 at 5:43 pm
Luis Cazares - Thursday, August 30, 2018 3:28 PMThis is one of the weirdest required skills I've seen in a job posting. They almost mentioned that each employee would need a crystal ball.
- You enjoy the seesaw between slick technical solutions and understanding what a client really wants. The client may tell you to paint the sky blue but you are astute enough in your questioning that you know the client really meant that the sky should look like a sunset.
Heh... at least it sounds honest and, with a no BS description like that, sounds like it might be an interesting place to work!
I got a long term job by answering a similar weird job posting. It was just one sentence long.
"Basically, we're looking for someone that can look at T-SQL, figure out what's wrong, and fix it".
I was the only one that responded to the ad. Apparently, everyone else thought it was a joke. It turned out to be one of the best jobs I ever had with good people, interesting work, and decent pay. I landed the interview by walking in to the recruiters office on the day I saw it (a Wednesday) with the tiny snippet of paper I'd cut from the newspaper and said "I think I'm the guy you're looking for". After 1 interview, I was hired to start the following Monday.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 30, 2018 at 10:47 pm
Thom A - Thursday, August 30, 2018 5:19 AMI know they are there for a reason, however, there are some days that I really hate the restrictiveness of the group policy permissions that are applied to every domain account at work...I've been tasked with updating the data source of every report in a repository on SSRS, as it's moving. Powershell is a great way of doing this, so off I went to install the ReportingServicesTools Module. Firewall blocked the download (anything the firewall is unable to read (i.e. anything that isn't a pdf, excel or word document, it basically blocks)... Finally got that signed off, and now I can't actually add the module because running scripts are disabled across the domain. >_<
Looks like I need to get a minion to manual go into every report in that repository (all 300 odd of them), and manually update them all. Now, to just need to find a "willing" minion. :Whistling:
Are you sure they're blocked by group policy? The default behaviour of PowerShell is to prohibit scripts from running and it needs to be manually enabled with Set-ExecutionPolicy
August 31, 2018 at 1:48 am
andycadley - Thursday, August 30, 2018 10:47 PMAre you sure they're blocked by group policy? The default behaviour of PowerShell is to prohibit scripts from running and it needs to be manually enabled with Set-ExecutionPolicy
Thanks Andy. I honestly thought I'd changed the settings when I got the new PC, clearly i had not. When I spoke to the Network team that did say it was intentional. Clearly I had forgotten to change the policy. This makes my day a lot easier, really appreciate it!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 31, 2018 at 3:56 am
Luis Cazares - Wednesday, August 29, 2018 4:42 PMSo today I got bad news and will have to start job hunting again. :pinch:
I'll appreciate if anybody knows about any open positions.
Sorry to hear that. Where are you located? What do you want to do?
August 31, 2018 at 5:04 am
andycadley - Thursday, August 30, 2018 10:47 PMAre you sure they're blocked by group policy? The default behaviour of PowerShell is to prohibit scripts from running and it needs to be manually enabled with Set-ExecutionPolicy
Thanks again Andy, you have no idea how many hours you have saved me!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 31, 2018 at 11:33 am
Steve Jones - SSC Editor - Friday, August 31, 2018 3:56 AMSorry to hear that. Where are you located? What do you want to do?
I'm currently in Atlanta, willing to relocate if necessary but trying to avoid it as we just renewed our lease. I'm searching for SQL Server Development jobs ranging from development DBA (query writing, tuning and reviewing) to BI/ETL development (SSIS, SSRS and some SSAS). I could be open to something else if the company trusts me to learn it.
August 31, 2018 at 12:29 pm
Thom A - Friday, August 31, 2018 1:48 AMandycadley - Thursday, August 30, 2018 10:47 PMAre you sure they're blocked by group policy? The default behaviour of PowerShell is to prohibit scripts from running and it needs to be manually enabled with Set-ExecutionPolicy
Thanks Andy. I honestly thought I'd changed the settings when I got the new PC, clearly i had not. When I spoke to the Network team that did say it was intentional. Clearly I had forgotten to change the policy. This makes my day a lot easier, really appreciate it!
Is it blocked even when you run with the multiple options to bypass the script security - I find it very hard that executing any powershell script is blocked regardless of what command line is used.
B?y default all executions on the projects I work on we use "powershell -ExecutionPolicy Bypass ...."
and plenty of options for it without changing the GPO policies.
https://blog.netspi.com/15-ways-to-bypass-the-powershell-execution-policy/
August 31, 2018 at 12:53 pm
frederico_fonseca - Friday, August 31, 2018 12:29 PMIs it blocked even when you run with the multiple options to bypass the script security - I find it very hard that executing any powershell script is blocked regardless of what command line is used.B?y default all executions on the projects I work on we use "powershell -ExecutionPolicy Bypass ...."
and plenty of options for it without changing the GPO policies.https://blog.netspi.com/15-ways-to-bypass-the-powershell-execution-policy/
I think I read somewhere that it's blocked by default so someone with sys admin doesn't accidentally run something they shouldn't have, but yes it seems silly because there are a ton of easy ways to get around it.
August 31, 2018 at 1:03 pm
The theory was that the average user doesn't need to run scripts, so Windows just shouldn't do it. And anyone running scripts (or in an environment where someone in control has assessed the risk) will be able to enable the functionality.
Good to hear it has avoided descending into a horribly manual task!
August 31, 2018 at 2:48 pm
Why do people have such trouble understanding the relationship between sample data and expected results. The expected results should have more than a tenuous relationship to the sample data. Let me just pull some figures out of thin air.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
September 4, 2018 at 7:47 am
drew.allen - Friday, August 31, 2018 2:48 PMWhy do people have such trouble understanding the relationship between sample data and expected results. The expected results should have more than a tenuous relationship to the sample data. Let me just pull some figures out of thin air.Drew
Because people are becoming more and more entitled and lazy at a shockingly fast rate. The universities keep handing out degrees in technical fields to people who are woefully inadequate. I find this to be a two factor problem. First is the general "gimme gimme" mentality that society is moving towards with alarming speed. The second is that the professors are the ones who couldn't make it in the field. Sure there are exceptions with the rare person who just really enjoys teaching but most developer types would prefer the salary that comes with the job. Those who can't make it end up taking a professorship and do awesome things like teach people to use cursors for updates and all sorts of terrible things.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 4, 2018 at 8:13 am
Sean Lange - Tuesday, September 4, 2018 7:47 AMBecause people are becoming more and more entitled and lazy at a shockingly fast rate. The universities keep handing out degrees in technical fields to people who are woefully inadequate. I find this to be a two factor problem. First is the general "gimme gimme" mentality that society is moving towards with alarming speed. The second is that the professors are the ones who couldn't make it in the field. Sure there are exceptions with the rare person who just really enjoys teaching but most developer types would prefer the salary that comes with the job. Those who can't make it end up taking a professorship and do awesome things like teach people to use cursors for updates and all sorts of terrible things.
I'll just say that my online degree included some SQL classes, which were woefully inadequate. If we'd gotten to the level of cursors I'd have been much happier with them. As it was, I just wanted to check them off the list, so didn't complain. So, no, I don't think the teachers are instructing people on how to use cursors, they learn those bad habits from google.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
September 4, 2018 at 8:27 am
jonathan.crawford - Tuesday, September 4, 2018 8:13 AMI'll just say that my online degree included some SQL classes, which were woefully inadequate. If we'd gotten to the level of cursors I'd have been much happier with them. As it was, I just wanted to check them off the list, so didn't complain. So, no, I don't think the teachers are instructing people on how to use cursors, they learn those bad habits from google.
You should be glad they didn't teach cursors. They are truly a terrible thing to teach new people in the database universe. I would disagree and say they are learning this from their teachers. So many posts from people who say things like they have to use a cursor because that is what the assignment states.
You did however touch on an element I kind of forgot which is that databases are an afterthought in many degree programs that are pumping out developers. That is often justified with the notion that most places have a DBA to handle the database stuff. But the reality is that so many shops do not have a dedicated and trained DBA. Most of the time they are born as an accidental DBA with inadequate knowledge. By no means am I slamming the individuals here (even the teachers), it is the whole system that is broken.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 62,086 through 62,100 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply