SQLSaturday #465 - Providence 2015

Event Date: 12/12/2015 00:00:00

Event Location:

  • NEIT
  • 1408 Division Rd
  • East Greenwich, Rhode Island

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Getting the most from your SAN - File and Filegroup design patterns

Abstract: You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you’re only seeing 200 MB/s?

This session will dive into how to optimise your File and Filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customer’s table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include:

  • Layout for OLTP
  • Data Warehousing Fast Track Style
  • Data Warehousing on a SAN
  • Get data into your SSAS cubes faster (ProcessData)
  • Hidden options and “go faster” buttons
  • How to maximise performance in enterprise edition and master read ahead


  • Stephen Archbold

Track and Room: Enterprise Database Administration Deployment - Room 3

Title: Create a Power BI Dashboard in 90 Minutes or LESS

Abstract: Power BI is quickly outpacing Excel as the one tool needed for self-service Business Intelligence. In this session we’ll walk through Microsoft’s exciting new Power BI SaaS offering, creating some Reports and Dashboards along the way. We’ll explore some of the ready-made content packs for major SaaS providers such as Salesforce or Google Analytics, then create our own based on an Azure SQL Database. Next, we’ll explore Power BI Desktop, a powerful new tool for creating advanced analytic data models and authoring reports using familiar experiences from the best of Excel’s BI components. Finally, we’ll deploy the reports to Power BI, extend and share our Dashboard, and configure Automatic Data Refresh. All inside 90 minutes! Don’t miss this session on the cutting edge of Microsoft’s self-service Business Intelligence offering.


  • Todd Chittenden

Track and Room: BI Information Delivery - Room 5

Title: What about the Data Dude? SSDT Database Projects

Abstract: For years the database has been treated as a second class citizen when it comes to source, change, and version control, often thought of as a dumb data store. Microsoft first addressed this with Visual Studio Team System 2008 Database Edition, aka “Data Dude”. After the release of Visual Studio 2012, Microsoft pulled the database project out of Visual Studio and created SQL Server Data Tools as separate, free to SQL Server users, install on top of the Visual Studio shell. The database project was updates making managing databases as code much easier and making the database a first class citizen in the code world. We will cover how to create a database project, connect it to source control, and deploy to our database servers.


  • Jack Corbett

Track and Room: Application Database Development - Room 3

Title: Creating Access 2013 Web Apps in SharePoint with SQL Azure

Abstract: Access 2013 web apps are fully integrated with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data using Access or other applications, including mobile. In this session you will learn how to easily create an Access Web App with automatic views, view the online development environment and see a live, production web app in action. We’ll also discuss different ways of extending web apps through the use of hybrid applications and integrating office web apps and the best ways to utilize Access Web Apps within your organization.


  • Andy Tabisz

Track and Room: Application Database Development - Room 4

Title: Right-Sizing Your SQL Server Virtual Machine

Abstract: Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now?

The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.


  • David Klee

Track and Room: Enterprise Database Administration Deployment - Room 6

Title: Building a Big Data Solution

Abstract: As a follow-on to the presentation “Building an Effective Data Warehouse Architecture”, this vendor-free presentation will explain exactly what Big Data is and its benefits, including use cases. We will discuss how Hadoop, the cloud and massively parallel processing (MPP) is changing the way data warehouses are being built. We will talk about hybrid architectures that combine on-premise data with data in the cloud as well as relational data and non-relational (unstructured) data. We will look at the benefits of MPP over SMP and how to integrate data from Internet of Things (IoT) devices. You will learn what a modern data warehouse should look like and how the role of a Data Lake and Hadoop fit in. The Big Data boom brings new challenges to those of you who define the architectures to create and consume business-critical data. You will need guidance on the best solution for your data warehouse going forward. This presentation will help to give you that guidance!


  • James Serra

Track and Room: Strategy and Architecture - Room 2

Title: Data Pages, Allocation Units, IAM chains… Oh My!

Abstract: Understanding how SQL Server stores your data can seem like a daunting task. In this session You’ll learn how objects such as tables and indexes are stored in a data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map and GAM and SGAM pages. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.


  • Brandon Leach

Track and Room: Enterprise Database Administration Deployment - Room 5

Title: SSIS 2012/2014: The Quiet Revolution

Abstract: The SQL Server 2012 release of SSIS was a complete game changer. Using sample packages, we’ll show you how to deploy projects to the new SSIS catalog. You will see how project level parameters and connection managers can make your life easier. You will learn how to configure packages using the new configuration editor in SSMS. We’ll show you how to define a collection of configuration settings called an Environment which can automatically configure packages deployed to a server. Find out why SQL Agent no longer captures SSIS errors in the log and how you can get information about failed packages. Get up to speed on using the latest features of SSIS to make you job easier.


  • Bryan Cafferky

Track and Room: Application Database Development - Room 1

Title: 100 Times Faster: Experiences making SQL Server go fast

Abstract: How do you go about making a program run a lot faster! Like 100 times faster? It’s difficult. Microsoft tried in the Hekaton project, its in-memory tables feature of SQL 2014, and they got very close. Inspired by that effort, this presentation looks at some recent cases where I’ve been able to achieve huge performance improvements in SQL Server code and how that happens.

When I work on SQL Server performance I emphasize that the first thing to think about is how to accomplish the task in a different way that will be much faster”. Sometimes there’s a better algorithm. Sometimes a different technology is more appropriate. Sometimes it’s a combination of many changes that combine to create the desired outcome much, much faster.

This presentation is illustrated with examples from my work and we’ll look for common threads that might help us all.


  • Andrew Novick

Track and Room: Application Database Development - Room 3

Title: Dissecting the Data Flow: SSIS Transformations, Memory the Pipeline

Abstract: SQL Server Integrations Services is a robust product, with lots of different options available to the ETL developer. For someone new to SSIS, it can be daunting to be assigned a project to extract data from a source, transform it and then load it into its intended destination. What components do I use? Why pick one over another? Even if you are new to SSIS, it’s good to have an understanding of what’s going on under the hood when a package is run. Come to this session to learn what non-blocking, semi-blocking and fully-blocking transformations are. We’ll explore how SSIS creates and manages memory buffers. You’ll leave with a better understanding of how certain tasks and transformations can affect your package’s performance.


  • Matt Batalon

Track and Room: BI Platform Architecture, Development Administration - Room 1

Title: Accelerating DevOps Using Data Virtualization

Abstract: DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. “Storage is cheap” is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality. Learn about the technical details behind this solution.


  • Tim Gorman

Track and Room: Enterprise Database Administration Deployment - Room 3

Title: Index-fu - getting the most out of your indexes

Abstract: So you know the difference between a clustered and a nonclustered index. I won’t review it again - I promise. This session will focus on expanding your understanding of indexes and what you can use them for. We will look at the internals of how they are structured, included columns, filtered indexes and indexed views. We will explore how to use indexes to enforce contraints beyond just simple uniqueness. Earn your SQL Black belt with this fun and informative session.


  • Michael DeFehr

Track and Room: Application Database Development - Room 5

Title: Automated Installing and Configuration of SQL2014/SQL2012 AlwaysOn Across Multiple Datacenters

Abstract: Tired of watching progress bars and waiting for servers to reboot while you follow run books on how to install SQL Server. This session teaches you how to automate the whole process of installing a Windows Server (Core Installation), Install SQL Server, setup Clustering and configure an AlwaysOn availability groups.

The whole process is presented as a life demo


  • Thomas Grohser

Track and Room: Enterprise Database Administration Deployment - Room 1

Title: Diving Into Query Execution Plans

Abstract: There is no better way to understand how TSQL is executing than through the execution plan. We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance. Be sure to bring your safety helmet!


  • Edward Pollack

Track and Room: Enterprise Database Administration Deployment - Room 2

Title: Can the IT Job Market get any Hotter? Navigating Your Career Sea

Abstract: Are you thinking about making a career change in 2016? If so, this session is for you. Tom will explain the three factors that are required for you to make a career change and get you hired in either a new contract or direct hire role.

After this session, you will understand the mindset you need to make a change and be equipped to find the opportunity you want while increasing your compensation in a field you enjoy.


  • Tom Anderson

Track and Room: Other - Room 2

Title: Cardinality Estimates in Microsoft SQL Server 2014

Abstract: SQL Server 2014 includes a new cardinality estimator. This feature allows for statistics to be updated more frequently than previous versions of SQL Server, resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.


  • Thomas LaRock

Track and Room: Enterprise Database Administration Deployment - Room 2

Title: Managing Copy Data for BI

Abstract: As BI professionals we are straddled with multiple issues pertaining to Copy Data. We will discuss what ‘Copy Data’ is along with various terminologies that go with it.

The common issues are:

  1. Space
  2. Network Bandwidth
  3. Time
  4. Security
  5. Obfuscation/Masking
  6. Which Server does this go to?
  7. Onward protection of Copy Data

In this session we will study the issues above and see how we can avoid these issues. We will examine what technologies/products are available that help us mitigate such a massive problem.


  • Paresh Motiwala

Track and Room: BI Platform Architecture, Development Administration - Room 4

Title: SSRS Troubleshooting Tips

Abstract: Data is everywhere, but it doesn’t do any good if users can’t see and use it efficiently. SQL Server Reporting Services can be that gateway to uncover and open the doors into different data sources. If not configured correctly or unable to recognize bottlenecks it can make for a long, bad, day. Learn some of the basic mechanics of how this SQL Server feature is configured along with some useful tricks to monitor performance,and also learn some ways to solve some common issues.


  • Greg Celentano

Track and Room: BI Platform Architecture, Development Administration - Room 6

Title: Power BI Desktop Designer

Abstract: Microsoft just released The Power Business Intelligence Desktop Designer. Learn how X-Velocity uses super compression to query data faster than ever. See how Power Query can access virtually any data anywhere turning it into business information. Discover how disparate data can be conceptualized into a single business view. New visualization technology brings all this together to see your business like never before.


  • John Miner

Track and Room: BI Platform Architecture, Development Administration - Room 5

Title: Batches, Transactions, and Errors

Abstract: This session is an introduction into the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.


  • John Deardurff

Track and Room: Application Database Development - Room 4

Title: Advanced Programming in PowerShell

Abstract: PowerShell is the hottest new Microsoft technology and you need to know it. Assuming a basic knowledge of PowerShell, this session will focus on advanced topics like creating modules, advanced functions, creating custom PowerShell objects, creating a GUI for your scripts, application automation and much more. Many code examples will be examined to show you how to apply the concepts. This is the presentation to attend to step up your game.


  • Bryan Cafferky

Track and Room: Application Database Development - Room 1

Title: Whacha just say? Talking technology to non-technical people

Abstract: Many tech professionals are faced with the challenge of explaining technical concepts to people who don’t understand technology. And only a few are able to do it well. This session provides some strategies and suggestions to go about bridging the technological knowledge gap. With time and practice, a technical person can serve as an effective interpreter of technical concepts. This is an interactive session; audience participation is expected and encouraged!


  • Ray Kim

Track and Room: Professional Development - Room 4

Title: Stunning Dashboards using Datazen

Abstract: Datazen is one of the newest additions to Microsoft BI offerings. Allows you to develop Dashboards, KPIs and Maps. You can either use them locally or publish them to a Datazen server. Viewing and interactivity capabilities is then possible on any device; Laptop, Phone, or Tablet based on iOS, Android or Windows. Experience and interactivity is exactly the same on all of them.

In this session I will demonstrate the power and ease of using this technology


  • Sunil Kadimdiwan

Track and Room: BI Platform Architecture, Development Administration - Room 1

Title: Scratching the Surface: Designing your first Power View Report

Abstract: Dashboards have quickly become a cornerstone for decision-making by managers and business leaders in all facets of corporate operations. Microsoft Power View has enabled drastic improvements in the development of dynamic and interactive dashboards within the Microsoft SQL Stack. In this session, we will cover areas such as: Data Considerations; Deployment Options; Building your first report; and using some of the interactive features of Power View.


  • Chris Seferlis

Track and Room: BI Platform Architecture, Development Administration - Room 6

Title: Hybrid Cloud Scenarios with SQL Server 2014 and 2016

Abstract: SQL 2014 and 2016 have significant changes to allow seamless hybrid cloud scenarios. This session will talk about “why cloud” as well as the options available with backup, deployment, and new development scenarios with SQL 2014, 2016, and Azure.


  • George Walters

Track and Room: Cloud Application Development Deployment - Room 4

Title: What the Hekaton

Abstract: In SQL Server 2014 – Microsoft introduced In-Memory OLTP. (Formally known as project Hekaton.) In this session – we will introduce this technology, optimize an existing AdventureWorks stored procedure to use In-Memory OLTP, and discuss other applications such as ETL.


  • John Flannery

Track and Room: Application Database Development - Room 3

Title: Data Partitioning - Doing the splits…in the name of performance, scalability and sanity!

Abstract: Does only a small portion of your data change on a routine basis? Is index maintenance taking forever? Do users mostly focus only on a subset of data such as the current year, month or day? Do you want to delete or insert massive amount s of data with almost no blocking? Well, step right up because data partitioning can do all this and more! We will take a look at the different option for partitioning, the pros and cons and how to implement them in SQL.


  • Michael Nowill

Track and Room: BI Platform Architecture, Development Administration - Room 2

Title: Shortcuts from an Impatient DBA

Abstract: This session is about performance tuning your day.

We spend a lot of time thinking about how to write efficient code, but we don’t spend a lot of time thinking about how to be efficient at writing code. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I’ve picked up over the years that help me get my work done quicker and easier.


  • Andy Mallon

Track and Room: Professional Development - Room 5


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Michael Nowill

Mike has worked with SQL Server for over 10 years focusing mainly on data warehousing and business intelligence. He is currently a Manager of Production Services Enhancements at Farm Credit Financial Partners, Inc. Mike specializes in data warehouse design and performance tuning. He holds a masters degree in Information Technology from Bentley University. When not working with SQL Mike enjoys photography, American History, brewing beer and snowboarding.

Bryan Cafferky

LinkedIn: Bryan Cafferky

Contact: https://www.youtube.com/user/Bryancutube256123

Bryan Cafferky is a Big Data and AI consultant. Bryan was previously a Senior Data Science Training Content Developer for Microsoft Worldwide Learning. Prior to this he was a Microsoft Data and AI Enabler for healthcare customers. He is a Microsoft 2017 Data Platform MVP and a 2016 Cloud and Data Center Management MVP. Bryan is the author of Pro PowerShell for Database Developers by Apress, available on Amazon. He leads The RI Microsoft BI User Group, and The Greater Boston Area Data Science Group. He has been working with the SQL Server stack since 1997 and implemented projects in the banking, insurance, e-commerce, utility, and health care industries. He holds a bachelor of science in computer information systems and an MBA.

Edward Pollack

Twitter: - EdwardPollack

LinkedIn: Edward Pollack

Contact: https://www.sqlshack.com/author/edward-pollack/

Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.

Michael DeFehr

Twitter: - @mdefehr

LinkedIn: Michael DeFehr

Contact: http://mikedefehr.com

Michael DeFehr is an independent SQL Server consultant based in Winnipeg, Canada. He is focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity.

Andy Tabisz

Twitter: - @AccessWisdom

LinkedIn: Andy Tabisz

Contact: http://www.worksmartdb.com/blog/

Andy Tabisz is a Microsoft MVP and owner of WorkSmart Database Masters based in Grand Rapids, MI. WorkSmart provides custom database and mobile solutions for small to mid-sized corporations using Access, SQL/Azure, ASP.NET, SharePoint, Power BI, Excel and integration with many technologies. Through rapid application development, WorkSmart empowers organizations to work smarter and make better decisions by automating workflow, alerts and reporting capabilities.

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

Tom Anderson

LinkedIn: Tom Anderson

A dynamic leader, relationship builder and veteran technical recruiter with a successful track record in the Information Technology Recruiting and Staffing industry that includes: multiple startup companies, geographical expansion of divisional operations, corporate and national accounts management, daily and long-term talent acquisition strategies and corporate and field operations.

Jack Corbett

Twitter: - http://twitter.com/unclebiguns

LinkedIn: Jack Corbett

Contact: http://www.wisemanorwiseguy.com

JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.

Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.

Jack has presented at many user groups and SQLSaturday even

Chris Seferlis

Twitter: - bizdataviz

LinkedIn: Chris Seferlis

Contact: http://blog.bizdataviz.com

Chris Seferlis is a Sr Cloud Solution Architect at Microsoft. He has 20+ years’ experience working in IT and solving technical challenges from a business perspective. Chris is a former CIO with an MBA from UMass, bringing a mix of business acumen and practical technology solutions, primarily focusing on Data and AI within the Microsoft Data Platform, including MCSA and MCT designations.

Bryan Cafferky

LinkedIn: Bryan Cafferky

Contact: https://www.youtube.com/user/Bryancutube256123

Bryan Cafferky is a Big Data and AI consultant. Bryan was previously a Senior Data Science Training Content Developer for Microsoft Worldwide Learning. Prior to this he was a Microsoft Data and AI Enabler for healthcare customers. He is a Microsoft 2017 Data Platform MVP and a 2016 Cloud and Data Center Management MVP. Bryan is the author of Pro PowerShell for Database Developers by Apress, available on Amazon. He leads The RI Microsoft BI User Group, and The Greater Boston Area Data Science Group. He has been working with the SQL Server stack since 1997 and implemented projects in the banking, insurance, e-commerce, utility, and health care industries. He holds a bachelor of science in computer information systems and an MBA.

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

John Flannery

Twitter: - @AgileDataArch

LinkedIn: John Flannery

John is the Data Architect at Evolution 1 in Simsbury Connecticut – and Adjunct Professor at Quinnipiac University in Hamden, Connecticut. He has 30 years industry experience; working with SQL server since version 4.2 on OS/2, Oracle since 7.3.4. John holds a Master of Science – Computer Science degree from Rensselaer (1995). John is co-leader of the Hartford SQL User Group - and organizer of SQLSaturday 184.

Andy Mallon

Twitter: - AMtwo

LinkedIn: Andy Mallon

Contact: http://www.AM2.co

Andy is a Data Platform MVP and SQL Server DBA that has managed databases in the healthcare, finance, e-commerce, and non-profit sectors. He has been supporting high-volume, highly-available OLTP environments with demanding performance needs since 2003.

Andy is the founder of the BostonSQL User Group, and previous co-organizer of SQLSaturday events in Boston. He blogs at am2.co.

Andy lives just outside Boston, Massachusetts, USA with his husband and their two dogs.

John Miner

Twitter: - https://twitter.com/JohnMiner3

LinkedIn: John Miner

Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/

John Miner is currently a Data Architect at BlueMetal advising corporations on how to solve their business needs with data platform solutions.

He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.

He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.

Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.

George Walters

Twitter: - https://twitter.com/geo_walters

LinkedIn: George Walters

Contact: https://georgewalters.wordpress.com/

Currently a partner technical strategist, George has been solving customer needs and issues. He can translate customer pain into potential solutions.

A seasoned Microsoft SQL and Azure expert, with over 20 years of experience with Microsoft SQL Server, Sybase, Oracle, and other relational databases.

Specialties: Partner strategy, PreSales Engineering, Cloud Architecture, Enterprise Scalability, SQL Server performance, Business Intelligence, High Availability, Scale. I volunteer and present relevant topics at SQLSaturday and internal Microsoft events

Thomas LaRock

Twitter: - @SQLRockstar

LinkedIn: Thomas LaRock

Contact: http://thomaslarock.com

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.

Todd Chittenden

Twitter: - @toddchitt

LinkedIn: Todd Chittenden

Contact: http://blog.blumshapiro.com/blog/author/toddc/

Todd started working with Microsoft’s SSRS in 2004. When Microsoft released its rebuild of SQL Server in 2005, he quickly added the full BI Stack to his repertoire. He became a MCTS in SQL Server 2005. Today, Todd works for Blum Shapiro as a Business Intelligence Architect on various BI Projects across a wide range of company sizes and product combinations. He is a Microsoft Certified Solutions Expert in SQL Server Business Intelligence and a frequent speaker at local User Groups and SQLSaturday events. He Started working with Power BI in its early development time before General Availability in July of 2015.

Stephen Archbold

Twitter: - @stephenarchbold

LinkedIn: Stephen Archbold

Contact: http://simplesql.blogspot.com

Stephen is a Microsoft Certified Master, and a Lead DBA at Arrowstreet Capital, with over 8 years experience working in SQL Server as a Production DBA and consultant. He has a focus on Performance Tuning and Consolidation to get the most from your investment in SQL Server.

Tim Gorman

Twitter: - @TimGormanTech

LinkedIn: Tim Gorman

Contact: http://evdbt.com

Tim Gorman is a senior technical consultant for Delphix who securely enables masked data virtualization to increase the agility of IT development and testing while ending decades of security risk in SDLC.

Tim has co-authored six books on data warehousing and database administration, has performed technical review on eight more books, and has an author#39;s page on Amazon.com (http://www.amazon.com/Tim-Gorman/e/B00BKCTO5E).

Thomas Grohser

LinkedIn: Thomas Grohser

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

Paresh Motiwala

Twitter: - pareshmotiwala

LinkedIn: Paresh Motiwala

Contact: https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2

Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).

He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com

Matt Batalon

Twitter: - @MattBatalon

LinkedIn: Matt Batalon

Contact: http://codebatalon@wordpress.com

Matt holds an MCSE in Data Management Analytics, and has over 15 years of experience in the Information Technology field with a focus on software development and database administration. For over ten years, he has worked extensively with Microsoft SQL Server, including Integration Services, Reporting Services and Analysis Services. He has a Bachelors Degree from Bryant University with a concentration in Computer Information Systems. He is the president of the Rhode Island SQL Server Users Group.

Greg Celentano

Greg Celentano is a SQL Server DBA with a background in virtual and physical server administration. Greg holds a Bachelor’s degree in Computer Information Science and an MBA in Organizational Leadership.

Andrew Novick

LinkedIn: Andrew Novick

Contact: http://www.NovickSoftware.com

Andy Novick is a SQL Server MVP and consultant building business solutions with SQL Server. He has expertise in database design, T-SQL coding, SQL Server security, database performance tuning, partitioning, service broker, and database administration. Andy is a frequent speaker at local user group meetings and an author of two books on SQL Server.

David Klee

Twitter: - kleegeek

LinkedIn: David Klee

Contact: http://davidklee.net

David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.

James Serra

Twitter: - www.twitter.com/JamesSerra

LinkedIn: James Serra

Contact: http://www.JamesSerra.com

James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.

Sunil Kadimdiwan

Twitter: - @skadimdiwan

LinkedIn: Sunil Kadimdiwan

Contact: http://www.infotrove.com/events.html

Sunil Kadimdiwan Sunil Kadimdiwan has 25+ years’ experience in architecting and implementing database solutions. He has deep knowledge of the Microsoft SQL Server and Business Intelligence technology stack. He is a frequent speaker at SQLSaturdays, Code Camps, User Group meetings

Ray Kim

Twitter: - PianoRayK

LinkedIn: Ray Kim

Contact: https://pianorayk.wordpress.com/

Ray Kim is an advocate for documentation and technical communication. He is a co-founder of the Albany, NY SQL group (CASSUG), a member of the AlbanyUX user group, and has spoken at numerous SQLSaturdays and at PASS Summit. He has worked various positions in technology, including as a developer, webmaster, analyst, technical writer, and instructor. He holds an MS in technical communication from Rensselaer Polytechnic Institute and a BS in computer science from Syracuse University.

A musician in his spare time, Ray plays four different instruments. He also enjoys going to ball games and doing CrossFit, and is a two-time SQLServerCentral.com fantasy football champion. He lives in Troy, NY with his wife, Lianne, and their two cats.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page