Nr: 164
SQLSaturday #164 - Cleveland 2012
SessionID: 10010
Panel Discussion: Managing Your Career
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: 114/115
Speaker: Allen White
Title: Panel Discussion: Managing Your Career
Abstract:
SessionID: 10011
Sets and Relations and Queries, Oh My!
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL2
Speaker: Allen White
Title: Sets and Relations and Queries, Oh My!
Abstract:
SessionID: 11773
Searching for the Holy Grail of DDL Auditing
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL9
Speaker: Colleen Morrow
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was this index created? What happened to my stored procedure? From SQL Trace to SQL Audit, from C2 to Extended Events, we'll explore various methods of auditing object changes in SQL Server in a quest to find the perfect DDL audit solution.
SessionID: 11774
So I started this blog... now what?
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL5
Speaker: Colleen Morrow
Title: So I started this blog... now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you've started a blog but struggle with what to write about. We'll take a beginner's look at blogging and examine common roadblocks, finding topics, building readership, and setting you on the road to blogging stardom.
SessionID: 11870
Getting Started with Report Services: The Setup
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL2
Speaker: Cory Stevenson
Title: Getting Started with Report Services: The Setup
Abstract:
SessionID: 12034
LinkedIn for SQL Server Professionals
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL5
Speaker: Craig Purnell
Title: LinkedIn for SQL Server Professionals
Abstract:
SessionID: 12754
Overview of PowerPivot
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL16
Speaker: David Eichner
Title: Overview of PowerPivot
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users of Excel to extract business intelligence from a variety of data sources. This introductory session will demonstrate the power of PowerPivot in analyzing large sets of data quickly and efficiently.
SessionID: 13440
Factors for Successful Business Intelligence
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL2
Speaker: Dave Rodabaugh
Title: Factors for Successful Business Intelligence
Abstract:
Whether you are starting your first business intelligence project or have a struggling effort underway, this presentation will explain the challenges typically encountered in a BI effort. Success factors are grouped by skills and staffing, philosophy and architecture, technology selection, development methodology, quanlity and testing, production engineering, and user training. Addressing these factors early can avoid a failed project, and turn a good project into a great project!
SessionID: 13443
Designing for Common Problems in SQL Server
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: 114/115
Speaker: Louis Davidson
Title: Designing for Common Problems in SQL Server
Abstract:
In this session, I will do a design and code review of several common patterns of solving problems that a typical programmer will come up against. Problems like coding for hierarchical data, data driven design, dealing with image data, structure generalization, user specified schemas, dimensional reporting, and dealing with uniqueness beyond what you might deal with using a simple uniqueness constraint might allow you to deal with.
SessionID: 13444
What Sequence objects are (and are not)
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: 114/115
Speaker: Louis Davidson
Title: What Sequence objects are (and are not)
Abstract:
SessionID: 13970
Building a Better Development Shop
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL5
Speaker: Eric Wise
Title: Building a Better Development Shop
Abstract:
SessionID: 14073
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL9
Speaker: Eddie Wuerch
Abstract:
SessionID: 14074
Page Latches for Mere Mortals
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL15
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: 15491
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL16
Speaker: Ira Warren
Abstract:
SessionID: 15879
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL2
Speaker: Jason Spangler
Abstract:
Many new DBA's are unaware of the power of SQL Profiler. Many don't know it exists. And better yet, it's FREE. This session will generalize the importance of using Profiler to troubleshoot and tune your SQL queries. By demonstrating Profiler on a running server, attendees will get a look at what SQL is currently executing. This session will show how to discover query duration, reads, writes, locks, deadlocks, stored procedure executions and more.
SessionID: 16055
Hierarchies... on Steroids the No RBAR Way
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: 114/115
Speaker: Jeff Moden
Title: Hierarchies... on Steroids the No RBAR Way
Abstract:
Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and a new structure that just might make Nested Sets obsolete. For stalwarts, it also includes a very high performance method (100,000 nodes in 6 seconds) for converting Adjacency Lists to Nested Sets that even a beginner can understand. You just have to know that a Tally Table is involved somewhere in this. ;-)
SessionID: 16178
SQL 2012 -- All About HA and DR
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL15
Speaker: Joseph D'Antoni
Title: SQL 2012 -- All About HA and DR
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.
SessionID: 16179
Way Too Deep--Inside AlwaysOn
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL15
Speaker: Joseph D'Antoni
Title: Way Too Deep--Inside AlwaysOn
Abstract:
Are you really interested in the new Always On Availability Group feature in SQL 2012? Like really interested? We will talk about the basic architecture of AlwaysOn, then dive deep into the system views behind it, and then use Extended Events, to walk through what's going on inside of SQL and the Windows cluster to make AlwaysOn work.
SessionID: 16276
Migrating to and Integrating with SQL Azure
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL13
Speaker: Jeff Mlakar
Title: Migrating to and Integrating with SQL Azure
Abstract:
SessionID: 16724
Administering the BI Stack
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL15
Speaker: Josh Fennessy
Title: Administering the BI Stack
Abstract:
More often than not, a SQL DBA will also be requested (or required) to administer other applications in the SQL universe. These applications are often the BI stack, SSIS, SSRS, and SSAS. In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work. At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations.
This session will focus on the SSIS, SSRS, and SSAS engines in this session. Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only.
SessionID: 18047
Building Your Own SQL Server Virtual Playground
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL9
Speaker: Kendal Van Dyke
Title: Building Your Own SQL Server Virtual Playground
Abstract:
As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.
SessionID: 18050
Transactional Replication: Beyond The Basics
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL9
Speaker: Kendal Van Dyke
Title: Transactional Replication: Beyond The Basics
Abstract:
SessionID: 19165
SQL Server and Sharepoint: Best Frienemies
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL15
Speaker: Lisa Gardner
Title: SQL Server and Sharepoint: Best Frienemies
Abstract:
SharePoint is a rapidly growing application that relies heavily on SQL Server. In this session, we will discuss what a DBA needs to know to successfully manage instances hosting SharePoint databases. What configurations options are best for a SharePoint workload? What kind of maintenance shoule be performed? How should databases be provisioned? What the heck are all these databases for anyway? We will also discuss some nomenclature and key components of SharePoint to help better communicate with SharePoint application teams.
SessionID: 19874
Communicate for Great Good!
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL5
Speaker: Matt Velic
Title: Communicate for Great Good!
Abstract:
“No one knows what I do.” That’s a chief complaint of data professionals everywhere, and it’s a dangerous position to be in as well. Reviews may not be favorable, promotions more uncommon, and training dollars more rare. But by practicing written and verbal communication, new opportunities may present themselves. Blogging can land a book deal. In-house team lunch-and-learns can lead to community presentations. Most of all, good communication can be the skill that saves your job or opens the door to new horizons.
SessionID: 20045
Before You Optimize: Understanding Execution Plans
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL2
Speaker: Tim Corey
Title: Before You Optimize: Understanding Execution Plans
Abstract:
You know what your query does, but do you know how it does it? Do you know what type of resources your query uses? Come to this session to find the answers to these questions and more as we walk through reading execution plans. We will see how SQL breaks down the execution of your query and what each step tells us about the overall query. If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.
SessionID: 20073
Conquering ETL Projects
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL13
Speaker: Austin Zellner
Title: Conquering ETL Projects
Abstract:
SessionID: 22668
Goodbye Next Next Next, Hello Automated Installs
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL15
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 23074
Designing a SQL 2012 BI Architecture
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL16
Speaker: Rob Kerr
Title: Designing a SQL 2012 BI Architecture
Abstract:
SessionID: 23076
Designing Tabular BI Semantic Models
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL16
Speaker: Rob Kerr
Title: Designing Tabular BI Semantic Models
Abstract:
SessionID: 23826
14 New T-SQL Functions
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL13
Speaker: Sam Nasr
Title: 14 New T-SQL Functions
Abstract:
The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.
SessionID: 24410
NoSQL: Know Your Enemy
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL13
Speaker: Shelly Noll
Title: NoSQL: Know Your Enemy
Abstract:
A current trend among application developers to is move data storage away from a traditional relational database model. This presentation will provide an introduction into the technology known as NoSQL. We will discuss who’s who in the NoSQL world and explain the different ways that NoSQL databases store data. We will also cover which types of applications are best suited for the NoSQL approach and when a relational database would be a more appropriate choice.
SessionID: 24705
Data Visualization in Reporting Services
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL16
Speaker: Stacia Varga
Title: Data Visualization in Reporting Services
Abstract:
Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
SessionID: 24707
(Way Too Much) Fun with Reporting Services
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL16
Speaker: Stacia Varga
Title: (Way Too Much) Fun with Reporting Services
Abstract:
SessionID: 25125
Database Design Throwdown
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: 114/115
Speaker: Thomas LaRock
Title: Database Design Throwdown
Abstract:
SessionID: 25944
Shade Tree Mechanic's Guide to SSAS
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL9
Speaker: Steven Wright
Title: Shade Tree Mechanic's Guide to SSAS
Abstract:
SessionID: 25945
Resource Governor for SQL Server
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL9
Speaker: Steven Wright
Title: Resource Governor for SQL Server
Abstract:
In this presentation, Steve will provide an overview of Resource Governor, a feature introduced in SQL Server 2008 that gives DBAs and system administrators much more granular control over how CPU and memory are used by SQL Server. He’ll discuss the components that make up Resource Governor, then walk through examples of how to set it up along with various usage scenarios.
SessionID: 26276
Fundamentals of Join Operations
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL2
Speaker: Kevin Boles
Title: Fundamentals of Join Operations
Abstract:
SessionID: 26277
SQL Injection
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL5
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
SessionID: 8976
Introduction to SQL Server Service Broker
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL13
Speaker: Adam Belebczuk
Title: Introduction to SQL Server Service Broker
Abstract:
In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.
SessionID: 9570
Building Your Professional Development Plan
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL5
Speaker: Andy Warren
Title: Building Your Professional Development Plan
Abstract:
SessionID: 9571
SQL Server Security for Developers
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: 114/115
Speaker: Andy Warren
Title: SQL Server Security for Developers
Abstract:
SQL Server has a robust and granular system for granting and denying access to users, but all too often we see applications running as DBO or even sysadmin. Why? Part of is that same granular system can be overwhelming and part is that many developers don't see the point in applying such granular security. In this introductory level presentation we'll start at the beginning with creating and managing logins, take a quick look at system roles, and then get into the nitty gritty of users and roles and permissions at the database level. Along the way we'll talk about why its so important to set security at the database and not just rely on the application enforced security.
SessionID: 9822
Strategies for Sharding with SQL Azure Federations
Event Date: 18-08-2012 - Session time: 00:00:00 - Track: LL13
Speaker: Arie Jones
Title: Strategies for Sharding with SQL Azure Federations
Abstract:
Putting big data in the cloud is not without its difficulties and the Microsoft Azure teams have been consistently upping the resource limits that you are able to utilize within a given instance. Those of us with larger capacity instances still have to hedge our bets when looking at moving to the cloud. That is until the recent release of SQL Azure Federations, which offers a native SQL Azure based option to possible unlimited scalability. In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, and put you on the right path to a successful Federation based deployment.