Nr: 101
SQLSaturday #101 - Kansas City 2011
SessionID: 28731
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Andy Galbraith
Abstract:
Do you work by yourself each day and wonder what other SQL Server DBA's are doing?
Have you ever come across a question and wished that you could ask a Microsoft employee or MVP but didn't know how?
Do you read SQL Server Magazine every month and find yourself thinking, there must be more information out there?
Do you hear people talk about tweets and blogs and wonder what they're talking about, or stick your nose in the air and think - "that's not important"?
Let me show you how useful the various online knowledge and social networking tools can be to the beginner as well as to the expert DBA.
SessionID: 28859
User-Defined Aggregate Functions - Why and How
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Arlin Mast
Title: User-Defined Aggregate Functions - Why and How
Abstract:
This session is all about SQL Server user-defined aggregate functions. We'll start with why you may want to use one even when alternative methods exist to get the same results. Then we'll walk through a simple yet useful example of creating an aggregate function, from start to finish. We'll create the .dll file in Visual Studio, enable the CLR in SSMS, import the aggregate and then put it to use. Along the way we'll cover some of the error messages you may receive, what they mean, and how to correct them. Come see what has been missing in your life without user-defined aggregate functions.
SessionID: 29045
Kama Sutra of SSIS: A guide to loving ETL
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 6
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: 29060
Writing faster SQL
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Amazon Room
Speaker: Bill Graziano
Title: Writing faster SQL
Abstract:
This session will focus on how you can write faster queries. It’s based on all the different “interesting” approaches I’ve seen and fixed as a consultant. It will cover indexing and how to use indexes efficiently, writing efficient WHERE clauses, handling dynamic SQL in reports, tips and tricks to avoid table scans, reducing query compiles and a dozen other approaches to improve the response time of your applications.
SessionID: 29119
Backups Recovery In Depth
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Amazon Room
Speaker: Bob Pusateri
Title: Backups Recovery In Depth
Abstract:
BACKUP and RESTORE are among the most important commands for DBAs, and you don't want to learn them under fire. In just one hour, we'll take a detailed look at exactly how they work and show options you can't get in Management Studio. We'll also cover why you don't have the same capabilities in all recovery models. Once armed with this knowledge, you'll understand best practices for backup strategies, testing restores, and saving your job.
SessionID: 29125
The Skinny on Data Compression
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Bob Pusateri
Title: The Skinny on Data Compression
Abstract:
SessionID: 29418
Business Intelligence Power Hour
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Carlos Bossy
Title: Business Intelligence Power Hour
Abstract:
- How do I get started?
- What are best practices?
- How do I model this?
SessionID: 30211
Writing MDX in Reporting Services
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Frank Kearney
Title: Writing MDX in Reporting Services
Abstract:
Writing MDX can be a little intimidating and so most people that have to create an SSRS report against a cube will use the Query Designer. However, there are advantages to being able to write and craft your own MDX.
This session will walk the audience through writing MDX in Reporting Services versus using the Query Designer. During the session we will point out the good and the bad of each approach.
SessionID: 30361
Lessons Learned - Enterprise Data Management
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Amazon Room
Speaker: Ilona Shulman
Title: Lessons Learned - Enterprise Data Management
Abstract:
Lessons Learned - Enterprise Data Management with SQL Server
SessionID: 30507
"SOA What??": Service Broker Basics
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Jason Horner
Title: "SOA What??": Service Broker Basics
Abstract:
In this session, we will focus both on the why's of using Service Broker and the how's of actually doing something useful with it. We will also discuss common implementation pitfalls and how to avoid them. Finally, we spend some time covering what you need to know to successfully implement a Service Broker Solution in your Environment.
SessionID: 30854
I can use Numbers for that?
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: John Dempsey
Title: I can use Numbers for that?
Abstract:
SessionID: 30855
I have been converted. Will you?
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: John Dempsey
Title: I have been converted. Will you?
Abstract:
I am a database developer/dba like you and love using SSMS (SQL Server Management Studio) just like you. But, since using the Visual Studio Database Edition tools, I am now a convert. Visual Studio 2010 is the most recent released version of the database toolset and continues to greatly improve things providing database developers with the great tools that other developers have had for years. We will cover deploying databases from VS 2010, Configuration Manager, handling Reference data, Pre Post Deployment scripts, and touch on refactoring. Come be converted =).
SessionID: 31208
SQL Server on VMWare,what a DBA should know
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Kathy Gibbs
Title: SQL Server on VMWare,what a DBA should know
Abstract:
SessionID: 31558
Introduction to Analysis Services
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Marc Beacom
Title: Introduction to Analysis Services
Abstract:
By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.
SessionID: 31775
Making Powershell count
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Mike Lynn
Title: Making Powershell count
Abstract:
SessionID: 31820
Managing and Auditing SQL Server Permissions
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Fal
Title: Managing and Auditing SQL Server Permissions
Abstract:
When your boss asks you who has access to your databases, do you break out into a cold sweat? Or, instead, are you worried about those other people who might have 'sa' access to your server and might be causing trouble on your server? Either way, as DBAs we need to be able to audit our SQL Server security. This presentation will give you a general overview of the different types of roles that you can use to manage access, what they mean, and how we look at the security gremlins hiding under the covers of our databases.
SessionID: 31821
The Fabulous Query Plan Primer
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Fal
Title: The Fabulous Query Plan Primer
Abstract:
Ladies and gentlemen, boys and girls, data professionals of ALL ages, we welcome you to learn the basics of query plans and their operators. This presentation will not only cure you of mental aches caused by the mysteries of estimated and actual row counts, but will also part the misty veil of physical join operators and aggregates. When you leave this room, you will have the fundamental understanding of the language of query plans so that you can begin the wondrous process of query tuning.
SessionID: 32394
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Randy Knight
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: 32395
Understanding SQL Server XML Features
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Randy Knight
Title: Understanding SQL Server XML Features
Abstract:
The XML Functionality embedded into SQL Server 2005 and 2008 is one of its most powerful yet least understood features. This seems to be primarily because DBA's shy away from it and developers prefer to work with XML in their code. In this session we will explore the XML features of SQL Server and how we can bridge these two worlds. Topics covered will include retrieving relational data as XML, storing XML in the database using the XML Datatype, XML indexes, and the XQuery functions included in SQL Server. We will also look at using XML as stored procedure parameters as a way to pass large amounts of complex data between client and server.
SessionID: 32555
SQL Injection and XSS: How to and How to prevent
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Rob Kraft
Title: SQL Injection and XSS: How to and How to prevent
Abstract:
SessionID: 32776
Asynchronous programming with Service Broker
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Sanil Mhatre
Title: Asynchronous programming with Service Broker
Abstract:
SessionID: 32976
Execution Plan Quick Dive
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Scott Shaw
Title: Execution Plan Quick Dive
Abstract:
This sessions intends to give the participant a quick but thorough overview of key explain plan components. We'll go through a step-by-step interpretation of explain plans and look at how we can use them to determine whether or not we've made our queries as efficient as possible. The presentation is geared for open discussion and participation.
SessionID: 32977
The Enterprise SQL Server DBA
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Scott Shaw
Title: The Enterprise SQL Server DBA
Abstract:
This session is a revision of my SQLRally presentation in Orlando, FL. It details the trials and tribulation of a being a DBA in a large (+200 SQL Server) environment. I'll discuss management strategies, corporate policies and politics, and technical challenges. If you are a SQL Server team lead, ever want to be a SQL Server team lead, or just want to know what your team lead might be thinking then join me for a great rant and raving discussion.
SessionID: 33578
High-Availability and DR Options for SQL Server
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Tim Plas
Title: High-Availability and DR Options for SQL Server
Abstract:
A comparison of SQL HA DR options, by a practitioner who has implemented managed all the current SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.
SessionID: 33776
Statistics 101: The Cost of Poor Cost Estimation
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Travis Whitley
Title: Statistics 101: The Cost of Poor Cost Estimation
Abstract:
An entry level session regarding SQL Server statistics and the importance of their accuracy. The presentation will cover basic principles around what statistics are, how they are generated, and how the optimizer utilizes them (Cardinality Estimation). Will cover at a high level and provide examples regarding the histogram, string stats, and density in relation to their function in the estimation process. Will provide scenarios on how out of date stats can generate a bad plan and maintenance principals that can be applied to avoid bad plan generation. Finally, will provide a free set of code to automatically determine out of proportion stats for every database in a set of registered instances.
SessionID: 33891
Visualizing Your Indexes - Science vs Art
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Amazon Room
Speaker: Wendy Pastrick
Title: Visualizing Your Indexes - Science vs Art
Abstract:
Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
SessionID: 34486
Building a Data Warehouse with SQL Server 2008
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Wes Dumey
Title: Building a Data Warehouse with SQL Server 2008
Abstract:
In this session we will discuss the fundamentals behind data warehousing and the ways to use SQL Server and SSIS to build and populate a datawarehouse.
SessionID: 34816
10 Things That Every DBA Should Know!
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 5
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.
SessionID: 34817
Only You Can Prevent Database Fires!
Event Date: 29-10-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: John Morehouse
Title: Only You Can Prevent Database Fires!
Abstract:
Do you find yourself always putting out "fires"? Can't take the heat in the data center? Then come learn about some things that you can do to help you do "fire prevention" instead of "fire fighting". We will look at several things that you can take back to your shop and implement ranging from code tuning, backup maintenance, monitoring and performance tuning!