SQLSaturday #146 - Nashua 2012

Event Date: 10/20/2012 00:00:00

Event Location:

Rivier College - Education Center Building
420 South Main Street
Nashua, New Hampshire

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Bridging the Chasm: BI Theory vs. Practice

Abstract: A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.

Speaker(s):

William E Pearson III

Track and Room: Track 6 - N/A

Title: Performance Monitoring 101

Abstract: Are you confused where to start when it comes to performance monitoring? If so then come learn the essentials of daily performance monitoring using readily available TSQL scripts, stored procedures and utilities. You will see how easy it is to identify potential bottlenecks and poor performing queries without requiring an extensive infrastructure. Most DBA’s these days are overworked and under budgeted. You will walk away with a solid grasp on how to approach the seemingly daunting task of performance monitoring.

Speaker(s):

Andrew Kelly

Track and Room: Track 1 - N/A

Title: Faster Stored Procedures and Functions

Abstract: Stored procedures and functions are the mainstay of SQL Server coding. This presentation will show techniques to improve their performance. We’ll start with techniques to learn where the time is really going using standard server traces and the new Extended Events. Once we know where the time is going we look at strategies to decrease it: • Managing indexes on temp tables

Why heaps are often the best choice for temp tables
How building non-clustered indexes on heaps is faster than building clustered indexes. • Rewriting scalar and multi-statement functions to as inline functions Each technique is illustrated with examples drawn from real cases in Andy’s work.

Speaker(s):

Andrew Novick

Track and Room: Track 3 - N/A

Title: Big Data with SQL Standard Edition - True Story

Abstract: While SQL Server Standard Edition ships without several advanced enterprise features, it nonetheless can be used as a cost-effective data platform for many Big Data OLTP applications. This talk will highlight what exactly SQL Standard Edition is, discuss the scale-up vs. scale-out debate, dive into techniques for ordering, splitting and joining very large tables, and present a case study.

Speaker(s):

Robert McCauley

Track and Room: Track 5 - N/A

Title: DBA Worst Practices, Disasters and Horror Stories

Abstract: Join SQL Server MVPs and Community Speakers Aaron Betrand, Andy Kelly, Joey D’Antoni and Mike Walsh as we discuss some of the worst practices we often see bite SQL Server environments. Most of these are settings and configurations that are destined to cause headaches from the defaults shipped with SQL Server, some are misunderstandings but all will cause you heartache. This will be a VERY interactive panel discussion. We’ll cover a list of worst practices, share horror stories from our own experiences and take plenty of questions from the audience. We’ll try and leave time at the end for you to throw your DBA or performance questions at this panel with over 50 years of SQL Server experience.

Speaker(s):

Mike Walsh

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 1 - N/A

Title: Beyond Plateaux: Optimize SSAS with Best Practices

Abstract: Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.

Speaker(s):

William E Pearson III

Track and Room: Track 6 - N/A

Title: EIM - Bringing Together SSIS, DQS, and MDS (300)

Abstract: Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution.

Speaker(s):

Matt Masson

Track and Room: Track 2 - N/A

Title: PowerPivot Power View: Create Impressive Reports

Abstract: Microsoft SQL Server 2012 PowerPivot and Power View provide a way for you to create impressive and dynamic reports for data analysts, business decision makers, and information workers. You can easily create and interact with large amount of data from multiple sources and publish share these reports views. In this session I will give you an overview of the key features of PowerPivot and Power View.

Speaker(s):

Sunil Kadimdiwan

Track and Room: Track 6 - N/A

Title: Advanced Transactional Replication

Abstract: We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to a table without having to snapshot; creating replicated tables on file systems other than Primary – including partitioned file systems. And hint – we will be leaving the wizard in Redmond!! Bring a copy of SQL 2012 Developers Edition with AdventureWorks2012 if you want to play along.

Speaker(s):

John Flannery

Track and Room: Track 4 - N/A

Title: Database Development ALM with SQL Server Data Tool

Abstract: Transform traditional database development by using SQL Server Data Tools - a declarative, model-based experience that supports both online and offline (project-based) database development.

Speaker(s):

Andy Roberts

Track and Room: Track 5 - N/A

Title: Database design for mere developers

Abstract: SQL Server 2012: Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development “patterns and anti-patterns”, final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.

Speaker(s):

Steve Simon

Track and Room: Track 3 - N/A

Title: Designing an SSIS Framework

Abstract: In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Speaker(s):

Andy Leonard

Track and Room: Track 2 - N/A

Title: Introduction to BI Semantic Model (BISM)

Abstract: SQL Server 2012 brings new efficient way of processing and designing data structures for analytics and reporting. These new concepts called BI Semantic Model and Tabular Model. In this session we will take a tour of building corporate BI Semantic Model step-by step using (SSDT). We also cover what are the Tabular model and Multidimensional models. How do I build a Tabular model, measures and KPI.

Speaker(s):

Slava Kokaev

Track and Room: Track 3 - N/A

Title: Way Too Deep–Inside AlwaysOn

Abstract: Are you really interested in the new Always On Availability Group feature in SQL 2012? Like really interested? We will talk about the basic architecture of AlwaysOn, then dive deep into the system views behind it, and then use Extended Events, to walk through what’s going on inside of SQL and the Windows cluster to make AlwaysOn work.

Speaker(s):

Joseph D’Antoni

Track and Room: Track 3 - N/A

Title: Alright,WHY is the server REALLY running so slow!

Abstract: SSRS 2012: Having just completed a PRACTICAL dashboard to answer JUST this exact question, we shall be looking at how to create a reporting tool that will provide YOUR management with all their answers. We shall be focusing on the plethora of information that may be reaped from Dynamic Managment Views (DMV) and see how KPI’s may be incorporated into the mix.

Speaker(s):

Steve Simon

Track and Room: Track 5 - N/A

Title: Effective use of temporary tables

Abstract: Every developer eventually comes against business logic that can not 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 derived tables, local temporary tables, global temporary tables, table variables, user tables in tempdb, and common table expressions in my examples using the AdventureWorks database. The pros and cons of each contruct will be examined. Advanced options like enabling trace flag 1118 will be explored.

Speaker(s):

John Miner

Track and Room: Track 4 - N/A

Title: SQL2012 Query Procedure Call Statistics

Abstract: Did you know that SQL Server keeps track of almost every call you make to the database instance? Do you know what information it collects and more importantly how to use that information effectively? Don’t get this confused with statistics used by the optimizer to generate the query plan. These are the stats gathered during the executions. In this session we will show you how to identify the query activity on your instance and allow you to make smart decisions on which ones to address first and get the biggest ROI on your precious time. Please note that most of this is applicable to SQL2008 as well.

Speaker(s):

Andrew Kelly

Track and Room: Track 1 - N/A

Title: Overcoming Barriers and Avoiding Mistakes with BI

Abstract: A Dynamic Dialog session: Whether you’re considering implementing business intelligence for the first time, have completed projects in the past (and are perhaps looking at later phases), or are somewhere in between, an investment in this session will likely pay dividends. Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog about common pitfalls or traps that we can encounter in designing and implementing BI. We’ll discuss, as a group, environmental and other challenges we have experienced, and share ways to avoid or minimize them, in our ongoing efforts with BI.

Speaker(s):

William E Pearson III

Track and Room: Track 6 - N/A

Title: Introduction to SQL Azure

Abstract: Provision, Create, Maintain and use SQL Azure Databases

Speaker(s):

Andy Roberts

Track and Room: Track 5 - N/A

Title: SSIS 2012 – Overview and Changes

Abstract: Matt Masson will discuss the latest and greatest in SSIS 2012. More details to be provided.

Speaker(s):

Mike Walsh

Track and Room: Track 2 - N/A

Title: “I See a Control Flow Tab. Now What?” (Level 100)

Abstract: This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Speaker(s):

Andy Leonard

Track and Room: Track 2 - N/A

Title: T-SQL : Bad Habits to Kick

Abstract: The session will cover a collection of minor bad habits that can occasionally lead to major problems.

Speaker(s):

Aaron Bertrand

Track and Room: Track 4 - N/A

Title: MDX Trek: First Contact

Abstract: Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

Speaker(s):

Mark Vaillancourt

Track and Room: Track 4 - 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 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.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

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.

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

Robert McCauley

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

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Mike Walsh

Twitter: - mike_walsh

LinkedIn: Mike Walsh

Contact: https://www.straightpathsql.com

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.

Matt Masson

Twitter: - @mattmasson

Contact: http://www.mattmasson.com/

Matt Masson is a Program Manager in the Information Management and Machine Learning (IMML) organization. Matt has worked on multiple data integration products, including Power Query, SSIS, DQS, MDS, and the Data Management Gateway for Power BI. He has authored two books on SSIS (Apress, and MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at http://www.mattmasson.com/.

Andrew Kelly

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

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

Andy Roberts

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

Slava Kokaev

Twitter: - @SlavaKokaev

LinkedIn: Slava Kokaev

Contact: http://bostonbi.org/Blog.aspx

Slava Kokaev is a lead BI architect. Over a 6 years he spend on Business Analytics side Modeling, Analyzing and Optimizing business processes. Designing and deploying Analytical Solutions. Last 10 years Slava is specializing in Design and Development of the BI Systems and Custom BI Applications He is the leader of the Boston Microsoft BI Users Group. And heavily involved in MS BI Community by: organizing and speaking in BI Code Camps, Firestarters, SqlSaturdays and recording video tutoria

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.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Steve Simon

Contact: http://www.infogoldusa.com

Steve Simon is a senior BI engineer with MyWebGrocer. He has been involved with database design and analysis for over 25 years. Steve has presented papers at eight PASS Summits and one at PASS Europe 2009 and 2010. He has just recently presented a Business Intelligence paper at Oracle Open World in San Francisco . Steve has also presented 5 papers at the Information Builders’ (IBI) International Summits. He is a PASS regional mentor chair of the Oracle/SQL Server VC

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.

John Miner

Twitter: - JohnMiner3

LinkedIn: John Miner

Contact: http://www.craftydba.com

John has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Admistration (MCSA). John is currently a Senior SQL Server Developer / Administrator in charge of best practices by the IT team at Sensata Technologies.

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.

Andrew Kelly

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

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Steve Simon

Contact: http://www.infogoldusa.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

SQLSaturday #146 - Nashua 2012

Sessions

Title: Bridging the Chasm: BI Theory vs. Practice

Title: Performance Monitoring 101

Title: Faster Stored Procedures and Functions

Title: Big Data with SQL Standard Edition - True Story

Title: DBA Worst Practices, Disasters and Horror Stories

Title: SQL 2012 – All About HA and DR

Title: Beyond Plateaux: Optimize SSAS with Best Practices

Title: EIM - Bringing Together SSIS, DQS, and MDS (300)

Title: PowerPivot Power View: Create Impressive Reports

Title: Advanced Transactional Replication

Title: Database Development ALM with SQL Server Data Tool

Title: Database design for mere developers

Title: Designing an SSIS Framework

Title: Introduction to BI Semantic Model (BISM)

Title: Way Too Deep–Inside AlwaysOn

Title: Alright,WHY is the server REALLY running so slow!

Title: Effective use of temporary tables

Title: SQL2012 Query Procedure Call Statistics

Title: Overcoming Barriers and Avoiding Mistakes with BI

Title: Introduction to SQL Azure

Title: SSIS 2012 – Overview and Changes

Title: “I See a Control Flow Tab. Now What?” (Level 100)

Title: T-SQL : Bad Habits to Kick

Title: MDX Trek: First Contact

Speakers

Sponsors