Wise man or Wise guy? You Decide

Just another WordPress.com weblog

Archive for the ‘Twitter’ Category

Networking Successes

Posted by sqlwiseguy on September 5, 2009

Over the last few weeks I’ve had several instances where I’ve had to learn new things and, in my struggles, have had the opportunity to get help from people I have met recently (both in person and on-line).  Notice I said “opportunity”.  One thing I’ve learned recently is that people like to help other people!   As part of my professional development I’ve been attempting to work on my networking skills, and, in my opinion, networking is more than meeting people, it is interacting with them to help and to be helped.

What the heck is jQuery?

The current project I am working on is using ASP.NET MVC and AJAX for the web site and my HTML and javascript skills are not strong so I was reading and workring with Professional ASP.NET MVC 1.0.  As I went through the examples I encountered a jQuery script that was not working.  I posted a question on Twitter which was answered by Jeremiah Peschka (Blog|Twitter).  He sent me his email address and offered to look at the script for me.  He also forwarded on the problem to a jQuery guru he knows.  All that effort and we’ve never met!  See people DO like to help!

How does this work in Powershell?

A few months ago I began interacting with Chad Miller (Blog|Twitter) on Twitter and was able to set him up to speak at my local user group (OPASS).  Chad is a Powershell guru and presented on T-SQL vs. Powershell back in July.  I’m working on a presentation about the Default Trace and I wanted to provide some examples of how to archive the Default Trace files/data.  This seemed like a good opportunity to learn some Powershell, so I sent Chad an email asking him to point me in the right direction, which he did.  I completed a “working” Powershell script and sent it to him for review.  He responded with explanations of what I had done wrong and a corrected script.

Why can’t I get this file processed?

Again as part of the Default Trace presentation I wanted to present a solution using SSIS.  Now I have some experience with SSIS and consider myself to be at an intermediate level so I figured I could get it done without trouble.  Well, I was wrong.  I had what I thought was a working solution, until I got Log_10.trc at the same time as Log_9.trc.  The ForEach File Enumerator orders files by name so the active Log_10.trc file was the first file the File System Task attempted to move and it is locked, thus the task failed.  So once I again I used Twitter to ask an SSIS guru, Andy Leonard (Blog|Twitter), if there was a way to change the sort order on the ForEach File Enumerator.  He said that you needed to script it, unfortunately.  He also emailed me an example script.

Those are just 3 instances where I’ve had the opportunity to truly practice networking (I blogged about another here).  Interacting with people and using those interactions to learn new skills and share your skills.  In my mind this is real networking.  Sure these are examples where I got something from my network, but there have been times where I’ve been on the other side, and you’d better believe if I can help out any of these guys I’ll do it!

Posted in Community, Networking, Professional Development, Twitter | 2 Comments »

Access Denied, Not Possible

Posted by sqlwiseguy on August 27, 2009

What’s going on here?

When trying to open Default Trace files on Windows 7 and SQL Server 2008 I got the “You don’t have permission to open this file” error.  My first and second thoughts were “How can this be, I’m an administrator!?”.  SO the first thing I tried was reading the files using fn_trace_gettable in SSMS.  This works, what is different between SSMS and Profiler?  Nothing that I can think of.

What’s Next?

First step, check permissions on the folder, yup, full control.  Second step, turn off inheritance.  Third step, bang head on desk!  So off to google/bing I went.  I found this post by the SQL Server PSS team, , which told me about the issue, but not a good way to solve it.  I can’t just grant rights to each file because the Default Trace rolls over and creates new files, I need rights all the time.  Then I found this post, which says the owner of the files needs to copy and paste them out to a another shared folder.  While not the most helpful idea for my situation I tried it, and it worked!  I’m still annoyed at this point because I don’t want to have to move the files to read them.

Finally, a solution

Once again it is Twitter to the rescue.  I tweeted my problem and got a pretty quick response from Brian Kelley (Twitter|Blog) asking about OS and if I ran Profiler as Administrator.  I answered Win 7 and Yes, I was mistaken on the Yes it turns out.  I thought because the account I was running under had administrative privileges that I was running as administrator.  This is not the case in Vista, Win 7, and Windows Server 2008 when UAC is on.  With UAC on you still need to run Profiler using elevated privileges by right-clicking and selecting “Run As Administrator”.  That is the answer.  I should also note that Ken Simmons (Twitter|Blog) also produced this answer.   Jonathan Kehayias (Twitter|Blog) also chimed in to let me know that you can set individual applications to always run as administrator by right-clicking, selecting Properties, Compatibility, and checking the Run as Administrator box.  All of this in about 20 minutes and this is after I spent at least an hour fighting with it and searching the internet for a solution!

Conclusion

I really need to get a better understanding of UAC, and believe it or not, Twitter works!

Posted in Problems, Profiler, SQL Server, Twitter | Leave a Comment »