You are here

IT Consulting

Sync Data Changes with TSQL Merge

The TSQL Merge statement has been around since SQL 2008, but I haven’t had a real need for it until recently. Typically, if you wanted to modify or synchronize data in a table based on some source, you would have to perform separate operations for insert, update and delete. This is where Merge comes in as it allows you to perform those insert, update and delete operations on a target table in one statement by joining to a source table.

Make Better, Data-Driven Decisions

What if you had a secret weapon? A tool that could tell you if a decision was smart before it was made or pointed you in a positive direction? You wouldn’t leave home without it. It would not leave your side. That tool does exist for businesses, with the proper support and training. It is your company’s own data. Your company can hone in on what its data can reveal to not only help you understand your past but, more importantly, to shed some light on your future.

Data as an Asset

The foundation of any business is composed of three things: the products/services offered, the people who keep the company running and the data that demonstrates past decisions and supports future decisions. Data is the backbone of every business. It is filled with useful nuggets of information, detailing past business trends, successes (and failures) and opportunities for growth moving forward. The data can assist your business in many ways, including in the development of new offerings, boosting total revenue and better managing your company’s costs.

Collaboration on the Go

Today, time is a luxury that most of us don’t have in the office. We are constantly on the go, moving between meetings, projects and deadlines. We don’t have time to be strapped to our desks all day in the hopes of completing projects and hoping those collaborating are available at the same time. And, as an added hurdle, more teams are spread out. Every member of your team won’t necessarily be located in the same building. If your team is spread out across the country, waiting by your email for updates is not an option we often have. 

Viewing Executed SQL or FetchXml in Microsoft CRM Reports

One important thing about any CRM system is being able to get data out of the system; in other words: reports. Reports aren't sexy for developers, but they're important for end users.

Sometimes as you're debugging a report, you want to see exactly what was executed by the reporting engine to retrieve the data because something isn't exactly what you expect. You're not sure what parameters are being sent, or maybe you just want to get the full query with real parameters.

10 Best Practices for Integrating your Customer Data

Posted in

Business Intelligence

Data integration is often underestimated and poorly implemented, taking significant time and resource. Yet, it's growing in strategic importance to the business, as customer data and touch points grow exponentially with the emergence of cloud, social and mobile technologies.

Learn more about common integration mistakes and best practices for making your company more agile through data integration.

Simple Salesforce Data Migration

43:53

Posted in

Business Intelligence

You have lots of customer data and you need to ensure that it's readily available to all of those who need it to drive business results across sales, service and customer engagement.

Nicole Tilton & Pierre Hulsebus, of Scribe Software, discuss how easy it is to migrate your critical data into Salesforce and how it will immediately benefit the different areas of your business. See a demonstration of how simple and seamless it is for you to transfer your customer data into Salesforce from different external sources such as; text files, another CRM, or homegrown systems.

Pages