Murder in Raleigh

sqlsat320_webI am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it to say at this point that it all started with a comment about a sailing train a few months back.

raleigh_traini

Time to sink or sail, so to speak.  SQL Saturday 320 in Raleigh will mark the next attempt at what I hope to be a repeat performance – many times.  I will be tag-teaming with Wayne Sheffield in this all day workshop event.  The session is one of two all day sessions for the event in Raleigh NC.

If you are a DBA or a database developer, this session is for you.  If you are managing a database and are experiencing performance issues, this session is a must.  We will chat with attendees about a horde of performance killers and other critical issues we have seen in our years working with SQL Server.  In short, some of these issues are pure murder on your database, DBA, developer and team in general.  We will work through many of these things and show some methods to achieve a higher state of database Zen.

Description

Join Microsoft Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine numerous crazy implementations they have seen over the years, and how these implementations can be murder on SQL Server.  No topic is off limits as they cover the effects of these crazy implementations from performance to security, and how the “Default Blame Acceptors” (DBAs) can use alternatives to keep the developers, DBAs, bosses and even the end-users happy.

Presented by:

wayneWayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles atwww.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne

 

 

 

JasonBrimhall

Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2012. He has experience in performance tuning, high transaction environments, as well as large environments.  Jason also has 18 years experience in IT working with the hardware, OS, network and even the plunger (ask him sometime about that). He is currently a Consultant and a Microsoft Certified Master(MCM). Jason is the VP of the Las Vegas User Group (SSSOLV).

 

 

 

 

Course Objectives

  1. Recognize practices that are performance pitfalls
  2. Learn how to Remedy the performance pitfalls
  3. Recognize practices that are security pitfalls
  4. Learn how to Remedy the security pitfalls
  5. Demos Demos Demos – scripts to demonstrate pitfalls and their remedies will be provided
  6. Have fun and discuss
  7. We might blow up a database

kaboom

 

There will be a nice mix of real world examples and some painfully contrived examples. All will have a good and useful point.

If you will be in the area, and you are looking for high quality content with a good mix of enjoyment, come and join us.  You can find registration information and event details at the Raleigh SQL Saturday site – here.  There are only 25 seats available for this murder mystery theater.  Reserve yours now.

The cost for the class is $110 (plus fees) up through the day of the event.  When you register, be sure to tell your coworkers and friends.

Wait, there’s more…

Not only will I be in Raleigh for this workshop, I hope to also be presenting as a part of the SQLSaturday event on Sep 6 2014 (the day after the workshop which is Sep 5, 2014).  I hope to update with the selected session(s) when that information becomes available.

You can see more details about the topics lined up for this event – here.

Shameless plug time

I present regularly at SQL Saturdays.  Wayne also presents regularly at SQL Saturdays.  If you are organizing an event and would like to fill some workshop sessions, please contact either Wayne, myself or both of us for this session.

Murder In Denver

Comments: 1 Comment
Published on: July 14, 2014

sqlsat331_webI am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it to say at this point that it all started with a comment about a sailing train a few months back.

train

Time to sink or sail, so to speak.  SQL Saturday 331 in Denver will mark the next attempt at what I hope to be a repeat performance – many times.  I will be tag-teaming with Wayne Sheffield in this all day pre-con / workshop event.  The session is one of three all day sessions for the event in Denver CO.

If you are a DBA or a database developer, this session is for you.  If you are managing a database and are experiencing performance issues, this session is a must.  We will chat with attendees about a horde of performance killers and other critical issues we have seen in our years working with SQL Server.  In short, some of these issues are pure murder on your database, DBA, developer and team in general.  We will work through many of these things and show some methods to achieve a higher state of database Zen.

Description

Join Microsoft Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine numerous crazy implementations they have seen over the years, and how these implementations can be murder on SQL Server.  No topic is off limits as they cover the effects of these crazy implementations from performance to security, and how the “Default Blame Acceptors” (DBAs) can use alternatives to keep the developers, DBAs, bosses and even the end-users happy.

Presented by:

wayneWayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles atwww.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne

 

 

 

JasonBrimhall

Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2012. He has experience in performance tuning, high transaction environments, as well as large environments.  Jason also has 18 years experience in IT working with the hardware, OS, network and even the plunger (ask him sometime about that). He is currently a Consultant and a Microsoft Certified Master(MCM). Jason is the VP of the Las Vegas User Group (SSSOLV).

 

 

 

 

Course Objectives

  1. Recognize practices that are performance pitfalls
  2. Learn how to Remedy the performance pitfalls
  3. Recognize practices that are security pitfalls
  4. Learn how to Remedy the security pitfalls
  5. Demos Demos Demos – scripts to demonstrate pitfalls and their remedies will be provided
  6. Have fun and discuss
  7. We might blow up a database

kaboom

 

There will be a nice mix of real world examples and some painfully contrived examples. All will have a good and useful point.

If you will be in the area, and you are looking for high quality content with a good mix of enjoyment, come and join us.  You can find registration information and event details at the Denver SQL site – here.  There are only 30 seats available for this murder mystery theater.  Reserve yours now.

The cost for the class is $125 up through the day of the event.  When you register, be sure to choose Wayne’s class.

Wait, there’s more…

Not only will I be in Denver for the Precon, I hope to also be presenting as a part of the SQLSaturday event on Sep 20 2014 (the day after the precon which is Sep 19, 2014).  I hope to update with the selected session(s) when that information becomes available.

You can see more details about the topics lined up for this event – here.

Shameless plug time

I present regularly at SQL Saturdays.  Wayne also presents regularly at SQL Saturdays.  If you are organizing an event and would like to fill some pre-con sessions, please contact either Wayne, myself or both of us for this session.

Murder in Richmond

Comments: 2 Comments
Published on: February 6, 2014

sqlsat277_webI am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it to say at this point that it all started with a comment about a sailing train a few months back.

loco_stoppedsailingTime to sink or sail, so to speak.  SQL Saturday 277 in Richmond will mark the second attempt at what I hope to be a repeat performance – many times.  I will be tag-teaming with Wayne Sheffield in our first all day pre-con event.  The session is one of three all day sessions for the event in Richmond VA.

If you are a DBA or a database developer, this session is for you.  If you are managing a database and are experiencing performance issues, this session is a must.  We will chat with attendees about a horde of performance killers and other critical issues we have seen in our years working with SQL Server.  In short, some of these issues are pure murder on your database, DBA, developer and team in general.  We will work through many of these things and show some methods to achieve a higher state of database Zen.

Description

Join Microsoft Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine numerous crazy implementations they have seen over the years, and how these implementations can be murder on SQL Server.  No topic is off limits as they cover the effects of these crazy implementations from performance to security, and how the “Default Blame Acceptors” (DBAs) can use alternatives to keep the developers, DBAs, bosses and even the end-users happy.

Presented by:

wayneWayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles atwww.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne

 

 

 

JasonBrimhall

Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2012. He has experience in performance tuning, high transaction environments, as well as large environments.  Jason also has 18 years experience in IT working with the hardware, OS, network and even the plunger (ask him sometime about that). He is currently a Consultant and a Microsoft Certified Master(MCM). Jason is the VP of the Las Vegas User Group (SSSOLV).

 

 

 

 

Course Objectives

  1. Recognize practices that are performance pitfalls
  2. Learn how to Remedy the performance pitfalls
  3. Recognize practices that are security pitfalls
  4. Learn how to Remedy the security pitfalls
  5. Demos Demos Demos – scripts to demonstrate pitfalls and their remedies will be provided
  6. Have fun and discuss
  7. We might blow up a database

kaboom

 

There will be a nice mix of real world examples and some painfully contrived examples. All will have a good and useful point.

If you will be in the area, and you are looking for high quality content with a good mix of enjoyment, come and join us.  You can find registration information and event details at the Richmond SQL site – here.  There are only 30 seats available for this murder mystery theater.  Reserve yours now.

The cost for the class is $99 if you register by February 20th, when they raise to $125.  When you register, be sure to choose Wayne’s class.

Wait, there’s more…

Not only will I be in Richmond for the Precon, I will also be presenting as a part of the SQLSaturday event on Mar 22 2014 (the day after the precon which is Mar 21, 2014).  I have the distinct pleasure of presenting a really fun topic.  My session on table compression was selected for the main event.  So, if you can’t make it out for the precon, at least come out for the main event.

You can see more details about the topics lined up for this event – here.

Shameless plug time

I present regularly at SQL Saturdays.  Wayne also presents regularly at SQL Saturdays.  If you are organizing an event and would like to fill some pre-con sessions, please contact either Wayne, myself or both of us for this session.

Murder They Wrote

Comments: 4 Comments
Published on: November 5, 2013

sqlsat233_webI am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it to say at this point that it all started with a comment about a sailing train a few months back.

loco_stoppedsailingTime to sink or sail, so to speak.  SQL Saturday 233 in Washington DC will mark the premier of what I hope to be a repeat performance – many times.  I will be tag-teaming with Wayne Sheffield in our first all day pre-con event.  The session is one of three all day sessions for the event in Chevy Chase, MD.

If you are a DBA or a database developer, this session is for you.  If you are managing a database and are experiencing performance issues, this session is a must.  We will chat with attendees about a horde of performance killers and other critical issues we have seen in our years working with SQL Server.  In short, some of these issues are pure murder on your database, DBA, developer and team in general.  We will work through many of these things and show some methods to achieve a higher state of database Zen.

Description

Join Microsoft Certified Masters, Wayne Sheffield and Jason Brimhall, as they examine numerous crazy implementations they have seen over the years, and how these implementations can be murder on SQL Server.  No topic is off limits as they cover the effects of these crazy implementations from performance to security, and how the “Default Blame Acceptors” (DBAs) can use alternatives to keep the developers, DBAs, bosses and even the end-users happy.

Presented by:

wayneWayne Sheffield, a Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 20 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles atwww.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne

 

 

 

JasonBrimhall

Jason Brimhall has 10+ yrs experience and has worked with SQL Server from 6.5 through SQL 2012. He has experience in performance tuning, high transaction environments, as well as large environments.  Jason also has 18 years experience in IT working with the hardware, OS, network and even the plunger (ask him sometime about that). He is currently a Consultant and a Microsoft Certified Master(MCM). Jason is the VP of the Las Vegas User Group (SSSOLV).

 

 

 

 

Course Objectives

  1. Recognize practices that are performance pitfalls
  2. Learn how to Remedy the performance pitfalls
  3. Recognize practices that are security pitfalls
  4. Learn how to Remedy the security pitfalls
  5. Demos Demos Demos – scripts to demonstrate pitfalls and their remedies will be provided
  6. Have fun and discuss
  7. We might blow up a database

kaboom

 

There will be a nice mix of real world examples and some painfully contrived examples. All will have a good and useful point.

If you will be in the area, and you are looking for high quality content with a good mix of enjoyment, come and join us by registering at this eventbrite site.  There are only 30 seats available for this murder mystery theater.  Reserve yours now.

Between now and November 8th, the registration is discounted to $99 (plus transaction fees).  Use this code for the discount: SQLSATDC.

Shameless plug time

I present regularly at SQL Saturdays.  Wayne also presents regularly at SQL Saturdays.  If you are organizing an event and would like to fill some pre-con sessions, please contact either Wayne, myself or both of us for this session.

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.

SQLSat 83 – Johannesburg

Comments: 1 Comment
Published on: April 28, 2011

Awesome news.  I submitted a presentation for SQLSat 83 in Johannesburg South Africa for May 7, 2011.  I saw that they were opening up the presentation schedule a little bit to allow for remote presenters and I decided to give it a try.

I got an email notification yesterday that my presentation has been accepted and I will be presenting – woohoo.  If you are interested, you can see the presentation schedule here.  My presentation will be similar to the last time I presented at SQLSaturday in Salt Lake City – but with some refinements and hopefully a better overall presentation.  I will be sharing some of the tools/scripts I use to help learn more about an environment as I inherit a database.

Here’s the fun part – I will be presenting from my home in Utah which is 8 hours behind Johannesburg.  At the time of my presentation (12:15 PM there) it will be 4:15AM local for me.  That should make for an interesting presentation if I am groggy. ;)

If you are in the area at the time of the event (in Johannesburg), I highly recommend you make it out to some sessions.  From looking at the lineup, there appears to be some really good stuff to be presented.  As we get closer to May 7th, I will post more information.  For now, I need to go clean up my slidedeck and get it submitted.

Parting note:  I am glad I was selected for this SQLSaturday.  If you read my SQLPeople interview (here), you may recall that I lived in the area for a couple of years.  I only passed through Johannesburg when returning home but have always wanted to go back and visit.  It has been quite some time and I have yet to make it back.  At least now I can do it virtually!

SQLSat 54

Comments: No Comments
Published on: October 1, 2010

Wow, I have really been kinda slow in the blog department for a couple of weeks now.  I have a few things in queue that i will be letting out within the next week.

I got notice today that I have a presentation on the slate for SQL Saturday #54 – woohoo.  I was honestly unsure of whether I would be able to present.  I was hopeful but this is a new venture for me.  I hope to get to meet some of you at SQL Saturday 54.

You can find more info on it here.  You should be able to read my little blurb for the presentation as well as find a bit of a bio about me there.

BTW, I am a bit stoked to be able to do this in the community.

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.

Another Presentation Down

Categories: News, Professional
Comments: 2 Comments
Published on: March 11, 2010

This evening I had the opportunity to once again give a presentation at our local SQL Uses Group (SSSOLV).  I went into the presentation with the hope of trying to encourage participation and group discussion.

I think the presentation started off a little shaky for a couple of reasons.  I had sent out an email requesting additional info to help prep for the presentation – however, I sent it late which impacted the feedback.  I also didn’t review the PASS Monthly slide deck and sort of shot from the hip going through that stuff.

Despite that, the presentation went well.  I had several people give good feedback.  They liked the presentation!!  Participation really went well and it felt more like a conversation than a presentation – that is a good thing.

Probably the best thing to come from the presentation was the resounding support in favor of trying to get a SQLSaturday down here.  With that info, it looks like I will be starting the process to host a SQLSaturday and organize it from our side.

Another benefit to be derived from this presentation is a growing warmup that has been happening with the group.  Each presentation I have given has improved in group participation.  That would be coming from both sides – I am sure.  Going back to some of my early blogs about participating in the Local User’s Groups, I want to reiterate how good it feels to participate.  I am glad I have had the opportunities to present.

Presentations – Lessons Learned

Categories: News, Professional
Comments: No Comments
Published on: January 14, 2010

This will be a very short entry.  I just wanted to share a few things  I learned very quickly while prepping for my most recent presentation for SSSOLV (Las Vegas PASS).

First, while doing the slides and testing the SQL, it dawned on me that I could probably fix one of the flaws in my first presentation very easily.  I did some checking and voila – it was indeed a very easy fix.  The problem that needed fixing was readability of SQL code on screen during presentations.  I tried using the magnifier, but that was horrific.  So for that presentation, I dealt with it.  It was very aggravating.

So, how did I fix it for this time around?  I changed the font size.  From SSMS, click tools and then options.  Under the environment option, select Fonts and Colors.  There is a Size dropdown menu on the right.  I changed that setting from the default of 10 to 20.  The code was plenty big to read now.

The same can also be done for the results.  Just change to “Grid Results” in the “Show Settings For” dropdown.  The default is 8, I just double this to 16.

Changing the “Grid Result” setting does require a Restart of the “Grid Result” which turned out to be a Management Studio restart for me.

Second, was something that ticked me off while prepping the slide deck.  I didn’t have an issue with this during the last presentation, and it was a monstrous issue this time around.  Sometimes it is nice to add custom animations to the slides to help hide and reveal items as you progress through the discussion.  The animations on images were not working.  The images were just laying on top of each other, doing nothing and looked like crud.  This too, is a simple fix – though tedious.  To get an image to perform the custom animation, it must be an attached image.  A pasted image will not work.  Once the image is saved as a “jpg” for example and then attached to the slide – the animation will work as expected and the slide will look more professional.

Third, to help the presentation flow, is to make sure all SQL connections are open and running.  I thought I was ahead of the game by having all of my scripts open in SSMS and ready to go in the order that I need them.  Well, my system went to standby while waiting for my turn to present.  When the system went to standby, all of my connections closed.  I didn’t think of this prior to starting my presentation.  This too is easy to fix – it just requires a mental note.  Prior to starting the presentation, and even prior to plugging in the connector for the projector – verify the connection state of any open scripts in SSMS.

Fourth, to save any embarrassment, run through your slides one more time close to presentation time.  Make sure they make sense.  Make sure any thoughts you want to bring up are noted on the slides or can be keyed from something on the slides.  And verify the look, flow, feel, and function of the slides.  The slide deck could be a useful tool along with any scripts to distribute to the group.  You will want to know that they are flawless.  Consider this as your final opportunity to edit and revise.

Lastly, build in some question and answer segments.  Invoke the group to participate.  Get them to help carry the presentation.  This will not only  help save your voice, but it will also help the group to stay in tune with the presentation.  This is less of a lesson learned, and more of a reminder.  I try to do this in any setting where I may be presenting (school, church, job).  This can easily be done with a slide insert labeled “Discuss” or “Why” or “Questions.”  Anything that will remind you and notify the group that interaction is forthcoming.

page 1 of 1




Calendar
September 2014
M T W T F S S
« Aug    
1234567
891011121314
15161718192021
22232425262728
2930  
Content
SQLHelp

SQLHelp


Welcome , today is Monday, September 22, 2014