Skip to content
John Perry

Business Intelligence, Data Warehousing, and beyond…

Primary Menu
  • Home
  • About
  • Contact

Day: August 27, 2015

  • Home
  • 2015
  • August
  • 27
By John Perry August 27, 2015January 29, 2019 ETL

Debugging and Troubleshooting Code in SSIS Packages

Code and language-based developers may be initially turned off by the overwhelmingly GUI-based nature of SSIS packages. I’ll admit, I was. Thankfully Microsoft didn’t forget about us code geeks. All Hail the Script Task The Script Task allows developers to utilize VB and C#, and more importantly opens up the .NET Framework, which

Continue Reading
Load More Posts
Categories
  • Database Administration
  • ETL
  • MicroStrategy
  • Software Engineering

You may also like

By John Perry December 29, 2017January 29, 2019 MicroStrategy

How to Increase MicroStrategy Mobile Performance

While desktop users are accustomed to waiting for large reports and dashboards to load, mobile users expect nearly-instant results. Getting those results can be a challenge, and since MicroStrategy doesn’t offer many tips to increase or improve mobile performance, I’ll share a few nuggets I’ve learned from my experience optimizing

Continue Reading
Database Administration

DBA Tools of the Trade: SQL Job Visualizer

ETL

Debugging and Troubleshooting Code in SSIS Packages

Database Administration

CXPACKET Waits and High CPU Usage

John Perry

Business Intelligence, Data Warehousing, and beyond…

Copyright All right reserved. Theme: Knight by Themeinwp

How to Increase MicroStrategy Mobile Performance

DBA Tools of the Trade: SQL Job Visualizer

Debugging and Troubleshooting Code in SSIS Packages

CXPACKET Waits and High CPU Usage

MicroStrategy Information Window INCEPTION

Failing Backups and FlushFileBuffers

Design Patterns Quick Reference