11 Mar 2014
By Allen
0 Comments
How to set OLE DB Source data in SSIS

How to set OLE DB Source data in SSIS

SSIS, , ,
Sometimes I have to learn things repeatedly before it sticks.  I re-learned this tip from Tim Costello at last night's Oklahoma City SQL User Group presentation.  We will get his presentation up soon. First, a big thank you to Tim Costello for coming to Oklahoma City to speak at our user group.  Check out his site for more tips.  This tip was just one tidbit from his presentation "Pro Tips: Tuning the data flow in SSIS".   Watch for him at a SQL Saturday near you.   Why you need to set IsSorted property on the OLE DB Source When preparing…
Read More
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
17 Aug 2013
By Allen
0 Comments
SSIS 2012 Parameters vs. 2008R2 Configurations

SSIS 2012 Parameters vs. 2008R2 Configurations

Microsoft SQL Server, SSIS, , , ,
Update 8/17/2013: The SSIS Project downloads have been updated below. Abstract: In this session, Allen Smith, Business Intelligence consultant, compares SSIS Parameters in SQL 2012 to SSIS configurations in SQL 2008R2. The 2008R2 options allowed dynamic configuration across environments.  In SSIS 2012 we review the new dynamic options, including Parameters and Catalogs. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so anyone with basic SSIS experience can follow along. Special thanks to our friends at GDH Consulting for hosting the December meeting of Oklahoma City SQL User Group. SQL Integration Server developers need…
Read More
06 Aug 2013
By Allen
0 Comments
Upcoming Speaking Events

Upcoming Speaking Events

Uncategorized, ,
Allen Smith will be presenting business intelligence topics at upcoming SQL PASS events. Upcoming speaking engagements: Tulsa SQL User Group When: Thursday, August 8th, 6:00 PM Topic: SSIS Parameters vs. Configurations In this session, we will review configurations in SQL 2008R2 which allowed dynamic configuration across environments. SSIS 2012 expands our choices with new options, including Parameters, Expressions and Variables. This upgrade takes SSIS from simply confusing to downright confounding. We will simplify these options so anyone can follow along. SQL Saturday #223, Oklahoma City When: Saturday, August 24 Topic: Sharing SQL Data in SharePoint Microsoft SharePoint is a collaboration…
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