Category Archives: Training

Presenting for SQL Saturday Nashville

Recently, I was humbled to be selected to speak at SQL Saturday Nashville over the Martin Luther King, Jr weekend.  I will be presenting “Backup Strategies Are For Losers” at 10:30AM.  This will be my first presentation in Nashville, and I am excited to expand my geographic range.   In addition, I was excited to see some of the big names coming into town.   Don’t believe me?  Check out the schedule for yourself.

Do not forget that there are some excellent pre-cons that start on Friday, January 17th by Denny Cherry, who is presenting “SQL Server Performance Tuning and Optimization” and David Klee is presenting “Virtualization for  SQL Server DBAs.”  Please check those out as soon as you can while space is still available.

If you haven’t registered yet, please do so now!  See you there!sqlsat272

PASS Women in Technology Luncheon #PASSWIT

For the second consecutive year, I had the privilege of sitting at the blogger’s table during the Professional Association for SQL Server’s Women in Technology luncheon at the annual Summit conference in Charlotte, North Carolina.  This luncheon was over a week ago and today is the first chance that I have had to sit down and really put my thoughts together.  Therefore, I apologize for the delay.

The theme for this year’s luncheon was “BEYOND STEREOTYPES: Equality, Gender, Neutrality, and Valuing Diversity.”  The distinguished panel consisted of Rob Farley, Erin Stellato, Cindy Gross, Kevin Kline and Gail Shaw.  The luncheon was moderated by my dear friend Mickey Stuewe.  The bloggers present included Jes Borland, Mark Stacey, Karen Lopez, Grant Fritchey, Jen McCown, Jen Stirrup and Laerte Junior.  As you can see it was very humbling to be chosen amongst that lineup.

It has become a tradition at the #PASSWIT luncheon for men and women to wear #SQLKilts to support the Women in Technology.  Next year, I should be able to wear a kilt, however this year I wore pink in honor of breast cancer awareness month.  This luncheon was very moving for me this year and I found myself caught up in the conversations instead of taking notes.  However, I did manage to grab some very good quotes outlined below:

Gail Shaw was asked if she had to make an effort to fit in within the technology community to which she replied: “No I don’t because I can’t literally be bothered.”

Cindy Gross later said “Every single person is prejudiced about something…”

Kevin Kline said that stereotypes are the index pages because our brains cannot know intimate details for more than maybe 150 people, for the rest we rely on stereotypes.

Rob Farley said for us to “Stand up and be the person who champions what is right.”

Erin Stellato when asked by a question from the floor about how to make it in the industry with all of the stereotypes working against you said “How am I not going to make it?  Push through the stress and win!”

2013-10-17 12.35.26

Rob Farley

2013-10-17 12.42.56

Cindy Gross

2013-10-17 12.49.50

Mickey Stuewe

2013-10-17 13.02.40

Rob Farley and Erin Stellato

Presenting at Summit 2013

Today I was thinking about the SQL PASS Summit which begins next Tuesday and I just realized that I have yet to announce that I was chosen to speak for the very first time at the Summit.  I am so humbled and excited at this opportunity. I cannot begin to thank the program committee, PASS headquarters, and the SQL community enough for everything they have done for me in the past few years.  At this point in my career, I truly feel that my career has exploded thanks to my involvement with SQL PASS.

Rob Volk (b|t) and I had this idea to do a humorous session where we play Laurel and Hardy depicting the interactions between junior and senior DBAs.  It should be a good time for all.  Our session is Wednesday at 3pm, come by and say hi.  Enjoy!

Presenting for SQL Saturday Orlando

This Saturday, I will be presenting “Backup Strategies Are For Losers” at 7:30AM in Orlando.  It should be noted that my first ever SQL Saturday that I attended was in Orlando, so I have a special place in my heart for this event.  In addition, I have never presented a session this early in the morning so hopefully there is a Starbucks close by to the campus of Seminole State College.  Do not forget that there are some excellent pre-cons that start on Wednesday (tomorrow) so please check those out as soon as you can while space is still available.

If you haven’t registered yet, please do so now!  See you there!

A Month, Really?

Wow, I just realized this morning that an entire month has passed since I last blogged.  Surprisingly, much has happened yet I could barely find time to blog.  That isn’t necessarily true, but it sounds better than I’ve been lazy for the last 30 days.

So let’s do a rundown real quick of the last month.  I spoke at the very first SQL Saturday in beautiful Cocoa Beach, Florida and had an amazing time catching up with old friends and meeting new ones.  I completed my dizzying full-time college schedule with resounding success in my first semester back to the glorious University of Florida in pursuit of a Business Administration degree. Last but not least, Rob Volk (b | t) and I were selected to present our Lightning Talk for the PASS Summit in Charlotte, North Carolina.  That is an extremely humbling and terribly exciting feeling.  Our session, titled “DBAs in Toyland: Here’s Another Fine Mess You’ve Gotten Me Into!” is going to be a lot of fun to present as Rob and I are thoroughly enjoying the process of putting it together.  Enjoy!

 

PASS_2013_SpeakingButton_250x250

The Chocolate Beach: SQL Style

I am humbled and honored to have been selected to present my “Backup Strategies are for Losers” presentation at the inaugural SQL Saturday for Cocoa Beach, Florida.  This is SQL Saturday #231 as well as being the first for the Space Coast SQL Users Group, so please make your way to the chocolate beach on July 27th for a great day of SQL Learning.

You can register here, come on you know you want to hit the beach for the weekend.  There is also a group rate code for the Hilton (SQLP), where the event is being held, that expires tomorrow (June 28th).  You can reserve your room here.  However, I will be staying just down the road at the Courtyard where my wife and I stayed on our wedding night before our honeymoon cruise to the Bahamas.  I look forward to seeing you there.  Enjoy!

The Chocolate Beach courtesy of Space Coast SQL User Group

T-SQL Tuesday #41 – Why I Love Presenting

T-SQL Tuesday

This month’s T-SQL Tuesday blog meme is brought to us by Bob Pusateri (blog|twitter) and the subject is “how did you come to love presenting?

For me I am not sure that I am at that point.  I love being a presenter, I love going to the speaker dinners for SQL Saturday events, I love meeting other speakers and talking about presenting, but in all honesty I am not sure that I am in love with presenting.  But I am getting there.  Presenting still terrifies the hell out of me, but it is a fear that I set out to conquer last year as a goal in my personal development plan.

For a long time, if  an activity involved a public speaking component I avoided it like the plague.  Seriously.  I am not kidding here.  I coached Dixie Youth baseball and Pop Warner football and every year I had to give a first practice speech.  I would spend a couple of sleepless nights and I would vomit several times before muttering something from my note cards and then quickly move on to begin the practice.  The last few years I stopped doing it all together and went around to the parents individually and this worked much better for me.  Crisis averted.  Problem put back on the shelf for a later date.

After several SQL Saturdays, I started to think that I could do this again.  Some time ago, I was a consultant that also provided week-long training courses in addition to programming and DBA work in Progress 4GL RDBMS, but all of the material that I presented was created by a team (similar to a Microsoft training course) of professionals.  Whenever I got nervous in those courses, I could always go back into the material as it had notes on the slides.  It was fool-proof, and after doing them over and over I was a pro at it.  But after not doing this for twelve years, the fear took over again.

After presenting a lightning talk in Pensacola, a couple of user group meetings and a few SQL Saturdays, the fight or flight reflex has lessened and the vomiting is non-existent.  I can do this, I am doing this, and I will conquer this.  I can proudly say that I brushed the fear back and now think that I am getting better at this.  I am starting to love presenting, it has a foothold in the depth of my being.  What about you?

Looking for Humorous Backup/Recovery Stories

While preparing my newest presentation, I thought the best way to teach backup and recovery is through humorous stories revolving around horrific backup and/or recovery incidents.  I have a couple, but I thought I would open this up to the SQL community and see if there were some really outrageous ones out there.  I can cite you (or not if you choose to remain anonymous) in my presentation and tell your story to help teach the world about SQL Server Backup and Recovery.   You can simply e-mail me at Ed at SQLGator.com or comment on this post.

Thanks for your help.

Jacksonville SQL Saturday

In less than a month from today, I am honored to be presenting a new session called “Backup Strategies are for Losers!” at SQL Saturday #215 in Jacksonville, Florida.  This is a new session and the first session created after attending Buck Woody’s (B|T) workshop on how to be a better speaker.  If you came out and saw some of my earlier sessions over the last year, then please come back out and let me know what you think.

If you haven’t registered yet, what are you waiting for it is free training!  See you there!

sqlsat215_speaking

Primary Key versus Unique Key

SQL Schoolhouse!

SQL Schoolhouse!

Recently, I was asked the difference between a primary key and a unique key and this seemed like a good topic for a blog post.

First of all, the primary key is the key that will uniquely identify the record and enforce entity integrity.  By default this will create a clustered index on the column or columns selected.  The unique key, like the primary key, will be unique, however it creates a non-clustered index by default.  The unique key will also allow one NULL record where the primary key will not allow any.

In addition, there is only one primary key per table, whereas you can have multiple unique keys.  Enjoy!

 

Follow

Get every new post delivered to your Inbox.

Join 1,080 other followers