Nr: 220
SQLSaturday #220 - Atlanta 2013
SessionID: 10262
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: PowerShell
Speaker: Ben Miller
Abstract:
SessionID: 10263
SQL Server TDE
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 5 - Presented by Red Gate
Speaker: Ben Miller
Title: SQL Server TDE
Abstract:
Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE.
SessionID: 10585
Jump-starting your career
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 2 - Presented by Tek Systems
Speaker: Bobby Dimmick
Title: Jump-starting your career
Abstract:
Some say that the first step is the hardest.. Sometimes it's the second step that truly knocks us off-balance. Join us in a discussion of taking that next step in your career. Learn about finding your passion, preparing the way, building your resume, and the people who can help along the way..
SessionID: 11122
Matching with Data Quality Services
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 1 - Presented by Slalom
Speaker: Julie Smith
Title: Matching with Data Quality Services
Abstract:
Matching is the identification of rows which are likely duplicates and is the less well known feature of Data Quality Services. Join me in showing Matching some love. We'll go over the creation of matching rules, how to use the rules with matching activity projects and also work a bit with Master Data Services and the Excel add ins for MDS and DQS.
SessionID: 11220
Data Warehouse physical design - better practices
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Twelfth Track!
Speaker: Carlos Rodrigues
Title: Data Warehouse physical design - better practices
Abstract:
you have your star schema beautifully defined. Now what? how can you assure that you physical database design is prepared to receive the amount of data that you are expecting? How can you best utilized your servers, SAN, memory, partitions, SSIS, SSAS, etc? Lets talk about a real case scenario where all of that were applied in order to improve daily process and meet businesses SLA's.
SessionID: 11551
Enhanced Phone Interrogation
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBD 1 - Presented by Idera
Speaker: Chris Skorlinski
Title: Enhanced Phone Interrogation
Abstract:
Encountered odd problem with SQL Server, something you've not seen before and thinking about calling Microsoft SQL Support? What do you need to collect before you call? How can you make the call a collaborative effort and not an "enhanced phone interrogation".
SessionID: 12545
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 2 - Presented by Precise
Speaker: David Klee
Abstract:
SessionID: 13346
The Last Mile: Dynamically Created Objects
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBD 1 - Presented by Idera
Speaker: Dan Holmes
Title: The Last Mile: Dynamically Created Objects
Abstract:
SessionID: 13465
Database Design Fundamentals
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 3 - Presented by Intellinet
Speaker: Louis Davidson
Title: Database Design Fundamentals
Abstract:
SessionID: 13698
Backup Strategies are for Losers!
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 2 - Presented by Precise
Speaker: Ed Watson
Title: Backup Strategies are for Losers!
Abstract:
SessionID: 13885
High Availability with SQL Server 2012
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 3 - Presented by Intellinet
Speaker: Eric Peterson
Title: High Availability with SQL Server 2012
Abstract:
A review of higg availability options for SQL Server incliding log shipping, mirroring, clustering and 2012 Always on. The presentation will show all options and give a comparison of each. The majority of the presentation will dive deep into 2012 Always on availability groups.
SessionID: 14088
Page Latches for Mere Mortals
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 1 - Presented by SIOS
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: 14492
Smart Rats Leave First
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Zero Level
Speaker: Geoff Hiten
Title: Smart Rats Leave First
Abstract:
IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career.
SessionID: 15883
Advanced Charting Techniques in SSRS
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Twelfth Track!
Speaker: Jason Thomas
Title: Advanced Charting Techniques in SSRS
Abstract:
SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts. This session will explore the functionalities of all the charts as well as some tips and tricks around them. You will also learn to start thinking creatively to make charts that most people think can not be made with SSRS. Come to this session and take your charting skills to the next level.
SessionID: 15884
GeoSpatial Analytics Using Microsoft BI
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 1 - Presented by Slalom
Speaker: Jason Thomas
Title: GeoSpatial Analytics Using Microsoft BI
Abstract:
SessionID: 16021
DAX Formulas: Evaluation Context
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBD 1 - Presented by Idera
Speaker: Javier Guillen
Title: DAX Formulas: Evaluation Context
Abstract:
Data Analysis Expressions (DAX) is an the expression language of PowerPivot and Analysis Services Tabular models. Its power lies on the ability to create aggregations that are evaluated at different contexts over in-memory data. This session will explore the most challenging DAX topic: formula context. A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing the context of a calculation. Attendees will gain a better understanding of how to leverage context manipulation expressions to create powerful business calculations.
SessionID: 16073
T-SQL: Beyond the Basics
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 3 - Presented by Intellinet
Speaker: Jon Boulineau
Title: T-SQL: Beyond the Basics
Abstract:
SessionID: 16218
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 4 - Presented by Dell
Speaker: Joseph D'Antoni
Abstract:
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
SessionID: 16471
When a Strange Server Calls
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 1 - Presented by SIOS
Speaker: Jennifer McCown
Title: When a Strange Server Calls
Abstract:
Have you checked the databases lately? It could be that you’re new on the job, or you’ve inherited a set of servers from another team. Maybe things have just been busy lately. Any which way, you’ve got a SQL Server instance (or five) that may have issues, may have backups, may have maintenance…or not. How do you start getting to know an instance? We’ll go over scripts and methods to gather and prioritize important information about your server, so you don’t have to be afraid when the server calls.
SessionID: 16835
Taming Complex Tasks with the Psake Module
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: PowerShell
Speaker: Jim Christopher
Title: Taming Complex Tasks with the Psake Module
Abstract:
PSake is a PowerShell module that helps you work with a tree of interdependent tasks. Originally designed for software builds, the simple workflow-as-tasks model lends itself to solving many other complex problems, such as VM provisioning, database setup and migration, even installing software.
In this session we will explore the PSake module, specifically learning how we can use the module to make small work out of a versioned SQL database migration. You will learn how to translate a complex problem into a set of reusable and interrelated tasks, how to make your tasks discoverable, and how to manage large numbers of tasks in your workflow.
SessionID: 17351
PowerScripting Live! (PowerShell podcast / BoF)
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: PowerShell
Speaker: Jonathan Walz
Title: PowerScripting Live! (PowerShell podcast / BoF)
Abstract:
Do you listen to podcasts? It's like the radio, but more Internetty. Well, Atlanta just so happens to be the home to the two co-hosts of the PowerScripting Podcast, the first podcast devoted to talking about Windows PowerShell. We have news, interviews, tips and resources that we present every week at powerscripting.net, but this time, the show is coming to you live! We'll come prepared to hit most any general PowerShell topic you want, and we'll probably sneak some SQL + PowerShell experts on stage to help out. This won't be a canned lecture, it will be more of a Birds of a Feather or talk show feel. Audience participation is REQUIRED!
SessionID: 17441
New T-SQL features in SQL Server 2012
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 4 - Presented by Dell
Speaker: Richie Rump
Title: New T-SQL features in SQL Server 2012
Abstract:
With the introduction of SQL Server 2012 data developers have new ways to interact with their databases. This session will review the powerful new analytic windows functions, new ways to generate numeric sequences and new ways to page the results of our queries. Other features that will be discussed are improvements in error handling and new parsing and concatenating features.
SessionID: 18205
Team Leadership Fundamentals
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Zero Level
Speaker: Kevin Kline
Title: Team Leadership Fundamentals
Abstract:
- What are the fundamental ways that a new leader can build credibility and trust with their team?
- What are the unique ways in which IT people are motivated?
- How can a leader effectively communicate with their IT team using a variety of communication channels?
- How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?
SessionID: 19118
Report Builder: Reports made Easy.
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 3
Speaker: Yelena Pavlyuk
Title: Report Builder: Reports made Easy.
Abstract:
See for yourself if you as a developer would like to use this product or convince your power users to give it a try.
In this session we'll look at differences between BIDS Report Designer and Report Builder.
Then we'll walk through creating some reports to highlight Report Builder features and make a general overview of Report Builder benefits.
SessionID: 20620
What I Wish I Knew Before Becoming a DBA
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Zero Level
Speaker: Mike Walsh
Title: What I Wish I Knew Before Becoming a DBA
Abstract:
Are you interested in becoming a DBA? Would you consider yourself an accidental DBA?
In this talk, Mike Walsh will share some thoughts on the role of DBA - How to become one, What a DBA's priorities should be and what the pros and cons of being one are.
He'll look through his 13 years of DBA experience and share some of the lessons he wish he learned before he started out.
SessionID: 20701
PowerShell Fundamentals for Beginners
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: PowerShell
Speaker: Mike Robbins
Title: PowerShell Fundamentals for Beginners
Abstract:
PowerShell IS where Microsoft is going for the administration of its products. If you’re not actively trying to learn PowerShell today, you’re soon going to be well behind the learning curve of the average IT pro. This session will start from zero and cover the basic fundamentals of PowerShell that will get you started on the right track to becoming a PowerShell Hero. The fundamentals that will be taught in this session are applicable whether you’re a Desktop Admin, Server Admin, SQL Server Admin, Exchange Admin, SharePoint Admin, or even if you’re the Admin of a third party product that supports PowerShell integration such as a SAN Admin. This will be an interactive session full of demos so bring your questions.
SessionID: 21069
Using SQL Server 2012s Always On
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 4 - Presented by Dell
Speaker: Denny Cherry
Title: Using SQL Server 2012s Always On
Abstract:
In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.
SessionID: 21070
Storage for the DBA
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 1 - Presented by SIOS
Speaker: Denny Cherry
Title: Storage for the DBA
Abstract:
SessionID: 21815
Automating SSIS Development with Biml
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 2 - Presented by Tek Systems
Speaker: Paul Waters
Title: Automating SSIS Development with Biml
Abstract:
In this session we will start by showing the power of Biml. We will then step back, and start from the beginning of using BimlScript. Once we cover the basics, we will cover practical examples using the BIDS Helper add-in to automate SSIS development.
SessionID: 22334
Tips Tricks for dynamic SSRS Reports
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 1 - Presented by Slalom
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: 22738
SQL Database (Windows Azure)
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 5 - Presented by Red Gate
Speaker: Ryan Duclos
Title: SQL Database (Windows Azure)
Abstract:
***It is assumed that you have familiarity with SQL Server.
SessionID: 23798
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 1 - Presented by SIOS
Speaker: Dave Bermingham and Eric Schwartz
Abstract:
SessionID: 24677
Taking BI to the Next Level: Collaboration
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 1 - Presented by Slalom
Speaker: Stacia Varga
Title: Taking BI to the Next Level: Collaboration
Abstract:
SessionID: 24693
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 3
Speaker: Stacia Varga
Abstract:
SessionID: 24931
So You Want To Be A Rockstar Report Developer?
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 2 - Presented by Tek Systems
Speaker: Melissa Coates
Title: So You Want To Be A Rockstar Report Developer?
Abstract:
You don't want to settle for being an average Report Developer, right? In this highly interactive session we'll discuss various development, standardization, deployment, and documentation practices that will make your SSRS development life easier, your output of higher quality, increase maintainability, and ultimately save you time. Audience participation and sharing of experiences is encouraged as we cover choices you have for datasets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session focuses primarily on SQL Server Reporting Services 2012, although some concepts may apply to other BI tools as well. Join us for this this session and take your reporting skills to the next level!
SessionID: 25760
SQL Server Parallel Data Warehouse 2012 Deep Dive
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 4 - Presented by Dell
Speaker: Steve Busby
Title: SQL Server Parallel Data Warehouse 2012 Deep Dive
Abstract:
This session will provide a technical overview and deep dive into the architecture and features of SQL Server Parallel Data Warehouse 2012, Microsoft's massively scalable data warehousing appliance.
SessionID: 25837
Working with "Biggish Data"
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 4 - Presented by Dell
Speaker: Stuart Ainsworth
Title: Working with "Biggish Data"
Abstract:
Most database professionals know (from firsthand experience) that there continues to be a "data explosion", and there's been a lot of focus lately on "big data". But what do you do when your data's just kind of "biggish"? You're managing Terabytes, not Petabytes, and you're trying to squeeze out as much performance out of your aging servers as possible. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of "larger-than-average" databases. Special attention will be paid to the following areas: * query design * logical and physical data structures * maintenance backup strategies
SessionID: 25903
Managing the SQL Server 2012 SSIS catalog (SSISDB)
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 1 - Presented by Slalom
Speaker: Sven Aelterman
Title: Managing the SQL Server 2012 SSIS catalog (SSISDB)
Abstract:
In SQL Server 2012, the new project deployment model also provides benefits for managing and monitoring your SSIS solutions. This session delves into the SSISDB, the database where your packages and their execution details and results are stored. You’ll learn about the schema of the SSISDB and how to use the provided stored procedures and views to manage your SSIS catalog.
SessionID: 25992
45 min to build your first SSRS report
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 3 - Presented by Intellinet
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2008 R2 and go interstellar with some space data!
SessionID: 26097
Best Practices for Implementing an Enterprise BI Solution
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 3
Speaker: Teo Lachev
Title: Best Practices for Implementing an Enterprise BI Solution
Abstract:
Learn best practices to make your organization a center of BI excellence! I’ll walk you through lessons learned during our implementation of an enterprise end-to-end BI solution, which is discussed in the Records Management Firm Saves $1 Million, Gains Faster Data Access with Microsoft BI case study published by Microsoft. Working experience with the dimensional modeling and the Microsoft BI stack is assumed.
SessionID: 26175
TSQL Road Less Traveled: MERGE
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 2 - Presented by Precise
Speaker: Kevin Boles
Title: TSQL Road Less Traveled: MERGE
Abstract:
Yeah, it has an arcane syntax - but that is why we have templates and snippets! :-P Merge is a very powerful TSQL construct that can both simplify your code and help with some otherwise difficult maneuvers such as the classic "Upsert".
SessionID: 26176
TSQL Road Less Traveled: APPLY
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 1 - Presented by SIOS
Speaker: Kevin Boles
Title: TSQL Road Less Traveled: APPLY
Abstract:
SessionID: 26520
Using SSIS 2012 for ETL in a Data Warehouse
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Twelfth Track!
Speaker: Thomas LeBlanc
Title: Using SSIS 2012 for ETL in a Data Warehouse
Abstract:
This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints.
SessionID: 26522
Attributes Hierarchies in Analysis Services 2012
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 1 - Presented by Slalom
Speaker: Thomas LeBlanc
Title: Attributes Hierarchies in Analysis Services 2012
Abstract:
SessionID: 26717
You Inherited a Database, Now What?
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBD 1 - Presented by Idera
Speaker: Tim Radney
Title: You Inherited a Database, Now What?
Abstract:
SessionID: 26725
Know Backups and Know Recovery
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 1 - Presented by SIOS
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
It is easy to schedule full backups to run each night, but is that the right decision for your organization? You say you have a backup strategy, but what is your recovery strategy? Do you have a well-executed recovery plan?
In this session I will cover several methods for performing much needed backups and how to recover those backups. Full, Differential, File Group, Transaction logs and recovery the tail end of a the log. He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
SessionID: 26829
A Walk Around the SQL Server 2012 Audit Feature
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 5 - Presented by Red Gate
Speaker: Timothy McAliley
Title: A Walk Around the SQL Server 2012 Audit Feature
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
SessionID: 27160
Managing Enterprise Environments with PowerShell
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: PowerShell
Speaker: Thomas Stringer
Title: Managing Enterprise Environments with PowerShell
Abstract:
SessionID: 28087
Bridging the Chasm: BI Theory vs. Practice
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 3
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 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: 34712
Expanding Self-Service BI with Excel 2013
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 2 - Presented by Tek Systems
Speaker: Leo Furlong
Title: Expanding Self-Service BI with Excel 2013
Abstract:
With Excel 2013, you can now easily build out a self-service BI solution that tells a complete story of your data. During this session, we will explore new features such as PowerPivot, Power View, Quick Explore, Quick Analysis, Timeline Slicers, and Flash Fill that enable you to rapidly mash-up, explore, analyze, and visualize any data ranging from a few rows to hundreds of millions of rows.
SessionID: 34721
Secrets of Enterprise Data Mining
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 3
Speaker: Mark Tabladillo
Title: Secrets of Enterprise Data Mining
Abstract:
SessionID: 34722
Applied Enterprise Semantic Mining
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 2 - Presented by Tek Systems
Speaker: Mark Tabladillo
Title: Applied Enterprise Semantic Mining
Abstract:
Text mining is projected to dominate data mining, and the reasons are evident: we have more text available than numeric data. Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining.
SessionID: 8846
SQL Server Database Development with SSDT
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 3 - Presented by Intellinet
Speaker: Aaron Nelson
Title: SQL Server Database Development with SSDT
Abstract:
Most importantly we’ll show the many benefits of the Publish feature, and why you will want to use the built-in refactoring instead of just renaming objects. Throughout this presentation we will also highlight and demonstrate the features that have been added to SSDT in the past year.
SessionID: 9033
Storage Tuning Deep Dive
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBD 1 - Presented by Idera
Speaker: Wesley Brown
Title: Storage Tuning Deep Dive
Abstract:
Takeaways:
- How to configure spinning disk for maximum IO or maximum throughput
- How to keep your SSD’s from suffering the write cliff and keep performance strong
- Using the DVD Store 2 benchmark to test with SQL Server installed
- Using ioMeter to test disks directly
SessionID: 9363
5 Query Plan Culprits That Cause 95% of Headaches
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: DBA 2 - Presented by Precise
Speaker: Adam Machanic
Title: 5 Query Plan Culprits That Cause 95% of Headaches
Abstract:
SessionID: 9496
Using BIML as an SSIS Design Patterns Engine
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: B/I 2 - Presented by Tek Systems
Speaker: Andy Leonard
Title: Using BIML as an SSIS Design Patterns Engine
Abstract:
Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.
SessionID: 9499
Hacking the SSIS 2012 Catalog
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Twelfth Track!
Speaker: Andy Leonard
Title: Hacking the SSIS 2012 Catalog
Abstract:
Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!
SessionID: 9716
The Decoder Ring for Data Warehousing / BI
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Zero Level
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: 9720
Off and Running with PowerPivot for Excel 2013
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Twelfth Track!
Speaker: Robert Cain
Title: Off and Running with PowerPivot for Excel 2013
Abstract:
PowerPivot is an exciting new technology from Microsoft that will allow users to leverage their data to answer many of their business questions. Commonly referred to as "Self Service Business Intelligence", PowerPivot consists of two components, PowerPivot for Excel 2010/2013 and PowerPivot for SharePoint 2010/2013. This presentation will provide an overview of both components then dig deeper into PowerPivot for Excel 2013. Multiple demos illustrate everything from importing data to creating pivot tables and charts, as well as using techniques such as filters and calculated columns.
SessionID: 9967
Database Design for Beginners
Event Date: 18-05-2013 - Session time: 00:00:00 - Track: Zero Level
Speaker: Audrey Hammonds
Title: Database Design for Beginners
Abstract:
Interested in understanding the basics of database design? This session is for you! We’ll cover some tried and true rules to follow when designing a new database, as well as how to examine an existing database from a design perspective. By the end of the session, you should be ready to get back to work and tackle any design challenge.