SQLSaturday #293 - Maine 2014

Event Date: 06/28/2014 00:00:00

Event Location:

  • USM Wishcamper Center
  • 34 Bedford Street
  • Portland, Maine

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).


Sessions

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


Title: Squeezing the Most out of Row Page Compression

Abstract: SQL Server 2008 brought us the ability to do Row and Page level compression in our databases but even today many people are not taking full advantage of these wonderful features. The most common bottle neck today is physical I/O and SQL Server compression can help with that in most cases. If you are not sure how these features work or how to apply them in your environment this session is for you. We will discuss in detail how the compression schemes work at both the row and page levels along with which data types may or may not be able to participate. We will see from various demos what else affects the compression ratio and just how extensive it can be under the right conditions. Nothing comes for free though so we will also cover the pros and cons along with why, when and most importantly how to use it effectively.

Speaker(s):

  • Andrew Kelly

Track and Room: Track IV - N/A


Title: T-SQL Power! SQL Server Windows That Open Doors

Abstract: Ever feel like your Transact-SQL solution to a tricky issue was almost just as difficult as the problem itself? Ever find yourself unable to cleanly express the logic you really need in T-SQL for your complex data calculation? Don’t blame yourself—blame the limitations of the language. Get ready to embrace the most powerful SQL Server programming enhancement: turbocharged support for windowing functions. If you write analytical queries and you need results fast, attend this session to learn everything you need to know to leverage all the power that windowing functions bring to the table. See examples taken from real-world projects that illustrate how to create running sums, calculate moving averages, look both backward and forward in your set, and achieve many other seemingly complex tasks—all with ease and clarity. The hallmark of a truly great SQL Server feature is the ability to make difficult tasks simple. Windowing functions will have you writing better T-SQL than ever before.

Speaker(s):

  • Adam Machanic

Track and Room: Track V - N/A


Title: Using Hive to Query and Process Big Data

Abstract: Writing map-reduce jobs to process data is not a trivial experience. To do this effectively you really need to be a seasoned java or C# programmer. Even then it is a time consuming experience. A very useful tool available to create and run Map-reduce jobs in Hadoop is Hive. HiveQL is a declarative language modeled to provide a similar experience as writing SQL. If you are familiar with SQL the use of HiveQL should be very intuitive. With HiveQL you construct and run the statement, submitting it to a query engine. The query engine transforms the query into a series of map-reduce jobs. By not having to worry about the low level coding you become much more productive and can concentrate on data analysis. This session is designed to get you up to speed and productive with hive. It includes several practical examples in order to make data analysis with hive as concrete as possible.

Speaker(s):

  • Dan Clark

Track and Room: Track III - N/A


Title: Statistics and Query Optimization

Abstract: There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.

Speaker(s):

  • Grant Fritchey

Track and Room: Track II - N/A


Title: Basic Database Programming

Abstract: Abstract:

You just found out that a client needs a SQL database to be designed from scratch. However, you existing DBA has given two week notice.

This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects.

After this presentation, will be ready to meet that clients need.

Coverage:

1 - How is a view better than ad-hoc SQL? 2 - Abstracting underlying tables via a view. 3 - Avoiding DML updates to views. 4 - Using triggers to enforce business rules. 5 - Using triggers to prevent data modifications. 6 - What are the different types of functions? 7 - Simple use of each type. 8 - Using stored procedures as an application interface. 9 - Batch programming using stored procedures. 10 - How to schedule batch jobs.

Speaker(s):

  • John Miner

Track and Room: Track V - N/A


Title: Building Perfect SQL Servers, Every Time

Abstract: One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.

Speaker(s):

  • Joseph D’Antoni

Track and Room: Track I - N/A


Title: From Mess to Mastery: Managing Large Environments

Abstract: In an era of “do more with less,” IT staff are constantly being asked to manage environments without spending money. Worse yet, budgets are being cut for staff and tools.

IT veteran Mike Hillwig will show you how some of the integrated tools within SQL Server can help you manage your environment without spending a ton of money. We’ll look at the Central Management Server, Management Data Warehouse, Multi-Server Administration, and Policy Based Management. Mike will also show you his tips for building an Environment Inventory Database, a tool you can use to track your servers, instances, and login credentials.

By leveraging what you already have in SQL Server, you’ll certainly be able to do more with less.

Speaker(s):

  • Mike Hillwig

Track and Room: Track I - N/A


Title: DAX and the tabular model

Abstract: With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done, how to extract data from a tabular model using Data Analysis Expressions (DAX). We shall discuss many of the often used functions, discuss their ‘overloads’ (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.

Speaker(s):

  • Steve Simon

Track and Room: Track III - N/A


Title: It’s not just a pivot on the data…

Abstract: SQL Server 2012 introduced a new index type - the Columnstore index. SQL Server 2014 upped the game with the clustered columnstore index. What are these index types, how do they work and what’s really going on in there?

Speaker(s):

  • Andy Roberts

Track and Room: Track V - N/A


Title: SQL Server TDE

Abstract: Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy in general as well as how it relates to SQL Server TDE.

Speaker(s):

  • Ben Miller

Track and Room: Track III - N/A


Title: What the Hekaton

Abstract: In SQL Server 2014 – Microsoft is introducing 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.

Speaker(s):

  • John Flannery

Track and Room: Track III - N/A


Title: Mastering Date-Time Based Analysis in DAX

Abstract: A large volume of analysis that a business typically performs on its data involves dates and/or times. For example, you may need to compare sales from one year to the next or aggregate transactions over time. DAX incorporates many built in time intelligence functions to help make date-time based calculations easier. Although the time intelligence functions are very beneficial, they can be misused and give erroneous results. To avoid this, it is imperative that you understand what functions to use and how to use them. This session is designed to guide you through the various time intelligence functions available in DAX and provide practical examples of how to use them.

Speaker(s):

  • Dan Clark

Track and Room: Track III - N/A


Title: SQL Server–All About HA and DR

Abstract: Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don’t know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, all of the HA and DR options within SQL Server (even the ones that aren’t in Enterprise Edition), and finally a demonstration of the new Availability Groups feature in SQL Server 2012/2104 and see them in practice

Speaker(s):

  • Joseph D’Antoni

Track and Room: Track II - N/A


Title: Introducing SQL Server 2014 (Lunch Session Room 102)

Abstract: It’s no joke, on April Fool’s day this year, SQL Server 2014 was officially launched! Join Microsoft over lunch for a quick intro to What’s new in SQL Server 2014.

Speaker(s):

  • Andy Roberts

Track and Room: Track V - N/A


Title: Develop Impressive Dashboards using SSRS 2014

Abstract: Microsoft Reporting Services 2014 has many exciting features. You can show your business data on Maps, Charts including Sparklines, Data bars and Indicators. Make them interactive, so that your users can drilldown to details. In this session I will show you how can make use of these and other enhancements in SSRS 2014.

Speaker(s):

  • Sunil Kadimdiwan

Track and Room: Track IV - N/A


Title: DBA to Project Manager in 70 minutes flat

Abstract: As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects.In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.

Speaker(s):

  • Paresh Motiwala

Track and Room: Track IV - N/A


Title: 5 Common SQL Server Performance Issues

Abstract: I spend a large portion of each day looking through performance reports and dashboards from various organizations around the world. I’ve identified some very common performance problems and/or misunderstandings that tend to have easy, though not always obvious, solutions.

I intend to share the whys and hows of these issues with anyone who would like to attend during a SQLSaturday session.

Speaker(s):

  • Jason Hall

Track and Room: Track V - N/A


Title: TempDB 101

Abstract: TempDB is not your ordinary user database and should definitely not be treated like one. The usage patterns and internals dictate that the configuration, monitoring and usage be done in a different way to get the best performance. We will see why aspects such as configuration and file placement play such a key role and why you need to plan ahead for TempDB. See how to detect the memory and space usage associated with the various users in TempDB along with some of the most common performance related scenarios that you will encounter with a well-used TempDB database. In addition we will explain the differences between temp tables and table variables and when to use one over another.

Speaker(s):

  • Andrew Kelly

Track and Room: Track IV - N/A


Title: Easy SQL Server Benchmarking

Abstract: Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and want to see how they compare against each other? Multiple free and easy ways to stress test your SQL Servers exist by simulating an OLTP workload against a real SQL Server and the infrastructure underneath. In this session we will demonstrate how to test your storage and SQL Server instances to get raw performance numbers that you can use to compare performance of machines across your enterprise. The utilities DVDStore, HammerDB, and SQLIO will be demonstrated in depth.

Speaker(s):

  • David Klee

Track and Room: Track V - N/A


Title: Squeezing Top Performance from Your Virtualized SQL Server

Abstract: Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.

Speaker(s):

  • David Klee

Track and Room: Track I - N/A


Title: Best Practices for Database Deployment

Abstract: The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you’ve done to ensure that you’re deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.

Speaker(s):

  • Grant Fritchey

Track and Room: Track II - N/A


Title: SMO Internals for High Performance Automation

Abstract: Ever wanted to know what happens behind the scenes in SQL Server when automating your maintenance work? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come to learn about the knobs available to tune your SMO automations. PowerShell will be used as the vehicle that leverages SMO. Come see this demo-heavy session, you’ll be glad you did.

Speaker(s):

  • Ben Miller

Track and Room: Track IV - N/A


Title: Dynamic SQL: Writing Efficient Queries on the Fly

Abstract: Dynamic SQL can be a powerful tool that allows you to write fast efficient queries when the specifics may not be known until run-time. It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you’ll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!

Speaker(s):

  • Edward Pollack

Track and Room: Track II - N/A


Title: Crazy Things That Developers Do

Abstract: Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it’s bad to the database server (or your career)… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.

Speaker(s):

  • Wayne Sheffield

Track and Room: Track II - N/A


Title: Wrangling performance with Resource Governor

Abstract: In this introductory session we’ll delve into the basics of the resource governor feature in SQL Server. We’ll look at the types of issues this feature can help resolve. We’ll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we’ll bring all this together with an example implementation. From there, if time allows, we’ll look at best practices and questions to answer to ensure a successful implementation.

Speaker(s):

  • Brandon Leach

Track and Room: Track I - N/A


Speakers

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

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.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

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.

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.

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.

Adam Machanic

Twitter: - @AdamMachanic

LinkedIn: Adam Machanic

Contact: http://sqlblog.com/blogs/adam_machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is the author of the award-winning SQL Server monitoring stored procedure, quot;sp_WhoIsActive.quot; He has contributed to several books on SQL Server, including quot;T-SQL Queryingquot; (Microsoft Press, 2015). He is a Microsoft Most Valuable Professional (MVP) for SQL Server.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Andrew Kelly

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

Steve Simon

Twitter: - SQLServerBoffin

LinkedIn: Steve Simon

Contact: http://www.sqlservercentral.com/blogs/simon_says/

Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com

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.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Andrew Kelly

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.

Andy Roberts

LinkedIn: Andy Roberts

Contact: http://blogs.msdn.com/andyroberts

Andy Roberts is a currently a Data Platform Specialist for Microsoft in the Northeast district and has spent 12 years as a consultant for Microsoft Consulting Services. As a consultant Andy assisted customers in implementing mission critical OLTP and DW/BI solutions on SQL Server. Andy wore many hats as a consultant including application developer, solution architect, mentor to development teams, mentor to DBAs, BI lead, SCRUM Master, and the guy-that-knows-a-bunch-of-stuff-about Microsoft.

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

Mike Hillwig

Twitter: - @mikehillwig

LinkedIn: Mike Hillwig

Contact: http://www.mikehillwig.com

Veteran DBA Mike Hillwig is a native Pittsburgher and resident of the Boston Suburbs. He’s a DBA Manager for a financial software company that’s owned by one of the world’s largest bank. Mike has been working with SQL Server since version 7 and has a background in infrastructure and network. Today, he manages a team of DBAs around the globe.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Dan Clark

LinkedIn: Dan Clark

Contact: http://drclarkblog.wordpress.com/

Dan Clark is a senior data analytics consultant. He is focused on all things data analytics and training others how to get value from their data. Dan has published several books and numerous articles on .NET programming and data analytics. He is a regular speaker at various developer and database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. His latest book Beginning Power BI published by Apress is a will get you up and running with self-service data analytics on the Power BI platform in no time.

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.

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

Andy Roberts

LinkedIn: Andy Roberts

Contact: http://blogs.msdn.com/andyroberts

Andy Roberts is a currently a Data Platform Specialist for Microsoft in the Northeast district and has spent 12 years as a consultant for Microsoft Consulting Services. As a consultant Andy assisted customers in implementing mission critical OLTP and DW/BI solutions on SQL Server. Andy wore many hats as a consultant including application developer, solution architect, mentor to development teams, mentor to DBAs, BI lead, SCRUM Master, and the guy-that-knows-a-bunch-of-stuff-about Microsoft.

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.

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

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page