sqlsathistory

Nr: 68

Back to Main list

SQLSaturday #68 - Olympia 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Arie Jones	151	Managing Sparse Resources with Resource Governor
00:00:00	Arie Jones	252	Monitoring Data Changes with Change Data Capture
00:00:00	Buck Woody	252	Cloud computing for the Data Professional
00:00:00	Robert Davis	352	Strategies for Working with VLDBs
00:00:00	Diane Robey	351	Get the most out of SQL Server Standard Edition
00:00:00	Dale Cunningham	351	Solving Real Life Production Issues
00:00:00	Greg Larsen	252	Through the Looking-Glass
00:00:00	Hope Foley	151	Self Service BI in SQL Server 2008 R2 (PowerPivot)
00:00:00	Rick Morelan	352	Basic Performance Tips and Gotchas
00:00:00	John Halunen Aubra Moore	252	Load-balancing architectures for Online Reporting
00:00:00	Nicholas Cain	351	Powershell: Are you checking out my profile?
00:00:00	Paul Turley	151	Visual Report Design: Bringing Sexy Back
00:00:00	Ron Talmage	352	A DBA Looks at Relational Data Warehouses
00:00:00	Scott Stauffer	352	SSIS for the faint of heart
00:00:00	Sopheap Suy	351	Women in Technology
00:00:00	Chuck Lathrope	252	Inside and out of Transactional Replication
00:00:00	Toshi Watanabe	151	Row Level Security and SQL-CLR integration
00:00:00	John Huang	352	Query Plans

SessionID: 28841

Managing Sparse Resources with Resource Governor

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 151

Speaker: Arie Jones

Title: Managing Sparse Resources with Resource Governor

Abstract:

A large majority of a modern DBA's workload consists of managing the resources on their systems in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides Resource Governor, which allows the DBA to discretely manage system resources in a very structured way. In this session, we will show you how to configure, monitor, and administer these features as well as demonstrate some of the pitfalls and helpful hints that you will need in order to successfully implement this fascinating tool.

SessionID: 28842

Monitoring Data Changes with Change Data Capture

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 252

Speaker: Arie Jones

Title: Monitoring Data Changes with Change Data Capture

Abstract:

Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.

SessionID: 29354

Cloud computing for the Data Professional

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 252

Speaker: Buck Woody

Title: Cloud computing for the Data Professional

Abstract:

The term “Cloud Computing” has become so polluted that it has come to mean “web”. How do you de-tangle all the hype and vendor terms and determine when and where you can use it? Buck Woody, a Senior Technical Specialist in Distributed Computing at Microsoft will explain your options – and describe the information you need to take back to your organization.

SessionID: 29463

Strategies for Working with VLDBs

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 352

Speaker: Robert Davis

Title: Strategies for Working with VLDBs

Abstract:

Very large databases (VLDBs) are just like regular databases, right? There's just more of them to love. Working with very large databases can be difficult and tricky at times. Everything takes longer and minor issues become major very quickly. In this session you will learn some strategies for working with VLDBs such as how to speed up backups and restores, how to minimize your maintenance window requirements, and how to efficiently and quickly set up failover partners and replicas. Demos will include how I set up a log shipping secondary and a replica of a 2 TB database in less than half an hour.

SessionID: 29983

Get the most out of SQL Server Standard Edition

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 351

Speaker: Diane Robey

Title: Get the most out of SQL Server Standard Edition

Abstract:

How can you get the most out of SQL Server Standard Edition? The SQL Server Enterprise Edition (EE) is far more expensive than the Standard Edition (SE). Many small office applications use SE. What features do you really need for your database system? Many features that are only available in EE, such as partitioning and data compression, are specific to managing larger databases. If you do not have very large databases, perhaps SE will be sufficient. Find out what actually improves performance for SE.

SessionID: 30194

Solving Real Life Production Issues

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 351

Speaker: Dale Cunningham

Title: Solving Real Life Production Issues

Abstract:

A real life application of solving one companies serious production issues. This session will touch on many SQL Server tools, Third Party Tools, disciplines and resources and bring them all together into a synergy of useful index generation, and interpreting execution plans to get real performance measurements.

SessionID: 30287

Through the Looking-Glass

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 252

Speaker: Greg Larsen

Title: Through the Looking-Glass

Abstract:

"Through the Looking-Glass, and What Alice Found There" - When your world is SQL Server, you need a looking-glass to determine server health, diagnosis problems, and tune performance. In this session will we follow Alice through the looking-glass to determine what she finds in SQLServerLand. Alice will be using dynamic management views and functions (DMVs) to explore the land behind the looking-glass. She will find statistics, poorly performing queries, and much more. Follow Alice and her new friends, as she traverses across SQLServerLand and provides you with snippets of T-SQL code that you can use to explore your own SQLServerLand.

SessionID: 30326

Self Service BI in SQL Server 2008 R2 (PowerPivot)

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 151

Speaker: Hope Foley

Title: Self Service BI in SQL Server 2008 R2 (PowerPivot)

Abstract:

There are many IT pros who know all the snazzy tools to create fantastic reports. The users who know the data inside and out may not know those tools, but odds are that they know Excel. Microsoft has released PowerPivot which seems to bridge the gap between the two worlds. These power users can now create their own fantastic reports within PowerPivot. We will explore what PowerPivot is and how can use it to create a self-service business intelligence solution.

SessionID: 30367

Basic Performance Tips and Gotchas

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 352

Speaker: Rick Morelan

Title: Basic Performance Tips and Gotchas

Abstract:

Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do – when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Programming Joes 2 Pros.

SessionID: 30920

Load-balancing architectures for Online Reporting

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 252

Speaker: John Halunen Aubra Moore

Title: Load-balancing architectures for Online Reporting

Abstract:

We will describe some of the different architectures (focusing on the db side) that Microsoft Adserving has used to Load Balance ever growing user reporting loads, data refreshes, and database maintenance across multiple reporting servers. The focus will be on the DB side, with minor context given to the web and middle tier pieces necessary for each system to work. Note that this is reporting in the sense of generating end user reports (not using SSRS).

SessionID: 32072

Powershell: Are you checking out my profile?

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 351

Speaker: Nicholas Cain

Title: Powershell: Are you checking out my profile?

Abstract:

Powershell is a very powerful management tool and you can spend hours writing magical scripts to do all the things you want. Frequently forgotten is the Powershell profile, a place you can add your own functions which can provide you lightening fast access to information. We'll talk about the power a profile puts at your fingertips. I will also demo (and share) a bunch of short functions that I use frequently for common tasks. I'll show you my Powershell profile if you show me yours.

SessionID: 32172

Visual Report Design: Bringing Sexy Back

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 151

Speaker: Paul Turley

Title: Visual Report Design: Bringing Sexy Back

Abstract:

Do your users have the same old, mundane table reports they’ve been using for decades? Stop living in the past and make your reports pop. Learn to use design patterns, best practices and visuals that pack more usable information into fewer, more usable reports. Use Reporting Services and other Microsoft BI tools to create dynamic, browse-able reports that answer important business questions at a glance and then let business users explore the details to gain insight and take action. Sure, Business Intelligence is all the rage but you don’t have to invest in an entire BI platform to have fresh, usable reports. With a little simple programming code, these design techniques apply to big analytic solutions smaller-scale operational reports.

SessionID: 32681

A DBA Looks at Relational Data Warehouses

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 352

Speaker: Ron Talmage

Title: A DBA Looks at Relational Data Warehouses

Abstract:

This session focuses on some surprising lessons learned and insights gained from applying DBA practices to relational data warehouses. Scenarios covered include use of table schemas versus synonyms, database chaining, managing user security, logical separation of user work from the data, backup and restore strategies, index maintenance, and change control.

SessionID: 32812

SSIS for the faint of heart

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 352

Speaker: Scott Stauffer

Title: SSIS for the faint of heart

Abstract:

Scott's gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use this tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server's DTS functionality. ETL? It's okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your "Extract, Transform, and Load" processes.

SessionID: 32973

Women in Technology

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 351

Speaker: Sopheap Suy

Title: Women in Technology

Abstract:

Most women working in technology keep a low profile, rarely standing out, rarely pushing the extra effort that typically denotes excellence. Women are constantly juggling to find the balance between career and family –with added complexity when children are involved. Come and learn about the three essential career considerations for Women in Technology. Understanding and applying these considerations can help you get to the next level of excellence in your career and family life. Men who understand these considerations can better support the women members in their life. I will share some of my own experiences, challenges, and lessons learned as I have learned how to balance career, family, and life in general.

SessionID: 33041

Inside and out of Transactional Replication

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 252

Speaker: Chuck Lathrope

Title: Inside and out of Transactional Replication

Abstract:

Replication in SQL Server is great tool for scaling out your master database(s) onto other servers for reporting and remote site access with near real-time data propagation. In this session, I will cover LAN and WAN data replication tricks-of-the-trade to offload work from your master servers. Using these techniques, you can improve your performance and monitoring of your existing installations or gain knowledge and confidence to implement new solution for your company.

SessionID: 33775

Row Level Security and SQL-CLR integration

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 151

Speaker: Toshi Watanabe

Title: Row Level Security and SQL-CLR integration

Abstract:

RLS (Row Level Security) is often integral part of EDW (Enterprise Data Warehouse) design. There are many ways to implement RLS. This is the story about our evolution of RLS implementation and how SQL-CLR integration helped us solve technical difficulty.

SessionID: 34682

Query Plans

Back to calendar

Event Date: 09-04-2011 - Session time: 00:00:00 - Track: 352

Speaker: John Huang

Title: Query Plans

Abstract:

This session is written to help developers to read query plans, understand commonly seen operators and properties in the plan. at the end, I will explain how SQL Server estimates the cost of operators and how SQL Server make decisions to choose a plan out of numerous alternatives

This site is open source. Improve this page.