Derek Comingore

Derek
Comingore

Derek Comingore is a principal architect with B.I. Voyage, a Microsoft Partner that specializes in business intelligence services and solutions. He's a SQL Server MVP and holds several Microsoft certifications.

Articles
Market Watch: Scalable Data Warehousing
Companies that need their data warehouse hardware and software platforms to scale with their analytic needs can choose from two main types of solutions: data warehouse appliances and data warehouse reference configurations.
Review: Crystal Reports 2008 2
An extensive list of data sources and export formats makes this reporting tool stand out.
Review: Panorama NovaView Suite 2

Editor's note: Updated 5-26 to correct pricing information.

Panorama Software’s Panorama NovaView is a suite of analytical and reporting software products driven by the centralized NovaView Server. There are two editions of NovaView: Standard Edition and Enterprise Edition. All NovaView components are installed on the server, except for NovaView Spotlight, which is an extension to Microsoft Office, so it’s installed on client machines.

How to Create PowerPivot Applications in Excel 2010
With PowerPivot, Microsoft is closer to its goal of bringing business intelligence (BI) to the masses. Learn what PowerPivot is and how to use its client-side components to create use a self-service BI application.
Managing Analysis Services Activity - 14 Feb 2010 1
Derek provides an overview of Analysis Services Connection Architecture, Monitoring Tools & Techniques
PowerPivot Alpha Geek Challenge #2
The PowerPivot Team wants to see what you're made of! Win a $250 Microsoft Store shopping spree and a chance for a free trip to 2010 Microsoft BI Conference!
SQL Server PowerPivot: My Thoughts 1
Derek provides his thoughts on SQL Server PowerPivot and why the product is a game changer
Top 5 Reasons Your Company Should Consider SQL Server PowerPivot
Derek provides a list of key SQL Server PowerPivot features that will propel the upcoming SSBI product beyond its competitors.
2010 Microsoft BI Conference Details Surface
Derek provides an update on the elusive Microsoft BI 2010 Conference
Microsoft PowerPivot Resources
Derek shares a wealth of valuable Microsoft PowerPivot resources to help kick-start your evaluations of the upcoming self-service BI platform.
Building Your First Cube 5
Jump into advanced BI by using this step-by-step guide to making your first cube.
SQL Saturday #23: 10.24.2009 @Louisville, KY
Derek along with a host of other great speakers will be presenting at SQL Saturday #23 in Louisville, KY on 10.24.2009.
Business Intelligence for the DBA, Part 2 1
Derek provides the 3rd and final post to his series on BI for the DBA.
Business Intelligence for the DBA, Part 1.5 2
Derek provides a supplement to his recent post on why BI is so valuable.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More
Jan 22, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×