Posts Tagged ‘SQL Server’

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

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

CIO and CMO convergence has been mentioned by many esteemed thought leaders as the key driver to digital marketing (DX) success.  At Perficient, we very much agree with that statement.  See below for a few great examples: https://blogs.perficient.com/microsoft/2013/10/the-blurring-line-between-cio-and-cmo/ https://blogs.perficient.com/portals/2013/12/09/cmo-and-cio-need-to-work-together/ We also believe that the age old adage, “you can lead a horse to water, but […]

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

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

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

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

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

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

Now that we have created out first SSRS report, it is time to make our reports presentable. SSRS is really user friendly and customizing a report is very simple. This is how our reports currently look:   Let us first add a title to the report so that the users/managers know what information to look […]

I’ve been using Twitter for some time. While I don’t normally take part in all the conversations, I do know how to get help from colleagues in the community. Hashtags have been around for several years and are now used in most main stream social networks. Hashtags are mainly used for joining people with similar […]

Perficient’s Sitecore team recently worked with Lamar Advertising to transform Lamar’s web presence resulting in increased customer awareness, allowing Lamar to address customer needs on both a local and national level. In addition, Lamar has experienced increased conversions, has the ability to reach, engage and educate potential customers about out-of-home advertising, and has reduced time-to-market […]