Nr: 165
SQLSaturday #165 - Lincoln 2012
SessionID: 10436
Kama Sutra of SSIS: A guide to loving ETL
Event Date: 06-10-2012 - 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: 10437
Type more, click less: using EzAPI to build SSIS
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Bill Fellows
Title: Type more, click less: using EzAPI to build SSIS
Abstract:
The EzAPI is a free .NET library produced by the SSIS team supporting 2008 and 2012. In this code-centric talk, we will start with a basic package and progressively work through the object model to build more complex packages. You will leave this talk with an understanding of how to spin up new packages that have variables, precedence constraints, dataflows, logging and configuration---all without abusing your poor mouse.
SessionID: 11308
Data Modeling Best Practices for Tabular Models
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Carlos Bossy
Title: Data Modeling Best Practices for Tabular Models
Abstract:
The new Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you'll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you'll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel and Power View.
SessionID: 11309
Real-time Data Warehouse and Reporting Solutions
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Carlos Bossy
Title: Real-time Data Warehouse and Reporting Solutions
Abstract:
SessionID: 11591
SQL Server Internals: It's What's for Dinner!
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Christina Leo
Title: SQL Server Internals: It's What's for Dinner!
Abstract:
Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a chef analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server.
SessionID: 11592
What's Buried in the Plan Cache?
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Christina Leo
Title: What's Buried in the Plan Cache?
Abstract:
Creating a query plan can be a time consuming and expensive process. To avoid repeating these costly steps unnecessarily, SQL Server stores its query plans, in the plan cache where they can be reused as needed.
In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.
SessionID: 12570
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: David Klee
Abstract:
SessionID: 12571
Virtualizing Business Critical SQL Servers
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 1
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) and Andy Galbraith (@DBA_ANDY) 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: 12893
Take Control with SQL Server PowerShell
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: David Brockelsby
Title: Take Control with SQL Server PowerShell
Abstract:
SessionID: 13042
Case study - Compression and Partitioning (BCBSNE)
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Dean Nicholson
Title: Case study - Compression and Partitioning (BCBSNE)
Abstract:
Discussion of the reasons Blue Cross Blue Shield of Nebraska decided to implement table partitioning and data compression, how we implemented it, what issues we encountered and some examples of how we resolved the issues.
SessionID: 13401
Heart to Heart with Business Users
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Dave Pettengill
Title: Heart to Heart with Business Users
Abstract:
Now days the technician spends more and more of their time conversing with non-technical business users. The problem is, we speak different languages. This results in confusion, frustration and the impression that IT is difficult to work with. This discussion will focus on how to better communicate with business users to provide products and solutions that meet their needs, get them to understand the issues in providing those products and helping the business user to expand their thinking beyond the ordinary.
SessionID: 13402
A Database Perspective
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Dave Pettengill
Title: A Database Perspective
Abstract:
Too often we get wrapped up in the latest release of feature of database products. This presentation provides a broader perspective on databases, their life cycles and the life of a DBA. Based on 40 years in IT, we discuss why we do this and why it’s so hard for others to understand why we do what we do.
SessionID: 16882
The Accidental Programmer
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Jason Kassay
Title: The Accidental Programmer
Abstract:
Most people in the database world have heard of the term, "The Accidental DBA", those programmers who have to work with databases. How about the other side of the coin? What about DBA's an Dev's who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.
SessionID: 18155
Top 10 Admin Mistakes on SQL Server
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Kline
Title: Top 10 Admin Mistakes on SQL Server
Abstract:
Microsoft SQL Server is easier to administrate than any other relational database on
the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that
database administration on SQL Server is problem free. And since SQL Server is constantly
growing from small, home-grown applications, many IT professionals end up encountering issues
that others had tackled and solved years ago. Why not learn from those who first blazed the trails
of database administration, so that we don’t make the same mistakes over and over again. In
fact, wouldn’t you like to learn about those mistakes before they ever happen?
SessionID: 18157
Disk IO Tuning for Microsoft SQL Server
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Kline
Title: Disk IO Tuning for Microsoft SQL Server
Abstract:
Tuning disk subsystems for optimal SQL Server performance is typically the domain
of very experienced, enterprise DBAs. It normally requires years of experience the hard disk
subsystem to learn exactly what configurations perform best, provide the greatest fault tolerance,
and allow for the most scalability. This session removes the need for those years of experience
by answering questions like:
How does RAID compare to SAN, hard disk to SSD?
What is needed to properly monitor and tune the performance of my disk subsystem?
How do I tune my SQL Server for improved IO performance?
Configuring hardware can be very intimidating, especially when the application needs to scale.
SessionID: 19149
Securing the Cube; SSAS security framework
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Daniel Lewandowski
Title: Securing the Cube; SSAS security framework
Abstract:
Secure, Enable, Maintain, Sustain. In depth discussion on a SSAS security framework with SSIS maintenance toolkits. Create security roles in the cube that enable the business based on underlying data patterns. Presentation covers creation of roles in the cube, with a demo creating SSIS roles with a toolkit based on the adventureworks db model and cube. Using integrated security, service accounts and data sources in the presentation layers this we walk through a security model for end-to-end security as can be implemented in sharepoint integrated solutions and/or standalone reports. This presentation provides real world application and an SSIS toolkit to take away and implement in your solutions. Presented in English.
SessionID: 19199
Reporting Services tips for the Stephen Few fan
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Meagan Longoria
Title: Reporting Services tips for the Stephen Few fan
Abstract:
SessionID: 20096
PowerPivot with NASA data
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark Stacey
Title: PowerPivot with NASA data
Abstract:
Using DAX, you will see how to create filtered measures, and then dive into the new enhancements for the date table, relationshios, perspectives and KPIs.
As an added bonus, you will see how to pull the model into Visual Studio, decorate it with new attributes, and show the visualisations in other tools such as Performance Point and Crescent (PowerView)
SessionID: 20097
Analysis Services for the DBA
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark Stacey
Title: Analysis Services for the DBA
Abstract:
This session will be practical for SQL 2005 through 2008 R2, but he will also take the time to explain what changes in SQL 2012 and the new Tabular mode.
SessionID: 22108
SSIS 2012: A Deep Dive into the SSIS Catalog
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Phil Brammer
Title: SSIS 2012: A Deep Dive into the SSIS Catalog
Abstract:
SessionID: 25861
SQL Server 2012 High Availability and DR
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Sudhir Gajre
Title: SQL Server 2012 High Availability and DR
Abstract:
SessionID: 25863
How to be a DBA and retire Rich
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Sudhir Gajre
Title: How to be a DBA and retire Rich
Abstract:
Yes, how to be a DBA and retire rich. This is a session in the ‘off the beaten path’ or the ‘miscellaneous track’. You will learn nothing SQL Server technical in this session, but will learn about the Modern Portfolio Management theory in Finance. I will conduct a practical discussion on how to structure your 401(K) portfolio or your general investment portfolio for the most optimal asset allocation and maximum return while minimizing taxes and expenses. You can use the practical tips in this session to consider options to streamline your portfolio to maximize returns. This session may serve as a wakeup call to do something about your portfolio. When it comes to retirement, clearly, luck is not a strategy.
SessionID: 26577
Amazon RDS and SQL Azure - DB in the cloud
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 6
Speaker: Tim Plas
Title: Amazon RDS and SQL Azure - DB in the cloud
Abstract:
SessionID: 28053
Serene Velocity: Reporting Services and SSAS Data
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: William E Pearson III
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract:
SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
SessionID: 28054
SSAS 2012 Tabular vs. Multidimensional
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: William E Pearson III
Title: SSAS 2012 Tabular vs. Multidimensional
Abstract:
The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. BI professionals can implement Multidimensional cubes, or they can deploy Tabular models developed by business users to a dedicated server. Those new to Tabular, or those embarking upon BI for the first time with Analysis Services 2012, may find it difficult to choose between the two paths. In this session, BI Architect and MVP Bill Pearson overviews the nature and design goals of each option, comparing Multidimensional and Tabular features. He then offers guidance on selecting the appropriate model, providing real world examples to illustrate approaches for given scenarios.
SessionID: 34804
SQL Server Monitoring Crash Course
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: Michael Fal
Title: SQL Server Monitoring Crash Course
Abstract:
No one likes to be alone in the dark. Yet, often this is the case with our SQL Servers which usually suffer from a lack of monitoring. What's important? Tracing slow queries? Collecting wait stats? Looking at perfmon counters? This session will show you the key elements to monitor in your database instances, how to track them automatically, and where to go after your foundatation is built.
SessionID: 34805
Exposing the Core: SQL 2012 on Server Core
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Fal
Title: Exposing the Core: SQL 2012 on Server Core
Abstract:
Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
SessionID: 34833
Social Networking Is Alive!
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 5
Speaker: John Morehouse
Title: Social Networking Is Alive!
Abstract:
Social Networking is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don't have any fear as this session is for you! Social networking can be a very confusing place and when you don't know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We'll be covering Facebook, LinkedIn and Twitter.
SessionID: 34834
Backups Restores: You’re Not In Kansas Anymore!
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: John Morehouse
Title: Backups Restores: You’re Not In Kansas Anymore!
Abstract:
Have you ever been in Kansas and have a random house drop on you? Ok, probably not, but the moral of the question is that you never know when a house might fall out of the sky and you certainly don't want to be caught under it when it does!. Not understanding database backups restores is just like having a house crash down on around your ears. Loud, noisy and sometimes hard to put the pieces back together. As a follower of the Yellow Database Road, You have to be ready for said event. Now how do you do that you ask? You come to this session about Backups Restores. We'll talk about how to use them to help avoid having a house fall on your head!
SessionID: 9608
Maintain Your DBs with Help from Ola Hallengren
Event Date: 06-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Andy Galbraith
Title: Maintain Your DBs with Help from Ola Hallengren
Abstract:
One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren's MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.