Nr: 145
SQLSaturday #145 - Nashville 2012
SessionID: 10477
BI in the Cloud
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2
Speaker: David Liebman
Title: BI in the Cloud
Abstract:
SessionID: 12113
Why BI Projects Fail--And What You Can Do About It
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Craig Utley
Title: Why BI Projects Fail--And What You Can Do About It
Abstract:
Is your organization planning to build a data warehouse or BI solution? Data warehousing projects, like many large IT projects, have high failure rates. While the exact rate of failure for data warehousing projects is difficult to pin down, the causes of these failures fall into a small number of categories. It is obviously possible to successfully complete a data warehousing project and deliver value to the business. Craig Utley has seen Microsoft BI solutions in various states of completeness at over 30 companies worldwide and has seen some awesome successes and some spectacular failures. This session addresses the reasons data warehousing projects fail and how you can succeed in overcoming these obstacles.
SessionID: 12124
What's new in BI for SQL Server 2012
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Daniel Evans
Title: What's new in BI for SQL Server 2012
Abstract:
Many new features of SQL Server 2012 enable businesses to leverage Business Intelligence efforts. Come learn what's new in SQL Server 2012 for BI and the new capabilities with Tabular models, PowerPivot and Power View.
SessionID: 12567
Virtualizing Business Critical SQL Servers
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration
Speaker: David Klee
Title: Virtualizing Business Critical SQL Servers
Abstract:
Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session.
SessionID: 13456
Quiz Bowl
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2
Speaker: Louis Davidson
Title: Quiz Bowl
Abstract:
A rough cut preview of the SQL PASS opening session game show of SQL and general trivia.
SessionID: 14064
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration
Speaker: Eddie Wuerch
Abstract:
SessionID: 14491
Bad SQL
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions
Speaker: Geoff Hiten
Title: Bad SQL
Abstract:
SessionID: 14675
Hardware 301: Diving Deeper into Database Hardware
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions
Speaker: Glenn Berry
Title: Hardware 301: Diving Deeper into Database Hardware
Abstract:
SessionID: 15513
Custom SQL Server Transaction Log Shipping
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration
Speaker: J.D. Pellerin
Title: Custom SQL Server Transaction Log Shipping
Abstract:
Using a custom database transaction log shipping process instead of the built in SQL Server transaction log shipping component. Custom database transaction log shipping has several advantages, including:
a) The SQL Server instances need not have any connectivity to one another
b) Applying of the transaction log backups can be suspended for weeks and then enabled, with the log shipped database being brought as
current as the most recent transaction log backup.
While transaction log backups are suspended, the Log Shipped Database can be placed in standby/Read Only mode, for querying.
c) Using custom database transaction log shipping also allows more control over each part of the process.
SessionID: 15949
Extended Events, Work Smarter Not Harder
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions
Speaker: Jason Strate
Title: Extended Events, Work Smarter Not Harder
Abstract:
SessionID: 16078
T-SQL: Beyond the Basics
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development
Speaker: Jon Boulineau
Title: T-SQL: Beyond the Basics
Abstract:
SessionID: 16188
You Wouldn't Let HR Manage Your DBs...
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More
Speaker: Joseph D'Antoni
Title: You Wouldn't Let HR Manage Your DBs...
Abstract:
So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel.
SessionID: 16295
Rewriting bad T-SQL Code
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development
Speaker: Jeffrey Garbus
Title: Rewriting bad T-SQL Code
Abstract:
SessionID: 16712
New Models! An Introduction to Tabular Mode SSAS
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More
Speaker: Josh Fennessy
Title: New Models! An Introduction to Tabular Mode SSAS
Abstract:
In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.
SessionID: 17133
Professional Development
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More
Speaker: Joe Webb
Title: Professional Development
Abstract:
Imagine trying to steer a car blindfolded. How about shooting a jump shot without being able to see the goal. It's not easy, is it? Yet, that's exactly what your team is doing if you are not providing clear and effective feedback about their work and behavior.
In this session, you'll learn how to provide effective feedback to your peers and direct reports. You'll learn how to deliver feedback that encourages the behavior that you'd like to see repeated and provides recommended changes for behavior that is subpar or not acceptable. You'll also lean how to customize your feedback based on different personality types.
SessionID: 17326
Adventures in Project Management
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More
Speaker: Jonathan Gardner
Title: Adventures in Project Management
Abstract:
Projects that run long, run over budget, or flat out fail always get management's attention, and not good attention. This session will cover the project management process and demonstrate how it can help deliver higher quality results on time and on budget.
Case studies and real world examples will arm managers and team leads with tools including communication management plans, requirements documentation, stakeholder management plans, and change management. These tools will help mitigate and manage common project pitfalls like status update meetings, gold plating, and scope creep.
At the end of the session attendees will be armed with the knowledge necessary to streamline projects and how to deliver a top quality work product.
SessionID: 17822
Beginners guide to Table Expressions
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More
Speaker: Joe Murphree
Title: Beginners guide to Table Expressions
Abstract:
Common Tables Expressions (CTE) were introduced in SQL 2005. If you have only heard about them and would like to know more about how they work and there benefits this class is for you.
What you will learn:
- The structure and syntax of a CTE
- Benefits of using a CTE vs derived or temp tables
- Recursive CTE’s
- DML with CTE’s
SessionID: 17908
Database Design Throwdown
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions
Speaker: Karen Lopez
Title: Database Design Throwdown
Abstract:
Karen and Tom debate about options and best practices of common and advanced design issues, such as:
- Natural vs. Surrogate keys *NULL vs NOT NULL
- Agile Database Design
- Database Refactoring
- How much does Size Matter?
- Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 18397
SQL Server 2012 T-SQL
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions
Speaker: Kathi Kellenberger
Title: SQL Server 2012 T-SQL
Abstract:
You have heard all about AlwaysOn, BI Semantic Model, and Power View. Did you know that SQL Server 2012 has a host of new T-SQL features? Attend this session to learn more about the Sequence object, new functions and enhancements to the OVER clause.
SessionID: 18535
Virtualizing SQL Server with Windows Server 2012 a
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2
Speaker: Keith Mayer
Title: Virtualizing SQL Server with Windows Server 2012 a
Abstract:
Windows Server 2012 has been acclaimed by industry pundits as the most ambitious release of a Microsoft Server OS since Windows 2000! Windows Server 2012 is now available, and now is a great time to start evaluating it for your next project. Attend this session to learn what’s new in Windows Server 2012 and Hyper-V in Scalability, Virtualization, Storage, Networking and Manageability and get a jump start in preparing for how best to leverage Windows Server 2012 in your environment for SQL Server database workloads.
SessionID: 19619
I Shoulda Taken That Left Turn at Albuquerque...
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Professional Development And More
Speaker: Mark Swofford
Title: I Shoulda Taken That Left Turn at Albuquerque...
Abstract:
The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role. To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals.
Organization, planning, and having a roadmap to where you are going will be crucial to your success. This session will bring these topics together so you can set your GPS to success avenue.
SessionID: 20024
The Fangorn Forest - ColumnStore Indexes
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Gareth Swanepoel
Title: The Fangorn Forest - ColumnStore Indexes
Abstract:
SessionID: 20111
Slowly changing dimensions- an integrated approach
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2
Speaker: Mark Stacey
Title: Slowly changing dimensions- an integrated approach
Abstract:
There are many treatments of table design for slowly changing dimenions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.
In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build the versioning directly into the dimension in Analysis Services
SessionID: 21048
TBA - Introductory SQL Session
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development
Speaker: Denny Cherry
Title: TBA - Introductory SQL Session
Abstract:
TBA
SessionID: 22351
Taking the Scary out of Monster Reports
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Pam Shaw
Title: Taking the Scary out of Monster Reports
Abstract:
So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
SessionID: 23017
Do SQL XML queries have to scare me?
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development
Speaker: Rick Morelan
Title: Do SQL XML queries have to scare me?
Abstract:
I have seen days of amazing C# XML library coding work replaced by 2 lines of a FOR XML statement in SQL. Built into SQL is the power to make XML do pretty much whatever you need it to. Learn how to use the XML data type and built-in XQuery functions. You will also see how to join (or “bind”) a SQL table to an XML stream to produce a single result set.
SessionID: 23314
Revenge: The SQL Part 2: The Sequel!
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development
Speaker: Rob Volk
Title: Revenge: The SQL Part 2: The Sequel!
Abstract:
In a world…where DBAs are blamed, mistreated, and overworked…one man….WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, hiding and obfuscating data and code, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
SessionID: 23949
Parameter sniffing - make it work for you !
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Application Development
Speaker: Sanil Mhatre
Title: Parameter sniffing - make it work for you !
Abstract:
In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.
SessionID: 23975
Bulletproof: Hardening your SQL Server from Attack
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration
Speaker: Sarah Barela
Title: Bulletproof: Hardening your SQL Server from Attack
Abstract:
Recent major security breaches have not only exposed customer data, but also the system vulnerabilities DBAs must overcome daily. As data protection is a DBA’s primary responsibility, establishing an impenetrable environment to host the data is the first step towards risk-free security. How can DBAs ensure SQL Servers are fortified against the latest threats and vulnerabilities? In this session, we will go through the process of hardening your SQL Server from attack from Windows Server to the database level step-by-step. I will share will share with you how establish security baselines and monitor for changes to your security foundation. This session will provide specific actions for you to take back and apply to your servers.
SessionID: 26279
Indexing Deep Dive
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration
Speaker: Kevin Boles
Title: Indexing Deep Dive
Abstract:
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
SessionID: 26854
The Periodic Table of Dynamic Management Objects
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2
Speaker: Tim Ford
Title: The Periodic Table of Dynamic Management Objects
Abstract:
SessionID: 27673
Deeper into Tabular Models - M-to-M and the "W"
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions 2
Speaker: Wayne Snyder
Title: Deeper into Tabular Models - M-to-M and the "W"
Abstract:
You will need to understand how many-to-many relationships work in tabular models. While different than dimensional models, you can be successful in getting many of the behaviors you will need. Understanding how filters propagate is necessary requisite. We will use a "W" diagram to understand how this occurs in tabular models. Then we will learn how to force filter propagation, called cross-filtering. Then we will cross-filter conditionally, based on what the user has chosen for filters. If time permits we will also learn how to handle large numbers of fact rows, both in development and production.
SessionID: 27901
Bridging the Chasm: BI Theory vs. Practice
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: William E Pearson III
Title: Bridging the Chasm: BI Theory vs. Practice
Abstract:
A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
SessionID: 8984
SQL Server 2012 AlwaysOn Readable Secondaries
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Database Administration
Speaker: Adam Belebczuk
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract:
SessionID: 9698
The Decoder Ring for Data Warehousing / BI
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Robert Cain
Title: The Decoder Ring for Data Warehousing / BI
Abstract:
Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean.
SessionID: 9997
Event Date: 13-10-2012 - Session time: 00:00:00 - Track: Mixed Sessions
Speaker: Allen White
Abstract: