SQL Server | Data & Analytics
Data & Analytics Blog

Posts Tagged ‘SQL Server’

SSRS – Making Reports Presentable

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

Read more

Using DTUTIL to Migrate SSIS Packages

I often use the SQL Server (MSDB) Database to store and execute SSIS packages.  However, I found it cumbersome to migrate multiple packages back and forth from network locations to the MSDB or from the various environments (DEV, QA, PROD).  So, I created a simple script to generate the dtutil commands necessary to quickly migrate […]

Read more

Introduction to Data Quality Services (DQS) – Part I

I was recently introduced to SQL Server 2012 and discovered Data Quality Services (DQS); a new feature of SQL Server 2012.  I wanted to use this blog as an introduction to DQS, define key terms, and present a simple example of the tool.  According to MSDN, The data-quality solution provided by Data Quality Services (DQS) […]

Read more

EIM awareness with SQL Server 2012

I just finished reading the results of an interview I gave earlier this week to technology webzine www.CRN.com regarding the pending release of SQL Server. I was interested to know which parts of my 30 minute discussion with the technical writer would make it into the article. I was happy to see that the writer […]

Read more

Magic Quadrant Madness, Denali and complete transparency

So I just read the recently published BI magic quadrant analysis from Gartner and noticed a slight adjustment in the bubbles. The Microsoft BI platform continues to increase along the ‘Completeness of Vision’ axis (X), but the ‘Ability to Execute’ measure (Y-axis) slipped a notch and I wanted to know why. After reading the ‘Strengths’ […]

Read more

Microsoft BI in the enterprise

I was demoing the Microsoft BI stack to a client the other day and although PerformancePoint, PowerPivot and Power View showed well as always, I was amazed that the Q&A session gravitated back to the same old questions that I always hear. “Well what about Oracle?” “Have the BI tools made it out of the […]

Read more

Perficient Data & Analytics

Trends, best practices, and technical perspectives from data and analytics experts. Readers will gain valuable insights and strategies in harnessing the power of data to drive actionable intelligence for a digital transformation journey.