13 Sep 2014
By Allen
SQL Saturday #300 Kansas City, MO 2014

SQL Saturday #300 Kansas City, MO 2014

Microsoft SQL Server,
This is my second year at SQL Saturday in Kansas City.  I thoroughly enjoy the people and of course the BBQ Crawl.  This year my hands down favorite was Q39.   Of course that's not what your'e here for, so here is the synopsis and download for the BI Basics session.  This slide deck has been updated since SQL Saturday in Oklahoma City. If you are in the market for superclone Replica Rolex , Super Clone Rolex is the place to go! The largest collection of fake Rolex watches online! Session Outline: This session will you chart the waters through the…
Read More
23 Aug 2014
By Allen
SQL Saturday 309 Downloads

SQL Saturday 309 Downloads

BI/DW Projects, Business, Microsoft SQL Server,
Downloads for SQL Saturday #309 in Oklahoma City are below. Thank you to all who attended. Thanks also to all the sponsors who help make these great events possible for the tech community. 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 session talks about 'Return on Data' for IT Managers. In this session we look at the roles of data warehousing, big data and business intelligence systems. The Microsoft BI…
Read More
18 Aug 2014
By Allen
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
14 Aug 2014
By Allen

Review – Pragmatic Works Task Factory

Uncategorized
I've been using Pragmatic Works Task Factory to prototype a Business Solution (BI) for a new client and want take a minute to list my likes and dislikes. First, I'm no expert as I've only used it a month but their video tutorials have helped get started. Some of the individual components, such as Slowly Changing Dimension (SCD) component, have older versions available as freeware through Codeplex. The benefit of using Pragmatic Works is having supported compenent versions to keep up with your SQL version. Time vs. Money So as a BI consultant, I have to look at tools from…
Read More
12 Aug 2014
By Allen
Speaking Schedule

Speaking Schedule

Microsoft SQL Server, Uncategorized,
I'm looking forward to speaking at the following upcoming events. August 15th - Tulsa TechFest,  speaking about Business Intelligence Basics and SQL Server Reporting Services Basics August 23 - SQL Saturday 309 in Oklahoma City, speaking about Business Intelligence Basics and SQL 2014 Columnstore Indexes September 13 - SQL Saturday 300 in Kansas City,  Business Intelligence Basics Hope to see you there.
Read More
23 Jul 2014
By Allen
SQL 2014 ColumnStore Indexes

SQL 2014 ColumnStore Indexes

Microsoft SQL Server, ,
Recently I was invited to speak at Oklahoma City SQL User Group and Tulsa SQL User Groups about the advancements available in SQL 2014 with Columnstore Indexes. ColumnStore indexes were first introduced as xVelocity with SQL 2012 as a way to improve query performance against large data sets by grouping and storing columns of data instead of rows.  With SQL 2014, those ColumnStore indexes become update-able.   In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance. Allen is a Microsoft Certified Technology Specialist with certification in Business Intelligence Development and Maintenance. His IT specialties include…
Read More
11 Mar 2014
By Allen
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