SQLSaturday #314 - Providence 2014
Event Date: 10/18/2014 00:00:00
Event Location:
- NEIT
- 1408 Division Rd
- East Greenwich, Rhode Island
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: Breaking Down BI Barriers with PowerShell
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
Track and Room: Track 2 (DEV) - N/A
Title: Power BI Components in Microsoft’s Self-Service BI Suite
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
Track and Room: Track 1 (BI) - N/A
Title: SQL Server 2012/2014 AlwaysOn Availability Groups
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
Track and Room: Track 4 (ADM) - N/A
Title: A dive into Data Quality Services
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
Track and Room: Track 1 (BI) - N/A
Title: Murder They Wrote
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
Track and Room: Track 3 (PERF) - N/A
Title: SQL Server 2012/2014 Failover Clustering
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
Track and Room: Track 4 (ADM) - 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: Track 2 (DEV) - N/A
Title: Data Partitioning - for performance, scalability and sanity!
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
Track and Room: Track 2 (DEV) - N/A
Title: Scratching the surface: An overview of SSRS and building your first BI Report
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
Track and Room: Track 1 (BI) - 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 1 (BI) - N/A
Title: The Quest for the Golden Record:MDM Best Practices
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
Track and Room: Track 1 (BI) - N/A
Title: Prevent Recovery Amnesia – Forget the Backups
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
Track and Room: Track 4 (ADM) - N/A
Title: Storing Data in Windows Azure
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
Track and Room: Track 4 (ADM) - N/A
Title: Understanding Transaction Isolation Levels
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
Track and Room: Track 3 (PERF) - N/A
Title: Diving Into Query Execution Plans
Abstract: There is no better way to understand how TSQL is executing than through the execution plan. We will go into detail about the more complex parts of execution plans, relating them to other query statistics, and use this information to improve overall query performance. Be sure to bring your safety helmet!
Speaker(s):
- Edward Pollack
Track and Room: Track 3 (PERF) - N/A
Title: T-SQL : Bad Habits Best Practices
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
Track and Room: Track 2 (DEV) - N/A
Title: Locks, Blocks, and Deadlocks Oh My!
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
Track and Room: Track 3 (PERF) - 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.
http://wcompute.org/2012/05/19/review-of-sqlsaturday-142-network-or-perish/
Speaker(s):
- Paresh Motiwala
Track and Room: Track 4 (ADM) - N/A
Title: Check Engine Lights
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
Track and Room: Track 3 (PERF) - N/A
Title: SQL Server Data Tools Dev Life Cycle
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
Track and Room: Track 2 (DEV) - 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.
Aaron Bertrand
Twitter: - @AaronBertrand
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.
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.
Chris Skorlinski
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;
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
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
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.
Christopher Seferlis
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.
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.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
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.
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.
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.
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
Dennis Messina
LinkedIn: Dennis Messina
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.
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
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
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
Todd Chittenden
Twitter: - @toddchitt
LinkedIn: Todd Chittenden
Contact: http://blog.blumshapiro.com/blog/author/toddc/
Todd started working with Microsoft’s SSRS in 2004. When Microsoft released its rebuild of SQL Server in 2005, he quickly added the full BI Stack to his repertoire. He became a MCTS in SQL Server 2005. Today, Todd works for Blum Shapiro as a Business Intelligence Architect on various BI Projects across a wide range of company sizes and product combinations. He is a Microsoft Certified Solutions Expert in SQL Server Business Intelligence and a frequent speaker at local User Groups and SQLSaturday events. He Started working with Power BI in its early development time before General Availability in July of 2015.
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.
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.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: