FMTFMT

SQL Archives - FMT

Search Archive
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 availability, improved backups, and cloud functionality, you’ll be very excited to hear about the changes in SQL 2016. With the release of SQL 2016, a few major changes were made to entice customers to make the switch. Free Access to the Developer Edition You can now download and use the Developer edition for free. This is a great way to test out the functionality of SQL 2016 without the upfront cost. This edition of SQL server is fully functional, and comes equipped with every feature that you would find in the standard edition all the […]
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 some of the new features of SQL 2016 Reporting Services and some of the most recent updates in Power BI that you’ll see during the Microsoft BI session at nVerge In the Cloud.  We’ll also look at how you can jump in and get started with these tools and how they work together to provide you access and insights into your data. SQL 2016 Reporting Services SQL Reporting Services (SRS) is still the go to on-premise solution for deploying and managing reports. Some of the great new features include the ability to: Develop paginated reports […]
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 track the changes for customers in CRM 2011 On-Premise to show one instance where the data had changed. CRM 2011 on premise Audit view contains all the attributes of a transaction in a string. Changes to a transaction are separated by “,” and the previous values of a transaction are separated by “~”.  Unfortunately, using the string alone we can’t query individual attributes to track changes. In order to more easily accomplish this, we would split the values to be able to join to other views or tables. In the following example, we will be […]
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 or manipulate the data prior to integrating it. Simple or complex, integration tools can make the whole process easier! The backbone of these tools is eConnect, a set of SQL stored procedures that can be installed for Dynamics GP. They are used to accept data and integrate it into the appropriate database tables. The eConnect stored procedures use business rules to validate the data before integrating it to GP, thus protecting the integrity of the data and only allowing you to insert valid data. Using eConnect without integration tools can be a complicated process. Which […]
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 releases, SQL 2012 brings along faster performance, great availability, improved data exploration, more consistent data, and optimized productivity. So what does all this mean? And more importantly, should you upgrade? The new release of SQL Server comes with many new and cool features. So many that it is outside the scope of this article to go through them all, but here are a few highlights: Always On: A new feature that improves database mirroring allowing you to fail over multiple databases instead of individually.  SQL Server Data Tools: SQL Server Management Studio now runs in […]
©
2021
 FMT Consultants, LLC.
|
Privacy Policy
X
FMT

Contact Us

X
FMT

Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram