June 7, 2016 at 9:03 am
Brandie Tarvin (6/7/2016)
Ray K (6/7/2016)
Lynn Pettis (6/7/2016)
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Even a success notification of the backup doesn't mean the backup succeeded. Brandie is right, to truly know a backup succeeded you need to restore from the backup.
Backups are worthless, Restores are priceless!
I remember once hearing someone say, "you shouldn't have a backup plan; what you need is a recovery plan."
You can't truly have a backup plan until you do have a recovery plan anyway.
I've use the "we don't need a backup plan; we need a recovery plan" for some time, but I also heard it from someone else.
June 7, 2016 at 9:07 am
Jeff Moden (6/7/2016)
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.It was almost as sarcastic as using LMGTFY but I'm absolutely with you on this. It wasn't a difficult question and I saw nothing of intellectual curiosity on the part of the OP. Certainly, they're not qualified for whatever SQL Server related job they were going after even if you just measure the intellectual curiosity part. And I find it difficult to believe that anyone thinks that's the wrong question to ask on a technical interview.
You seen my posts on the subject before... I'm totally disgusted with both the extremely low level of knowledge that 90% of the applicants have and the total lack of investing some time to get that knowledge.
To wit, the sarcasm was actually well placed. I just wouldn't get in the habit because it will affect you in your dealings with people that you have to work with.
To wit, intellectual curiosity, I am close to having my workstation setup at home. I have a "gaming laptop" to use as the base for the workstation; the docking station to connect three displays to my laptop; the display stand to hold three 28" monitors. This Friday I will order the three displays so I will have those by early next week. Then I just need a new desk to set everything up on.
Then the fun part, learning Hyper-V so I can start running VMs and getting OS's to run on them.
June 7, 2016 at 9:12 am
Lynn Pettis (6/7/2016)
Jeff Moden (6/7/2016)
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.It was almost as sarcastic as using LMGTFY but I'm absolutely with you on this. It wasn't a difficult question and I saw nothing of intellectual curiosity on the part of the OP. Certainly, they're not qualified for whatever SQL Server related job they were going after even if you just measure the intellectual curiosity part. And I find it difficult to believe that anyone thinks that's the wrong question to ask on a technical interview.
You seen my posts on the subject before... I'm totally disgusted with both the extremely low level of knowledge that 90% of the applicants have and the total lack of investing some time to get that knowledge.
To wit, the sarcasm was actually well placed. I just wouldn't get in the habit because it will affect you in your dealings with people that you have to work with.
To wit, intellectual curiosity, I am close to having my workstation setup at home. I have a "gaming laptop" to use as the base for the workstation; the docking station to connect three displays to my laptop; the display stand to hold three 28" monitors. This Friday I will order the three displays so I will have those by early next week. Then I just need a new desk to set everything up on.
Then the fun part, learning Hyper-V so I can start running VMs and getting OS's to run on them.
One of the big tricks to Hyper-V that can trip up people is, you can't create VMs and such on the Hyper-V server itself (UNLESS you're running a full Windows Server with the Hyper-V Role installed,) you need to have the Hyper-V manager on a workstation / different server.
After that, it's fairly easy.
June 7, 2016 at 9:13 am
Luis Cazares (6/7/2016)
jasona.work (6/7/2016)
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.Nah. I was sorely tempted to put together a Powershell script to actually do what they wanted, then wait for the "I tried running this in SSMS and it failed" response...
Then I thought about commenting that the people here are very helpful, as long as you show signs you're trying to help yourself, just asking for the answer to an interview question is not "trying to help yourself" and will tend to get ignored or dog-piled...
But I've got better things to do with my time.
Like posting on the thread? :-D:hehe:
Well yeah...
:-D:hehe::-D
June 7, 2016 at 9:26 am
jasona.work (6/7/2016)
Lynn Pettis (6/7/2016)
Jeff Moden (6/7/2016)
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.It was almost as sarcastic as using LMGTFY but I'm absolutely with you on this. It wasn't a difficult question and I saw nothing of intellectual curiosity on the part of the OP. Certainly, they're not qualified for whatever SQL Server related job they were going after even if you just measure the intellectual curiosity part. And I find it difficult to believe that anyone thinks that's the wrong question to ask on a technical interview.
You seen my posts on the subject before... I'm totally disgusted with both the extremely low level of knowledge that 90% of the applicants have and the total lack of investing some time to get that knowledge.
To wit, the sarcasm was actually well placed. I just wouldn't get in the habit because it will affect you in your dealings with people that you have to work with.
To wit, intellectual curiosity, I am close to having my workstation setup at home. I have a "gaming laptop" to use as the base for the workstation; the docking station to connect three displays to my laptop; the display stand to hold three 28" monitors. This Friday I will order the three displays so I will have those by early next week. Then I just need a new desk to set everything up on.
Then the fun part, learning Hyper-V so I can start running VMs and getting OS's to run on them.
One of the big tricks to Hyper-V that can trip up people is, you can't create VMs and such on the Hyper-V server itself (UNLESS you're running a full Windows Server with the Hyper-V Role installed,) you need to have the Hyper-V manager on a workstation / different server.
After that, it's fairly easy.
Don't burst my bubble, I can't afford a second computer system. I have already budgeted future paychecks to other endeavors.
June 7, 2016 at 10:52 am
Lynn Pettis (6/7/2016)
jasona.work (6/7/2016)
Lynn Pettis (6/7/2016)
Jeff Moden (6/7/2016)
Luis Cazares (6/7/2016)
Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.It was almost as sarcastic as using LMGTFY but I'm absolutely with you on this. It wasn't a difficult question and I saw nothing of intellectual curiosity on the part of the OP. Certainly, they're not qualified for whatever SQL Server related job they were going after even if you just measure the intellectual curiosity part. And I find it difficult to believe that anyone thinks that's the wrong question to ask on a technical interview.
You seen my posts on the subject before... I'm totally disgusted with both the extremely low level of knowledge that 90% of the applicants have and the total lack of investing some time to get that knowledge.
To wit, the sarcasm was actually well placed. I just wouldn't get in the habit because it will affect you in your dealings with people that you have to work with.
To wit, intellectual curiosity, I am close to having my workstation setup at home. I have a "gaming laptop" to use as the base for the workstation; the docking station to connect three displays to my laptop; the display stand to hold three 28" monitors. This Friday I will order the three displays so I will have those by early next week. Then I just need a new desk to set everything up on.
Then the fun part, learning Hyper-V so I can start running VMs and getting OS's to run on them.
One of the big tricks to Hyper-V that can trip up people is, you can't create VMs and such on the Hyper-V server itself (UNLESS you're running a full Windows Server with the Hyper-V Role installed,) you need to have the Hyper-V manager on a workstation / different server.
After that, it's fairly easy.
Don't burst my bubble, I can't afford a second computer system. I have already budgeted future paychecks to other endeavors.
If you're running Hyper-V on the workstation (Win 7 Pro / 8 Pro / 10 Pro or Enterprise of those) then you're good, just load the Hyper-V Management tools as well as the role.
PM me and I can throw some help your way when I'm off work.
June 7, 2016 at 2:03 pm
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Notifications for success become noise, and we're generally very bad at noticing when something doesn't happen, especially when the noise results in an outlook delete rule. Alerts should never advise that things are fine, they're *alerts*
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 7, 2016 at 3:22 pm
GilaMonster (6/7/2016)
Luis Cazares (6/7/2016)
WayneS (6/6/2016)
PRO TIP:If you're depending on an email notification to warn you when a backup fails, lack of receiving the email doesn't mean that the backup succeeded.
That's why I suggest to have notifications for success instead of failures.
Notifications for success become noise, and we're generally very bad at noticing when something doesn't happen, especially when the noise results in an outlook delete rule. Alerts should never advise that things are fine, they're *alerts*
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)
I agree. Work on fine-tuning your alerts so that they are always something that needs to be actioned. 'Noise' alerts/warnings/messages should be turned off.
June 7, 2016 at 4:51 pm
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)
And then have another server monitor the monitoring server, and mail you when it has problems.
June 7, 2016 at 5:11 pm
Hugo Kornelis (6/7/2016)
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)And then have another server monitor the monitoring server, and mail you when it has problems.
And have the first monitoring server attemp to restore the backup (if it didn't fail), and notify you if that fails; the second monitoring server can also check that the restore worked (in case the first monitoring server has failed in a way that the second one can only detect by checking that the restored database exists).
Maybe overkill - but if your data is important enough, definitely not overkill.
Tom
June 7, 2016 at 5:12 pm
Hugo Kornelis (6/7/2016)
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)And then have another server monitor the monitoring server, and mail you when it has problems.
And then another, and another , ... when does the monitoring end? :w00t:
June 7, 2016 at 10:53 pm
Lynn Pettis (6/7/2016)
Hugo Kornelis (6/7/2016)
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)And then have another server monitor the monitoring server, and mail you when it has problems.
And then another, and another , ... when does the monitoring end? :w00t:
When the users call with a problem that you forgot to monitor for. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 8, 2016 at 5:36 am
Jeff Moden (6/7/2016)
Lynn Pettis (6/7/2016)
Hugo Kornelis (6/7/2016)
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)And then have another server monitor the monitoring server, and mail you when it has problems.
And then another, and another , ... when does the monitoring end? :w00t:
When the users call with a problem that you forgot to monitor for. 😉
There will always be one. The best one would be when one of the monitors sends an email saying that the email server is down. 😛
June 8, 2016 at 5:40 am
Ed Wagner (6/8/2016)
Jeff Moden (6/7/2016)
Lynn Pettis (6/7/2016)
Hugo Kornelis (6/7/2016)
GilaMonster (6/7/2016)
What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send mail)And then have another server monitor the monitoring server, and mail you when it has problems.
And then another, and another , ... when does the monitoring end? :w00t:
When the users call with a problem that you forgot to monitor for. 😉
There will always be one. The best one would be when one of the monitors sends an email saying that the email server is down. 😛
Reminds me of our internet provider that went down. They wanted us to post a message to their site. :crazy:
June 8, 2016 at 5:42 am
Well, I'm planning to put together my own take on this, but I found someone who already invented the wheel so my take will need to be a better mousetrap (there, I think I mangled enough metaphors...)
Lynn, here's a decent guide to getting started with Hyper-V on Win10 It's enough to get you started as it covers all the basics.
One thing I've run into, which is a known issue, is if you create a Gen2 VM, when you load the OS your keyboard won't pass through to the VM (it's a problem with the keyboard driver used,) so you need to use the on-screen keyboard to type in things like the OS CD key...
Viewing 15 posts - 54,481 through 54,495 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply