July 19, 2017 at 3:21 pm
WayneS - Wednesday, July 19, 2017 12:10 PMEd Wagner - Tuesday, July 18, 2017 1:30 PMBrandie, kudos for asking the question. Three of 15 is 20%, which, given Jeff's observations, isn't horrible. I know that sets the bar pretty low, but asking such a simple question can really save you time. It says a lot about the person claiming to have 10 years of experience. Or is that an aggregate that really means "1 month of experience 120 consecutive times" or something similar? 😉It's more like 1 day x 3650 consecutive times...
What, only 1 non-working day in each year (2 in a leap year)?
Tom
July 19, 2017 at 3:32 pm
Jason A. Long - Wednesday, July 19, 2017 7:45 AMBrandie Tarvin - Wednesday, July 19, 2017 4:39 AMJason A. Long - Tuesday, July 18, 2017 1:56 PMI'm in Jacksonville so I'm not an out of state call. I just know I have a backlog of recruiter messages on LinkedIn that I haven't had a chance to respond to. I don't actually have clue what positions they're looking to fill just yet.Operational DBA. Day to day production & dev support. Basically making sure everything is working in the morning, then supporting the Devs and the users when they think they find an error in the system. Security, backups, jobs, need to know T-SQL. You know. Basic DBA stuff.
So tell me, Jason. How do you get the current date and time from SQL Server? @=)
LOL... Either GETDATE() or CORRENT_TIMESTAMP. If I need MS granularity or better, then I use SYSDATETIME().
We don't use UTC but if we did, then GETUTCDATE() or SYSUTCDATETIME().
Unfortunately, I'm a far better SQL Dev than I am DBA, That said, a good SQL Dev opportunity that comes with some tutelage from a top shelf DBA would be tough to ignore. 😉
Wait, there are functions to get the current date and time? I was certain everyone just used this:
SELECT start_time
FROM sys.dm_exec_requests
WHERE session_id=@@SPID;
:hehe:
July 19, 2017 at 3:39 pm
Brandie Tarvin - Friday, July 7, 2017 9:03 AMIf the answer is '42', what is the question?
Putting 42 in quotes spoils option 1 below, Brandy, because it adds 2 extra characters; but the question to which 42 is the answer could be any of:
1) How many characters are there in the question "If the answer is 42, what is the question?"?
2) What do you get when you multiply six by nine? in The Restaurant at the End of the Universe (Douglas Adams)
3) how many carefully packed boxes does the Baker have in fit the first of The Hunting of the Snark (Lewis Carroll)
4) what is the rule number of "No one shall speak to the Man at the Helm" (preface to the above) (Lewis Carroll)
5,6,7,8) various questions "Alice's Adventures in Wonderland" and "Through the Looking Glass" (Lewis Carroll)
9) how many US gallons in a barrel of oil?
and so on and on and on. Peter Gill's "42: Douglas Adams' Amazingly Accurate Answer to Life, the Universe and Everything" probably contains a lot of them but I think it's currently out of print, haven't been able to find a copy at a reasonable price - Amazon has second hand copies starting at about $65 + delivery and going up to about $700 for a copy not in good condition. (Of course Amazon having only 2nd hand copies at ridiculous prices doesn't always mean the book is out of print , a week ago I bought a mint copy of another book from the publisher's website while Amazon was showing only second hand copies at rip-off prices many times the cost of the book from the pulisher; but for this book on 42 the publisher went bust in November 2011).
Tom
July 20, 2017 at 1:37 am
Steve Jones - SSC Editor - Wednesday, July 19, 2017 9:57 AMThom A - Wednesday, July 19, 2017 7:02 AMAnyone having problems creating topics? I'm trying to post one and it just sits there for a few minutes, then I get an unknown error. Tried a few times.While it hangs, I also can't use SSC on the PC, no pages on the forums load. I'm having to use the mobile at the moment.
Edit: This seems to be irrelevant of content of the topic, or the sub forum I choose. So, I can't actually make a topic about the problem either! The humanity! :angry:
Apologies, a hard coded config item bit the developers.
Thanks Steve. 🙂
Got the dev environment link too, which amused me. Reminded me of the time someone when to correct someone's surname in the database from Lepane to Lepine. Instead they changed EVERYONE's surname in the database to Lapine. The staff were incredibly amused that everyone had suddenly become related to each other 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 20, 2017 at 7:42 am
TomThomson - Wednesday, July 19, 2017 3:21 PMWayneS - Wednesday, July 19, 2017 12:10 PMEd Wagner - Tuesday, July 18, 2017 1:30 PMBrandie, kudos for asking the question. Three of 15 is 20%, which, given Jeff's observations, isn't horrible. I know that sets the bar pretty low, but asking such a simple question can really save you time. It says a lot about the person claiming to have 10 years of experience. Or is that an aggregate that really means "1 month of experience 120 consecutive times" or something similar? 😉It's more like 1 day x 3650 consecutive times...
What, only 1 non-working day in each year (2 in a leap year)?
Heh... actually, YES! I'm the only DBA in the company I work for and it seems that way.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2017 at 7:50 am
Ed Wagner - Wednesday, July 19, 2017 1:53 PMJeff Moden - Wednesday, July 19, 2017 1:24 PMGrant Fritchey - Wednesday, July 19, 2017 12:31 PMBrandie Tarvin - Wednesday, July 19, 2017 12:27 PMPhil Parkin - Wednesday, July 19, 2017 8:49 AMIs this cheating?
EXEC sys.xp_cmdshell 'date /t';
EXEC sys.xp_cmdshell 'time /t';Nope. It's inventive.
It's old-fashioned. Make a PowerShell called to Get-Date. That's the correct answer. What do I win?
A free one way trip to the Tower of Babel. 😉
Jeff, you realize that Grant probably posted that comment just for you...right? He might be on the floor laughing right now. 😀:hehe:
Heh... that's why I posted what I did. I felt the sighting-laser on my forehead. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2017 at 7:56 am
Jeff Moden - Thursday, July 20, 2017 7:50 AMEd Wagner - Wednesday, July 19, 2017 1:53 PMJeff, you realize that Grant probably posted that comment just for you...right? He might be on the floor laughing right now. 😀:hehe:Heh... that's why I posted what I did. I felt the sighting-laser on my forehead. 😉
I'm here to entertain.
"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
July 20, 2017 at 7:59 am
Grant Fritchey - Thursday, July 20, 2017 7:56 AMJeff Moden - Thursday, July 20, 2017 7:50 AMEd Wagner - Wednesday, July 19, 2017 1:53 PMJeff, you realize that Grant probably posted that comment just for you...right? He might be on the floor laughing right now. 😀:hehe:Heh... that's why I posted what I did. I felt the sighting-laser on my forehead. 😉
I'm here to entertain.
You're pretty good with sighting-lasers, as well. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2017 at 8:27 am
TomThomson - Wednesday, July 19, 2017 3:39 PMBrandie Tarvin - Friday, July 7, 2017 9:03 AMIf the answer is '42', what is the question?Putting 42 in quotes spoils option 1 below, Brandy, because it adds 2 extra characters; but the question to which 42 is the answer could be any of:
1) How many characters are there in the question "If the answer is 42, what is the question?"?
2) What do you get when you multiply six by nine? in The Restaurant at the End of the Universe (Douglas Adams)
3) how many carefully packed boxes does the Baker have in fit the first of The Hunting of the Snark (Lewis Carroll)
4) what is the rule number of "No one shall speak to the Man at the Helm" (preface to the above) (Lewis Carroll)
5,6,7,8) various questions "Alice's Adventures in Wonderland" and "Through the Looking Glass" (Lewis Carroll)
9) how many US gallons in a barrel of oil?
and so on and on and on. Peter Gill's "42: Douglas Adams' Amazingly Accurate Answer to Life, the Universe and Everything" probably contains a lot of them but I think it's currently out of print, haven't been able to find a copy at a reasonable price - Amazon has second hand copies starting at about $65 + delivery and going up to about $700 for a copy not in good condition. (Of course Amazon having only 2nd hand copies at ridiculous prices doesn't always mean the book is out of print , a week ago I bought a mint copy of another book from the publisher's website while Amazon was showing only second hand copies at rip-off prices many times the cost of the book from the pulisher; but for this book on 42 the publisher went bust in November 2011).
Does 6.480740698407860230965967436088 ring a bell?
😎
July 20, 2017 at 8:36 am
TomThomson - Wednesday, July 19, 2017 3:13 PMPhil Parkin - Wednesday, July 19, 2017 8:49 AMIs this cheating?
EXEC sys.xp_cmdshell 'date /t';
EXEC sys.xp_cmdshell 'time /t';What happens if command extensions are off? I imagine it would be some error pointing out that "EXEC sys.xp_cmdshell 'time /t';" isn't a valid time, so it wouldn't return get the current time, but I haven't tested it..
Heh... that's the importance of follow-up questions after someone thinks they've answered the question. 😉 I don't settle for a single word answer on the date/time question (or any question, for that matter) that I ask. It would be nice to have someone like that candidate that Brandie was talking about that amplified some little bit of amplification to the answer but, if they don't, then I ask for the amplification.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2017 at 8:39 am
Lynn Pettis - Wednesday, July 19, 2017 1:33 PMJeff Moden - Wednesday, July 19, 2017 1:27 PMPhil Parkin - Wednesday, July 19, 2017 1:01 PMBrandie Tarvin - Wednesday, July 19, 2017 12:27 PMPhil Parkin - Wednesday, July 19, 2017 8:49 AMIs this cheating?
EXEC sys.xp_cmdshell 'date /t';
EXEC sys.xp_cmdshell 'time /t';Nope. It's inventive.
But what would you say in an interview if I told you xp_cmdshell had been blocked / disabled?
At that point, I would come clean and state that if it's safe enough for world-renowned DBA Jeff Moden, it's safe enough for me 🙂 And therefore that I'd like to further understand the reasons for blocking it.
That would be when I break out my hour long presentation on why enabling using xp_CmdShell could be considered a worst practice. 😉
And yet you advocate for its use, albeit when properly configured and used in a controlled manner.
😀
Dammit.. I fat fingered that. I left out the word "NOT" . I meant to write...
That would be when I break out my hour long presentation on why NOT enabling using xp_CmdShell could be considered a worst practice. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2017 at 8:41 am
Eirikur Eiriksson - Thursday, July 20, 2017 8:27 AMDoes 6.480740698407860230965967436088 ring a bell?
😎
42^0.5, too easy.
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
July 20, 2017 at 8:42 am
Ed Wagner - Wednesday, July 19, 2017 1:51 PMLynn Pettis - Wednesday, July 19, 2017 1:33 PMJeff Moden - Wednesday, July 19, 2017 1:27 PMPhil Parkin - Wednesday, July 19, 2017 1:01 PMBrandie Tarvin - Wednesday, July 19, 2017 12:27 PMPhil Parkin - Wednesday, July 19, 2017 8:49 AMIs this cheating?
EXEC sys.xp_cmdshell 'date /t';
EXEC sys.xp_cmdshell 'time /t';Nope. It's inventive.
But what would you say in an interview if I told you xp_cmdshell had been blocked / disabled?
At that point, I would come clean and state that if it's safe enough for world-renowned DBA Jeff Moden, it's safe enough for me 🙂 And therefore that I'd like to further understand the reasons for blocking it.
That would be when I break out my hour long presentation on why enabling using xp_CmdShell could be considered a worst practice. 😉
And yet you advocate for its use, albeit when properly configured and used in a controlled manner.
😀I think Jeff probably meant to say that disabling it could be considered a worst practice. I've seen the presentation and it's a very logical progression that goes at it from many angles.
Yeah... I left out the word NOT during an edit. Thanks for the catch from both of you. I'm going back to that original post to fix it so that no one get's the wrong idea if that's the only post they read.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 20, 2017 at 8:55 am
Brandie Tarvin - Wednesday, July 19, 2017 12:32 PMEd Wagner - Wednesday, July 19, 2017 10:43 AMAnd in other news, a new vulnerability in IoT has been found.http://thehackernews.com/2017/07/gsoap-iot-device-hacking.html
YIKES! Makes me glad I'm playing the luddite lately when it comes to connected items for the home.
I want my refrigerator to do only two things... keep my stuff cold and give me access to the interior when I need it. All this IOT stuff reminds me of why Adama was so strict about limiting computer controls on Battlestar Galactica. Seems far fetched until you hear stuff like what's in that article but, like you, I definitely play the part of a Luddite there. The problem is going to be when you can no longer buy things that don't have IOT capabilities. Look at what GM did a long time ago... They built in On-Star. Just because you don't have an active subscription doesn't mean that they can't use it to find you. An unconfirmed rumor says they can also pulse the vehicle to kind of safely drop the speed to zero in case someone has stolen it.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 59,356 through 59,370 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply