sqlsathistory

Nr: 175

Back to Main list

SQLSaturday #175 - Fargo 2013

Start Time (24h)	Speaker	Track	Title
00:00:00	David Klee	Track 2	Database Health and Performance
00:00:00	Eric Ness	Track 4	Data Mining Deep Dive: Clustering
00:00:00	Eric Zierdt	Track 3	Table Partitions for Archiving and Performance
00:00:00	Jason Horner	Track 1	Dimension Modeling Design Patterns: Beyond Basics
00:00:00	Jason Strate	Track 3	Discovering the Plan Cache
00:00:00	Jim Dorame	Track 1	PowerShell and SQLPSX the Dynamic Duo for the DBA
00:00:00	Jeff Prom	Track 4	Data Quality Services
00:00:00	Jes Schultz	Track 3	Index Options You're Not Using
00:00:00	Jes Schultz	Track 1	The What, Why, and How of Filegroups
00:00:00	Kathi Kellenberger	Track 3	T-SQL Analytic Functions
00:00:00	Kathi Kellenberger	Track 1	SQL Server 2012 T-SQL
00:00:00	Michael DeFehr	Track 2	Deadlocks: What to do about the dreaded 1205
00:00:00	Paul Timmerman	Track 2	An Optimistic Approach: Snapshot Isolation in SQL
00:00:00	Ross McNeely	Track 4	F# for Data Analysis
00:00:00	Steve Jones	Track 3	The Encryption Primer
00:00:00	MIKE DONNELLY	Track 2	Flipping Through the SSIS Catalag
00:00:00	Scott Shaw	Track 4	The Future of the DBA
00:00:00	Steve Hughes	Track 2	Building BI Solutions with Excel 2013
00:00:00	Terry Bunio	Track 4	How to install and configure SSRS 2012/Sharepoint
00:00:00	Aaron King	Track 1	A Complete BI Solution in About an Hour!

SessionID: 12594

Database Health and Performance

Back to calendar

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

Speaker: David Klee

Title: Database Health and Performance

Abstract:

Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment's overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.

SessionID: 13909

Data Mining Deep Dive: Clustering

Back to calendar

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

Speaker: Eric Ness

Title: Data Mining Deep Dive: Clustering

Abstract:

Microsoft SQL Server makes it simple to apply data mining algorithms to a wide variety of data. Applying the results to business decisions without a thorough understanding of how the algorithms work is dangerous to the bottom line of the business, though. This session will take one of the algorithms, the Microsoft Clustering Algorithm, and do a deep dive into the mechanics of how it works. The algorithm is valuable for analyzing data in the fields of marketing, social networks and many others. The session will also examine the types of data that are valid for clustering. A demonstration of building a clustering model using SQL Server Analysis Services and viewing the model using the Excel Data Mining Add-In will be given.

SessionID: 13916

Table Partitions for Archiving and Performance

Back to calendar

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

Speaker: Eric Zierdt

Title: Table Partitions for Archiving and Performance

Abstract:

What is Table Partitioning? How can it be used to enhance performance? How can it be used with a data archiving strategy to quickly and easily drop archived data from a table? We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you.

SessionID: 15847

Dimension Modeling Design Patterns: Beyond Basics

Back to calendar

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

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: 15918

Discovering the Plan Cache

Back to calendar

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

Speaker: Jason Strate

Title: Discovering the Plan Cache

Abstract:

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery.

SessionID: 16253

PowerShell and SQLPSX the Dynamic Duo for the DBA

Back to calendar

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

Speaker: Jim Dorame

Title: PowerShell and SQLPSX the Dynamic Duo for the DBA

Abstract:

With PowerShell and SQLPSX your DBA life can be a lot simpler.

SMO is powerful, but can be difficult to use. Enter SQLPSX. Chad Miller put together a set of PowerShell functions that streamline the use of SMO, easing management of a multi-server environment. Come learn when and how the addition of PowerShell and SQLPSX can benefit you.

SessionID: 16364

Data Quality Services

Back to calendar

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

Speaker: Jeff Prom

Title: Data Quality Services

Abstract:

As the old adage goes, 'Garbage in, garbage out.' Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data

quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.

SessionID: 16628

Index Options You're Not Using

Back to calendar

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

Speaker: Jes Schultz

Title: Index Options You're Not Using

Abstract:

There are index options in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! If you have a solid knowledge of index basics and want to add to your collection, this is the session for you! I'll show you how filtered indexes, compressed indexes, and indexed views work and can improve performance!

SessionID: 16630

The What, Why, and How of Filegroups

Back to calendar

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

Speaker: Jes Schultz

Title: The What, Why, and How of Filegroups

Abstract:

Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores.

SessionID: 18403

T-SQL Analytic Functions

Back to calendar

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

Speaker: Kathi Kellenberger

Title: T-SQL Analytic Functions

Abstract:

You have been writing T-SQL for years but just haven't had time to learn about the new features. Attend this session to take your T-SQL skills to the next level. We'll cover the new analytic functions that can help you write highly performing queries with less effort than the old techniques.

SessionID: 18404

SQL Server 2012 T-SQL

Back to calendar

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

Speaker: Kathi Kellenberger

Title: SQL Server 2012 T-SQL

Abstract:

Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!

SessionID: 20460

Deadlocks: What to do about the dreaded 1205

Back to calendar

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

Speaker: Michael DeFehr

Title: Deadlocks: What to do about the dreaded 1205

Abstract:

Deadlocks can be very tricky, unpredictable and generally nasty. Is all hope lost? This demo-intensive session will explore several types of deadlocks and give you some insight into how to track them down and prevent them. We wil start with a quick review of locking and blocking concepts, then take a deep-dive into deadlock demos.

SessionID: 22393

An Optimistic Approach: Snapshot Isolation in SQL

Back to calendar

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

Speaker: Paul Timmerman

Title: An Optimistic Approach: Snapshot Isolation in SQL

Abstract:

Until 2005, SQL Server was a very pessimistic RDBMS. However with the introduction of the Read Committed Snapshot database option and the new Snapshot Isolation level, that is no longer the case.

After a high level look at all SQL Server isolation levels, we’ll spend the majority of this session discussing the implementation of optimistic concurrency control in SQL Server. We’ll look at the benefits and drawbacks of using an optimistic isolation level and discuss use cases where it may or may not be appropriate.

Come learn how to put one of the more powerful, but least understood, aspects of SQL Server to work for you!

SessionID: 23461

F# for Data Analysis

Back to calendar

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

Speaker: Ross McNeely

Title: F# for Data Analysis

Abstract:

Begin using F# for Data Analysis. Learn how to take advantage of this function-based language to tackle advanced analysis. I will walk through what F# is, and why it is a great tool for data analysis. This presentation will be full of demonstrations on how to use F# with data sets, analysis models, and data visualization. Supplement your SQL data analysis with the F# functional language, which is ideal for solving complex analytical problems.

SessionID: 24460

The Encryption Primer

Back to calendar

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

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: 24965

Flipping Through the SSIS Catalag

Back to calendar

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

Speaker: MIKE DONNELLY

Title: Flipping Through the SSIS Catalag

Abstract:

With the release of SQL Server 2012 one of the biggest changes for SSIS Administration was the addition of the Integration Services Catalog and using parameters. The Catalog is the storage and logging location for SSIS 2012. Parameters are the new configurations in SSIS 2012 and once you start using them you will never go back. Package Variables, Configuration Strings, Package properties can all be configured using Parameters. You will learn how to create the catalog, use parameters to deploy packages through different environments and use the built in reporting to monitor packages as they run.

SessionID: 25192

The Future of the DBA

Back to calendar

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

Speaker: Scott Shaw

Title: The Future of the DBA

Abstract:

What will the DBA role look like in 10 years? 20 years? Will a DBA still be necessary? We'll explore a number of scenarios in an forum as we try6 to determine how, as DBAs, we can position ourselves for a bright and productive future. I'll talk about trends I'm seeing in companies of all shapes and sizes. This presentation isn't about concensus, but about tackling tough issues facing the future of our profession.

SessionID: 25782

Building BI Solutions with Excel 2013

Back to calendar

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

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: 26035

How to install and configure SSRS 2012/Sharepoint

Back to calendar

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

Speaker: Terry Bunio

Title: How to install and configure SSRS 2012/Sharepoint

Abstract:

Come to this session and learn how easy it is to install an SQL Server Reporting Services (SSRS) Environment with a SharePoint Foundation environment. Terry will share his lessons learned on how to install and configure an SSRS/Sharepoint environment. Terry will also share the lessons learned about what the books don't tell you and how to set up your SharePoint sites and security to lessen future grief. Terry will even cover some more detailed topics like how to configure Visual Studio to be able to deploy from within Visual Studio right to Sharepoint and how to call an SSRS report from Java.

SessionID: 9165

A Complete BI Solution in About an Hour!

Back to calendar

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

Speaker: Aaron King

Title: A Complete BI Solution in About an Hour!

Abstract:

In this presentation Aaron will cover how to collect data from multiple sources using SQL Server 2012 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.

This site is open source. Improve this page.