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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×