Kevin Goff


– Microsoft Data Platform (SQL Server) MVP
– Microsoft MVP since 2005
– Database/Business Intelligence architect/consultant
– Frequent Speaker in the Mid-Atlantic
– Columnist for CODE Magazine (Baker’s Dozen Productivity Series)

13 Reasons to upgrade to SQL Server 2016 Enterprise

Saturday, October 22nd, 2016 at 3:00 pm in

SQL Server 2016 is one of the most important versions in the history of Microsoft SQL Server. In this presentation I’ll walk through 13 enhancements in SQL Server and why they are important. I’ll cover SSRS enhancements, changes to in-memory OLTP and Columnstore index functionality, the new Query Store, new row-level security, temporal tables, and many others. If you want to see a good (and fast) deep-dive on what’s new in SQL Server 2016 Enterprise, this is the session to attend!

T-SQL for Application Developers – Attendees chose

Saturday, October 22nd, 2016 at 11:30 am in

That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.

SQL Server Reporting Services for Developers – attendees choose topics!

Saturday, April 9th, 2016 at 3:00 pm in

In this presentation, I’ll show over a dozen different SSRS topics, and allow attendees to select which topics to cover. Everything from sparklines to heat maps, from Tablix-drilldown reports to advanced charts, from performance gauges to subreport/drilldown reports to new page/group control features in R2….and even topics like data-driven subscriptions, reports against OLAP cubes, and deploying to SharePoint. There are even topics for integrating SSRS reports into ASP.NET pages, and launching SSRS reports using C#. Since no presentation can cover all the topics, I’ll let the majority of the audience decide which to cover.

Transact-SQL for Developers – attendees choose

Saturday, April 9th, 2016 at 11:30 am in

That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.

T-SQL for Application Developers – Attendees choose

Saturday, March 21st, 2015 at 3:00 pm in

That’s right, attendees choose! I’ll show 30 possible topics on the screen, and the attendees vote on which topics I’ll cover. Everything from isolation levels to ranking…everything from GUIDs to table-valued functions….everything from querying temporal data to instances where subqueries are necessary….everything from update triggers to reading execution plans. The good news is that you’ll walk away with 30 code samples, even though we’ll only cover a portion of them in the presentation. This has always been a very popular session.

Columnstore Index in SQL Server 2012/2014

Saturday, November 23rd, 2013 at 1:30 pm in 305

It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I’ll also show how the new Batch execution mode can improve performance as well. Finally, I’ll show what queries can take advantage of the columnstore index (and which ones can’t) and how to use partition switching as a workaround for the fact that the columnstore index is a read only index. Time permitting, I’ll talk about the new features in the columnstore Index in SQL Server 2014

Integrating .NET with the BI Stack

Saturday, November 17th, 2012 at 1:40 pm in 305

This presentation covers many scenarios where .NET intersects with the BI stack. I’ll walk through examples where a developer might need to write C# code to launch an SSIS package, generate an SSRS report to a PDF, or even to access an OLAP cube. I’ll also cover some advanced SSIS scripts in C#. The attendee will see many practical samples for accessing elements of the BI stack from .NET.