sqlsathistory

Nr: 104

Back to Main list

SQLSaturday #104 - Colorado Springs 2012

Start Time (24h) Speaker Track Title
00:00:00 Ben DeBow DBA / DEV Your own Private Cloud for SQL
00:00:00 Bill Fellows BI Kama Sutra of SSIS: A guide to loving ETL
00:00:00 Carlos Bossy BI Using Columnstore Indexes in SQL Server 2012
00:00:00 Meredith Ryan-Smith DBA / DEV Backup Basics - Know your options
00:00:00 Chris Randall DBA / DEV SQL Azure: Future-Proofing Your SQL Career
00:00:00 David Eichner BI SQL Report Builder for Business Intelligence
00:00:00 Doug Lane BI Devs are from Mars, Report Servers are from Venus
00:00:00 Grant Fritchey DBA 7 Ways to Fix Bad Parameter Sniffing
00:00:00 Jason Horner DBA / DEV PowerShell for the Reluctant DBA / Developer
00:00:00 Josh Fennessy BI GASP Real-time user defined sets in SSAS
00:00:00 Jim Murphy DBA AlwaysOn - Finally, A usable 'mirror'!
00:00:00 Joe Sack DBA Performance Issue Archetypes
00:00:00 John Halunen Aubra Moore BI Reporting DBs behind Virtual IP's
00:00:00 Jason Strate DBA Discovering the Plan Cache
00:00:00 Karen Lopez DBA Database Design Contentious Issues
00:00:00 Marc Beacom BI Introduction to Data Warehousing
00:00:00 Mark Halstead DBA / DEV PowerShell and VBScript for the DBA
00:00:00 Michael Fal BI Eating the Elephant: SQL Server Table Partitioning
00:00:00 Michael Sexton BI ETL as MDM
00:00:00 Randy Knight DBA / DEV But it worked great in Dev! Perfomance for Devs
00:00:00 Thomas LaRock DBA / DEV Choose Your Own Adventure: Performance Tuning
00:00:00 Keith Tate DBA / DEV Development Mise en Place
00:00:00 Ted Malone DBA / DEV To the Cloud and Back Again!
00:00:00 Thomas LeBlanc BI Dimenional Modeling 101
00:00:00 Tim Ford DBA The Periodic Table of Dynamic Management Objects
00:00:00 Thomas Norman DBA / DEV PBM and you!
00:00:00 Troy Ketsdever BI Predictive Analytics - You Can, Too!
00:00:00 Vicky Harp DBA / DEV Edge Case Testing for the Database Professional
00:00:00 William E Pearson III BI PowerPivot for Excel
00:00:00 John Morehouse DBA / DEV 10 Things That Every DBA Should Know!

SessionID: 29005

Your own Private Cloud for SQL

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Ben DeBow

Title: Your own Private Cloud for SQL

Abstract:

Can SQL Server be offered as a service (SQLaaS) in your own private cloud? Can it provide application teams with the ability to easily procure an instance of SQL Server quickly? You may have some elements of this created in your environment but how do you create the full service offering? Creating a SQLaaS offering is a lot easier than you think and many companies are now ready for this change. In this session, you will learn how to design a SQL Server service offering for the Private Cloud that will enable your organization to react faster to the increasing project demands.

SessionID: 29044

Kama Sutra of SSIS: A guide to loving ETL

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Bill Fellows

Title: Kama Sutra of SSIS: A guide to loving ETL

Abstract:

Slow running packages? SSIS consuming all your resources? No idea what it's doing?

After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.

SessionID: 29421

Using Columnstore Indexes in SQL Server 2012

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Carlos Bossy

Title: Using Columnstore Indexes in SQL Server 2012

Abstract:

Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the processing time of common data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos will also discuss the scenarios for which columnstore indexes should be implemented to provide powerful but flexible BI solutions.

SessionID: 29585

Backup Basics - Know your options

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Meredith Ryan-Smith

Title: Backup Basics - Know your options

Abstract:

Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.

SessionID: 29657

SQL Azure: Future-Proofing Your SQL Career

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Chris Randall

Title: SQL Azure: Future-Proofing Your SQL Career

Abstract:

SQL Azure's not just coming; it's here. In your role as the local expert on all-things-SQL-Server, you will need to know how to talk intelligently about it. You may also want to be able to whip up an impromptu SQL Azure demo for co-workers and decision makers. This demo-heavy session will help get you to that point.

We'll look at what kind of usage scenarios work best for SQL Azure. We'll look at what SQL Azure does, and what it doesn't do. We walk through the process of creating, loading and querying databases, at what management tools are available, and how you will create and manage your account. We'll explore what cost-efficient ways there are for an individual to get access, and how to monitor the costs on an ongoing basis.

SessionID: 29794

SQL Report Builder for Business Intelligence

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: David Eichner

Title: SQL Report Builder for Business Intelligence

Abstract:

Learn how easy it is to utilize the free download from Microsoft that allows users to create charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.

SessionID: 29975

Devs are from Mars, Report Servers are from Venus

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Doug Lane

Title: Devs are from Mars, Report Servers are from Venus

Abstract:

Do you remember what it was like to fall in love? Wasn't it wonderful?

Lately it hasn't been the same. There's no spark anymore. You've been stuck doing the same old charts and tables. Maybe Reporting Services won't tell you what's wrong, and you're even thinking about seeing other reporting products.

In this session, Doug will re-ignite your passion for RS by reminding you how reports perform best, what RS has been trying to tell you (but you haven't been listening), and show you some new -- and easy -- tricks you may not have known RS can do. You'll leave knowing more about troubleshooting with the execution log views, understanding how to design reports for high performance, how to deal with blank pages, and more.

SessionID: 30273

7 Ways to Fix Bad Parameter Sniffing

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Grant Fritchey

Title: 7 Ways to Fix 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 I’ll show you seven different ways you can deal with it when it does. You’ll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment.

SessionID: 30499

PowerShell for the Reluctant DBA / Developer

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Jason Horner

Title: PowerShell for the Reluctant DBA / Developer

Abstract:

This presentation will provide a brief overview of how to get started with powershell and will be demo intensive.

Demo topics will include common challenges that database professional's face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices.

SessionID: 30820

GASP Real-time user defined sets in SSAS

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Josh Fennessy

Title: GASP Real-time user defined sets in SSAS

Abstract:

Given in the form of a case study, this session will highlight a real-life implementation done of an interesting user request. Using the functionality of SharePoint, SSIS, and SSAS attendees of this session will learn how to give analyists the ability to generate, define, and immediately use Custom Defined sets in an Analysis Services cube.

This session will highlight some of the power of SharePoint lists, third party SSIS providers, and many-to-many relationships in SSAS cubes. Additionally, the flexibilty of this solution will be shown though the use of several different user reporting tools.

SessionID: 30839

AlwaysOn - Finally, A usable 'mirror'!

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Jim Murphy

Title: AlwaysOn - Finally, A usable 'mirror'!

Abstract:

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.

SessionID: 30900

Performance Issue Archetypes

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Joe Sack

Title: Performance Issue Archetypes

Abstract:

While a SQL Server consultant may encounter various one-off situations over the course of a career, there are also several patterns and scenarios which repeat themselves with only minor variations. In this presentation Joe Sack will walk through common scenarios based on his experiences as a field engineer at Microsoft and also as a consultant with SQLskills.

SessionID: 30993

Reporting DBs behind Virtual IP's

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: John Halunen Aubra Moore

Title: Reporting DBs behind Virtual IP's

Abstract:

Tips, tricks and architecture options to successfully use Virtual IP's to give your users 100% reporting database uptime with a minimum of pain (and most importantly, learn from our mistakes, its much easier). This session describes how we used VIP's (virtual IP's) to present 10TB of datawarehouse to thousands of users to run user generated reports 24x7x365 with good maintenance and recoverability practices.

SessionID: 31136

Discovering the Plan Cache

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Jason Strate

Title: Discovering the Plan Cache

Abstract:

SessionID: 31184

Database Design Contentious Issues

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

SessionID: 31560

Introduction to Data Warehousing

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Marc Beacom

Title: Introduction to Data Warehousing

Abstract:

Just starting or thinking of starting a data warehousing project but not sure where to begin. Or still not sure if your organization needs a data warehouse. This discussion is geared towards answering the what and why (or why not) of data warehousing.

SessionID: 31723

PowerShell and VBScript for the DBA

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Mark Halstead

Title: PowerShell and VBScript for the DBA

Abstract:

There are times when T-SQL, DMV's and system tables can't tell you what you need to know or do what you need to do. Knowing the basics of PowerShell VBScript can provide functionality when you need to work "outside of the box".

SessionID: 31826

Eating the Elephant: SQL Server Table Partitioning

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Michael Fal

Title: Eating the Elephant: SQL Server Table Partitioning

Abstract:

Is your table fat? Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours? SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy. This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.

SessionID: 31862

ETL as MDM

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Michael Sexton

Title: ETL as MDM

Abstract:

Companies store data in multiple diverse formats on multiple databases using multiple versions of software and none of it is designed to integrate of work together… until that it gets to the BI systems. In the BI system data suddenly must – as if by magic - become a fully integrated and logically coherent system to generate reports for executives. This session will explore the Master Data Management (MDM) default system for many companies, their BI stack and how we can use the ETL process to get a single version of truth for corporate data.

SessionID: 32432

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Randy Knight

Title: But it worked great in Dev! Perfomance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

SessionID: 33075

Choose Your Own Adventure: Performance Tuning

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Thomas LaRock

Title: Choose Your Own Adventure: Performance Tuning

Abstract:

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft MVPs Jason Strate from Digineer and Thomas LaRock from Confio Software as they help guide you while YOU make the choices in this interactive performance tuning adventure.

SessionID: 33316

Development Mise en Place

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Keith Tate

Title: Development Mise en Place

Abstract:

Chefs and cooks have a process called mise en place (MEEZ ohn plahs) which translates to "put in place". For cooks this means "organize and prepare" their stations. They have everything they need ready and in the right place. It also means to remove all distractions.

In this session I will show how developers and DBAs can use this method to better organize their time and efforts to get more done with less rework.

SessionID: 33326

To the Cloud and Back Again!

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Ted Malone

Title: To the Cloud and Back Again!

Abstract:

This session will discuss developing applications that make use of SQL Azure databases, and will address some of the challenges of off-premise data. This session will also discuss developing Windows Azure applications that take advantage of on-premise databases and the various security mechanisms that are involved. Attendees will learn how hybrid cloud solutions are architected and built. Attendees will also learn about the various security implications of cloud and on-premises data applications.

SessionID: 33572

Dimenional Modeling 101

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Thomas LeBlanc

Title: Dimenional Modeling 101

Abstract:

This session is going to help create a dimensional Data Mart from the AdventoureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications. A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting.

SessionID: 33674

The Periodic Table of Dynamic Management Objects

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA

Speaker: Tim Ford

Title: The Periodic Table of Dynamic Management Objects

Abstract:

Taking the periodic table of elements into consideration I've created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today's SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yeild interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!

SessionID: 33700

PBM and you!

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Thomas Norman

Title: PBM and you!

Abstract:

Peanut Butter and Mayonnaise? No, Policy Based Management What can it do for me? Do I really need it? How do I install and configure it? How can it help me to pass audits? Who is that masked man you got into my database. You mean each server can really be configured the same. Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers.

SessionID: 33799

Predictive Analytics - You Can, Too!

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: Troy Ketsdever

Title: Predictive Analytics - You Can, Too!

Abstract:

Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…

SessionID: 33821

Edge Case Testing for the Database Professional

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: Vicky Harp

Title: Edge Case Testing for the Database Professional

Abstract:

Are you confident that your application performs as expected on Leap Day? Do you know how long it would take to run out of identity values in your major tables? Can you support case-sensitive collations and non-standard sort orders? If not, odds are good that you are not edge and corner testing your application. In this session, learn how to define the edges of your application and start to stretch those boundaries by setting up challenging test and development environments. For database administrators, learn what configurations in your environment may be a source of bugs in application code and what you can do about it. Learn about edge cases that you can start hardening your code against on Monday morning!

SessionID: 34358

PowerPivot for Excel

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: BI

Speaker: William E Pearson III

Title: PowerPivot for Excel

Abstract:

Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities.

SessionID: 34818

10 Things That Every DBA Should Know!

Back to calendar

Event Date: 07-01-2012 - Session time: 00:00:00 - Track: DBA / DEV

Speaker: John Morehouse

Title: 10 Things That Every DBA Should Know!

Abstract:

Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand.