23 Aug 2014
By Allen
2 Comments
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
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
14 Aug 2014
By Allen
0 Comments

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
0 Comments
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
1 Comment
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
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
15 Jan 2014
By Allen
0 Comments
SSAS Cube Partition Slice ErrorCode=”3240034361″

SSAS Cube Partition Slice ErrorCode=”3240034361″

SSAS, ,
Slices are a great way to improve query performance in a heavily partitioned SSAS Cube.  The photo above shows where to add or change a Slice properties in partition properties dialog box. If you ever get the following errors when processing cubes, it has to do with the Slicer property at the partition level.  The first error message tells you it is a slicer, the next few messages will indicate which partition puked. This post is sponsored by our partners Wigs <Error ErrorCode="3240034361" Description="Errors in the OLAP storage engine: The restrictions imposed on partition slice where violated." Source="Microsoft SQL Server…
Read More