sqlsathistory

Nr: 87

Back to Main list

SQLSaturday #87 - Louisville 2011

Start Time (24h) Speaker Track Title
00:00:00 Arie Jones Developer Everything You Need to Know About SQL Azure
00:00:00 Arie Jones Misc. Master Data Services in Denali
00:00:00 Allen White DBA Let Service Broker Help You Scale Your Application
00:00:00 Allen White Advanced DBA Automate Policy-Based Management using PowerShell
00:00:00 Chris Albrektson BI Intro to SSRS
00:00:00 Chris Skorlinski Misc. High Availability features in the NEXT SQL Server
00:00:00 Chris Skorlinski Advanced DBA Transactional Replication – Follow the Data
00:00:00 Craig Utley BI Add It Up: Analysis Services Aggregations
00:00:00 Craig Utley BI Secure SSAS Data Without Tying Yourself in Knots
00:00:00 Dave Fackler Misc. Get Ready for SSIS in Denali!
00:00:00 Dave Fackler BI Understanding SSIS Performance
00:00:00 Louis Davidson Misc. What Counts For a DBA
00:00:00 Eddie Wuerch Advanced DBA TempDB Performance Troubleshooting and Optimizing
00:00:00 Eddie Wuerch Advanced DBA Page Latches for Mere Mortals
00:00:00 Joe Ferry DBA SQL Server Performance Monitoring
00:00:00 John Magnabosco DBA Exploring Data Privacy
00:00:00 Rodney Landrum Developer T-SQL Alphabet Soup
00:00:00 Sarah Barela DBA The 4-hour DBA: Automate, Audit and Relax
00:00:00 Shannon Lowder Developer Database design for developers
00:00:00 Thomas LaRock DBA Monitoring Databases in a Virtual Environment
00:00:00 Kevin Boles Advanced DBA SQL Server Memory Deep Dive
00:00:00 Kevin Boles Developer Common TSQL Mistakes
00:00:00 Tim Chapman Advanced DBA Writing faster queries
00:00:00 Tim Chapman DBA Choose Your Own Adventure: Performance Tuning
00:00:00 Tim Ford Misc. The Periodic Table of Dynamic Management Objects
00:00:00 Vicky Harp Developer Introduction to Common Table Expressions
00:00:00 Wayne Sheffield Developer Table Vars and Temp Tables - What you NEED to Know
00:00:00 William E Pearson III BI Beyond Plateaux: Optimize SSAS with Best Practices
00:00:00 William E Pearson III BI Serene Velocity: Reporting Services and SSAS Data
00:00:00 Kathi Kellenberger Misc. T-SQL in Denali

SessionID: 28850

Everything You Need to Know About SQL Azure

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Arie Jones

Title: Everything You Need to Know About SQL Azure

Abstract:

Cloud computing is one of the hot topic issues of the day and Microsoft is pushing hard to show that they are in the game to win. As such, SQL Azure is your data storage in the cloud solution. However, the platform is much different from simply a SQL Server that sits in the cloud and needs to be approached in an intelligent manner. In this fast paced session, we will be going well beyond the simple “hello world” scenario to show you how to leverage the cloud architecture for data storage as well as educate you in how the cloud works differently than your local database instance. This session is going to be an eye opener for sure and will have many of you dreaming of your data sitting in the cloud.

SessionID: 28851

Master Data Services in Denali

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Misc.

Speaker: Arie Jones

Title: Master Data Services in Denali

Abstract:

Most DBAs at one time or another have been taught the importance of master data management(MDM), which is just comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of Denali, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the basics of MDS in Denali This session will definitely be an eye opener for some that ar

SessionID: 28925

Let Service Broker Help You Scale Your Application

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Allen White

Title: Let Service Broker Help You Scale Your Application

Abstract:

How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.

SessionID: 28926

Automate Policy-Based Management using PowerShell

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Advanced DBA

Speaker: Allen White

Title: Automate Policy-Based Management using PowerShell

Abstract:

The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

SessionID: 29373

Intro to SSRS

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: BI

Speaker: Chris Albrektson

Title: Intro to SSRS

Abstract:

Are you still ramping up on SSRS? In this session Chris will show you how to create your first SSRS report. In this session we will cover all of the basics including some best practices to get you up to speed when creating reports. This session was designed for someone with little to no experience with SSRS.

SessionID: 29520

High Availability features in the NEXT SQL Server

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Misc.

Speaker: Chris Skorlinski

Title: High Availability features in the NEXT SQL Server

Abstract:

This sessions provides insight into the high availability features planned for the next release of SQL Server, code named Denali. I’ll provide a brief look at current HA options, Clustering, Replication, Mirroring, and Log Shipping. Then we’ll explore how these were all combined into new AlwaysOn HA feature for Denali.

SessionID: 29522

Transactional Replication – Follow the Data

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Advanced DBA

Speaker: Chris Skorlinski

Title: Transactional Replication – Follow the Data

Abstract:

Okay, you’ve run the Wizard and have Replication up and running; but how does it really work? Learn the behind the scenes for Transactional Replication as we follow the data from Publisher to Subscriber. We’ll look at both design and troubleshooting techniques to ensure your data is moving at near-real-time through your topology.

SessionID: 29674

Add It Up: Analysis Services Aggregations

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: BI

Speaker: Craig Utley

Title: Add It Up: Analysis Services Aggregations

Abstract:

Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session.

SessionID: 29675

Secure SSAS Data Without Tying Yourself in Knots

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: BI

Speaker: Craig Utley

Title: Secure SSAS Data Without Tying Yourself in Knots

Abstract:

Are you looking for the best way to secure the data in your cube? There are several approaches to applying data security, each with its own pros and cons. Learn about the basic built-in security, and then see approaches for extending this through dynamic security, using security dimensions, and SSAS stored procedures. You'll see examples of each as well as a discussion of when to use which approach.

SessionID: 29714

Get Ready for SSIS in Denali!

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Misc.

Speaker: Dave Fackler

Title: Get Ready for SSIS in Denali!

Abstract:

With the next release of SQL Server right around the corner, BI developers and database professionals need to know what's coming and how to take advantage of new features and capabilities. During this session, we'll drilldown on the next release of SSIS and discuss development improvements, the new deployment model, and better managability options. Along the way, we'll look at new SSIS features including project parameters, shared connection managers, a new Data Quality Services component, and team-based development improvements. Come see some of the exciting changes coming in your favorite data integration tool!

SessionID: 29715

Understanding SSIS Performance

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: BI

Speaker: Dave Fackler

Title: Understanding SSIS Performance

Abstract:

Many casual users of SSIS (including database professionals using the SSMS Import/Export Wizard) don't necessarily understand the inner workings of SSIS and what factors impact performance. During this session, we'll look at different aspects of SSIS and discuss their impact on package performance. We'll take a deep dive into the Data Flow component, looking at how SSIS manages data as it moves from sources, through transformations, and then to destinations. Finally, we'll talk about several of the top performance killers casual SSIS users experience and discuss strategies for overcoming these common issues.

SessionID: 30020

What Counts For a DBA

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Misc.

Speaker: Louis Davidson

Title: What Counts For a DBA

Abstract:

The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA.

SessionID: 30158

TempDB Performance Troubleshooting and Optimizing

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Advanced DBA

Speaker: Eddie Wuerch

Title: TempDB Performance Troubleshooting and Optimizing

Abstract:

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

SessionID: 30159

Page Latches for Mere Mortals

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Advanced DBA

Speaker: Eddie Wuerch

Title: Page Latches for Mere Mortals

Abstract:

Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!

SessionID: 30918

SQL Server Performance Monitoring

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Joe Ferry

Title: SQL Server Performance Monitoring

Abstract:

Everyone knows perfmon is a great tool, but knowing which counters to collect and their optimal values is less well known. I will discuss the counters most helpful in diagnosing performance issues with SQL Server.

SessionID: 30995

Exploring Data Privacy

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: DBA

Speaker: John Magnabosco

Title: Exploring Data Privacy

Abstract:

Somewhere out there someone is storing data about you. What defines sensitive and personally identifiable data? What should you, as a consumer, expect in regard to the protection of this data? What should you as a database professional do to ensure that your customer's data is protected? In this session we will explore these and other dimensions of the increasingly critical topic of data privacy.

SessionID: 32625

T-SQL Alphabet Soup

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Rodney Landrum

Title: T-SQL Alphabet Soup

Abstract:

Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.

SessionID: 32793

The 4-hour DBA: Automate, Audit and Relax

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Sarah Barela

Title: The 4-hour DBA: Automate, Audit and Relax

Abstract:

Do you feel that you are overworked and always fighting fires and never can get ahead? In this session, I will help you identify what is important to your job and how to find the time to address those critical tasks. I will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores. The flip side of automation is auditing. Routine auditing your server is essential to avoid nasty surprises that can lead to a loss of control. We will create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office.

SessionID: 32962

Database design for developers

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Shannon Lowder

Title: Database design for developers

Abstract:

As a developer there are a few things you'll want to know about database design. How can you build tables optimized for high transaction volume? How can referential integrity checks save you from building extra validation code into your applications? We'll cover how and when to add indexing to your tables for performance gains. Finally we'll briefly cover views, functions, and triggers, and when you should avoid them.

SessionID: 33060

Monitoring Databases in a Virtual Environment

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Thomas LaRock

Title: Monitoring Databases in a Virtual Environment

Abstract:

When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.

SessionID: 33396

SQL Server Memory Deep Dive

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Advanced DBA

Speaker: Kevin Boles

Title: SQL Server Memory Deep Dive

Abstract:

Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance.

SessionID: 33398

Common TSQL Mistakes

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too, some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I have given this talk nearly a dozen times now and it is always very highly rated!

SessionID: 33621

Writing faster queries

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Advanced DBA

Speaker: Tim Chapman

Title: Writing faster queries

Abstract:

Poor database performance is the Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this all-demo session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.

SessionID: 33622

Choose Your Own Adventure: Performance Tuning

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: DBA

Speaker: Tim Chapman

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's Tim Chapman and Thomas LaRock from Confio Software as they help guide you while YOU make the choices in this interactive performance tuning adventure.

SessionID: 33669

The Periodic Table of Dynamic Management Objects

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Misc.

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

Introduction to Common Table Expressions

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Vicky Harp

Title: Introduction to Common Table Expressions

Abstract:

Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.

SessionID: 33871

Table Vars and Temp Tables - What you NEED to Know

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Developer

Speaker: Wayne Sheffield

Title: Table Vars and Temp Tables - What you NEED to Know

Abstract:

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"

SessionID: 34107

Beyond Plateaux: Optimize SSAS with Best Practices

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: BI

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

Serene Velocity: Reporting Services and SSAS Data

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: BI

Speaker: William E Pearson III

Title: Serene Velocity: Reporting Services and SSAS Data

Abstract:

SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.

SessionID: 34698

T-SQL in Denali

Back to calendar

Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Misc.

Speaker: Kathi Kellenberger

Title: T-SQL in Denali

Abstract:

The next version of SQL Server has something for everyone! Attend this session to learn about the new features and functions to make T-SQL coding easier and more efficient. Those attending will have a chance to win my Denali T-SQL book.