sqlsathistory

Nr: 146

Back to Main list

SQLSaturday #146 - Nashua 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Joseph D'Antoni	Track 1	SQL 2012 -- All About HA and DR
00:00:00	Joseph D'Antoni	Track 3	Way Too Deep--Inside AlwaysOn
00:00:00	John Flannery	Track 4	Advanced Transactional Replication
00:00:00	John Miner	Track 4	Effective use of temporary tables
00:00:00	Mark Vaillancourt	Track 4	MDX Trek: First Contact
00:00:00	Matt Masson	Track 2	EIM - Bringing Together SSIS, DQS, and MDS (300)
00:00:00	Mike Walsh	Track 2	SSIS 2012 – Overview and Changes
00:00:00	Mike Walsh	Track 1	DBA Worst Practices, Disasters and Horror Stories
00:00:00	Robert McCauley	Track 5	Big Data with SQL Standard Edition - True Story
00:00:00	Steve Simon	Track 3	Database design for mere developers
00:00:00	Steve Simon	Track 5	Alright,WHY is the server REALLY running so slow!
00:00:00	Sunil Kadimdiwan	Track 6	PowerPivot Power View: Create Impressive Reports
00:00:00	Slava Kokaev	Track 3	Introduction to BI Semantic Model (BISM)
00:00:00	William E Pearson III	Track 6	Beyond Plateaux: Optimize SSAS with Best Practices
00:00:00	William E Pearson III	Track 6	Bridging the Chasm: BI Theory vs. Practice
00:00:00	William E Pearson III	Track 6	Overcoming Barriers and Avoiding Mistakes with BI
00:00:00	Andy Roberts	Track 5	Introduction to SQL Azure
00:00:00	Andy Roberts	Track 5	Database Development ALM with SQL Server Data Tool
00:00:00	Aaron Bertrand	Track 4	T-SQL : Bad Habits to Kick
00:00:00	Andrew Kelly	Track 1	Performance Monitoring 101
00:00:00	Andrew Kelly	Track 1	SQL2012 Query Procedure Call Statistics
00:00:00	Andy Leonard	Track 2	Designing an SSIS Framework
00:00:00	Andy Leonard	Track 2	“I See a Control Flow Tab. Now What?” (Level 100)
00:00:00	Andrew Novick	Track 3	Faster Stored Procedures and Functions

SessionID: 16190

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Joseph D'Antoni

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.

SessionID: 16191

Way Too Deep--Inside AlwaysOn

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Joseph D'Antoni

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.

SessionID: 16726

Advanced Transactional Replication

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: John Flannery

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.

SessionID: 17017

Effective use of temporary tables

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: John Miner

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.

SessionID: 19640

MDX Trek: First Contact

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Mark Vaillancourt

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.

SessionID: 19834

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

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Matt Masson

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.

SessionID: 20631

SSIS 2012 – Overview and Changes

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Mike Walsh

Title: SSIS 2012 – Overview and Changes

Abstract:

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

SessionID: 20632

DBA Worst Practices, Disasters and Horror Stories

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Mike Walsh

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.

SessionID: 23373

Big Data with SQL Standard Edition - True Story

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Robert McCauley

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.

SessionID: 25211

Database design for mere developers

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Steve Simon

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.

SessionID: 25215

Alright,WHY is the server REALLY running so slow!

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Steve Simon

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.

SessionID: 25877

PowerPivot Power View: Create Impressive Reports

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: Sunil Kadimdiwan

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.

SessionID: 27504

Introduction to BI Semantic Model (BISM)

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Slava Kokaev

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.

SessionID: 27927

Beyond Plateaux: Optimize SSAS with Best Practices

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: William E Pearson III

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.

SessionID: 27928

Bridging the Chasm: BI Theory vs. Practice

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: William E Pearson III

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.

SessionID: 27934

Overcoming Barriers and Avoiding Mistakes with BI

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 6

Speaker: William E Pearson III

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.

SessionID: 34600

Introduction to SQL Azure

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Andy Roberts

Title: Introduction to SQL Azure

Abstract:

Provision, Create, Maintain and use SQL Azure Databases

SessionID: 34601

Database Development ALM with SQL Server Data Tool

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 5

Speaker: Andy Roberts

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.

SessionID: 8915

T-SQL : Bad Habits to Kick

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4

Speaker: Aaron Bertrand

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.

SessionID: 9155

Performance Monitoring 101

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Andrew Kelly

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.

SessionID: 9156

SQL2012 Query Procedure Call Statistics

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1

Speaker: Andrew Kelly

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.

SessionID: 9515

Designing an SSIS Framework

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Andy Leonard

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.

SessionID: 9518

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

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2

Speaker: Andy Leonard

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.

SessionID: 9672

Faster Stored Procedures and Functions

Back to calendar

Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3

Speaker: Andrew Novick

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.

This site is open source. Improve this page.