Skip to main content

Posts Tagged ‘SQL Server’

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

Big Data and the Microsoft Data Platform and You

The age of Big Data is upon us, and the age of Pervasive (or “Ambient”) Data is rapidly approaching. This means that not only the typical loosely-structured Big Data sources that we’ve become accustomed to considering, like Twitter feeds, Facebook posts, and web logs. This also means we’re dealing with the streams of data generated […]

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

Declarative data caching in .NET business layer

One of the most effective ways to improve application performance is to implement data caching. Most of the applications are relatively retrieving the same data from external sources like database of web service and if that source data is never or seldom changes then application is just wasting CPU time and I/O querying the source […]

Webinar Recap: ProHealth Improves in Population Health Management

On Wednesday, ProHealth Care and Perficient teamed up to present a session describing how the healthcare system implemented Epic’s Cogito data warehouse to deliver clinically integrated insights. During the webinar, Christine Bessler, CIO and VP of Information Technology at ProHealth Care, described the organization’s innovative approach to population health management. Why innovative? Well, for starters, […]

Perficient partners with ProHealth to improve data architecture

Today, Perficient announced that it has been working with ProHealth Care to improve the organization’s data architecture and implement a new data warehouse to drive population health management. ProHealth Care is the first healthcare system to produce reports and data out of Epic’s Cogito data warehouse, delivering integrated, real-time clinical insights. From the Press Release. […]

Case Study: ProHealth Uses Cogito DW to Manage Population Health

Perficient recently worked with ProHealth Care to help the healthcare system with their data architecture efforts, specifically working on the integration of Epic System’s Cogito data warehouse and several other key data sources surfacing data via SQL Server. ProHealth Care,  a community-based healthcare system with 15 primary care clinics, three hospitals, and numerous other services, […]

How ProHealth is Innovating Population Health Management Webinar

The process of effectively managing population health while consistently measuring and reporting its outcomes can be a challenge for healthcare providers. We will be having a conversation with Christine Bessler, CIO and VP of Information Technology at ProHealth Care and Juliet Silver, Director of Healthcare Advisory Services at Perficient on Wednesday, March 26. We will […]

Webinar: How ProHealth Innovates in Population Health Management

For healthcare providers, it can be a challenge to effectively manage population health, and consistently measure and report its outcomes. Recently, ProHealth Care announced that it was the first healthcare system to use Epic’s data warehouse, Cogito, in a production environment. Specifically, ProHealth implemented the data warehouse to help its physicians assess their entire population […]

Changing the SQL mirror endpoint owner breaks mirror in Lync 2013

When you install Lync 2013 and configure the back end for mirroring, a lot of things happen “under the hood” to configure the mirror (and witness, if applicable). Microsoft really has done a fantastic job of hiding the overall complexity of SQL mirroring through Lync topology builder, but suffice it so say, there are many […]

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

SQL SERVER – Introduction to LEAD and LAG

SQL Server 2012 introduces new analytical functions LEAD () and LAG (). These functions accesses data from subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join. The syntax for the Lead and Lag functions is: Note that: −        “Partition by clause” is optional, “order […]

Load More