28 Apr 2015
By Allen
0 Comments
Want to Be a SQL BI Consultant?

Want to Be a SQL BI Consultant?

Business, Downloads, Featured, , ,
  At the February meeting of the OKC SQL User Group, I presented a session on what it takes to become a consultant. After having done consulting for 8 years, I've learned a few things the hard way and still made a good go of it. Here is that presentation for download. [download id="870"]   This download does not constitute any legal or accounting advice.  By downloading you assume all risk for yourself getting into business, after all, that is part of being an entrepreneur. Best wishes in all your endeavors. Allen
Read More
20 Oct 2014
By Allen
0 Comments

My Intro to SQLFamily

Uncategorized, ,
By trade, I'm a Cognos BI developer that jumped the fence to MS SQL BI a few years ago. My first encounter with SQLfamily was at SQL Saturday #63, April 2, 2011 in Dallas, Texas. First SQL Saturdays and SQL Rally I came to a SQL Saturay #63 pre-con to learn more about the BI stack.  There, I met Sri and learned about the North Texas User Group.  I didn't know anyone in town or in SQL, so after the pre-con Sri Sridharan and the NTSUG people welcomed me into their group, invited me to dinner, invited me to volunteer…
Read More
18 Aug 2014
By Allen
0 Comments
Tulsa TechFest Presentations

Tulsa TechFest Presentations

Microsoft SQL Server, SSRS,
Thank you to all who attended my sessions at Tulsa TechFest. It was my first time to attend TechFest and I really enjoyed it. I do ask for an email address for downloads, so I can stay in touch to see if you have questions or need help getting the demos to work. I will never sell or share your email info. Business Intelligence Basics: Finding Return on Data This session will you chart the waters through the sea of Business Intelligence (BI) options. IT departments need tools to turn data into useful information for users. Instead of ROI, this…
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