Keys to Successful SharePoint Administration for the DBA – SQL Saturday Nashville 2016

It is an honor and I am excited to be speaking at the January 16th, 2016 installment of SQL Saturday Nashville (#SQLSatNash). I will be doing a ‘spotlight’ 90-minute session covering the keys to being a successful SharePoint administrator, with a focus on database administrators who might have inherited a SharePoint farm or have been tasked with implementing it. We will cover common SharePoint misconceptions & use live demos to show frequently performed tasks. Lastly we will cover the training options and other resources available to make your job easier and more automated.

With the extended time I plan on diving a little deeper than I could with a regular 60-minute session – highlighting automation tools/methods, how to document your farm and troubleshooting common issues. My session is right before lunch, so it will be easy enough to carry the conversation over into lunch if attendees want to continue.



[UPDATE]
The event was a great success and I really enjoyed spending time with the attendees. We were able to have a great conversation about SharePoint as it relates to a DBA, even with a small projector problem 🙂

The slides can be found here: SQL Saturday Nashville 2016

Twin Cities SharePoint Saturday 2015

I was really excited to be selected to speak at this year’s SharePoint Saturday Twin Cities in Minneapolis. It is known as one of the best SharePoint Saturday (SPS) events and I now was going to see the event first-hand!

I had a little fun with the promotion of my session at the event, given that #SPSTC was only a few days after #BackToTheFutureDay (October 21st, 2015).

CRdUAziWcAAggrL.png large

The speaker dinner was excellent; great location, food, and a relaxed atmosphere. I had the opportunity to catch up with organizers and other speakers, some of which I hadn’t seen since the Microsoft Ignite conference in May. The organizing committee was awesome and we all had a great time enjoying the fun items in our speaker bags.

IMG_2886

Saturday morning arrived and with over 500 people in attendance, I knew the day was going to be fun! CSFtuU-U8AEo1mP.jpg largeCSFosT4XAAANuc9.jpg large

I had a room full of people eager to hear about Tuning SQL Server for SharePoint. The group had a lot of questions and was very interactive…and fun? Smile

IMG_2924

As is the norm at SPS events, there were some fabulous speakers delivering world-class content. After the giveaways, some of the organizers and speakers went to dinner to wrap-up a fun day. Thank you to all the organizers, volunteers, sponsors, and other speakers – I am sure to return for the announced Spring 2016 edition of #SPSTC!

IMG_2947

Download the deck from my Tuning SQL Server for SharePoint session.

Cincinnati SharePoint Saturday 2015

I was honored to speak at this year’s installment of SharePoint Saturday (SPS) Cincinnati – is was a spooktacular event!

CQ-R0YVW8AABcnb.jpg large

Every year the organizers of #SPSCincy do a Halloween theme and this year, all the speakers were given football jerseys to help them with their costume. Others, well, they brought there own: CQ9iFdoUwAAxR5s.jpg largeCQ9op0KWgAAmv9f.jpg large

When I arrived at the event, the theme was in full swing – decorations and people dressed as their favorite gorilla, princess, or Star Wars character.

I attended several great sessions during the day – if you aren’t attending SPS events, you are really missing out on high-quality, free content! As I prepared for my session, I grabbed a quick pick with those initially in the room: CQ-0y-XUYAAJIY4.jpg large

The organizers and volunteers did an excellent job – SPSCincy was a huge success!

Download my deck for my Out of the Box SharePoint Solutions session

Louisville SQL Saturday 2015

As it turns out, my last scheduled SQL Saturday event for 2015 was one of the closest – #SQLSat403 was my first time at the event held in Louisville, but I hope it won’t be the last!

The speaker dinner was held at a great restaurant that was known for is delicious food – even featured on one of the TV cooking shows! We all gathered around tables and talked shop, family, work, and stuffed our faces with a lot of pizza. CNIBpQtVEAAFcu8.jpg large

My session, Keys to Successful SharePoint Administration for the DBA, was slated later in the day, so I was able to attend several sessions throughout the day.

Untitled

I had a smaller group of attendees, so the session was even more interactive than normal and I really enjoyed it. This is was the first time I attempted to use Microsoft Sway as a presentation method. The week prior I spent a lot of effort taking my existing slide deck into a ‘Sway’. I was getting Sway advice and tips from Mark Kashman and Chris Pratley, Microsoft GM (and founder of Sway and OneNote) and gave presenting with it a shot.

I started my presentation off and everything was going well, but Sway started advancing twice for every time I clicked once, so I had to abandon it 15 minutes into the session – I reverted back to using PowerPoint and I had no issues moving forward.

The day was capped off ice cream and giveaways. The team also had a twitter-wall on a projector running throughout the day. It was great to see everyone’s comments as they sat in sessions.CNCl88LUAAAevTZ.jpg large

 

I also happen to win something – so that was cool too!

Download the Keys to Successful SharePoint Administration for the DBA deck from my session

Indianapolis SQL Saturday 2015

I traveled up to the great state of Indiana for SQL Saturday Indianapolis this past weekend.

20150808_181429309_iOS

My session went well, except for the demo. I performed a SharePoint 2013 install using PowerShell but the installation didn’t finish. The most likely reason is that the virtual server host was busy (disk I/O). Oh well, the process had completed some steps and I was able to show databases without the GUID – which is kinda the point.

Untitled

I also attended Mike Lawell’s Execution Plans for Mere Mortals session. A lot of the information was new for me, but that is why I love going to SQL Saturdays – I stretch my knowledge.

Execution plans CL6BYiTWoAA9fDJ

Right after Mike’s session, Robert Verell gave his second session of the day, Know Your Role(s)! One of the things Robert talked about was not giving db_owner rights to accounts. Which came up in my session when Robert asked if SharePoint service accounts, namely the Farm account, can have the db_owner rights removed from databases.

CL6SbYSVEAApSa7

Special thank you to Hope Foley and the rest of the #SQLSatIndy team – it was a great event! I hope to be able to make the event next year.

CL6fFAIWwAAoJM_CMDjGLAUAAA98bfDownload the Keys to Successful SharePoint Administration for the DBA deck from my session

Chattanooga SQL Saturday 2015

It was a such a great pleasure being part of the first SQL Saturday in Chattanooga!

I arrived on Friday for the speaker dinner. Larry Ortega and the rest of the organizing crew did an excellent job with the dinner and getting #SQLSat410 started off.
20150626_235649000_iOS

Another plus for the event – right outside my hotel was the Jurassic Park vehicle and the Mystery Machine (Scooby Doo van).CIgTLptWsAAjZt4

On Saturday, everything seemed to run very smoothly and attendees were ready to get their learn on.

CIgkjIIUcAI8l42

My presentation went well – even the demo worked! The group was awesome and we had a productive conversation.

Untitled

Download the deck from my Tuning SQL Server for SharePoint session.

Atlanta SQL Saturday 2015

It was a great honor to speak at SQL Saturday Atlanta this past Saturday. This event is known to be a good one with large attendance, high-quality speakers, and a great organizing committee. #SQLSat392 was a huge success!

CFICAm4WEAA7nUd

This year’s theme was Back to the Future, and along with movie references in the event materials, speaker shirts, and signage, there was a DeLorean parked out front!

CFICYxBWMAAJGOG

My session, Tuning SQL Server, went well – great conversation from the attendees and the topic was received really well. I learned a few things as well, so I will apply that to my upcoming speaking opportunities.

Robert Verell, who lives in the same part of Tennessee as I do, was a speaker as well and we had a little fun in the sun after the event.

CFNW4OQW8AAvAniCFNWnaWXIAAvbFp

Download the deck from my Tuning SQL Server for SharePoint session.