sqlsathistory

Nr: 197

SQLSaturday #197 - Omaha 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	Bill Fellows	Developer	2012 TSQL Sweets
00:00:00	Brandie Tarvin	General	Designing a Data Recovery Solution
00:00:00	David Klee	DBA	SQL Server vs. Oracle: The Throwdown!
00:00:00	Dean Nicholson	Developer	Minimum Database Indexing
00:00:00	Glenn Berry	DBA	Hardware 201: Selecting Database Hardware
00:00:00	Glenn Berry	DBA	Dr. DMV: How to Use Dynamic Management Views
00:00:00	Jason Horner	Business Intelligence	Dimension Modeling Design Patterns: Beyond Basics
00:00:00	Jeff Hicks	General	Getting Started with PowerShell's Job Infrastructure
00:00:00	Jeff Hicks	General	Getting Started with PowerShell Workflow
00:00:00	Joe Sack	Developer	Troubleshooting Query Plan Quality Issues
00:00:00	Kathy Gibbs	DBA	Extend your Knowledge with Extended Events
00:00:00	Leslie Weed	Business Intelligence	Windows Azure SQL Reporting Services
00:00:00	Meagan Longoria	Business Intelligence	Building Dashboards in PerformancePoint
00:00:00	Matthew Brimer	DBA	Database Security Shrinking Your Attack Surface
00:00:00	Phil Brammer	Business Intelligence	SSIS 2012: A Deep Dive into the SSIS Catalog
00:00:00	Reeves Smith	Business Intelligence	Master Data Services – 101
00:00:00	Reeves Smith	Business Intelligence	DAX – Get Context
00:00:00	Jeff Renz	Business Intelligence	Tabular Models
00:00:00	Ronald Yenko	General	Tips and Tricks for Auditing in SQL Server
00:00:00	Steve Jones	Developer	Searching Binary Data in SQL Server 2012
00:00:00	Steve Jones	DBA	The Encryption Primer
00:00:00	Shawn Meyers	DBA	Performance baseline your new SQL instance
00:00:00	Scott Shaw	Business Intelligence	Dimensional Modelling for the DBA
00:00:00	Steve Hughes	Business Intelligence	Building BI Solutions with Excel 2013
00:00:00	Sudhir Gajre	DBA	SQL Server 2012 HA and DR
00:00:00	Kevin Boles	Developer	Windowing Functions: THE Reason to Upgrade to 2012
00:00:00	Tim Plas	DBA	Amazon RDS and SQL Azure - DB in the cloud
00:00:00	William E Pearson III	Business Intelligence	Beyond Plateaux: Optimize SSAS via Best Practices
00:00:00	Michael Fal	DBA	Exposing the Core: SQL 2012 on Server Core

SessionID: 10432

2012 TSQL Sweets

Back to calendar

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

Speaker: Bill Fellows

Title: 2012 TSQL Sweets

Abstract:

The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.

SessionID: 11067

Designing a Data Recovery Solution

Back to calendar

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

Speaker: Brandie Tarvin

Title: Designing a Data Recovery Solution

Abstract:

Having scheduled database backups is one thing, but knowing what backup types are needed is a different horse of a different color. Building on the "Backups 101" session, this discussion focuses on why we should build Recovery solutions instead of Backup solutions, and the most important things to remember when designing the solution.

SessionID: 12583

SQL Server vs. Oracle: The Throwdown!

Back to calendar

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

Speaker: David Klee

Title: SQL Server vs. Oracle: The Throwdown!

Abstract:

Come see David Klee (@kleegeek) and Joe Grant (@dba_jedi) in a "discussion" with a competitive comparison between SQL Server and Oracle in a highly interactive dynamic session. Each database engine has its place in the IT world, and we will discuss which is the right tool for the job. The goal is to be objective and compare features, strengths and weaknesses, and editions. Check your opinions at the door and come join us for an educational session!

SessionID: 13040

Minimum Database Indexing

Back to calendar

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

Speaker: Dean Nicholson

Title: Minimum Database Indexing

Abstract:

Discuss the basic indexing principles you should have learned in school if you had been paying attention. We will examine a couple of data and indexing patterns that will enable you to make an educated decision on your indexing strategy. We will also take a deep dive in how indexes begin and grow and how they are used

SessionID: 14679

Hardware 201: Selecting Database Hardware

Back to calendar

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

Speaker: Glenn Berry

Title: Hardware 201: Selecting Database Hardware

Abstract:

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.

SessionID: 14680

Dr. DMV: How to Use Dynamic Management Views

Back to calendar

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

Speaker: Glenn Berry

Title: Dr. DMV: How to Use Dynamic Management Views

Abstract:

SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

SessionID: 15851

Dimension Modeling Design Patterns: Beyond Basics

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Jason Horner

Title: Dimension Modeling Design Patterns: Beyond Basics

Abstract:

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

SessionID: 16793

Getting Started with PowerShell's Job Infrastructure

Back to calendar

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

Speaker: Jeff Hicks

Title: Getting Started with PowerShell's Job Infrastructure

Abstract:

A key feature of Windows PowerShell is the ability to execute long running tasks in the background while you continue to use the shell for other tasks. In this session you will learn about the PowerShell's job infrastructure including using scheduled background jobs, a new PowerShell 3.0 feature. We'll also explore some alternatives such as using runspaces.

SessionID: 16794

Getting Started with PowerShell Workflow

Back to calendar

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

Speaker: Jeff Hicks

Title: Getting Started with PowerShell Workflow

Abstract:

One of the killer features in PowerShell 3.0 is the ability to create workflows with Powershell script. You do not need a developer background or Visual Studio to create workflows. Now you can workflow scripts for long running and unattended tasks that can survive network interruptions or even reboots. In this session we'll look at workflow syntax, how to run and some best practices.

SessionID: 17123

Troubleshooting Query Plan Quality Issues

Back to calendar

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

Speaker: Joe Sack

Title: Troubleshooting Query Plan Quality Issues

Abstract:

When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.

SessionID: 17977

Extend your Knowledge with Extended Events

Back to calendar

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

Speaker: Kathy Gibbs

Title: Extend your Knowledge with Extended Events

Abstract:

With 2012 Extended Events became much easier to use and is a great way to find out more of what is going on in the database. This

presentation will show how you can use Extended Events to find out about items like Deadlocks and Query Performance. We will create a new Event and I will show you how you can use the data collected to report commonly monitored statistics.

SessionID: 19141

Windows Azure SQL Reporting Services

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Leslie Weed

Title: Windows Azure SQL Reporting Services

Abstract:

What you need to know about Reporting Services in the Cloud. We will cover benefits, limitations and scenarios that you may or may not have thought about for implementing this into your enviornment or for simply taking advantage of the free trial period.

SessionID: 19196

Building Dashboards in PerformancePoint

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Meagan Longoria

Title: Building Dashboards in PerformancePoint

Abstract:

PerformancePoint can be a useful tool for delivering a dashboard to users through SharePoint. The data visualizations for your dashboard can come from PerformancePoint, Excel Services, Reporting Services, or a web page. Understanding the features and limitations of these sources of data visualizations can help you create a dashboard that best meets your users’ needs.

SessionID: 19863

Database Security Shrinking Your Attack Surface

Back to calendar

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

Speaker: Matthew Brimer

Title: Database Security Shrinking Your Attack Surface

Abstract:

Database Security is a very broad and scary topic, one which

many days could be dedicated to speaking on it. In this session Matt will give a high level overview of what Database Security is, what tools Microsoft gives you to accomplish it and some simple things that you can do to shrink your attack surface.

SessionID: 22109

SSIS 2012: A Deep Dive into the SSIS Catalog

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Phil Brammer

Title: SSIS 2012: A Deep Dive into the SSIS Catalog

Abstract:

New in SQL Server 2012, the SSIS catalog provides a rich set of built-in tools for capturing/reporting package logging, statistics, and other interesting things all within a few keystrokes or mouse clicks. This session will focus on the internals of this new catalog and how to use it. You will learn how to extend and query the metadata captured by the package execution process and how to navigate your way around the built-in reports.

SessionID: 22772

Master Data Services – 101

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Reeves Smith

Title: Master Data Services – 101

Abstract:

Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in for Master Data Services.

SessionID: 22774

DAX – Get Context

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Reeves Smith

Title: DAX – Get Context

Abstract:

Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Understand the basics of the DAX language and get introduced to evaluation context.

SessionID: 22885

Tabular Models

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Jeff Renz

Title: Tabular Models

Abstract:

Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.

SessionID: 23787

Tips and Tricks for Auditing in SQL Server

Back to calendar

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

Speaker: Ronald Yenko

Title: Tips and Tricks for Auditing in SQL Server

Abstract:

SQL Server 2005 and later continued to introduce tools to help you audit what was occurring in your database, with 2012 introducing even more auditing tools. In this session, we'll go over the questions you need to ask your business to determine what level of auditing is appropriate. We'll go through how to set up many of the common audits to meet your business' requirements. Each technique has its features and each has associated costs - your goal is to find a balance.

SessionID: 24472

Searching Binary Data in SQL Server 2012

Back to calendar

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

Speaker: Steve Jones

Title: Searching Binary Data in SQL Server 2012

Abstract:

More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data. Filestream, Filetable, Full-Text Search, and Semantic Search are covered.

SessionID: 24474

The Encryption Primer

Back to calendar

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

Speaker: Steve Jones

Title: The Encryption Primer

Abstract:

Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.

SessionID: 24625

Performance baseline your new SQL instance

Back to calendar

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

Speaker: Shawn Meyers

Title: Performance baseline your new SQL instance

Abstract:

Using freely available tools to baseline your new SQL server instance. Using Crystal disk mark, SQLIO, Memtest86, and Dell DVDstore tools to measure, baseline and compare results of your new hardware. Crystal disk mark and SQLIO will test IO subsystems ; memtest86 will test your memory before you put it into production. Dell DVDstore will be used to create a database enabling you to put a synthetic load simulating numerous users to your SQL server instance, enabling the creation of solid baselines when putting the server under a heavy load. Using the benchmarks to determine capacity of the hardware and will it met the expected load.

SessionID: 25194

Dimensional Modelling for the DBA

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Scott Shaw

Title: Dimensional Modelling for the DBA

Abstract:

Have you ever wondered what's going on with that SQL Server Analysis server you support? Do you want to know what this

BI fuss is all about? I'll walk you through the basics of dimensional modelling to help you understand from a operational DBA perspective what's going on and why a BI system needs to be treated differently. I'll take the mysticism out of the differences between OLTP and OLAP and provide a method to the maddness.

SessionID: 25779

Building BI Solutions with Excel 2013

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Steve Hughes

Title: Building BI Solutions with Excel 2013

Abstract:

If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went "all-in" with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was.

SessionID: 25864

SQL Server 2012 HA and DR

Back to calendar

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

Speaker: Sudhir Gajre

Title: SQL Server 2012 HA and DR

Abstract:

This is a deep dive session in the new HA/DR options for SQL Server 2012. Through interactive discussions and lively demos, get an in depth understanding of the AlwaysOn Failover Clustering and AlwaysOn Availability Groups. Experience how to set up active secondary’s and off load backups to the secondary servers. You will walk away with a thorough understanding of the pros and cons of each HA/DR option in SQL Server 2012 and can immediately apply it to practical use.

SessionID: 26233

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

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

Speaker: Kevin Boles

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26576

Amazon RDS and SQL Azure - DB in the cloud

Back to calendar

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

Speaker: Tim Plas

Title: Amazon RDS and SQL Azure - DB in the cloud

Abstract:

Amazon’s AWS and Microsoft’s Azure both offer SQL Server instances as services (not necessarily as servers). What do they offer, why would one use them, how do they differ, what special considerations are there? What exactly does “Platform as a Service” (PaaS) mean with SQL?

SessionID: 28077

Beyond Plateaux: Optimize SSAS via Best Practices

Back to calendar

Event Date: 06-04-2013 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Beyond Plateaux: Optimize SSAS via 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.

SessionID: 34795

Exposing the Core: SQL 2012 on Server Core

Back to calendar

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

Speaker: Michael Fal

Title: Exposing the Core: SQL 2012 on Server Core

Abstract:

Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.

This site is open source. Improve this page.