November 4, 2015 at 12:25 pm
Brandie Tarvin (11/4/2015)
Michael L John (11/4/2015)
Was it this link?http://www.sqlservercentral.com/Forums/Topic527155-359-1.aspx#bm1733766
Nope. It's this one: http://www.sqlservercentral.com/Forums/Topic1733767-1526-1.aspx
I'll give it a try.
November 4, 2015 at 12:51 pm
Jeff Moden (11/4/2015)
Steve Jones - SSC Editor (11/4/2015)
GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?Wrong country.
and wrong state
Oh my. Now THAT would be fun having you in the area.
Ditto. Why don't you come down here? A bit better weather and good economy 😉
November 4, 2015 at 1:55 pm
Steve Jones - SSC Editor (11/4/2015)
Jeff Moden (11/4/2015)
Steve Jones - SSC Editor (11/4/2015)
GilaMonster (11/3/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?Wrong country.
and wrong state
Oh my. Now THAT would be fun having you in the area.
Ditto. Why don't you come down here? A bit better weather and good economy 😉
I'd cast my vote in favor of you moving to Michigan. I'll even volunteer to buy the first lunch. 😉
November 4, 2015 at 2:03 pm
Brandie Tarvin (11/4/2015)
djj (11/4/2015)
I also interview really badly.Bridge Guardian: What is your name?
DJJ: Umm. I don't know?
DJJ: AGGGGHHHHH!
Bridge Guardian: Sigh. Usually they get to the swallow question before they go flying off into the gully.
😎
November 4, 2015 at 2:43 pm
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
If taking wouldn't lead to my wife putting out a contract on me (:w00t: exaggeration) I might be interested. 😉 I promised to be with her at least 8 months per year instead of just when the job allowed 6 years ago (when I hit 65).
But I doubt they'd be interested in me - I know zilch about SOX in particular or American law in general and anyway the only reason I'd be interested in the job would be that it would make me learn new SQL Server technical stuff (because I can't cover the whole 11 bullet point list) and they seem to want someone who already knows it all and could hit the ground running on every front; and on top of that my experience with modern versions of SQL Server is limited to some evaluation with SQL 2008 (when looking to upgrade NEOS from SQL 2000 to SQL 2008) and playing with my new toys (SQL 2008 R2, SQL 2012, SQL 2014) on my toy machines since I retired (and odd bits of advice and guidance to friends who asked for it).
Tom
November 4, 2015 at 4:35 pm
Ed Wagner (11/4/2015)
Brandie Tarvin (11/4/2015)
djj (11/4/2015)
I also interview really badly.Bridge Guardian: What is your name?
DJJ: Umm. I don't know?
DJJ: AGGGGHHHHH!
Bridge Guardian: Sigh. Usually they get to the swallow question before they go flying off into the gully.
I know that quote very well. There are a few of us here at work who quote the movie from time to time.
The color is subjective, but the swallow question is a matter of weight ratios. 😉
Blue no aaaaaaaaaaaaaaa
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 4, 2015 at 11:00 pm
Jeff Moden (11/4/2015)
Brandie Tarvin (11/4/2015)
Jeff Moden (11/3/2015)
Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they don't know what they don't know. I'm not asking difficult questions so far because none have gotten that far, yet.I am curious. How many people have you interviewed who (though unqualified for this specific posting) know more than they realize they know?
Actually and as impossible as it seems, there have been two and they're both wicked sharp. One was one of those self-trained Ninja's that never thought of herself as a "DBA" and yet she knew more about SQL Server and T-SQL than the last 8 candidates combined. It was a real pleasure to interview her. I also had the pleasure of interviewing Geoff Albin.
I'm also curious! What is it about the candidates that is really turning you off? I mean, are you generally looking for people with high capacity of knowledge on the phone or in person? No one trainable or anything like that? I heard you talk about this before when mentioning candidates failing to answer questions about date functions or something along those lines.
I ask because I generally fail at a lot of capacity questions like that too when on the spot. There is a wealth of information out there on every piece of technology. In most interviews, a lot of the common stuff gets asked and sometimes forgotten by the candidate because they are generally so simple and easy to reference it slips beneath the cracks like knowing every formatting code to a function or something like that versus how to restore to a point in time.
One being critical to the job to know where the other is not critical. 😀
November 5, 2015 at 1:38 am
Jeff Moden (11/4/2015)
anthony.green (11/4/2015)
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?Remote working an option?
Unfortunately, probably not for this one, Anthony. I will ask, though. Where do you call "home"?
The good old UK, probably be a bit of a stretch.
November 5, 2015 at 2:30 am
Woolly nebulous request of the month alert.
I've been asked to look into ad-hoc reporting solutions so users can create their own reports.
All I know is it's a SQL Server back end.
I don't know:
- The level of the users skills; is it a BI person or anybody from the cleaner upwards.
- What level of reporting i.e. whether it's operational 'did this happen', whether it's month by month figures or both.
- How ad-hoc it will be; is there going to be data there to be queried or is the user (see above) going to have to bring it in themselves.
The client is also in Australia and isn't to know that I'm looking into this.
Any suggestions?
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
November 5, 2015 at 6:02 am
BWFC (11/5/2015)
Woolly nebulous request of the month alert.I've been asked to look into ad-hoc reporting solutions so users can create their own reports.
All I know is it's a SQL Server back end.
I don't know:
- The level of the users skills; is it a BI person or anybody from the cleaner upwards.
- What level of reporting i.e. whether it's operational 'did this happen', whether it's month by month figures or both.
- How ad-hoc it will be; is there going to be data there to be queried or is the user (see above) going to have to bring it in themselves.
The client is also in Australia and isn't to know that I'm looking into this.
Any suggestions?
At risk of being lynched: Crystal Reports is probably the easiest ad-hoc reporting tool a user with no experience can learn to use.
November 5, 2015 at 6:14 am
Brandie Tarvin (11/5/2015)
At risk of being lynched:
Na, however the tar is heating up well. 😀
I actually like the suggestion.
November 5, 2015 at 6:18 am
Brandie Tarvin (11/5/2015)
BWFC (11/5/2015)
Woolly nebulous request of the month alert.I've been asked to look into ad-hoc reporting solutions so users can create their own reports.
All I know is it's a SQL Server back end.
I don't know:
- The level of the users skills; is it a BI person or anybody from the cleaner upwards.
- What level of reporting i.e. whether it's operational 'did this happen', whether it's month by month figures or both.
- How ad-hoc it will be; is there going to be data there to be queried or is the user (see above) going to have to bring it in themselves.
The client is also in Australia and isn't to know that I'm looking into this.
Any suggestions?
At risk of being lynched: Crystal Reports is probably the easiest ad-hoc reporting tool a user with no experience can learn to use.
Seconded. Not necessarily the safest, I've seen an instance restarted by poorly designed Crystal reports - but probably the easiest.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 5, 2015 at 6:28 am
Brandie Tarvin (11/5/2015)
At risk of being lynched: Crystal Reports is probably the easiest ad-hoc reporting tool a user with no experience can learn to use.
Well I agree with you on this one. By far one of the easiest reporting tools I've come across. The only problem I've seen is when users were given full access to the DB's and decided to pull back entire tables down to the client and wonder why it's so slow.
ChrisM@Work (11/5/2015)
Seconded. Not necessarily the safest, I've seen an instance restarted by poorly designed Crystal reports - but probably the easiest.
Wow, that's crazy...never came across that glitch before. Was it tied to a specific version of Crystal?
November 5, 2015 at 6:33 am
yb751 (11/5/2015)
Brandie Tarvin (11/5/2015)
At risk of being lynched: Crystal Reports is probably the easiest ad-hoc reporting tool a user with no experience can learn to use.Well I agree with you on this one. By far one of the easiest reporting tools I've come across. The only problem I've seen is when users were given full access to the DB's and decided to pull back entire tables down to the client and wonder why it's so slow.
ChrisM@Work (11/5/2015)
Seconded. Not necessarily the safest, I've seen an instance restarted by poorly designed Crystal reports - but probably the easiest.Wow, that's crazy...never came across that glitch before. Was it tied to a specific version of Crystal?
That was Crystal 11 point something about 7 years ago, using Crystal's query designer and applying parameters after grabbing a few tens of millions of rows from the server. As to the cause of the restart, nothing obvious stood out at the time.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 5, 2015 at 6:56 am
Thanks everybody.
That-Which-Shall-Not-Be-Named has already been mentioned as a possibility so I'm in the process of installing it so I can have a play. It's not something I've used before but the company previously used it for all its reporting.
It has been suggested (by me admittedly) that it will be useful to make a trip to Australia to find out the exact abilities and requirements of the team over there. I'm still waiting to hear back on that....
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 15 posts - 51,226 through 51,240 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply