SQLSaturday #142 - Waltham 2012
Event Date: 05/19/2012 00:00:00
Event Location:
- Microsoft
- 201 Jones Rd
- Waltham, Massachusetts
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: Writing Faster Procedures and Functions
Abstract: Stored procedures and functions are the mainstay of SQL Server coding. This presentation shows techniques to improve performance using the lessons learned by Andy Novick over years of development. We start with the most important techniques to learn where time is going using standard server traces and SQL Server Extended Events. Once we know where the time is going we look at strategies to decrease - Achieving Minimally Logging–Managing indexes on temp tables o Why heaps are often the best choice o How to discover if an index is helping o How building non-clustered indexes on heaps is faster- Rewriting scalar and multi-statement functions to as inline functions- Temp tables vs temp variables- The Magic, Go Faster Switc
Speaker(s):
- Andrew Novick
Track and Room: Track 2 - N/A
Title: Building your first BI Semantic Model Tabular
Abstract: SQL Server 2012 introduces the new Analysis Services Tabular Mode. BI Semantic Model (BISM) Tabular is in-memory database in Analysis Services using state-of-the-art compression algorithms. BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add-in. In this session, I will show you how to build a complete solution in Tabular and creating one from the ground up, deploy a rich semantic model and discover a simpler method for analyzing business data. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model. You will be able to create your BISM Tabular models, and gain a solid background to enable you starting your next project.
Speaker(s):
- Ayad Shammout
Track and Room: Track 1 - N/A
Title: Aviation Disasters - And IT Lessons From Them
Abstract: What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; even if a freak accident occurs, training and preparation can make all the difference - it’s the same for us! In this session we’ll have a group discussion through a few actual aviation disasters and see what skills, attitudes and thought processes led to them. We’ll look at some success stories and see what was different. We’ll see how these attitudes and decisions impact us at work and talk about how to identify them in ourselves and our teams. Then we’ll figure out how to prevent them in our day jobs.
Speaker(s):
- Mike Walsh
Track and Room: Track 5 - N/A
Title: Getting Started with MDX: The (Very) Basics
Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker(s):
- William E Pearson III
Track and Room: Track 4 - N/A
Title: Inroduction to Triggers
Abstract: This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn’t be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well
Speaker(s):
- Jack Corbett
Track and Room: Track 6 - N/A
Title: It Costs How Much? SQL Server Licensing
Abstract: Did you know that as of June 30th the model for licensing SQL Server is changing? Learn about what these changes mean to you and your IT organization. We will discuss the impact to hardware architecture, virtualization environments, and DR. Understand the strategies you are your organization can take to minimize the financial impact of these licenses changes.
Speaker(s):
- Joseph D’Antoni
Track and Room: Track 5 - N/A
Title: Hadoopla - Microsoft and the Hadoop Ecosystem
Abstract: Big Data is the buzz word du jour, and Hadoop (the open source map/reduce framework) is a primary part of the conversation. We’ll cover what Hadoop does (and doesn’t do) as well as the various other technologies that touch upon it. We’ll also look at what Microsoft is doing with Hadoop, both in the cloud and on-premises and how it’s a part of the overall Microsoft BI offering.
Speaker(s):
- Jim O’Neil
Track and Room: Track 1 - N/A
Title: SQL 2012 – 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 presentation you’ll learn all about the new DR features in SQL Server 2012 and see them in practice.
Speaker(s):
- Joseph D’Antoni
Track and Room: Track 3 - N/A
Title: Data Partitioning in SQL 2012
Abstract: We will discuss both the “how tos” and “why tos” of data partitioning. We will actually partition sales data in AdventureWorks2008R2. (Bring a copy – play along.) The majority of the presentation will focus on the performance effects of partitioning – and what to look for in query plans. In addition, we will discuss and implement adding a new partition, splitting off a partition, splitting on a partition (common in Data Warehouse scenarios), Aligned Indexes, Partial Database Availability and Statistics management implications.
Speaker(s):
- John Flannery
Track and Room: Track 3 - N/A
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract: SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
Speaker(s):
- William E Pearson III
Track and Room: Track 4 - N/A
Title: Transitioning from SQL Trace to Extended Events
Abstract: Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions.
Speaker(s):
- Jack Corbett
Track and Room: Track 2 - N/A
Title: New Server in an Hour? No Problem!
Abstract: “We need a new server before you leave on vacation!” Never mind that it’s Friday at 2:00 PM and you need to be in the airport in a couple of hours. This isn’t the time to panic. Mike Hillwig deploys new servers every week and has a streamlined process that allows him to deploy a new server in an hour from delivery of the Windows server. We’re not talking just installing SQL Server. This is having the new server production-ready in an hour, including scripts to backup, monitor, and maintain databases. With a little bit of advanced planning, following a few simple rules, and some scripting, you can be ready for just such an emergency. And you’ll still catch you flight!
Speaker(s):
- Mike Hillwig
Track and Room: Track 6 - N/A
Title: What’s in SQL Server 2012 for the DBA?
Abstract: In this session, you’ll learn how the new SQL Server 2012 features like Always On will help you create a better high availability experience for your users and applications. Then, you’ll learn about the new table types (file table) and how you can use it to create a better content management system. Lastly, we’ll cover new indexing strategies that SQL Server 2012 now allows called Column Store indexes to potentially give your queries a 500x boost!
Speaker(s):
- Brian Knight
Track and Room: Track 2 - N/A
Title: SQL Server Data Tools(SSDT) a.k.a. “Juneau”
Abstract: SSDT is a brand new new integrated environment for database developers. It’s based on VS2010 Shell and it will replace ‘Database Projects’ found in VS2010. Database Developers should be able to perform most, if not all of their work without any need to switch to a different tool. It enables Declarative, Model-Based database development, allows to develop both online/offline, enables local testing and SQL Server version-aware targeting. SSDT also makes it easy to integrate your code with Source Control Systems like TFS. At the beginning of the session I will explain what is declarative, model-based development and why do we need it. Then I will demonstrate the power of SSDT by showing how to use.
Speaker(s):
- Varsham Papikian
Track and Room: Track 1 - N/A
Title: Get-PowerShell | Get-SQLServer
Abstract: PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).
Speaker(s):
- SB Chatterjee
Track and Room: Track 5 - N/A
Title: Intuitive and ad-hoc reporting using Power View
Abstract: Microsoft SQL Server 2012 Power View (formerly known as Project Crescent) provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on PowerPivot workbooks published in a PowerPivot Gallery, or tabular models deployed to Analysis Services (SSAS). Power View is a browser-based Silverlight application launched from SharePoint Server 2010.
In this session I will give you an overview of the key features of Power View and then I will develop some of these views.
Speaker(s):
- Sunil Kadimdiwan
Track and Room: Track 1 - N/A
Title: Table Compression
Abstract: SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
Speaker(s):
- Jason Brimhall
Track and Room: Track 3 - N/A
Title: Network or Perish
Abstract: As IT personnel, we tend to get boxed-in, stranded on our own little island. We fail to make people aware of our activities, both within our own organization and in our wider professional circles. Just like a shipwrecked captain waiting for the rescue boat on a desert island, if you fail to communicate, your career will be stuck with no possibility of progression. This presentation will show you how to leverage networking and self-marketing techniques that will allow you to set sail off the island and into new opportunities.
Speaker(s):
- Paresh Motiwala
Track and Room: Track 6 - N/A
Title: What’s New in BI in SQL Server 2012
Abstract: In this session, you’ll go through a whirlwind tour of what’s new in one of Microsoft’s biggest releases of SQL Server in its history: SQL Server code named SQL Server 2012. You’ll learn about the upcoming Crescent feature, which allows users to build ad-hoc reports easily. You’ll also learn about the Tabular Model in SSAS and the huge enhancements to SSIS. Lastly, Brian will cover the database engine enhancements that make BI more accessible and faster.
Speaker(s):
- Brian Knight
Track and Room: Track 1 - N/A
Title: What’s New in T-SQL 2012 Denali
Abstract: New Code introduction and New DMV’s In sql Server 2012. New Coding features in management Studio
Speaker(s):
- Kailash Chintamani
Track and Room: Track 2 - N/A
Title: Loading a Data Warehouse using SSIS 2012
Abstract: N/A
Speaker(s):
- James Phillips
Track and Room: Track 3 - N/A
Title: New High Availability options with SQL Server 2
Abstract: Introduction to new availability options in SQL Server 2012 including enhancements to Failover and the new AlwaysOn Availability Groups to provide multiple readable secondaries!
Speaker(s):
- Andy Roberts
Track and Room: Track 6 - N/A
Title: New in SQL Server 2012 for Devs: SSMS and T-SQL
Abstract: SQL Server 2012 has a re-designed SSMS which is based on VS2010 Shell. There are many new features which should help us to be more productive. During the session I will demonstrate the new features in SSMS. I will also show a few existing but ‘hidden’ features. Then I will discuss a few new T-SQL features introduced in SQL Server 2012.
Speaker(s):
- Varsham Papikian
Track and Room: Track 2 - N/A
Title: What is this cache and how did it get so big?
Abstract: Ever wonder what’s in your SQL Plan cache? Wonder why or how the plan cache got so big? This session will cover what the cache is, how it is used, and how poor application and query design can make it worse. Rather than put participants to sleep with dozens of slides we will get down and dirty with lots of demos including .Net code and some cool DMVs to guide the way.
Speaker(s):
- Doug Brendle
Track and Room: Track 5 - N/A
Title: What’s new in SQL Server 2012 SSIS
Abstract: SQL Server 2012 gave more than a facelift to SSIS! This session will discuss improvements to the design, deployment and runtime environments.
Speaker(s):
- Andy Roberts
Track and Room: Track 3 - N/A
Title: Best Practices for Monitoring Databases on VMware
Abstract: SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker(s):
- Kathy Gibbs
Track and Room: Track 6 - N/A
Title: To click or to type, that is the question
Abstract: When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee’s Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks.
Speaker(s):
- David Taylor
Track and Room: Track 4 - N/A
Title: Best Practices Document
Abstract: As DBAs we are often straddled with writing a best practices document. In this session, I will start with a bare bones template and then we can collectively come up with a Best Practices Document by the end of the session. I challenge you that this document can come in handy, no matter where you go.If time permits, we can also discuss how to implement this in organizations with varying degrees of acceptance.
Speaker(s):
- Paresh Motiwala
Track and Room: Track 5 - 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.
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.
Jim O’Neil
Contact: http://blogs.msdn.com/jimoneil
Jim is a Developer Evangelist for Microsoft who covers the Northeast District (namely, New England and upstate New York). His overall focus is to engage with the development community in the area through user groups, code camps, BarCamps, Microsoft-sponsored events, etc., and just in general serve as ambassador for Microsoft. Over the past few years, Jim has been focusing on software development scenarios using cloud computing and Windows Azure.
Doug Brendle
Twitter: - @sql_db
Doug Brendle is a Solution Architect with Scalability Experts and has worked with SQL Server for over 10 years covering 7.0 to 2008r2. In one capacity or another he’s been involved with one database platform or another for over (almost entirely SQL Server from SQL Server, but with also enough MySQL and Oracle enough to be very dangerous) either as a developer, DBA or a consultant. Doug has been a member of PASS since 2005 and been active in his local SSUG and SQLSaturday events delivering his “What is this Cache and how did it get so big?” presentation to appreciative audiences. He also has recently discovered eerie similarities between tuning a query and tuning a banjo.
Kailash Chintamani
Over 14 years of Information Technology experience and presently in a Sr. Database Adminstrator with Business Intelligence Architect expertise at GE(Electric Insurance Co). I specializes in data access architecture, data integration especially extract transformation and load (ETL), and Microsoft® business intelligence solution design and development. Microsoft® Certified IT Professional (MCITP) for SQL Server™ 2005 Business Intelligence Developer and 2008.
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.
SB Chatterjee
Contact: http://weblogs.asp.net/sbchatterjee/default.aspx
Architect/Tech-lead in Hartford CT with over 20 years IT experience. Worked at companies like Aetna, IBM, Microsoft, UNICEF, United Technologies and State of Connecticut. Holds graduate degrees in Computer Science, Business Administration and Economics. Awarded the Microsoft MVP Award for SharePoint products 2008 thru 2013. He is active in the SharePoint StackExchange and other forums. Twitter: @sbc111 Acting Director - CT.NET Dev Group (CTDOTNET) CT Dev Startups Group (CTDEVSTARTUP).
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
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
James Phillips
Twitter: - @JPhillips_Data
James Phillips is the VP Technology for Mizuho Americas and has over 20 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He is a past Leader of the Northern NJ SQL Server User group and current Leader for SQLSaturday NYC. He has worked in a wide array of industries including finance and insurance. Regularly speaks about Database Performance Tuning, SSIS and Power BI topics. Also an avid softball player and father to 5 beautiful children.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Varsham Papikian
Twitter: - https://twitter.com/SQLVAR
LinkedIn: Varsham Papikian
Varsham Papikian has 20+ years of experience working with databases and different Microsoft technologies. He works as a Principal Database Architect, Developer and DBA at Wolters Kluwer Financial Services. He speaks at different events like SQLSaturday or user group meetings. Varsham helped to start and then run ‘Boston Business Intelligence’ user group for some time. Previously he was also involved in running ‘New England SQL Server’ user group.
Andy Roberts
Contact: http://blogs.msdn.com/andyroberts
Andy Roberts is a Data Platform Technology 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.
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
Paresh Motiwala
Twitter: - pareshmotiwala
LinkedIn: Paresh Motiwala
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
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
Andy Roberts
Contact: http://blogs.msdn.com/andyroberts
Andy Roberts is a Data Platform Technology 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.
Varsham Papikian
Twitter: - https://twitter.com/SQLVAR
LinkedIn: Varsham Papikian
Varsham Papikian has 20+ years of experience working with databases and different Microsoft technologies. He works as a Principal Database Architect, Developer and DBA at Wolters Kluwer Financial Services. He speaks at different events like SQLSaturday or user group meetings. Varsham helped to start and then run ‘Boston Business Intelligence’ user group for some time. Previously he was also involved in running ‘New England SQL Server’ user group.
Ayad Shammout
Twitter: - @aashammout
LinkedIn: Ayad Shammout
Contact: http://ayadshammout.com/
Ayad Shammout is a Database amp; BI Specialist and Microsoft MVP. He has more than 25 years deep experience in Database technologies and specializing in SQL Server, SharePoint, Windows OS. Shammout is working in OLTP design and development, Data Warehousing, Business Intelligence and Big Data, with extensive experience in data management and analysis. Ayad has been involved in many SQL Server Enterprise implementations for High-Availability, DR, Business Intelligence, Data Mining and Big Data.
Mike Walsh
Twitter: - mike_walsh
LinkedIn: Mike Walsh
Contact: https://www.straightpathsql.com
Mike Walsh is an experienced SQL Server professional and has worked with SQL Server since version 6.5. He has been in the role of DBA, developer, and performance tuner, but always leans on his DBA and tuning experience. He has been awarded the SQL Server (now Data Platform) designation 6 times since 2011 and is a current MVP. He runs a SQL Server consultancy focused on DBA services and cloud enablement. He has spoken several times at PASS and regional events. In his spare time, he runs a small farm with his family in rural New Hampshire and is a call Firefighter in his small town.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
David Taylor
Contact: http://dyfhid.wordpress.com
David is an DBA/Developer for a private educational institution in New Hampshire. David has five years of experience learning and administering SQL Server and more recently developing BI solutions using SSIS. Having earned both his MCTS and MCITP DBA certifications for SQL Server 2008, he still considers himself a beginner sharing with other beginners.
Kathy Gibbs
Twitter: - KGdba
LinkedIn: Kathy Gibbs
Kathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
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.
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”.
Paresh Motiwala
Twitter: - pareshmotiwala
LinkedIn: Paresh Motiwala
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
Brian Knight
Twitter: - @BrianKnight
Contact: http://www.bidn.com/people/brianknight
Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.
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”.
Sponsors
The following is a list of sponsors that helped fund the event: