Austin .NET SQL User Group Presentation

Thank you to everyone who made it out to the first Austin .NET User Group

Austin .NET User Group

Austin .NET User Group

Presentation in 2015. This also was my first of many presentation I plan on delivering in 2015. As promised I have uploaded the slide deck, code example and the Power Point for my session titled, “Making Your SQL Server Queries Run Faster.”

  • yogiaradhye

    The session was very informative. Thank you!

  • John

    I am glad you enjoyed it. Let me know if you have any questions after playing with the demos.

  • yogiaradhye

    Is there special permissions or settings required to see the sessions folder?

  • John

    Not sure I am following you with the sessions folder? Are you talking about the zip file with the sample code? Everything that is needed should be under Resources section. Please let me know if something isn’t working for you. I want to make sure everyone can access everything and do the demos.

  • yogiaradhye

    Sorry, I was little vague. I am trying to use the extended events instead of profiler like your showed in the session. However, I cannot see Extended Events under Management for my test db. I understand it could be difficult to resolve without looking at the db. I was wondering if you know something off the top your head that I can easily check. THanks again!

  • John

    Oh, I got you now.

    In SSMS under Management you should see Extended Events and under the session folder you should have existing events.

    Here is a quick video that goes through exactly what I did last night at the meeting.

    You would need the following security to be able to create/edit/delete Extended Events. Just replace UserNameGoesHere with the actual user name.

    GRANT CONTROL SERVER TO UserNameGoesHere

    GRANT ALTER ANY EVENT SESSION TO UserNameGoesHere

    Thanks for asking, I will turn this into a blog post to help others. Let me know if you have any other questions.

    Regards,
    John