Nr: 151
SQLSaturday #151 - Orlando 2012
SessionID: 10136
SQL Internals , Recovery Modes, and Backups! OH MY
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Bradley Ball
Title: SQL Internals , Recovery Modes, and Backups! OH MY
Abstract:
The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!
SessionID: 10473
SSRS in ASP.Net Application
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Reporting
Speaker: David Liebman
Title: SSRS in ASP.Net Application
Abstract:
In this session I will show you how to incorporate your SSRS reports into a ASP.Net Web Application. We will create a web page that will pass parameters to an SSRS report using the Report Server Service.
SessionID: 11837
Transitioning from SQL Trace to Extended Events
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Perf Tuning
Speaker: Jack Corbett
Title: Transitioning from SQL Trace to Extended Events
Abstract:
Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions.
SessionID: 11981
SSIS Moving Beyond the Script Task Script Compon
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Christopher Price
Title: SSIS Moving Beyond the Script Task Script Compon
Abstract:
Move beyond the script task and script component and you’ll find one of the often overlooked aspects of Integration Services is the extensibility options that are available. We will dive into a world of .Net code and discover your options for extending your SSIS Packages with custom objects. We will explore both custom task and data flow components as we develop from the ground up a set of reusable SSIS components using managed code.
SessionID: 11982
Introduction to Master Data Services 2012
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Christopher Price
Title: Introduction to Master Data Services 2012
Abstract:
SessionID: 12013
LinkedIn for SQL Server Professionals
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Craig Purnell
Title: LinkedIn for SQL Server Professionals
Abstract:
SessionID: 13275
Database Backend - Between Ground and Clouds
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Cloud
Speaker: Dmitri Korotkevitch
Title: Database Backend - Between Ground and Clouds
Abstract:
SessionID: 13694
Best Practices Are Not Just Hypothetical
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Ed Watson
Title: Best Practices Are Not Just Hypothetical
Abstract:
Ever had a discussion where someone said well X is best practices but that is impossible to implement? This session is a step by step installation guide to best practices for SQL Server. When you install with best practices in mind, maintaining them is much simpler.
SessionID: 14026
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Eric Wisdahl
Abstract:
No budget? That's OK! Need Tools? We've get them! Don't know where to go? We'll show you! The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out. In this session we will walk through a list of twenty great tools, scripts, blogs and other resources to help you out. Best of all, it's all free! But wait, there's more. Order now and we'll include an extra two tips at no additional cost!
SessionID: 14062
Partitioning for Perf Management of Large Tables
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Perf Tuning
Speaker: Eddie Wuerch
Title: Partitioning for Perf Management of Large Tables
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 14846
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Cloud
Speaker: Guillermo Caicedo Santiago
Abstract:
SessionID: 15682
Looney Tuner? No, there IS a method to my madness
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Perf Tuning
Speaker: Janis Griffin
Title: Looney Tuner? No, there IS a method to my madness
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 15781
PowerShell for Beginners
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Jason Hofferle
Title: PowerShell for Beginners
Abstract:
SessionID: 16127
PowerPivot+Powerview=Self-service BI Revolution
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Jose Chinchilla
Title: PowerPivot+Powerview=Self-service BI Revolution
Abstract:
SessionID: 16128
Real-world Fuzzy matching with SSIS
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Jose Chinchilla
Title: Real-world Fuzzy matching with SSIS
Abstract:
SessionID: 16298
Rewriting Bad Code
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Cloud
Speaker: Jeffrey Garbus
Title: Rewriting Bad Code
Abstract:
SessionID: 16955
Look who's Blocking
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Perf Tuning
Speaker: Jose L. Rivera
Title: Look who's Blocking
Abstract:
Have you ever faced the situation of trying to retrieve some data and the query keeps waiting on. Why this simple query is taking so long? There is a good chance that you are encountering locking/blocking problems. In this session, we will demonstrate how to recognize, diagnose and troubleshoot common locking and blocking scenarios. We will discuss transactions basics, lock types, escalation, and the infamous deadlock, among others.
SessionID: 17347
Surviving Your Sql Developer Interview
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Jonathon Moorman
Title: Surviving Your Sql Developer Interview
Abstract:
This session will describe what to expect when interviewing for a sql server developer position with tips from the "other" side of the table. The session will include tips to strengthen your interviewing techniques, and pitfalls to avoid. The session will explain why "I don't know." is a perfectly acceptable answer and when it's okay to brag. This session will describe what's "really" going on in the minds of the interviewer!
SessionID: 17450
Introduction to Project Management
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Richie Rump
Title: Introduction to Project Management
Abstract:
SessionID: 17662
Wish you could live the glamorous consulting life?
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Juan Soto
Title: Wish you could live the glamorous consulting life?
Abstract:
Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way.
In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out
SessionID: 18173
SQL Server Internals Architecture
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Perf Tuning
Speaker: Kevin Kline
Title: SQL Server Internals Architecture
Abstract:
SessionID: 18622
Introduction to Power View
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Devin Knight
Title: Introduction to Power View
Abstract:
Power View has the capability of creating eye-popping visualizations within SharePoint 2010. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. This session walks you through creating your first Power View report and shows you how to create an impressive reporting solution.
SessionID: 18999
Change Tracking and Change Data Capture Deep Dive
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Luis Figueroa
Title: Change Tracking and Change Data Capture Deep Dive
Abstract:
In this session Luis will cover beginning to end these two technologies key to delivering a real time reporting. Come join him to discuss different scenarios and some gotcha's he has learned and dealt with in real world implementations.
SessionID: 19904
Basic Intro to PowerShell for the DBA (1/2)
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Cloud
Speaker: Maximo Trinidad
Title: Basic Intro to PowerShell for the DBA (1/2)
Abstract:
SessionID: 19971
Complex DAX Functions
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Mike Davis
Title: Complex DAX Functions
Abstract:
SessionID: 20668
BI for the Masses Deux, PowerPivot 2012
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Michael Antonovich
Title: BI for the Masses Deux, PowerPivot 2012
Abstract:
SessionID: 21497
Data Conversions - Steps, Best Practices More
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Norm Bowen
Title: Data Conversions - Steps, Best Practices More
Abstract:
SessionID: 22352
Taking the Scary out of Monster Reports
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Reporting
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 2008 R2 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: 22353
Tips Tricks for dynamic SSRS Reports
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Reporting
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
SessionID: 23140
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Perf Tuning
Speaker: Robert Biddle
Abstract:
SessionID: 23166
The server side of Reporting Services
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Reporting
Speaker: Robert Hatton
Title: The server side of Reporting Services
Abstract:
SessionID: 23316
Tame Your Unruly Data...With Constraints!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Rob Volk
Title: Tame Your Unruly Data...With Constraints!
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
SessionID: 23386
DBA Repository Update Using SSIS and SSRS
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Reporting
Speaker: Rodney Landrum
Title: DBA Repository Update Using SSIS and SSRS
Abstract:
SessionID: 24107
SQL Azure vs. Azure Tables –Clearing The Confusion
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Cloud
Speaker: Scott Klein
Title: SQL Azure vs. Azure Tables –Clearing The Confusion
Abstract:
SessionID: 24717
Data Visualization in Reporting Services
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Reporting
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: 24902
Designing An Efficient Replication Topology
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Chad Churchwell
Title: Designing An Efficient Replication Topology
Abstract:
This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered.
SessionID: 26542
Job Common Sense - Don't be that Guy!!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Tom Brenneman
Title: Job Common Sense - Don't be that Guy!!
Abstract:
In this session, Tom will share stories from those in the community to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities.
SessionID: 26842
Running SQL Server 2012 as a Windows Azure VM
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Cloud
Speaker: Timothy McAliley
Title: Running SQL Server 2012 as a Windows Azure VM
Abstract:
This session will cover an introduction to Windows Azure Virtual Machines and then we will explore the options for planning and configuring SQL Server 2012 as a Windows Azure Virtual Machine. You will see a demonstration of configuring SQL Server 2012 as a Windows Azure Virtual Machine, and then a demonstration of post-configuration tasks such as storage provisions and resource monitoring. You will also learn the basics of what you need to obtain a Windows Azure account and the different subscription options.
SessionID: 9564
Building Your Professional Development Plan
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Career Skills
Speaker: Andy Warren
Title: Building Your Professional Development Plan
Abstract:
SessionID: 9566
How Active Directory Affects SQL Server
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: SSIS
Speaker: Andy Warren
Title: How Active Directory Affects SQL Server
Abstract:
There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent. We'll discuss how the location of your server in AD is important, how security can be compromised, AD DNS configuration, and of course Kerberos. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policy Objects.
SessionID: 9567
Object Level Recovery Made Easy
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Andy Warren
Title: Object Level Recovery Made Easy
Abstract:
Learn how to recover database objects quickly and efficiently without having to do a full database restore.
SessionID: 9877
Database Creation Process
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Arvin Meyer
Title: Database Creation Process
Abstract:
SessionID: 9906
SSAS Tabular and Self Service BI - TheDynamDAX Duo
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: BI
Speaker: Anthony Sammartino
Title: SSAS Tabular and Self Service BI - TheDynamDAX Duo
Abstract:
In this session I will cover how SSAS tabular and Self Service BI compliment each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each then will walk through how to create a SSAS tabular model, get into how to create data relationships from a regular database model with large tables, then hook it up to Excel and expose the elements for users to slice and dice data with ease and create charts. Then will demonstrate a few DAX commands that are very powerful yet very easy.
SessionID: 9992
Manage SQL Server 2012 on Server Core w/PowerShell
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Admin
Speaker: Allen White
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract: