Skip to main content

Posts Tagged ‘SQL Server Reporting services’

Istock 1194430859

How To Create Reports Using SQL Server Reporting Service(SSRS)

  SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, Mobile and printed reports using SQL Server and other data sources. It is part of Microsoft SQL Server Services suite. SQL Server is a relational database management system (RDBMS) that supports transaction processing, business intelligence and analytics applications. […]

On-Premises BI Gets a Boost in SQL Server 2016

At their recent Ignite conference in Chicago, Microsoft unleashed a flood of new information about their products and services across a wide variety of functions.   Business Intelligence was not left out, by any means, with announcements of exciting new cloud-based offerings such as Azure Data Warehouse and Azure Data Lake.  But given all the focus […]

Columnstore Indexes: When Should You Use Them?

When I speak to clients about In-Memory features in SQL Server, I find that Columnstore indexes just haven’t gained much traction as a marquee feature. The functionality itself is quite useful in the BI/DW realm as far as potentially boosting query performance by 1.5 to 10 times. But I think it gets overlooked because the […]

Power View Differences between Excel 2013 and SharePoint 2013

I knew that there were differences between Power View in desktop Excel and Power View as run from SharePoint. But I recently felt the impact of this for the first time. The first confusing point I found was, the Export to Power Point function only works for reports created in Power View in SharePoint Server. […]

Pervasive Data in Microsoft’s Cloud OS

As early as the beginning of this year, Microsoft began positioning their “Cloud OS” concept, based on the pillars of Windows Server and Microsoft (formerly Windows) Azure.  This perspective on the spectrum of Microsoft’s offerings casts Cloud OS as a giant next generation operating system, with all the scope and scalability that cloud computing offers. […]

Implementing and Extending Epic’s Cogito

Introduction Over the years as a consultant in the IT field, I’ve worked on quite a few health care related projects.  None have been as large or interesting as my current engagement. I am part of a team working with ProHealth to stand up and extend a new third party data warehouse offering called Cogito.  […]

Windows Azure SQL Reporting what’s missing?

I’m going to use the theme of an earlier post (Windows Azure SQL Database what’s missing?) and ask the same question on another service offered on Windows Azure. The reason I chose these offerings specifically is because I really like them as a developer. Not having to deal with configuring infrastructure and being able to […]

Windows Azure SQL Reporting – Calendar Reports

Before I started blogging for Perficient, I had a few posts on a personal blog. One of the post, though outdated, is still referenced quite often. So I thought it might be a good idea to update the post for use with SQL Reporting. The original post was created for SQL Server Reporting Services (SSRS). […]

Windows Azure SQL Reporting

I’m not sure why exactly, but I have always loved SQL Server Reporting Services (SSRS). If you didn’t already know it, I’m here to let you know that Windows Azure has a similar version called SQL Reporting. In everything I see about Windows Azure, SQL Reporting doesn’t seem to be talked about much. SQL Reporting doesn’t […]

Microsoft BI on an iPad?!

PerformancePoint, Reporting, and Excel Services on an iPad… it can’t be.  It is a fact.  What? You don’t believe me check out this link and see for yourself.  This feature was included in the December 2011 SharePoint 2010 CU.  However, I have some bad news if you have recently updated to iOS 6. The tap and hold […]

SharePoint as a Platform in a Highly Regulated, Clinical Research Environment

Last week, Perficient presented a webinar on using SharePoint as a platform in a highly regulated environment. Tony Egl, consulting services director and Jason Bell, consulting services senior technical director—both at Perficient—presented a case study that leverages SharePoint 2010 to bring clinical processes out of a paper environment and into an electronic, auditable environment. This provided the client the ability […]

Installation and Verification steps for SQL Server 2012 Analysis Services in Tabular Mode

  If you are new to SQL Server 2012 like me, you might run into some issues when you are trying to create some Tabular Model projects.A Tabular Model is simply a new type of server mode in SQL Server 2012. It utilizes a new storage mode known as the Vertipaq storage engine that enables […]