Search results matching tags 'SQL Server' and 'Help'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL+Server,Help&orTags=0Search results matching tags 'SQL Server' and 'Help'en-USCommunityServer 2.1 SP2 (Build: 61129.1)When you’re asking for help, make sure you explain what you’re trying to accomplishhttp://sqlblog.com/blogs/buck_woody/archive/2010/07/22/when-you-re-asking-for-help-make-sure-you-explain-what-you-re-trying-to-accomplish.aspxThu, 22 Jul 2010 12:24:09 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27232BuckWoody<p>At some time, all of us need technical help with something. Whenever you do, make sure you try and frame the question not necessarily in terms of what you want to know, but what you're trying to do. Spending time on thinking through your questions will help you get better answers, and people will appreciate that you're putting some effort into the process, and they are more willing to get help.</p>
<p>For instance - let's say yo're stuck on a particular SQL Server Replication issue. You're not sure whether moving the Distributor function away from the Publisher server is the right thing to do, given your budget. You could ask:</p>
<p><span style="color:#0000ff;">"Where should the Distrbutor go in a Replication scheme?"</span></p>
<p>That's too vague, and doesn't help others help you. Instead, this might be a better way to put the question:</p>
<p><span style="color:#0000ff;">"I'm setting up the design for my Replication scheme, and I have&nbsp;a limited budget. What are the best ways to save money in my design?"</span></p>
<p>This question goes more towards what you really want to know, and in fact, you may find out that the Distributor question isn't what you need to care about at all. Sure, sometimes you just want the phone number to a store, and you really don't need to tell everyone you're hungry, but if the question goes beyond simple facts, it's a good idea to include as much information as possible so folks can help you best.</p>Lessons from Volunteeringhttp://sqlblog.com/blogs/buck_woody/archive/2010/02/23/lessons-from-volunteering.aspxTue, 23 Feb 2010 14:31:01 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:22577BuckWoody<p>Saturday I volunteered at a work-day at our church. Our building is one of the first buildings built in this area of Washington, so it’s a beautiful old structure, which of course means there’s lots of maintenance.</p> <p>I’m fairly decent with tools, I’ve done some woodworking in my day, and I’ve even rebuilt a car or two. But working on a structure this old requires some special skills, skills that I don’t (or didn’t) have. And as I re-glazed a stained-glass window into an ancient window opening, I was not only humbled, I thought about how the entire project was handled and how I could learn about being a better DBA. I decided to share those lessons I learned here.</p> <p><strong>Not everybody knows what you do <br /></strong>This seems obvious – but I’m so often on the “knowing” end of a project that it’s easy to forget. Several of the other people at the workday knew what went where, how things worked, and what to do to take something out or put it back in. Even with my construction skills, I felt a little overwhelmed. Happily, the people that were there were VERY gracious and helped me do what I could. The nice thing is that they did not talk down to me or treat me like an idiot – they found out what I did know, and then mapped that to what I could do. They helped me learn, and by doing that I became useful to them. <br />This is also true in our career field. Are you having trouble between developers and data professionals? Buy a pizza, have a lunch and each team should take a turn at learning what the other knows, and what they would like them to know.</p> <p><strong>If you’re good at something, lead <br /></strong>One of the people at the workday was an older gentleman who was amazing in his knowledge. He’s a contractor, who’s dad trained him in construction starting at 5 years old! And in fact, his dad (and him) actually helped build this church. He’s an amazing guy. But he was running from task to task, doing all of the “hard” things. So I pulled him aside, and told him that we couldn’t do what he could do – but we were all willing hands and heads. I explained that if he would be willing, he could lead us. I asked him to group us into skillsets, and then come help each of us as needed. He agreed, and soon we were all productive. <br />You should do the same. If your kid’s school needs a “teacher for a day”, step up. Teach the kids what you know about databases. You’ll be surprised! Don’t be afraid to take a leadership role where you are.</p> <p><strong>Break things down into simple tasks <br /></strong>To do the two things above, you need to plan a little. The gentleman that helped us at first gave us things like “re-glaze that window.” After we stared at him blankly, he broke down the work into the steps of heating the old glaze with a torch, gently removing the old glaze, replacing the section of glass, and re-applying the glaze, all the while showing us the little parts of those tasks that keep the glass from shattering. <br />One of the easiest things to do when you’re a technical professional is to “glaze over” all of the little steps into a large one. You’ll need to learn to break things down into the simplest components, or at least the simple components that are needed for your workers.</p> <p>&#160;</p> <p>I hope these tips are useful – I’ve been applying them each day.</p>Make it Easy for People to Help Youhttp://sqlblog.com/blogs/buck_woody/archive/2010/02/08/make-it-easy-for-people-to-help-you.aspxMon, 08 Feb 2010 14:17:59 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:21982BuckWoody<p>OK, there are probably a dozen or more of these kinds of posts, but I’ll dive in anyway. From time to time, people send me e-mails or comments on this blog asking for help. Sometimes it’s on the topic at hand, and other times the topic just jogs their memory about something else. </p> <p>Often I’m happy to help. If I know the answer without doing any research (or even if I have to do a little) I’ll interrupt what I’m doing and dash out a note with the answer. But of course I have a job (three, to be exact) and so any time I help with a question I’m lengthening my day, spending less time with my family, and so on. If you think about it, everyone that you ask (and everyone I ask) is in the same boat – when someone helps me, I am taking their most valuable asset: their time. So I learned a very important lesson very early on: Make it easy for people to help you. </p> <p>So here’s the steps to follow to do that – it really isn’t that hard:</p> <ol> <li><font color="#800000">Request, don’t demand.</font> I got an e-mail yesterday (on Sunday) where someone found a blog entry about one topic, and basically said this about another topic: “Tell me where I can find ‘x’ so that I can alter it.” Guess what I did? That’s right, I hit the delete key. If you are asking a question from a professional, you need to understand that they normally get paid – very well, sometimes – for their time. Make sure your question is a question, not a demand. </li> <li><font color="#800000">Be clear about the problem.</font> Vague statements don’t help – and very few people have the time to dig the real question out of you. Be specific. Ask the single question you really need help with.</li> <li>Keep the problem limited. “Rewrite my code for me” isn’t going to happen. “help me with this line” might. “Where do I go to find out more about the SELECT statement” is even better. If your problem takes more than a few minutes for someone to answer, then you should probably get someone on-site to help you.</li> <li><font color="#800000">Explain what you’ve already done</font>. This, of course, means you’ve already actually <em>done </em>something. What have you looked up, what do you already understand, where have you looked, what have you tried?</li> <li><font color="#800000">Be polite</font>. <strong>Please</strong> and <strong>Thank You </strong>are magic words, whether you get the answer you were looking for or not. </li> </ol> <p>I’ll add one thing when you’re responding to a blog – not just mine, anyone’s. If you want to ask a question, ask it as a reply to a post, not an e-mail. The author wants to answer the question once, and it’s almost a guarantee that you’re not the only one with that question. Also, other readers might know the exact answer and help you even more. I know, you have to register, all that stuff. Just consider it the price of getting your answer.</p>Plan and Prepare or Just Do It? How about Both!http://sqlblog.com/blogs/buck_woody/archive/2010/01/07/plan-and-prepare-or-just-do-it-how-about-both.aspxThu, 07 Jan 2010 15:56:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:20683BuckWoody<P>I'm kind of a type "A" person. OK, I'm a VERY type "A" person. I even cook by setting things up ahead of time. I'm definitely more in the "Plan and Prepare" camp than the "Just Do It" camp. </P>
<P>But I do realize that there are times when you just can't stop and prepare. Sure, it would be great to know that server is going to melt down just now, but it happened and you have to deal with it. Now is not the time to open the plastic on that "Troubleshooting SQL Server" DVD course you bought! You just have to dive in and get the thing fixed.</P>
<P>Hopefully you're not operating like that all the time. If you are, you probably need to get some help with your systems, at least temporarily, until you can get them stabilized. </P>
<P>&nbsp;So which is it? Should you be like me, a type "A" who has to have everything planned out, or a reactionary agent, fixing things as they happen? How about - Both!</P>
<P>I think you should aim to plan and prepare as much as you can. Your life will be more stress-free, and you'll be happier in your job. But you can't lose your head when things go wrong and demand time to plan and prepare. You just have to jump in there and fix the problem.</P>
<P>But I think there's a happy medium in there somewhere. I ten to plan and prepare for the times I have to "just do it". I have my scripts ready for things like backups, DBCC repairs, restores, web site links for "how to" articles and so on. I have those right by my desk so that I don't have to panic when panic hits. So in effect, I'm doing both - I'm planning to just do it.</P>