Tag Archives: development

Speaking at the West Virginia SQL User Group

I am presenting SQL Server 2008 for Developers  at the West Virginia SQL User Group (WVPASS) meeting on February 17th at 6PM.  The meeting is free, open to the public and pizza will be provided.  If you’re in the area (Pittsburgh peeps this includes you) they would be glad to have you.  Registration is still open for the event.

I also submitted two abstracts to SQL Saturday #75 in Columbus, OH. The abstracts are SQL Server 2008 for Developers and Evaluate your Daily Checklist with Policy-Based Management and Central Management Server. The event is scheduled for June 11th. I hope to see you there!

Wheeling, WV to Houston, TX – A SQL Saturday #57 Recap..

Everyone, If you attended SQL Saturday #57 in Houston, TX thank the host and the sponsors. With out their dedication and hard work this event wouldn’t have happened.  Finally, if you haven’t done so submit a speaker evaluation for the sessions you attended.

Now that the basics are covered lets move on to the recap.

Why Houston?

Last week I took a trip out to H-Town to speak at my eighth venue in the last twelve months.  Family was a huge motivator for attending SQL Saturday #57.  Being a graduate of James E. Taylor High School in Katy, Texas I was able

John Sterrett SQL Server 2008 for Developers Presentation

If you build it they will come!

to double dip and visit my parents and my oldest brother.  I flew in on Thursday to surprise my father for his birthday. I got an extra bonus when I arrived.  I found out that this was also going to be the same day my nephew was born.


On Saturday, we meet up at the church for the first SQL Saturday in Houston. Yes, that sentence is correct.  The Houston Area SQL User Group was able to get the Bammel Church of Christ to host the event. I have to be honest when I found out that a church was going to be used I was skeptical.  Normally, these events are at a community college, university or Microsoft Office.  I wondered if a church be a good venue for a SQL Saturday? I was right, it wasn’t a good venue. It was a fantastic venue.  Kudos to Nancy Hidy Wilson (Blog | Twitter) and the Houston User Group for selecting this venue.

Connecting (Volunteer & Speakers Dinner)

Normally, when I am selected to speak at a SQL Saturday I always attend the volunteer and speaker dinner and the after party. Its a great opportunity to network.  We met up at the Outback Steakhouse in Tomball.  I felt like I was back at summer camp as I hanged out with some friends and also made some new friends. (Thomas LeBlanc, Wes Brown, Ryan Adams, Jen and Sean McCowen, Sri Sridharan, Tim Mitchell and more…)

My favorite quote comes from Sri, “John you cannot say its a once in a lifetime opportunity. Your Steelers are always in the Super Bowl.”

Learning (Presentations I attended)

  • Dean Richards – Best Practices for SQL Server on VMWare
    With the economy changing we all need to find ways to do things cheaper. One of the easiest ways to do this is to virtualize your servers. The concept seams great but SQL Server can be tricky to manage.  How do you configure the guest memory? How does the host share its CPU power with guests? I learned this and a lot more during Deans session.
  • Ryan Adams – Manage Your Shop with CMS and Policy Based Management
    Those of you who know me know I am very excited about Central Management Server and Policy Based Management. I currently use it to evaluate my daily checklist against 100+ instances of SQL Server with 3,000+ databases.  I am extremely interested in seeing how other DBA’s use it.  Ryan is into mirroring and loves the mirroring facets provided with PBM.  I am glad he showed this to me.
  • Thomas LeBlanc – Transition from DBA to BI
    Any time I can sit in the front row on a sofa and watch Thomas speak its a win-win. This talk was special because  I got my learn on and felt like I was at comedy hour.  I enjoyed his path from DBA to BI.  I really liked how he was able to use his DBA skills to make a good first impression.  He also showed us a great spreadsheet out there on the interwebs to build a data dictionary for your facts and dimensions.

Sharing (My Presentations)

  • SQL Server 2008 for Developers (About 30 attendees)
    Every once in a while I submit this topic to see if people are still interested in seeing demos going over the new features provided for developers with SQL Server 2008.  During the presentation I polled the attendees to see who hasn’t migrated to SQL Server 2008.  There still is a crowd that wants to know how to implement DateTimeOffset, T-SQL enhancements,  Merge, Table Value Parameters, Change Data Capture.  I spoke right before lunch and had a few people stay extra to go over a bonus demo.  I also talked with a few of the attendees later in the day and I got some great feedback.If you attend my session please submit feedback.  You can find the slide deck and sample code on my blog.
  • Evaluate your Daily Checklist using CMS and Policy Based Management (5 Attendees)
    My PBM and CMS talk was included in the last session.  This was my first presentation using VMWare Workstation.  I did this for two reasons. One, Brent Ozar made me do it. Finally, I wanted to throw up an instance of SQL 2000 for this demo and I couldn’t do it with Windows 7.  Even though the crowed was small one attendees told me he is going to start using PBM and CMS due to my presentation. This is the greatest complement I could receive. 

    If you attend my session please submit feedback.  You can find the slide deck and sample code on my blog.

Bloggers SQL Saturday #57 Posts

Speaking at PASS Member Summit 2010

I am excited to share with everyone that I am speaking at the PASS Summit in Seattle on Wednesday this week.   The Summit is by far the biggest event for database administrators and anyone who likes to work with data. I would refer to it as the Super Bowl for Database Administrators.  I will be participating in both a chalk talk and lightning talk.

Chalk-Talk is a forty minute interactive talk in the vendor expo hall.  I will be presenting SQL Server 2008 for Developers with a twist.  I will provide a list of topics and the crowd (yes this is you everyone) can pick the topics we cover.  That’s right everyone, even though I think Table Value Parameters is the most under used feature for developers we can skip it if you are more interested in other topics.

Lightning-Talk is a quick five minute talk about anything the speaker wants to talk about.  There is a session each day dedicated to Lightning talks and they will include seven speakers.  I will give a talk over using Profiler to troubleshoot third party applications.  This tip was very important to me when I became a production DBA and I am sure it will help others.

Table Value Parameters with SQL Server and .NET

Have you ever wanted to send multiple insert statements using one round-trip to the database? This month I published a tip on mssqltips.com to do this implementing Table Value Parameters with .NET.  It will be the first of many tips and blog entries on SQL Server 2008 Development as I am schedule to present at a few events across the country.

For more on Table Value Parameters check out my links.

Compare your websites traffic against your competitors

Once upon a time I did software development for a dot.com start-up that did very well.  Highschoolsports.com  is a huge success and eventually got bought by Gannett.  When I worked there we were constantly tracking unique hits.  In the back of my mind I always wondered how we did against other companies.

Today I caught up with a good friend of mine Adolph Santorine (old owner of highschoolsports.com) at tonights Greater Wheeling Chapter of AITP meeting and he showed me a tool I had to throw on here.  Its a web app that allows you to compare your competitors unique hits against yours. 

Give www.compete.com  a try.  It’s a nice tool that just might give you what you need.