February 29, 2016 at 12:14 pm
Luis Cazares (2/29/2016)
The problem as I understand is that these "car salesmen" assure you that the car has only 10,000 miles and when you make the trip to see the car you can easily check the odometer showing 750,000. It's just a waste of everybody's time as there won't be a sale.
Perhaps, but as someone that's owned, purchased, and sold a couple dozen cars in my life, I would say rarely are things this blatant. Instead there is subtle alterations of things.
"This car hasn't been in an accident", when having no idea. I cease asking these questions, because no one really knows and they can always claim this is what they were told.
"That happens rarely, but you can fix it like this." Saw this with a vacuum leak. Worked for a few months, then realized there were substantial other issues.
There are more examples, some minor, some major. The point is people selling something often shade the truth, sometimes outright lie, sometimes don't.
February 29, 2016 at 12:49 pm
It's always fun to find ways to use SQL features you never thought about before...
/best Keaneu Reeves as Neo voice
I know OVER (PARTITION BY now...
😀
We're keeping the option of moving to SQL managed backups to disk in our back pocket for after we migrate to SQL 2014, if we continue to have hassles with the backups our server guys are *supposed* to be providing. Of course, if we go that route, I'll probably also agitate for using something like SQL Backup Pro as well, so the bosses can get pretty reports...
February 29, 2016 at 2:27 pm
Luis Cazares (2/29/2016)
Steve Jones - SSC Editor (2/29/2016)
Alan.B (2/29/2016)
It's not a bad thing for a recruiter to work with the candidate to modify the resume for a position provided everyone is being honest. It's awful when they do it without you knowing and you show up to an interview.
My IT career started in the networking world (e.g hubs, switches, routers). I was a novice eager to learn and presented myself as such. A recruiter changed my resume to look like a Cisco super stud. In the interview I was actually answering questions by saying. "I don't even know what that is let alone how to do what you described..." I was himiliated, almost in tears and then visably furious when they showed me what was supposed to by my resume. I had a copy with me, showed to them my real resume and asked if it would be okay to end the interview. We had a few laughs about it. They were super cool and offered to take me lunch. Neither of us ever used that firm again.
I was going to note this hasn't been an issue for me, but then the more I thought about it, the more I had no idea if it was. My resume/experience has been strong, and I've gotten lots of responses, but I've never looked to see if what the company had for my resume was what I sent.
I have met with a number of recruiters and talked about what I want and what I'll do. I will need to be sure I keep a copy with me and check on the next interview.
Or just hope I'm forever wondering if this is the case 😛
I do think most recruiters are decent. However, they're essentially car salesman. And we're the cars. The fewer they place, the more they have to gain from a placement, the more they might alter the truth and hope it goes through.
As a manager, I've usually let recruiters know that I will ask about the resume, so I doubt I've gotten any that were too altered, as this forms the basis for things I'll use to start questioning people.
The problem as I understand is that these "car salesmen" assure you that the car has only 10,000 miles and when you make the trip to see the car you can easily check the odometer showing 750,000. It's just a waste of everybody's time as there won't be a sale.
Maybe recruitment agents are more honest in the USA than in the UK. I regard used car salesmen as far more honest and truthful than recruitment agents. Maybe they've got worse over the years - decdes ago when I used tahem for job serch they were fairly awful; recently when I used them for candidate search they seemed even worse; or maybe they were always even worse from the employer's point of view than from the job seekers point of view.
In something over 40 years in computing I've only 3 times had an interview through applying through an agent, and only once has that been anything other than a pure waste of my time (and the potential employer's) because the only once had the agent neither lied about my experience and/or my skills and/or my attitudes nor lied to me about what the employer wanted or what sort of company it was. The odd one time didn't work out (the company had asked for the wrong sort of person for what they wanted to do - not the agent's fault - the moon must have been blue that day).
Tom
March 1, 2016 at 5:39 am
^ I think that there are good and bad recruiters/headhunters, although in my experiences I have run into more on the bad side than good. I have not experienced a recruiter who has modified my resume other than cosmetic changes to make it comply with their "look".
My gripe is I updated my LinkedIn account which brought on a flurry of headhunter calls and emails - some for positions for which I have no experience (DB2 DBA, Unix Admin, etc.).
March 1, 2016 at 5:59 am
As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.
March 1, 2016 at 6:12 am
Brandie Tarvin (3/1/2016)
As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.
It's good. Your delivery is solid. The pace is good too. I'm not sure I like the step forward to pick up the props, but I like the use of props instead of slides (maybe have someone hand them to you).
As video though, the shot is far too wide. Also, I recognize it's meant to simulate a classroom. You need to choose to either stick to that simulation, and never look at the camera, or toss the simulation and then primarily address the camera.
One opinion.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 1, 2016 at 7:51 am
Brandie Tarvin (3/1/2016)
As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.
I like it.
I concur with Grant that getting the props was distracting. Can they be on a podium closer to you where you can just lift it up?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
March 1, 2016 at 9:27 am
Good job, Brandi. Agree with the comments above, but it was solid.
I'd like to see a touch more passion, though. That topic needs it.
March 1, 2016 at 11:46 am
Brandie Tarvin (3/1/2016)
As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you mind.
Well done, solid.
My 2 cents: Better lighting would be helpful - the current lighting is too dreary. I got depressed while watching. Lose the 7.25 on the white board, it's distracting. Smile more. Some kind of visual aid would be helpful; I don't love PowerPoint but I like what it accomplishes - it guides the viewer through the presentation. Some kind of chart/graph perhaps. 😉
-- Itzik Ben-Gan 2001
March 1, 2016 at 6:09 pm
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...
Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
March 1, 2016 at 7:52 pm
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation) returns 11! :hehe::hehe::hehe::hehe::hehe:
-- Itzik Ben-Gan 2001
March 1, 2016 at 8:35 pm
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation)returns 11! :hehe::hehe::hehe::hehe::hehe:
So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
March 1, 2016 at 8:56 pm
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation)returns 11! :hehe::hehe::hehe::hehe::hehe:So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination
-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
-- Itzik Ben-Gan 2001
March 2, 2016 at 3:13 am
Alan.B (3/1/2016)
Ed Wagner (3/1/2016)
Alan.B (3/1/2016)
jasona.work (3/1/2016)
Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...Hmm, using DD makes it seem so far away, lets try WEEK...
That's a little better...
How about MM?
There we go! Now it doesn't seem so far off!
🙂
SELECT DATEDIFF(DAY,getdate(),@MyVacation)returns 11! :hehe::hehe::hehe::hehe::hehe:So what does this return?
SELECT Destination, DATEDIFF(day, @MyVacationStart, @MyVacationEnd);
Destination-------------------------------- -----------
Caribbean Cruise with the family 8
(1 row(s) affected)
Now if I can get DBCC TimeTravel(days) to work 😛
Very cool. Have a great time and enjoy the warm weather and family time.
March 2, 2016 at 5:05 am
Glad to see I am not the only one who does something like that:
-- Convert Date difference into seconds
DECLARE @DiffSecs INT = DATEDIFF(SECOND, GETDATE(), '4/15/2016 16:00');
-- Total seconds in a day = 86400
SELECT
@DiffSecs/86400 AS [Days]
, (@DiffSecs%86400)/3600 AS [Hours]
,((@DiffSecs%86400)%3600)/60 AS [Minutes]
GO
Note I use the last Friday before. 🙂
Viewing 15 posts - 52,966 through 52,980 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply