SQLSaturday #302 - Albany 2014
Event Date: 07/26/2014 00:00:00
Event Location:
- SUNY Albany
- 1400 Washington Ave
- Albany, New York
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: Creating Access 2013 Web Apps based on SQL Azure using SharePoint
Abstract: Access 2013 web apps feature a new, full integration 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 in Access apps. In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action. We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades. And lastly, see the pros/cons of Access Web Apps in a corporate environment.
Speaker(s):
- Andy Tabisz
Track and Room: BI / DBA - 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: Database Design - N/A
Title: Effective use of temporary tables
Abstract: Abstract:
Every developer eventually comes against business logic that can’t be handled with a single simple or complex query. TSQL provides the developer with several constructs that can store temporary result sets that are passed to the next query in the script.
I will be covering these various TSQL techniques with examples using the [AdventureWorks] database as well as a toy database called AUTOS. The pros and cons of each construct will be examined. Advanced options like enabling trace flag 1118 will be explored.
Coverage:
1 – Derived tables. 2 – Local temporary tables. 3 – Global temporary tables. 4 – Table variables. 5 – Common Table Expressions (CTE). 6 – User databases in [tempdb]. 7 – Trace Flag 1118.
Speaker(s):
- John Miner
Track and Room: Development - N/A
Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
Abstract: Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker(s):
- Janis Griffin
Track and Room: Database Administration - 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: General Use - N/A
Title: PowerShell for Database Developers
Abstract: PowerShell has become the backbone of Windows Administrators but not heavily adopted by SQL Developers and this presentation is out to change that. Do you ever need to encrypt, decrypt, zip, unzip, combine files, export to csv format , import from csv format, move, copy, rename, even provide a nice interface to some powerful script you wrote? Bryan will even demonstrate how a PowerShell script can automatically navigate web pages doing tasks for you on the internet. In short, there is nothing PowerShell can’t do an if you are a SQL Developer or DBA, you need to be leverage its Power!
Speaker(s):
- Bryan Cafferky
Track and Room: Development - N/A
Title: How Not to Be a Cranky DBA
Abstract: Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.
Speaker(s):
- Mike Hillwig
Track and Room: General Use - N/A
Title: DANGER: The Art and Science of Presenting
Abstract: Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room–including you.
Speaker(s):
- Mark Vaillancourt
Track and Room: General Use - N/A
Title: BIML–Step by Step
Abstract: BIML–Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We’ll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We’ll move through basic syntax of plain BIML, and progress to BIMLScript, which enables exponentially faster development of SSIS packages.
Speaker(s):
- Julie Smith
Track and Room: Business Intelligence - N/A
Title: HealthySQL 2.0
Abstract: Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-) Session Level: Beginner Robert Pearl Speaker photo Robert Pearl, President of Pearl Knowledge Solutions, Inc., SQL MVP/SME, solutions-oriented Senior DBA with 12+ years of experience. He’s SQLCommunity/SQLSaturday evangelist/promoter and maintains his regular blog Pearlknows
Speaker(s):
- Robert Pearl
Track and Room: BI / DBA - N/A
Title: The Spy Who Loathed Me - An Intro to SQL Security
Abstract: You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.
Speaker(s):
- Chris Bell
Track and Room: BI / DBA - N/A
Title: Know Backups and Know Recovery
Abstract: It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan? In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
Speaker(s):
- Tim Radney
Track and Room: Database Administration - 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: Business Intelligence - N/A
Title: Ten T-SQL Techniques with Tally Tables
Abstract: Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
Speaker(s):
- Chris Hyde
Track and Room: Development - 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: Database Design - N/A
Title: SQL Server Storage Engine under the hood
Abstract: How SQL Server performs I/O
How is SQL Server really accessing the data and log files on the disk? What’s done asynchronous and what’s synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what’s different when SQL Server is starting up. Which I/O Subsystems (including SSD) are best for which type of data and what’s the impact if you choose a different one. Which files can be placed on the same volume and which should not.
Speaker(s):
- Thomas Grohser
Track and Room: Database Administration - N/A
Title: MongoDB for the Relational DBA
Abstract: NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there’s not RELATIONAL in DBA.
On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.
On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to.
Speaker(s):
- Justin Dearing
Track and Room: Development - 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: BI / DBA - N/A
Title: Database Forensics - Part 2
Abstract: Further to Database Foresnsics -Part 1, this session will discuss, various methods to analyse possible criminal actions and pin point it to a specific person/group of persons and time/time frame.
- Analyzing Network Traffic
- Searching for deleted, changed, renamed database files.
- Discussing header info of Database files,(and footers)
- Analyzing Logs: Transaction logs, Event Viewer, Trace Files, SQL Server Logs.
- Trapping crime as it happens or before it happens, use of “Honey Pots”
Speaker(s):
- Paresh Motiwala
Track and Room: General Use - N/A
Title: Entity Framework - Optimization Best Practices
Abstract: An in-depth look at performance considerations when using Entity Framework. This talk will cover common pitfalls, best practices, and performance troubleshooting. We’ll also discuss the pro’s and cons of using an ORM layer and examine situations where it is, and is not, the right tool for the job.
Speaker(s):
- Kelly Gendron
Track and Room: Development - N/A
Title: Treating Tables Like Legos, Partitioning Basics
Abstract: Partitioning allows us to isolate parts of our table as small chunks called partitions. In turn, these partitions allow us to do some really cool tricks for manageability and performance. In this session we’ll look at the concepts surrounding partitioning and how we can apply them. We’ll reinforce what we cover with some cool demo’s showing some really neat tricks.
Speaker(s):
- Brandon Leach
Track and Room: Database Design - N/A
Title: Remove the Linked Server 2 Hop Limitation by Implementing Kerberos
Abstract: Some of us have had to experience SSPI, untrusted domain, for login failed for NT Authority\Anonymous Logon errors can have come to the conclusion that there is a limitation when using windows authentication and linked servers. This is actually a limitation to the authentication method and not the linked servers. By implementing the new Kerberos authentication method in your Active Directory environment, you can overcome this 2 hop limitation.
Speaker(s):
- Derek Stanley
Track and Room: Database Administration - N/A
Title: Show me whatcha workin’ with: Big Data Edition
Abstract: Congratulations. You’ve setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we’re gonna go over Data Mining tools to help you gain some insight from your data. We’ll use tools like Hadoop and R to go over a couple examples. All this wrapped in true success stories and “Best Practices”.
Speaker(s):
- Josh Luedeman
Track and Room: Business Intelligence - N/A
Title: Hybrid Cloud Scenarios with SQL Server 2014
Abstract: SQL 2014 has 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 and Azure.
Speaker(s):
- George Walters
Track and Room: Database Administration - N/A
Title: Database Forensics - Part 1
Abstract: These are the days of increasing cyber and computer crimes. As DBAs and guardians of corporate data, it is your paramount duty to not only prevent any data loss but also discover lost , damaged or sabotaged data. But how can you do that without destroying evidence? Remember electronic evidence is extremely fragile. In this the first of the two part session, we will explore the following:
- Fundamentals of Computer Forensics
- Tools to use in Computer Forensics–Data Acquisition
- Processing a crime scene
- Network Forensics and Live Acquistions.
- Submitting reports
Speaker(s):
- Paresh Motiwala
Track and Room: General Use - N/A
Title: Creating an SSIS Framework
Abstract: In this session we will cover what is a SSIS Framework, why you need a SSIS Framework, and how to implement it.
Speaker(s):
- James Phillips
Track and Room: Business Intelligence - N/A
Title: 101 Stupid Things Your Colleagues Do When Setting Up SQL Server
Abstract: There are some things that you just wish your colleagues had known before they installed an instance of SQL Server. Next, Next, Next, Done. Right? NO!!! The stink from that just doesn’t go away. In this session you’ll learn which default settings can come back to haunt you as well as best-practice configurations for the entire infrastructure stack (Hardware, Storage, Virtualization, OS, and SQL Server) to ensure performance. This session is for the accidental DBA or anyone who needs to install SQL Server occasionally (or for their colleagues who need to mop up afterwards).
Speaker(s):
- Matt Slocum
Track and Room: Database Design - N/A
Title: SSIS Optimization techniques
Abstract: There are number of things you can do to optimize SSIS packages to improve overall performance and shorten load times. This session will review 3 areas: common mistakes developers make, settings and tweaks, and design pattern improvements. Some of the things you will see can make dramatic improvements in speed, while others are for those seeking to pull every last bit of performance out of your packages.
Speaker(s):
- Daniel Bowlin
Track and Room: Business Intelligence - N/A
Title: Seven Strategies for Awesome Excel Dashboards
Abstract: Come learn the Seven Strategies that Autotask uses to build their performance dashboards using the Microsoft BI platform (primarily Excel 2010/2013 and SQL Server). During this presentation, I will outline these strategies and highlight how they are implemented in actual Autotask Performance Dashboards. Whether you are a business owner interested in using dashboards or on the technical side looking for more information on how to build them – there is something here for you.
Speaker(s):
- Joe Rourke
Track and Room: BI / DBA - N/A
Title: SQL Server Compression - Getting More Out of Less
Abstract: We are storing more information then we ever have before and we need to retain this information for longer periods of time. Do we keep adding more and more disk space? What about performance? What about cost? Is there some way we can use the existing space more efficiently? With data compression we can tackle these issues and do it with minimal or even no changes to our existing code.
Speaker(s):
- Michael Nowill
Track and Room: Database Design - 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.
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.
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
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.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Joe Rourke
Contact: http://www.dashboardmentor.com
Autotask Director of Product Management - Joe has managed the Autotask core product roadmap for the past 8 years. He pioneered innovations such as the performance dashboards which provide companies a visual view of their business to make fact-based decisions. He is in the thick of planning through the product lifecycle, gathering and prioritizing requirements, defining the product roadmap and vision. Joe has a BS in Computer Science from Siena College.
Daniel Bowlin
Twitter: - @SQLBI_Dan
LinkedIn: Daniel Bowlin
Contact: http://www.danielbowlin.com/
I am a data integration developer at Time Warner Cable. I have been working with SQL Server technologies since the late 90s. About 6 years ago I specialized in the SQL Server BI stack. Lately I have been almost exclusively working in SSIS.
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.
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.
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.
Josh Luedeman
Twitter: - http://www.twitter.com/joshluedeman
LinkedIn: Josh Luedeman
Contact: http://www.joshluedeman.com
Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft’s Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.
Chris Bell
Twitter: - @cbelldba
LinkedIn: Chris Bell
Contact: https://www.wateroxconsulting.com/
Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.
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.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Robert Pearl
Twitter: - @PearlKnows
LinkedIn: Robert Pearl
Contact: http://www.sqlservercentral.com/blogs/pearlknows/
Robert Pearl is a 5-year SQL Server MVP and creator of the award-winning database and monitoring alert system, SQLCentric. Author of the HealthySQL - Comprehensive Guide to Healthy SQL Server Performance. He’s the founder of Pearl Knowledge Solutions. As a SQL Server community evangelist, he covers local SQL Server events in the New York City area and maintains the Pearl Knows blog. Voted TOP BLOGGER in 2011.
Kelly Gendron
Kelly Gendron is a senior software developer with over 9 years of experience in .Net and full stack web development. She spends most of her free time starting projects and then abandoning them for other, more interesting projects.
Derek Stanley
- 15+ Years Experience in IT Industry
- 2000 - 2003: Lead Trainer at Cytech Computer School (MCSE-NT, MCSE-2K, CCNA)
- 2003 - 2006: Chief Systems Engineer for US Army
- 2006 - 2007: Technical Trainer for New Horizons, Albany (MCSE, MCSA, Sec +, Net +, CCNA)
- 2006 - 2010: Senior DBA and IT Manager for OptionSoft Technologies
- 2010 - 2013: Database Administrator\Application Development Manager for DavisVision
- 2013 - Present: DBA for Commerce Hub
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.
Matt Slocum
Twitter: - SQLMatt
LinkedIn: Matt Slocum
Contact: http://www.sqlmatt.com
Husband, Father, and certifiable…I mean certified MCSE: SQL Data Platform. I manage lots of DBs on SQL 7-2017. I specialize in database hardware, SQL replication, and performance troubleshooting.
I also love space, technology Japanese culture.
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
Mark Vaillancourt
Twitter: - @markvsql
LinkedIn: Mark Vaillancourt
Contact: http://markvsql.com
Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.
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
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
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.
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
Justin Dearing
Twitter: - zippy1981
LinkedIn: Justin Dearing
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.
Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
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.
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
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.
Sponsors
The following is a list of sponsors that helped fund the event: