Nr: 54
SQLSaturday #54 - Salt Lake City 2010
SessionID: 29009
SQL Server TDE
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 209
Speaker: Ben Miller
Title: SQL Server TDE
Abstract:
Ever wondered how SQL Server can provide extra security for your database as it sits on the disk? This session will cover how to set it up, and some of the requirements to make it work. I will also discuss some of the gotchas that you must watch for when using TDE.
SessionID: 29291
Getting to Know Your DB
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Jason Brimhall
Title: Getting to Know Your DB
Abstract:
SessionID: 29655
Visual Studio LightSwitch for the DBA
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 206
Speaker: Craig Berntson
Title: Visual Studio LightSwitch for the DBA
Abstract:
LightSwitch is a new member of the Visual Studio family that is targeted to the business developer. But as a DBA, you may find great functionality from it. This session will provide a high-level overview of LightSwitch and discuss how users will access data. You will also learn useful ways to use LightSwitch in your daily work.
SessionID: 31989
How to decide if your database is a good candidate
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Denny Cherry
Title: How to decide if your database is a good candidate
Abstract:
SessionID: 31990
SQL Server Clustering 101
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Denny Cherry
Title: SQL Server Clustering 101
Abstract:
In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.
SessionID: 31991
Storage for the DBA
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Denny Cherry
Title: Storage for the DBA
Abstract:
SessionID: 32074
Backup Restore Basics
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Nicholas Cain
Title: Backup Restore Basics
Abstract:
The key to being able to recover data in an emergency is to have a good backup and to know how to restore that backup to get up and running again as quickly as possible. In this session we'll talk about how to design a backup and restore strategy that's a good fit for you, including discussion around the types of backups that can be taken. We will also work through a couple of demos showing backup and restore in action. After all a backup is only good if you can restore it.
SessionID: 32075
Be safe out there: Ship those logs
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 206
Speaker: Nicholas Cain
Title: Be safe out there: Ship those logs
Abstract:
What happens if your hardware fails or your data center loses power? Do you have a Disaster Recovery (DR) plan in place that you can implement quickly? Log shipping allows you to keep copies of your databases closely synced and ready to come online in an emergency. Log shipping also offers options for read-only warm standby databases to reduce load from your production servers, adding additional value to your investment. In this session we'll Log Shipping, how it works, and how it differs from its cousin, Mirroring. We'll discuss practical uses for Log Shipping and work through a demonstration to show you how you can get it up and running in your environment.
SessionID: 32526
Visual Studio 2010 Database Projects
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 206
Speaker: Randy Knight
Title: Visual Studio 2010 Database Projects
Abstract:
Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
SessionID: 32527
Become a Bilingual DBA! Oracle for the SQL Server
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Randy Knight
Title: Become a Bilingual DBA! Oracle for the SQL Server
Abstract:
SessionID: 32528
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 206
Speaker: Randy Knight
Abstract:
SessionID: 32798
Shortest Path Problem at DisneyLand
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 209
Speaker: Scott Heffron
Title: Shortest Path Problem at DisneyLand
Abstract:
We have all been on a vacation. Our thoughts sometimes are to get to the rides quickly so that we can hit each one and get through the park without missing anything.
This talk will be on given a list of points (Attractions) and their pairwise distances, the task is to find a shortest possible tour that visits each point (Attractions) exactly once. We will be discussing Dkjkstra's routing algorithm to solve the problem using T-SQL.
SessionID: 33028
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 209
Speaker: Pat Wright
Abstract:
SessionID: 33029
Lunch Provided by Tek systems
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Pat Wright
Title: Lunch Provided by Tek systems
Abstract:
Lunch will be provided by Tek systems.
SessionID: 33030
Registration Breakfast
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 200
Speaker: Pat Wright
Title: Registration Breakfast
Abstract:
Breakfast of bagels and coffee will be served during registration.
SessionID: 33686
Database Switch
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 206
Speaker: TJay Belt
Title: Database Switch
Abstract:
If you maintain a Hot/Warm/DR solution, you may need to switch between these, from time to time. Ensuring that your systems are in sync and ready to be failed over too, at a moment’s notice is imperative. Performing this task on your own time scale will assist with practicing the steps necessary inside the database, as well as outside the database. A lot of moving parts are involved in a DB Switch. Let’s discuss what you as a data professional can do to assist in this endeavor.
SessionID: 33687
SQL Server Profiler and Tracing, a “How To”
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 209
Speaker: TJay Belt
Title: SQL Server Profiler and Tracing, a “How To”
Abstract:
Auditing databases can be tiresome, but a good trace and supporting reports can really help out.
This presentation will show you some of my own ideas, along with others' ideas on best uses for Profiler and Trace.
Once armed with this knowledge, you should be able to take it back to your shops and implement systems that assist you track down these issues more easily.
SessionID: 33918
Many-to-Many: Multiple Calendars in a Single Cube
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 209
Speaker: William E Pearson III
Title: Many-to-Many: Multiple Calendars in a Single Cube
Abstract:
Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, we look at a way we can accomplish this by implementing a SQL Server Analysis Services many-to-many scenario.
SessionID: 33922
Getting Started with MDX
Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room 206
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.