Skip to main content

Here are Our Latest Publications

The SCS Associate Consultant Program
Traditionally, Superior Consulting Services (SCS) has hired consultants who bring years of experience in their respective field. Experience can be important in a consulting environment. However, in today’s ever-changing technology world, the ability to continually engage with and master new ...

Paul Purington Celebrates 20 Years!
We’re so proud of Paul and we’re thankful for his years of services as well as his continued exemplification of our Core Values: Ace – Heart – Ally. We sat down with Paul to discuss his 20+ years with SCS, to ask him what he thought of this milestone, what he loves about working at SCS and more.

Our Memorial Day Traditions!
What is your favorite Memorial Day recipe? Travis Thompson: Anything cooked on the grill! I usually BBQ chicken thighs and my wife makes either potato salad or pasta salad.

Working with Superior Consulting Services: What To Expect
At Superior Consulting Services, we are not a staffing agency. We are a consulting firm that delivers dynamic solutions. Our highly trained consultants keep current with the latest technologies and certifications. We partner with our clients to design and implement solutions for a gamut of business ...

Simplifying Processes with a New Scheduling Application at FIMC
We’re receiving excellent feedback on our end-of-the-year SharePoint install at FIMC. Everyone seems to be commenting on improved communication and easier project collaboration. It was a smart move by John and Dustin and is really propelling FIMC forward in terms of connectivity and efficiency. As ...

Reasons to Rewrite Applications
With the rapid evolution of user needs, technologies and processes, applications can quickly become antiquated. While developers work hard to maintain their relevancy, there are ultimately a plethora of arguments for rewriting applications. In this post, we will explore many of these arguments in ...

Querying Role-playing Dimensions with DAX
In data warehouses across many industries, it is common to have multiple foreign keys on a fact table that relate back to a single dimension, such as Date, State or Person. Let’s use Date as an example and look at the Order fact for a company. It is realistic to have multiple dimension keys in the ...

Exciting Developments in Application Development
The following is a summary of a virtual discussion that took place between members of the application development team at Superior Consulting Services. It highlights a number of the current trends, techniques and technologies in the application development space.

SharePoint Install at FIMC
After helping get FIMC back on their feet following the August ransomware attack, we finally got the SharePoint install underway. Although we were hoping to start in September, as a technology consulting company we recognize that sometimes unexpected events occur. Urgent situations need to be ...

Simple C# Model to SQL Server Stored Procedure Mapping using XML
When it comes to data access, I like to keep it simple. I prefer the database be exclusively responsible for database actions using stored procedures to execute queries and updates. I also like to avoid mapping lots of parameters in stored procedures. At other times, there’s a need for a way to ...

Improve Your Performance and Profitability Today

SCS uses best-in-class tools to deliver database, reporting and data platform and analytics solutions. We partner with your team to develop custom solutions.

Superior Consulting Services Responds to Recent Ransomware Attack at FIMC
Recent Ransomware Attack at FIMC As much as we would love to be updating you on our much-anticipated SharePoint install and data warehouse build, sometimes we’re forced to put the brakes on our plans in order to accommodate unforeseen events. Such is the case recently at FIMC.

SCS Featured Team – Data & Analytics
We would like to introduce you to our Data & Analytics team at SCS. Meet Paul, Tim H., Elle, Tim L., Brian, Michael, Erin & Sachin! We took some time to ask them to look into their crystal balls and to give us their predictions for the future of data & analytics. Scroll down to read ...

Reporting Services – Filtering Data by Current User
You’ve hit the home stretch of a data warehouse solution for your organization. Congratulations, as this is no small feat! All of the dimensions and measures are built and populated, bringing together data from several systems including systems from subsidiaries or partners. The parent company will ...

Utilizing Data Storage Solutions to Increase Workplace Efficiency
FIMC Explores Data Storage Solutions In our introductory post on the happenings at Foam Injection Mold Company (FIMC), we described three major technology solutions that Superior Consulting Services implemented to help them modernize and streamline their operations. One of these tech solutions is a ...

Migrating Reports? It’s Time to Talk
With the functionality, affordability, and beauty of Microsoft’s reporting tools like Power BI and SQL Server Reporting Services (SSRS), many companies are opting to migrate their existing reporting into the Microsoft stack. This effort, while exciting, can be daunting especially if you are looking ...

Superior Consulting Services Provides Technology Solutions That Enhance Business Operations
As experts in analytics and application development, when Superior Consulting Services (SCS) first arrived on the scene to create technology solutions for Foam Injection Mold Company (FIMC) we were pleased with how well the extensive list of business solutions we provide aligned with their ...

Solving a Business Problem with a Message Queue, DebuggableService and XML Serialization
Introduction When working with a client in the hardware maintenance business, I developed an efficient and robust solution to solve a specific label printing business problem. This blog will discuss the business requirement and how I solved it with a simple solution using a message queue, ...

Maximizing SQL Server Integration Services: Adding Functionality
After a bit of a spring break, I’m back! Believe me when I say March Madness is not limited to the basketball court. Hopefully, you have read through the first three blogs in this series and are anxiously waiting for this blog. (Well, I’d like to think you are.) In case you’ve found your way ...

Maximizing SQL Server Integration Services: Defining an SSIS Package Template
In a series of blogs about the design and implementation of solutions using SQL Server Integration Services (SSIS), Part 1 addressed design tasks and whether or not to stage the data in an intermediate database or operational data store. Part 2 stepped through the setup of an SSIS project in SQL ...

Maximizing SQL Server Integration Services: Optimizing the SSIS Project Layout
In a series of blogs about the design and implementation of solutions using SQL Server Integration Services (SSIS), Part 1 addressed design tasks and whether or not to stage the data in an intermediate database or operational data store. This may be necessary if the data is being pulled from a ...

Improve Your Performance and Profitability Today

SCS uses best-in-class tools to deliver database, reporting and data platform and analytics solutions. We partner with your team to develop custom solutions.

Maximizing SQL Server Integration Services: Technical Design
Hello! How is your week going? Did you just get slammed with a large, high priority data project? Or, are you in the middle of a project but aren’t sure how to get from point E to point L? If you’ve come across this blog post via a search for SSIS or Integration Services resources, you have come to ...

Move On Premise Servers to the Cloud
Moving on premise servers to the cloud can save you time, money and effort if done correctly. There are many approaches for moving on premise servers and workloads to the cloud, but here we will be focusing on lift and shift today.

HTML5 Introduction: New Semantic/Structural Elements
Introduction This blog will briefly discuss HTML, HTML5, and the new HTML5 Semantic/Structural Elements, as well as why you should use HTML5, and how one could migrate an HTML4 formatted document to an HTML5 format.

Microsoft Recognizes Superior Consulting Services’ John Gnazzo as Most Valuable Professional for Third Time
Minneapolis – August 22, 2017 – Superior Consulting Services (SCS), a technology firm that combines highly experienced IT professionals with Microsoft products and tools to solve business problems, today announced John F. Gnazzo has been recognized as a Microsoft Visual Studio and Development ...