SQL Server Reporting Services

Certain SQL Server Agent jobs failing due to Allow Updates option

I recently started working on a case where backups were not running although they were scheduled and enabled to run via SQL Server Agent 2008. They had previously been run without issue for at least a few months, but suddenly stopped. After some testing, I realized even new jobs would not even run on demand for certain processes such as backups and the Check Database Integrity Task. Others, Reorganize Index and Update Statistic Tasks, ran successfully and without issue.

Read More

Power Up

Power View is a new tool available through Microsoft SQL Server 2012 that provides an additional tool in the area of ad-hoc reporting for data analysts, decision makers, and -driven users. The tool allows creation and interaction with data based upon a data model designed in a PowerPivot workbook or even Microsoft SQL Server 2012 Analysis Services. The Power View report designer and viewer leverages Silverlight and is a browser based application that is launched from within Microsoft SharePoint Server 2010.

Read More

Microsoft SQL Server 2012: What can it do for you and is it worth it?

With the release of Microsoft SQL Server 2012, many companies are looking at the new features and contemplating whether it is worth upgrading. Of all the releases of SQL Server, this one seems to have the data-driven geeks in high

Read More

Loan Loss Reserve Reporting/Modeling

Summit Group recently had the opportunity to work with one of our banking clients to utilize Microsoft Dynamics CRM in a unique way. Taking advantage of Microsoft Dynamics CRM and Scribe we built a reporting solution for calculating Loan Loss Reserve Adequacy.

Read More