SQL Server Articles - Page 2 of 5 - Perficient Blogs
Blog

Posts Tagged ‘SQL Server’

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Leverage Power BI with SQL Server 2014 & Azure: Webinar Recap

Earlier in the year, we held a popular webinar on utilizing Power BI, a new Microsoft offering (then in preview). Of course, much has changed since that previous webinar, with Power BI being available to the general public and the release of SQL Server 2014. In light of those changes, my colleague, Andy Tegethoff, a […]

Read more

Webinar: Make the Most of Power BI with SQL Server 2014 & Azure

Within the last few months, you’ve probably heard about about Power BI for Office 365, the new cloud-centric BI front end tool set from Microsoft. You may have even attended one of our webinars on the topic, while Power BI was still in preview – it has since moved to general availability. (If you missed […]

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

New Azure VMs improve SQL Server Data Warehousing in the cloud

While poking around in Azure, looking to set up a BI Demo VM , I noticed that Microsoft had added a few SQL Server-oriented images to their catalog.   VMs labeled “SQL Server… for Data Warehousing”! There was one for SQL Server 2012 (SQL Server 2012 SP1 for Data Warehousing on WS 2012) and one for the current […]

Read more

Power BI for Office 365: Self-Service BI Webinar Recap

Yesterday, we hosted a webinar on Power BI for Office 365: Using SharePoint Online to Deliver Self-Service Business Intelligence. During the well attended session, Andy Tegethoff, Microsoft BI architect at Perficient, first reviewed what Power BI is all about, who is likely to be a user, and the components of it. He then dug deeper […]

Read more

Leveraging In-Line User Defined Functions in SQL Server

User-Defined Functions (UDFs) are great, and have been part of SQL Server for a long time now. They come in two primary flavors: scalar and table-value. The first returns a single value, where as the second will return an entire result set. It’s not uncommon to want to reuse a block of SQL. Views are […]

Read more

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

Read more

Lync 2013 SQL Mirroring Witness Gotcha

My colleague, Jason Sloan, has a great blog post on some SQL mirroring issues he encountered during a recent Lync 2013 deployment that I highly recommend everyone read.  This post is intended as an addition to that list with an issue that I discovered during my own Lync 2013 SQL mirroring deployment. Consider the following […]

Read more

An Interview with Perficient’s Newest Microsoft MVP, Ryan Duclos

First of all, congratulations to my colleague, Ryan Duclos, who received the Microsoft MVP award on January 1, 2014. You can read more about the announcement in the Microsoft MVP Award Program Blog here: These individuals were chosen because they have demonstrated their deep commitment to helping others make the most of their technology, voluntarily […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up