SQL Archives – FMT

Tracking and Reporting Projects using Office 365 and Project Online

Did you know Office 365’s tools can make your PMO run more efficiently?

Read More
  1. Cloud, IT

    5 Reasons to Upgrade to Microsoft SQL Server 2016

    If you’re reading this, it’s likely you’re interested in using SQL 2016 for your databases but are adopting the “wait and see” approach before making the leap to a new software version. Whether you’re interested in trying SQL Server’s new free editions and reworked reports, or you’re trying to enhance your current working environment with high…

    Read More
  2. BI

    New Features in Microsoft Business Intelligence with SQL 2016 and Power BI

    Microsoft Power BI recently had its one-year anniversary, and with the release of SQL 2016, the future of Business Intelligence just took a giant leap forward. Microsoft is starting to achieve its goal of putting the power of data in the hands of every business and person on the planet. In this blog, we’ll preview…

    Read More
  3. Microsoft Dynamics CRM

    Tracking Changes in On-Premise CRM 2011 Audit View using SQL

    Have you ever found yourself needing to track the changes you make to records in CRM, but feeling uncertain how to do so? If you are using the On-Premise version of CRM 2011, you can leverage the Audit view in SQL Management Studio to easily track your changes. For example, let’s say you needed to…

    Read More
  4. Development, Microsoft Dynamics GP

    Microsoft Dynamics GP Integration Tools Guaranteed to Make Your Life Easier

    Integration tools can be used to incorporate data from a variety of sources into Dynamics GP. They can also export data from Dynamics GP into many different file types such as text, Excel and XML. For some integrations, you will simply be moving data straight into Dynamics GP. For others, you will want to convert…

    Read More
  5. BI, Microsoft Dynamics, Microsoft Dynamics CRM, Microsoft Dynamics GP

    Should I Upgrade to SQL 2012?

    Microsoft recently released the latest version of SQL Server (“Denali”) 2012. With every new SQL Server release, hundreds of new features and improvements are added, and this is a major one! Enhancements can be found throughout the product, across all components including the Database Engine, Analysis Service, SSIS, Reporting and Master Data Services. Like previous…

    Read More

The FMT Way

Optimizing your business processes—and achieving your goals—can be easier. With our team of experts, from designers to architects, you’ll gain the technology experience, dedication, and know-how that your business needs.

We’re here to inspire your greatness through technology.

Let's Start the Conversation