Skip to main content

Posts Tagged ‘SQL Reporting’

Autonomous Data Warehouse is the Business Analyst’s Dream Database

At the heart of all business software is always a database. But what once used to be a cumbersome component, something that only developers and system administrators had to deal with, has evolved to become a directly reachable solution of itself. With Oracle Autonomous Data Warehouse (ADW), the Business Analyst is now able to be […]

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 […]

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. […]

Webinar Recap & Replay: Big Data and the Intelligent Enterprise

On Wednesday, we hosted a webinar on Big Data: Using Microsoft Enterprise Information Solutions to Make Smarter Business Decisions. During the session, Duane Schafer, Microsoft BI Practice Director at Perficient, began by defining Big Data, then analyzing Big Data with the Microsoft platform (including ways to manage structured vs. unstructured data such as a parallel […]

Upcoming Webinar: Building a Better Healthcare Dashboard

According to a recent world study, when it comes to the topic of big data and decision-making for healthcare organizations, a top challenge reported is the ability to analyze data and deliver insights in real time. Unfortunately, many key performance indicators on healthcare dashboards fail to drive real results or are missing key organizational improvement […]

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). […]

Microsoft Cloud BI: SharePoint in the Cloud

Previously, we addressed the specifics of data services in Azure, and what paths might be valid for SQL Server BI.   Today, we’ll look at delivering data to users — the “last mile” of Microsoft’s cloud BI story — via SharePoint. Whenever you talk about delivery of Microsoft BI, the first point of discussion is logically […]

SSRS SharePoint Mode Migration Scripting

I am currently at a client who is attempting to migrate Reporting Services objects from SharePoint 2007 to SharePoint 2013.  There are two paths they can choose for the migration: Copy the files over or do a database-attach upgrade to 2010 then 2013.  Either path they choose they will still have to set the reports […]

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 […]