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

Building Business Intelligence Dashboards with SharePoint Data – December 1st 2015

I will be co-presenting at the Nashville Business Intelligence User Group meeting this month. We will be walking attendees through creating dashboards using Power BI and I will be focusing on using SharePoint data.

I will show how to use Excel to create dashboards within SharePoint web part pages – first with an export of a SharePoint list and then an import of a SharePoint list into Excel. We will discuss the benefits and drawbacks of each method.

I will then show linking to the same SharePoint list data using the Power BI Desktop application and then publishing it to Power BI.

[UPDATE]
The meeting went really well – Tammy Clark started off showing how easily Power BI could connect to Facebook data.

I went second and used a SharePoint list I created with Helpdesk data to create dashboards using Excel and SharePoint web part pages. I then moved onto Power BI and ended with showing the cool iOS Power BI app (although it took some time to get it to project from my phone onto the screen).

Power BI iOS App
Helpdesk sample data within Power BI iOS app

Dan Evans then made a couple of announcements about Cortana and Power BI integration. Kerry Tyler finished off the night rocking our Power BI world with a demo that had us saying “wow!” πŸ™‚

Nash BI December 2015 Meeting
Business Intelligence User Group Meeting Attendees

We finished the night at a new restaurant around the corner called Tupelo – fried green tomatoes, pork egg rolls (they were fantastic!!), and chicken and biscuits were enjoyed by all!

Tupelo Honey Cafe
SQLFamily Night at Tupelo Honey Cafe