Event Location:
NEIT
1408 Division Rd
East Greenwich, Rhode Island
Abstract:
PowerShell is the language of Windows and as such offers amazing integration and automation opportunities. In this presentation, Bryan will demonstrate how PowerShell can provide self-service BI solutions, serve as a powerful ETL tool and augment database development with far less coding than other languages. This talk starts off where the introduction to PowerShell left off and focuses on the many possibilities PowerShell offers as a development platform. Questions that will be considered include: Is PowerShell a better ETL tool than SSIS? How can you provide a GUI to your PowerShell programs? Which is better C# or PowerShell? You need to attend to see just how important PowerShell is to the Windows world of database development.
Speaker(s): Bryan Cafferky,
Abstract:
Microsoft has made extensive effort in the arena of self-service BI. By now most BI professionals have at least dabbled in power pivot and power view. But there is so much more. In this session we will look at some new components in Microsoft's arsenal of BI tools. Power Query is used to retrieve data from a much more varied set of data source types than was ever available before. Power Map can be used to quickly visualize geocentric data with layers and Power Point like slides. Lastly, the Power BI content on your Office 365 site supports sharing your workbooks with others, and has the coolest feature yet: Natural Language Q A.
Speaker(s): Todd Chittenden,
Abstract:
Need HA and DR? Tired of Mirroring or Log Shipping restrictions? The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution, which is an enterprise-level alternative to database mirroring. How, and why to use this will be covered.
Speaker(s): George Walters,
Abstract:
Data quality and data cleansing have always been major challenges to any enterprise that deals with data. For those of us who have dealt with Data Profiler Tasks in SQL Server 2008, we were shocked yet pleasantly surprised with the great advances that Microsoft has made with the advent of Data Quality Services, in the SQL Server 2012 release. In this hands-on presentation we shall be looking at how to set up a new knowledge base, based upon an existing one, set up rules, do knowledge discovery within the new knowledge base and finally cleanse the data through a data quality project. The end results being more effective data, guaranteed to keep end users and management happy.
Speaker(s): Steve Simon,
Abstract:
Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy. This is the Solo version of the Joint version normally done as an all-day precon
Speaker(s): Jason Brimhall,
Abstract:
Need to Geocluster? Tired of spamming your SAN with Tempdb? SQL Server 2012 and 2014 have significant improvements in Failover Clustering Instances. This will review shared-disk instance clustering and illustrate the new features.
Speaker(s): George Walters,
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,
Abstract:
Does only a small portion of your data change on a routine? Is index maintenance taking for ever? Do users mostly focus only on a subset of data such as the current year, month or day? Do you want to delete or insert massive amount s of data with almost no blocking? Well, step right up because data partitioning can do all this and more! We will take a look at the different option for partitioning, the pros and cons and how to implement them in SQL.
Speaker(s): Michael Nowill,
Abstract:
This session will act as an introduction to SSRS, its infrastructure, and the basics of report design. There will be a brief overview of the development environment, wizards, datasets, grouping, subscriptions, permissions, parameters and some basic graphing alongside the data.
Speaker(s): Christopher Seferlis,
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,
Abstract:
In this session, we will focus on how to formulate a Master Data Management strategy and build a solution to find the single version of the truth, aka the Golden Record. We will demonstrate building a sample customer domain in this session, showing how to use various tools including MDS for data quality, matching, and deduplication across multiple data sources.
Speaker(s): Dennis Messina,
Abstract:
Do you suffer from Recovery Amnesia? You have a complete strategy to backup your SQL environment; but what about the recovery? Is that even part of your strategy? Through this introductory session we will review the various aspects myths of backups in SQL Server. We will pin down how developing a recovery strategy to meet business requirements is, in fact, more important than just a good backup strategy.
Speaker(s): Chris Bell,
Abstract:
There are a variety of data storage options in Windows Azure. Understand the use cases for VMs in Infrastructure as a Service, databases in Platform as a Service and other options that exist.
Speaker(s): Andy Roberts,
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
Speaker(s): Randy Knight,
Abstract:
There is no better way to understand how TSQL is executing than through the execution plan. We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance. Be sure to bring your safety helmet!
Speaker(s): Edward Pollack,
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Speaker(s): Aaron Bertrand,
Abstract:
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker(s): Randy Knight,
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. http://wcompute.org/2012/05/19/review-of-sqlsaturday-142-network-or-perish/
Speaker(s): Paresh Motiwala,
Abstract:
Problem with Windows server, IO storage or SQL Server stopped your business dead in its tracks? Together we'll explore "check engine lights" for your SQL Server warning you of pending doom. I'll cover Performance Monitor, IO STACK, Dashboards, ErrorLogs, and DMVs to keep your server and SQL Server running smooth.
Speaker(s): Chris Skorlinski,
Abstract:
We will discuss customization possible with SSDT (templates and snippets) to produce artifacts that conform to your standards. We'll also look at limits of localdb and strategies to deal with them. Finally – we’ll look at Enterprise deployment strategies.
Speaker(s): John Flannery,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: https://blogs.sentryone.com/author/AaronBertrand
Aaron, Product Manager at SentryOne, produces performance and optimization tools for the entire Microsoft data platform, as well as Plan Explorer, a free tool for SQL Server execution plan analysis. In his spare time, he is either playing volleyball, curling, blogging at sqlperformance.com and blogs.sentryone.com, or contributing to SQL Server conversations on Twitter and dba.stackexchange.com. He has worked with SQL Server since 6.5 and has been an MVP since 1997.
LinkedIn: https://www.linkedin.com/profile/view?id=81593638
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.
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
LinkedIn: http://www.linkedin.com/in/pareshmotiwala
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
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Contact: http://blog.bizdataviz.com
Chris Seferlis is the CIO of East Coast Seafood, the worlds largest shipper of Live North American Lobster and listed among the top 25 largest seafood companies in North America. He has 18 years experience working in IT and solving technology challenges from a business perspective. Chris is an MCITP in SQL Server 2012 with an MBA from UMass bringing a mix of business awareness with practical technology solutions primarily focusing on Business Intelligence within the Microsoft SQL stack.
LinkedIn: http://www.linkedin.com/in/johnwflannery/
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.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
LinkedIn: https://www.linkedin.com/pub/bryancafferky
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.
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
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.
LinkedIn: https://www.linkedin.com/in/georgewalters
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
LinkedIn: https://www.linkedin.com/in/dennismessina
Contact: http://www.profisee.com
Dennis Messina is the Northeast Regional Director with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which was sold to Microsoft in 2007. Profisee focuses on Master Data Management (MDM) and is a Microsoft Gold Partner providing solutions built on MDS and the Microsoft stack. Prior to joining Profisee, Dennis spent 10 years working as a Solution Specialist and Account Manager at Microsoft based in NYC.
LinkedIn: https://www.linkedin.com/in/georgewalters
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
LinkedIn: http://www.linkedin.com/in/stephenrsimon/
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
LinkedIn: https://www.linkedin.com/in/sunilkadimdiwan
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
LinkedIn: http://www.linkedin.com/in/toddchitt
Contact: http://blog.blumshapiro.com/blog/author/toddc/
Todd started working with Microsoft’s SSRS in 2004. When Microsoft released its rebuild of SQL Server in 2005, he quickly added the full BI Stack to his repertoire. He became a MCTS in SQL Server 2005. Today, Todd works for Blum Shapiro as a Business Intelligence Architect on various BI Projects across a wide range of company sizes and product combinations. He is a Microsoft Certified Solutions Expert in SQL Server Business Intelligence and a frequent speaker at local User Groups and SQLSaturday events. He Started working with Power BI in its early development time before General Availability in July of 2015.
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.
LinkedIn: https://www.linkedin.com/pub/andy-roberts/0/126/793?
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.
LinkedIn: https://www.linkedin.com/pub/bryancafferky
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.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
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.
The following is a list of sponsors that helped fund the event.