sqlsathistory

Nr: 203

Back to Main list

SQLSaturday #203 - Boston 2013

Start Time (24h) Speaker Track Title
00:00:00 Ayad Shammout Track 5 Building BI Semantic Model Tabular in 60 minutes
00:00:00 Bradley Ball Track 1 SQL Internals , Recovery Models, Backups! OH MY
00:00:00 Benjamin Nevarez Track 3 Top Query Optimizer Topics for Better Performance
00:00:00 Benjamin Nevarez Track 3 Dive into the Query Optimizer-Undocumented Insight
00:00:00 Brandon Leach Track 6 A DBAs Guide to HIPAA
00:00:00 Christina Leo Track 4 Why APPLY?
00:00:00 Dan Clark Track 2 Building Your First Tabular Model
00:00:00 Grant Fritchey Track 4 Tune Queries By Fixing Bad Parameter Sniffing
00:00:00 Grant Fritchey Track 2 What to Look for in Execution Plans
00:00:00 Joseph D'Antoni Track 2 Using PowerView and Hadoop to Unlock Hidden Market
00:00:00 Joseph D'Antoni Track 4 SQL 2012 -- All About HA and DR
00:00:00 John Miner Track 5 How to audit and prevent unwanted user actions.
00:00:00 Michael Corey Track 2 Virtualizing SQL Server 2012: Doing IT Right
00:00:00 Mike Hillwig Track 1 Ask the Experts: Database Administration
00:00:00 Paresh Motiwala Track 6 Network or Perish
00:00:00 Peter Myers Track 1 What's New for Self-Service BI in Excel 2013
00:00:00 Peter Myers Track 3 Introduction to SQL Server 2012 MDS and DQS
00:00:00 SB Chatterjee Track 4 [Get-PowerShell
00:00:00 Scott Klein Track 4 Kung Fu Migration to Windows Azure SQL Database
00:00:00 Stacia Varga Track 3 A Big Data Primer
00:00:00 Stacia Varga Track 6 Taking BI to the Next Level: Collaboration
00:00:00 Chad Churchwell Track 5 Designing An Efficient Replication Topology
00:00:00 Thomas LaRock Track 1 Database Design: Size DOES Matter
00:00:00 Steve Simon Track 6 Database design for mere developers
00:00:00 Steve Simon Track 5 Get your Mining Model Predictions out to all
00:00:00 Sunil Kadimdiwan Track 6 Self Service BI: Office 2013 and SQL 2012
00:00:00 Tim Sidor Track 3 Matching and Survivorship
00:00:00 Varsham Papikian Track 5 Secrets of SQL Server Management Studio (SSMS)
00:00:00 Allan Hirt Track 1 Demystifying Clustering for the DBA
00:00:00 Allan Hirt Track 1 Business Continuity: The Real Reason for HA and DR
00:00:00 Andy Roberts Track 2 Database Dev ALM with SQL Server Data Tools

SessionID: 10073

Building BI Semantic Model Tabular in 60 minutes

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Ayad Shammout

Title: Building BI Semantic Model Tabular in 60 minutes

Abstract:

SQL Server 2012 introduces the new Analysis Services Tabular Mode. BI Semantic Model (BISM) Tabular is in-memory database in Analysis Services using state-of-the-art compression algorithms. BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add-in. In this session, I will show you how to build a complete solution in Tabular and creating one from the ground up, deploy a rich semantic model and discover a simpler method for analyzing business data. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model. You will be able to create your BISM Tabular models, and gain a solid background to enable you starting your next project.

SessionID: 10142

SQL Internals , Recovery Models, Backups! OH MY

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Bradley Ball

Title: SQL Internals , Recovery Models, Backups! OH MY

Abstract:

The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!

SessionID: 10321

Top Query Optimizer Topics for Better Performance

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Benjamin Nevarez

Title: Top Query Optimizer Topics for Better Performance

Abstract:

This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.

SessionID: 10322

Dive into the Query Optimizer-Undocumented Insight

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer-Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 10659

A DBAs Guide to HIPAA

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Brandon Leach

Title: A DBAs Guide to HIPAA

Abstract:

In this hour long session We'll delve into the Health Insurance Portability and Accountability Act (HIPAA) and what implications it has for us as data professionals. We'll discuss SQL Server best practices that can help protect ourselves, our company, and the people whom we serve.

We'll also dive into several features in SQL Server that can help in this endeavor.

SessionID: 11627

Why APPLY?

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Christina Leo

Title: Why APPLY?

Abstract:

Most T-SQL developers know that the APPLY operator can be used to invoke a table valued function. But did you know that it can also be used to join to derived data sets, return multiple columns from a sub-query, shred XML, create working columns for use with the WHERE and GROUP BY clauses, and replace the UNPIVOT operator? If not, then why not take your skills to the next level, and come see each use case in action, using real-world examples. You'll leave the session with thorough understanding of the full potential of this versatile operator, as well as a few new tricks up your T-SQL sleeves.

SessionID: 12906

Building Your First Tabular Model

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Dan Clark

Title: Building Your First Tabular Model

Abstract:

With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine. To use the new Vertipaq engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to query the data, create calculations, measures, and KPI’s.This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded). We will import data from a SQL Server relational database into a tabular model project and create relationships between the tables. We will use DAX to create and manage calculations, measures, and Key Performance Indicators

SessionID: 14747

Tune Queries By Fixing Bad Parameter Sniffing

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Grant Fritchey

Title: Tune Queries By Fixing Bad Parameter Sniffing

Abstract:

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you – bad. In this session, we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then we’ll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You’ll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.

SessionID: 14748

What to Look for in Execution Plans

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Grant Fritchey

Title: What to Look for in Execution Plans

Abstract:

You've heard often enough that you need to look at execution plans to understand what's going on with a query. But what are you supposed to look at? This session answers that question, providing a step-by-step set of considerations for evaluating your execution plans. We'll look at the aspects of an execution plan that should be immediately checked, why they should be checked, and provide some guidance for what to do about what you find. You'll be able to apply this information to your SQL Server 2012 systems as well as older versions of SQL Server.

SessionID: 16220

Using PowerView and Hadoop to Unlock Hidden Market

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Joseph D'Antoni

Title: Using PowerView and Hadoop to Unlock Hidden Market

Abstract:

A practical way to derive business value from big data is to microtarget customers, but where do you begin? In this session, we examine real data from one of the nation's largest cable TV providers and combine it with data from the 2010 census and other data sources. In addition, we demonstrate how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that can be used to connect more effectively with customers.

SessionID: 16221

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 4

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 session we will walk through the process of creating a disaster recovery plan for your organization, the HA and DR options within SQL Server, and finally a demonstration of the new Availability Groups feature in SQL Server 2012 and see them in practice.

SessionID: 17031

How to audit and prevent unwanted user actions.

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: John Miner

Title: How to audit and prevent unwanted user actions.

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes. 1 – Granting correct user access is vital 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications 5 – Preventing table TRUNCATIONS 6 – Preventing unwanted SCHEMA changes 7 – New Feature (2008) – change data capture

SessionID: 20234

Virtualizing SQL Server 2012: Doing IT Right

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Michael Corey

Title: Virtualizing SQL Server 2012: Doing IT Right

Abstract:

Session Description: A database is a very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If it is not done correctly you will not be successful. This presentation will teach the you how to do it right. We will discuss why you virtualize a database, using the right hypervisor, installation, Architecting for performance, the storage layer, the processor, Memory considerations, the network layer. This presentation focuses on VMware but much of the information is relevant in any virtualized environment.

SessionID: 20519

Ask the Experts: Database Administration

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Mike Hillwig

Title: Ask the Experts: Database Administration

Abstract:

Have a question that wasn't answered today? Throw it to our panel of experts to see what they think.We'll take as many questions as possible. You'll have an opportunity throughout the day to provide your questions to our volunteers.

SessionID: 21654

Network or Perish

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Paresh Motiwala

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.

SessionID: 21964

What's New for Self-Service BI in Excel 2013

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Peter Myers

Title: What's New for Self-Service BI in Excel 2013

Abstract:

The self-service BI capabilities in Excel 2013 are growing in leaps and bounds! This presentation describes and demonstrates the PowerPivot and Power View functionality embedded inside the Excel client. Demonstrations will focus on the new features supported by both tools in Excel 2013. This presentation is relevant to those already experienced with PowerPivot and Power View, as well as those new to each.

SessionID: 21965

Introduction to SQL Server 2012 MDS and DQS

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Peter Myers

Title: Introduction to SQL Server 2012 MDS and DQS

Abstract:

This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).

MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.

DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.

SessionID: 24025

Get-PowerShell | Get-SQLServer

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: SB Chatterjee

Title: Get-PowerShell | Get-SQLServer

Abstract:

PowerShell is a command-line scripting language primarily designed for system administration development. Unlike VBScript or DOS batch files, PowerShell is built upon the .NET Platform which makes it customizable and extensible. This introductory session will show the PowerShell language constructs scripts and how it can be used for SQL Server administration (using SMO WMI providers) and development (ADO.Net OLEDB providers).

SessionID: 24071

Kung Fu Migration to Windows Azure SQL Database

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Scott Klein

Title: Kung Fu Migration to Windows Azure SQL Database

Abstract:

SessionID: 24681

A Big Data Primer

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Stacia Varga

Title: A Big Data Primer

Abstract:

The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.

SessionID: 24682

Taking BI to the Next Level: Collaboration

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Stacia Varga

Title: Taking BI to the Next Level: Collaboration

Abstract:

Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration.

SessionID: 24919

Designing An Efficient Replication Topology

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Chad Churchwell

Title: Designing An Efficient Replication Topology

Abstract:

With replication being a source for many data warehouse systems, this session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered.

SessionID: 25131

Database Design: Size DOES Matter

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Thomas LaRock

Title: Database Design: Size DOES Matter

Abstract:

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.

SessionID: 25346

Database design for mere developers

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Steve Simon

Title: Database design for mere developers

Abstract:

SessionID: 25347

Get your Mining Model Predictions out to all

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Steve Simon

Title: Get your Mining Model Predictions out to all

Abstract:

SQL Server 2012: Over the past 18 months many financial and portfolio management firms have been severely ‘hit’ by the depressed markets and poor economic conditions.This lead to risk exposure and considerable client liability.We like many firms have gone through the 'teething process'with regards to data mining model predictions and have now taken our systems from the prototype stage to our “shop floor” and are getting the 'good word' out to management via SQL Server Reporting Services.

SessionID: 25872

Self Service BI: Office 2013 and SQL 2012

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 6

Speaker: Sunil Kadimdiwan

Title: Self Service BI: Office 2013 and SQL 2012

Abstract:

In this session I will focus on how you can use the new features of Office 2013 such as Power View in Excel. How do you connect to multiple data models? How can you layout your data on a Map? How can you drill down to the details? And much more.

SessionID: 26592

Matching and Survivorship

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Tim Sidor

Title: Matching and Survivorship

Abstract:

The spectrum of Contact Data Quality covers numerous interrelated aspects such as parsing, standardization, correction, verification, enrichment and matching. But one crucial concept that is quite commonly overlooked in the field of data quality is the implementation of an intelligent and automatable process for the creation of the “golden record” through the consolidation of data within the matching process; a technique also known as Survivorship.

SessionID: 27544

Secrets of SQL Server Management Studio (SSMS)

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Varsham Papikian

Title: Secrets of SQL Server Management Studio (SSMS)

Abstract:

SQL Server Management Studio is a complex tool which database professionals use every day. Yet many people are not aware of some 'hidden' features in SSMS. During the session I will describe some of them using SSMS 2012. A few of them should also work in earlier versions of SSMS too.

SessionID: 9249

Demystifying Clustering for the DBA

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Allan Hirt

Title: Demystifying Clustering for the DBA

Abstract:

The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest.

SessionID: 9250

Business Continuity: The Real Reason for HA and DR

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Allan Hirt

Title: Business Continuity: The Real Reason for HA and DR

Abstract:

These days, I've stopped counting how many times I've been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.

SessionID: 9629

Database Dev ALM with SQL Server Data Tools

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Andy Roberts

Title: Database Dev ALM with SQL Server Data Tools

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.