31 Aug 2013
By Allen
0 Comments
Sharing SQL 2012 data in SharePoint 2013

Sharing SQL 2012 data in SharePoint 2013

SharePoint, , , , ,
I enjoyed presenting at SQL Saturday #223 in Oklahoma City last week.  If you attended, you will find the presentation and Data Solution files below.  The session recording is available at UserGroupTV, thanks to Sean. Session Description: Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session get an overview of the basics of sharing a SQL table as a 'List' using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users…
Read More
10 Apr 2013
By Allen
0 Comments
Getting SQL data into SharePoint

Getting SQL data into SharePoint

BI/DW Projects, Microsoft SQL Server, , , , ,
In March, I was invited to speak at the OKC SQL Users Group and I never got the slide deck posted. So here it is to help get you started. Sharing SQL data in SharePoint from Allen Smith Session Level:  Beginner SQL and Beginner SharePoint Session Abstract:  Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we will start with the basics of sharing a SQL table as a 'List' in Sharepoint. Next we move on to fun stuff of integrating SQL Server Reporting Services integration.…
Read More
05 Jun 2012
By Allen
0 Comments
SQL Rally 2012 BI Track Highlights

SQL Rally 2012 BI Track Highlights

SQL Server, SSAS, SSIS, SSRS, , , , , , , ,
When I got back from SQL Rally 2012 a few weeks ago in Dallas, I shoved the notes into my laptop bag and took off for vacation.   I still want to share a few of the highlights of my trip.  These were some excellent speakers and I hope to see them again at future events. Sessions: Tuning Analysis Services Performance by John Welch Presentation John did an excellent job of explaining the basics of the processing options in SSAS. What was interesting was his experience splitting up jobs to increase performance.  Process Full will process all the dimensions and facts…
Read More