Archive for the ‘Justin Taylor – Blog’ Category
The Rise of the Texas Wide Receiver
Feb 5, 2014 was National Signing Day. Every major sports outlet covered which high school football students signed with big time college program. I thought I’d throw in my own visualization about how the players from the state of Texas faired in the signing day. I know that the offensive systems in Texas high schools […]
Read MoreSSIS Deploy Error – Access is Denied
Here’s a quick problem I ran into in some recent work and the fix I found. I had been deploying my solution from my local machine to the development server with no issues. I decided it was time to deploy to the production server, but of course, things never go as planned. I was using […]
Read MoreSell an IT Project Using Waterfall, Manage It Using Agile
Today, there are plenty of examples of companies using the traditional waterfall project management methodology as compared to the agile methodology. Both methodologies are valid and have ample potential for success. That success always depends on the discipline of the project team and business. In my experience, it seems that most consulting firms pitch IT […]
Read MoreCollege QB Stats Visualizations
As a former Texas A&M athlete, I’m a bit biased towards Johnny Manziel and his ability to make plays. I believe he is the best player on the field, and I’ve always looked forward to seeing him play. Besides that, everyday in my professional life, I look at data for my clients and try to […]
Read MoreEnabling SSIS Packages On Demand
In work with a current client, they required that the execution and processing of certain packages to be configurable via a web interface. In my case, I wanted to proactively enable/disable the importing of certain data sources. If a source system goes down or is in maintenance mode, I need to be able to shut […]
Read MoreExecuting an SSIS Package Based on a Variable
On my current client, I’m using Microsoft SQL Server 2008 R2 and SSIS, Integration Services. I’m updating the data warehouse fact tables every hour, but there is a fact table that only needs to be updated once per day. This is mainly because Is able a it’s art long. It’s nba tip off 2014 me. […]
Read MoreUsing Both The Waterfall And Agile Methods
Today, there are plenty of examples of companies using the traditional waterfall project management methodology as compared to the agile methodology. Both methodologies are valid and have ample potential for success. That success always depends on the discipline of the project team and business. In my experience, it seems that most consulting firms pitch IT […]
Read MoreSSRS – Applying Parameter Default Value Using Custom Code
On a recent client engagement, I had to put in some default values for my parameters. No big deal. Normally, I just use the DEFAULT property of the Report Parameter, but this time was a little different. I needed to default the parameter to a different item depending on another selection of a report parameter. […]
Read MoreMicrosoft Announces SQL Server 2014 during Microsoft TechEd 2013
Last week during Microsoft TechEd 2013, Microsoft announced plans to incorporate in-memory OLTP in SQL Server 2014. They also expanded on some features included in the upcoming release.
Read MoreReducing the Risks in an Analytics Implementation
This insightful industry view offers several important concepts to help you avoid some risks when building an analytics solution. Topics include tool expectation issues, internal resistance to change, poor data quality, scope creep…
Read More