The Virginia Tour 2016

db nsfwLong Time Coming

With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.

This is not just a one day event for me. No no! I will be presenting for three consecutive days on many things SQL Server related. The Virginia Tour 2016 really is more of a Richmond Tour 2016 (March 16-19) with all three days being presentations in the Richmond area.

The tour starts off with a visit to the Richmond User Group. You can find details on the evening and event on their website – here.

Here is a quick recap of the NSFW (Naked Sql: Fundamentals to Wisdom) session:

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

This should be a light-hearted and fun session with a bit of NSFW learning. Just hope the censors don’t get to the slide deck first!

After the user group presentation to kick off the week, there will be an all-day encore on Friday. Friday is officially a part of the SQLSaturday event. You are welcome to come and participate in my all day workshop – Monitoring SQL Server with Extended Events. There is an event page with details for registering that you can visit – here!

Here is some of what I will be covering in day 2 of this Richmond tour:

Every good enterprising DBA has the prime directive of monitoring the SQL Servers under his/her jurisdiction. The last thing a DBA wants to hear is that there is a problem with a database under his/her purview from an end-user.

SQL Server has progressed over time to give better and better information to the DBA.  Much of this information can be used in a home grown solution to monitor SQL Server. With the constant increase in surface area from Extended Events, the power to build a home grown solution becomes more and more feasible while being limited only by the imagination of the enterprising DBA (or developer or data professional). This full day workshop will introduce you to an Extended Events based solution to achieve that home-grown monitoring goal.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties.  This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE.  Take advantage of this opportunity to dive into the world of Extended Events and learn how you can make best use of this tool in your SQL 2008+ environment.

This will be a fun day if for nothing else than it is about Extended Events and how to glean great information from your SQL Servers. That and we will keep it light. Just remember, the more you are involved in the workshop the better it will be!

sqlsat486webAfter a brief break to grab some zzzz’s, I will be wrapping up this tour with the grand finale – SQL Saturday 486!!

Not only will I be presenting at this event, I have also volunteered.

I will have a short introductory style presentation about Extended Events. I intend to show a little profiler and a little Extended Events. As usual, I intend to keep the session light, fun and engaging. Here is a little more info on that session:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

wheelofdoomThen to cap the day, I will be helping to assist with the Wheel of Doom.

The name of the session sounds much worse than it really is. The premise is simple. Speakers and attendees are invited to submit a lightening talk style session with slide deck. Then attendees of the session can volunteer to spin the wheel and present whichever session pops up.

This session is to help people get over the nerve of presenting. It will be very light-hearted and entertaining. No judgement, no shaming, just have fun with it!

 

 

DBA VC Presentation May 11

Categories: News, Professional, SSC
Comments: No Comments
Published on: May 11, 2011

Come one, come all!!  Oh wait, it’s too late now.  I just finished giving my presentation to the DBA VC (virtual chapter).  There was good attendance and there were good questions asked.  My presentation was the very same presentation that I gave for SQLSat83 (sheepishly: I even used the same slidedeck).

The presentation was recorded and I will post the link for that when it becomes available.  There was one goofup on my part.  I went on for about 5 minutes without the shared application having actually switched – D’OH.  My sincerest apologies for that.

During the presentation I made references to a few resources that I felt should be noted somewhere since I didn’t provide the exact resource during the presentation.

  1. Paul Randal myth-a-day concerning heap rebuilds.
  2. Kimberly Tripp’s information on VLFs.
  3. 3rd party tool for documenting a database quickly – called SQLSpec.  (it’s fairly inexpensive)

I really enjoyed giving this presentation and sharing my yet-to-be finished basement with everybody.  I hope to be doing more of these over time.

SQLSaturday SLC 2010

Comments: No Comments
Published on: September 1, 2010

Well, I have taken another plunge.  I finally got around to submitting a session for SQL Saturday Salt Lake City 2010 (Web | #sqlsat54 ).  I had been planning on doing this since it was announced through the grapevine.  The delay for submitting the first session really came down to a bit of confidence in writing an abstract on the topic.  Writing abstracts is new territory for me.  I plan on improving in this domain, thus will need to submit a few more abstracts to various different events.  That said – SQL Sat SLC will be the first but not the last.  If you check out the website for SQL Saturday 54, you will see that my topic is one of those that brings agony to many DBA’s – Documentation.  As I said in the abstract, I hope to share some scripts to help simplify some of the documentation tasks.

I am looking forward to this event and hope to see some of you there.  Here’s to hoping my presentation will be selected.  In the meantime, I will be working on another abstract for a second topic to present at SQLSat54.

page 1 of 1








Calendar
June 2017
M T W T F S S
« May    
 1234
567891011
12131415161718
19202122232425
2627282930  
Content
SQLHelp

SQLHelp


Welcome , today is Sunday, June 25, 2017