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
10 May 2013
By Allen
0 Comments
Business Intelligence Forecasting in SQL and Cognos

Business Intelligence Forecasting in SQL and Cognos

Cognos, SSAS, , , , ,
Note: This article is an update of a presentation given when I was at the University of Oklahoma's Health Sciences Center. At that time, I was using Cognos version 7.3. This article is updated for Cognos 10 and SQL Server Analysis Server 2012.  Revisiting this subject ten years later, my opinion is that Microsoft has finally surpassed IBM Cognos. Most businesses, including medical clinics, want some method for forecasting business trends. The Cognos BI powerplay presentation tools contain the tools needed for basic forecasting.  The trick in getting accurate forecasting is select the correct algorithm. I recommend trying the model…
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
04 Dec 2012
By Allen
0 Comments

What’s New in SQL Server Reporting Services (SSRS) 2012

SQL Server, SSRS, , ,
Everybody has been bloggin about the new features in SQL 2012, so I thought it would be best to just look at one part of the offering.  SQL Server Reporting Services (SSRS) has not gotten a much love but there are a few good improvements.  The list is so short, I covered it in one slide while presenting at SQL Saturday #125 in Oklahoma City.  Let's look at each area a little more. SSRS Data Alerts This is definitely a good improvement from the user perspective.   It allows users (OK, they may need help) to set up subscriptions based on…
Read More
09 Apr 2012
By Allen
0 Comments

SQL 2012 Study Materials

SQL Server, , , ,
This started as my personal list of study materials, but it bears sharing.  I got started studying as I studied for the new SQL 2012 Beta Exams.  You might still get a slot to try out the exams for free over at the Born to Learn blog  Once you choose an exam, follow their link to see the specifics about the exam.  Be sure to click on the 'Skills Measured' tab.  That will show what percent of the test covers different areas. Be sure to take a look at the planned certification paths for SQL 2012.  The paths have changed…
Read More