SQL Server and BI/BA With A Smile: March 2017

Tuesday, March 21, 2017

SSIS Articles on SQLShack

Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package or packages. The parameters are at the project level so you only have to change them once to effect multiple packages.

I use a simple example like changing the database name and server (instance) name for the Project level Connection Manage WHICH is another big change for SSIS. Starting in 2012, you can share connections among packages in a project. Enjoy!!!

Parametering Database Connection in SQL Server Integration Services

Deploying Packages to SQL Server Integration Services Catalog (SSISDB)

How to execute a Deployed Package from the SSIS Catalog with various options

Friday, March 17, 2017

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta. The presentation will be shorted than typical meetings, lasting 20-30 minutes.

But, the session will provide great insights into changes in Excel Pivot tables. You can register for the session at http://excelbivc.sqlpass.org or https://attendee.gotowebinar.com/register/3161827486429234947

Featured Presentation: Improvements to Excel Pivot Tables

Alexander Lahuerta, Program Manager Microsoft

The Excel team is working on several interesting new features to Excel. Join us to take a look at some really interesting improvements to Excel that are soon to be released.

About Alexander:
I’m a Program Manager on the Excel Team at Microsoft. I’ve been here for three and a half years. For the past two years, I’ve been diving deep into Business Intelligence and making it easier for people to dig into their data. I want you to love PivotTables as much as I do.

Wed, Mar 22 2017 15:00 (UTC+00:00) Dublin, Edinburgh, Lisbon, London

Improvements to Excel Pivot Tables

RSVP: https://attendee.gotowebinar.com/register/3161827486429234947

About Thomas LeBlanc

Thomas LeBlanc (Microsoft MVP in Data Technology Platform) is a Data Warehouse Architect in Baton Rouge, and uses his 28+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, Power BI, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is past chair of Data Arch VC & Excel BI VC  and involved with Baton Rouge SQL Server User Group and volunteers for SQLSaturday.