Here are Our Latest Publications

SQL Server Synonyms and How to Leverage Them in an ETL Process

In 2005 Microsoft introduced the synonym functionality for SQL Server. While Synonyms are not something SQL developers are likely to use on a daily basis, they are very powerful and useful, despite being relatively simple. They are essentially a placeholder that can be used as a static value in a ...

Read The Full Post

The Costs of (not) Catching Up

Technology is used in companies to improve efficiency, reduce the possibility of human error, and increase productivity. Once a technology stops doing these things because it slows the process, crashes, and constantly requires maintenance it is time to update. Unfortunately, it has become all too ...

Read The Full Post

Beginner’s Guide to Web Accessibility

Today, more people are accessing the world wide web, and using a wide variety of devices and assistants to do so, than ever before. This means it is crucial that your website works properly with all the different ways your user’s can interact with your website. Unfortunately, for many small- to ...

Read The Full Post

Awesome Apps in Microsoft 365 You Probably Don’t Know About!

Maybe you’re looking for software that allows your employees to collaborate from anywhere in the world with cloud-based services, the latest programs and robust security. Or maybe you’re already investing in technology like the Microsoft 365 platform but have only scratched the surface and want to ...

Read The Full Post

An Introduction to Microsoft Teams

A component of Microsoft 365, Microsoft Teams takes teamwork to the next level with intuitive navigation and on-point features that make doing business even easier. Let’s take a closer look!

Read The Full Post

The Importance of Data Backups

Backups are an essential, yet often overlooked and misunderstood, part of every organization. When the computer systems are running well, the topic gets shoved to the bottom of the meeting agenda and easily forgotten.

Read The Full Post

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 ...

Read The Full Post

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 ...

Read The Full Post

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.

Read The Full Post

Data Denormalization Made Easy

Power BI Query Editor Value and Table Columns Data stored as part of a transactional data processing system, for example a database to information on package deliveries, is often difficult to work with when it comes time to explore that data or create reports. This is because of a process called ...

Read The Full Post

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.

GET STARTED

Where Does Power BI Fit in Our Data Journey?

Power BI is the newest business intelligence offering from Microsoft. It’s a product that a lot of people have been talking and thinking about for the past year or two, and it is gaining more and more traction every day. I like to refer to it as “The best tool that people don’t realize they should ...

Read The Full Post

Power BI Connection Types

The most common way to use Power BI is to import the data into Power BI and define the structure of the data model there. In many situations, this is the best way to use Power BI. However, it is not the only way to use Power BI.

Read The Full Post

Why Technology Best Practices are Critical

As with many things in life, technology sometimes allows you to take the “easy way out.” For example, you have been working hard on implementing the new Exchange server and you hit a road block. The install won’t complete. You do some digging and find out what the issue is, then you come to a ...

Read The Full Post

Preventing Cross Site Request Forgery

Cross Site Request Forgery (CSRF) is an attack against web applications that forces users to execute unwanted actions within the web applications that they are currently authenticated. By sending a malicious link via email, social network post or chat, an attacker may trick users of web ...

Read The Full Post

Backup. Restore. Repeat. Your System Backup Survival Guide.

By Tim LaPean, SCS Infrastructure Consultant

Read The Full Post

Dynamic SQL Search Performance

Recently SCS was approached by a client and presented with an interesting problem: frequently, their data management application – a critical piece of their business model – would grind to a halt. Searches would take many minutes to complete, if they completed at all. Important reports which ...

Read The Full Post

Who is SCS?

Superior Consulting Services (SCS) is a Microsoft Gold Certified technology firm providing innovative solutions that enable our clients to solve business problems. We use Microsoft products and tools to provide custom solutions to small- to medium-sized businesses in the Twin Cities, as well as ...

Read The Full Post