Categories
Uncategorized

SQL Server 2012 Certification Path Update

Yesterday morning, I passed the 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012! This completes the second step on my SQL Server 2012 certification path. What follows is a quick outline of the materials I used while preparing for this exam along with some comments and afterthoughts. Data Warehouse Design Read The Data Warehouse […]

Categories
Uncategorized

Kaggle: Making Data Science a Sport

A few months ago, I stumbled upon an article that mentioned a cool site called Kaggle which hosts data-related “competitions”. Through this site, data problems collide with solutions as data-experts compete against each other for prizes (cash and/or bragging rights) to see who can come up with the most effective, elegant, efficient solution to each […]

Categories
Uncategorized

Interacting With Live Data via Power View During a Presentation: Worth the Risk?

Over the past few months I’ve delivered a few presentations for current clients (and potential leads) covering the “Sharepoint BI Portal”. The presentation is very demo-heavy and focuses on the self-service capabilities of the Micrsoft 2012 BI stack when integrated with Sharepoint 2010 and built upon a well constructed BI Semantic Model (BISM). This morning […]

Categories
Uncategorized

Value of Integrating Facebook Data For Customer Analysis

Unless you recently awoke from a coma, you probably noticed that Facebook filed for IPO earlier this year.  The stock opened at $38/share valuing the company at ~$104 billion.  Since then, the stock has gotten absolutely crushed as critics everywhere have come crawling out of the wood work with claims about Facebook’s mobile strategy (or […]

Categories
Uncategorized

Column­-Stores For Wide and Sparse Data

Over the weekend I read a paper titled Column­-Stores For Wide and Sparse Data by Daniel J. Abadi.  Below is a quick summary of the points made by Abadi followed by some thoughts / application for SQL Server’s ColumnStore index. Wide Tables & Column “Elimination” I’ve already discussed (in a previous post) why ColumnStores are […]

Categories
Uncategorized

70-463: Determine whether you need a star or snowflake schema…

If you’re a Kimball purist like myself, the title of this post should give you pause.  I came across this phrase when reviewing the SkillsMeasured section for the 70-463 exam.  At the time, the only scenarios I could come up with that would justify using a snowflake schema were the following: Short on Disk Space? […]

Categories
Uncategorized

Sequence vs Identity – Performance Comparison

Recently, as part of an effort to support a few database design choices, I spent a bit of time researching the performance characteristics of the new sequence objects available with SQL Server 2012. The main objective was to gain an understanding of how they stacked up performance-wise with the IDENTITY property…which is the predominant design pattern […]

Categories
Uncategorized

Generating a Database Clean Up Script

Below is a script I recently used on a project to dynamically generate and execute the statements needed to clear all the data out of a database.  It is heavily borrowed from a blog post by Nikola Ilijev.  I just added the parts pertaining to the dropping and re-creating of the ColumnStore index objects and […]

Categories
Uncategorized

SQL Server 2012 Certification Path

Regardless of your opinion on Microsoft certifications, when you work for a Microsoft partner company, you are typically encouraged to get certified in your area of expertise and stay current.  So now that SQL 2012 has been out for a few months, implementations are picking up speed, official exams have been released from beta, and […]

Categories
Uncategorized

Filter Enhancements in PerformancePoint Services 2013

On a previous project, there was quite a bit of PerformancePoint dashboard work.  A few of the dashboards contained a large multi-select nested filter with a ton of items to choose from.  Once the dashboards were published, some of the users began voicing their frustrations with having to dig through this filter to find all the previously […]