Posts Tagged ‘sql’

I hope everyone has found my articles useful and have used my articles in creating some great looking SSRS reports.  This week we will take a look at creating a product breakdown report or a detailed sales report. Let us refresh our memory.  Our sales table has the following fields: Fields Description Data Type ID […]

Currently, we have a long time running issue for a data warehouse job, so we decided to optimize some stored procedures. After analyzing the stored procedures. we have some findings regarding the sql optimization. 1. Use the temporary table to minimize disk access. From the sql tuning view, the main concern for the database applications is to minimize disk access. Try […]

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

Serviceability What is application serviceability?  “Serviceability (also known as supportability,) is one of the -ilities or aspects (from IBM’s RAS(U) (Reliability, Availability, Serviceability, and Usability)). It refers to the ability of application support personnel to install, configure, and monitor an application, identify exceptions or faults, debug or isolate faults to root cause analysis, and provide […]

On Wednesday we hosted a webinar on BI in the Cloud with Windows Azure and Office 365.  During the webinar Andy Tegethoff, a Microsoft BI architect in Perficient’s dedicated Microsoft BI practice, shared key point on taking advantage of the cost savings, scalability and speed of implementation benefits offered by Cloud based implementations. Andy offered […]

Business intelligence initiatives are often met with challenges. Getting the right information to the right people is often easier said than done. When implemented successfully, business intelligence solutions drive change; both in the way people work and the business decisions made. For organizations capturing business data electronically, Microsoft provides a set of integrated business intelligence […]

I’m always fascinated by the power of Social to connect people and information quickly. I’m also intrigued by the sense of community that can be driven by social collaboration, and how that community can drive crowd-sourced content curation. Here’s an example of that community collaboration at work.  ZDNet‘s MaryJo Foley published a post yesterday on […]

SQL development varies from case to case when it use different database such as Oracle, DB2 and MSSQL. Today we’d like to take “sub-query” as an example to explain the differences. For example, we want to calculate rate, Oracle support two ways:

Integration Projects / Enterprise Service Bus (ESB) are by its nature complex involving many Partners, Systems, technologies, and message structures. Since there are many moving parts in the ESB system, if there are any problem occurs, diagnosing and fixing the issue is challenging. Also Support personal / Developers need to be knowledgeable in many skills […]

My colleague Azam Zaidi and I talked about Perficient’s Health BI solution that’s ONC Certified for Meaningful Use Stage 2 & ACO reporting with Microsoft’s Steve Aylward and EHR TV’s Ann Fishman at the HIMSS12 conference.  Health BI is built leveraging SharePoint and SQL Server.   We also discussed how we are seeing increased interest […]

With the HIMSS Annual Conference wrapping up in Las Vegas there are a lot of sore feet and throats (from walking through clouds of smoke). The Perficient team was excited to be invited to demonstrate our ONC certified Meaningful Use Stage 2 and ACO reporting solution, Health BI, in the Microsoft booth.  There was great […]

Expanding on “Microsoft BI –No More Excuses”, I recently updated Denali SQL 2012 (Community Technology Preview CTP3) on my demo machine to work with Microsoft’s latest Self-Service BI (SSBI) tools. The result is a MS 2012 Denali SSBI demo and presentation available now from Perficient’s National MS BI team. Below are the highlights of the full blog […]