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
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 2

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....More
Mar 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 19: Availability Group Database Backups

One of the biggest strengths of AlwaysOn Availability Groups is that they allow DBAs to address both high availability and disaster recovery concerns from a single set of tooling or interfaces. But, this doesn’t mean that you won’t still need backups....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) ×