Nr: 89
SQLSaturday #89 - Atlanta 2011
SessionID: 28384
ETL Smackdown with Julie Smith
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell
Speaker: Aaron Nelson
Title: ETL Smackdown with Julie Smith
Abstract:
In this session, you’ll learn how to load a database using SQL Server Integration Services (SSIS) and PowerShell. You'll see a battle between two database professionals (Aaron Nelson and Julie Smith), attempting to load a database in the fastest, simplest, and most reliable way. You'll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the ETL Smackdown
SessionID: 28452
Zero to Cube
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1
Speaker: Adam Jorgensen
Title: Zero to Cube
Abstract:
Come get hands on with Analysis Services and learn how to quickly build a cube in your environment as well as best practices from the SSAS Maestro program co-course director. Adam will get you building cubes right in this session! Come check it out and get to ask your questions!
SessionID: 28583
Log Your Database Objects Execution
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 3
Speaker: Alex Tocitu
Title: Log Your Database Objects Execution
Abstract:
How do you know your scripts or T-SQL code ran successfully and accomplished what it was ment to?
This talk will discuss a generic framework for testing/logging results from database scripts, stored procedures, and other T-SQL coded objects.
SessionID: 28635
15 Powerful SQL Server Dynamic Management Objects
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1
Speaker: Adam Machanic
Title: 15 Powerful SQL Server Dynamic Management Objects
Abstract:
SessionID: 28636
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1
Speaker: Adam Machanic
Abstract:
SessionID: 28890
Database Makeover: Renovate Your Data Model
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 2
Speaker: Audrey Hammonds
Title: Database Makeover: Renovate Your Data Model
Abstract:
SessionID: 29115
Breaking out of your shell: Cube Dweller to Leader
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Bobby Dimmick
Title: Breaking out of your shell: Cube Dweller to Leader
Abstract:
… in which our young hero tells his story of going from lonely developer to community leader. A discussion of discovery, education, and adventure. Learn how to grow beyond a cube dweller to become someone recognized in the community as an enabler and educator.
SessionID: 29128
Inside SQL Server Wait Types
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 2
Speaker: Bob Ward
Title: Inside SQL Server Wait Types
Abstract:
SessionID: 29129
Inside SQL Server Latches
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 2
Speaker: Bob Ward
Title: Inside SQL Server Latches
Abstract:
The SQL Server database engine uses latches for internal synchronization to critical operations. So why would you care about what a latch is? Well, if you have ever monitored a SQL Server closely, you know you can’t escape latches. Come to this advanced session exploring the internals of how SQL Server uses the concept of latches for synchronization of key internal data structures. This talk is a very advanced “500” session that may include the use of advanced diagnostics such the Windows debugger and discussion of Windows APIs. I will assume the audience has a basic working knowledge of the SQL Server engine including an understanding of some of the more common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests
SessionID: 29130
More of Bob Ward
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 2
Speaker: Bob Ward
Title: More of Bob Ward
Abstract:
This session will wrap up Bob's first session and lead into his second.
SessionID: 29269
Are you a Linchpin? Career management lessons...
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Brian Moran
Title: Are you a Linchpin? Career management lessons...
Abstract:
Full title is "Are you a Linchpin? Career management lessons to help you become indispensible."
Are consultants better that people who work for ‘regular’ companies? Perhaps it is the other way around? No classification of IT worker is inherently smarter or better than another. However, I believe that many successful SQL Server professionals share similar characteristics that shape their careers and success. Of course they have interesting differences as well! This session explores 20 years of my ideas, learning, and research on this topic. The session also shares the experience of several top SQL Server professions as they share personal thoughts on what has made them indispensible. This is a panel session.
SessionID: 29270
Leadership Coaching: A repeatable methodology...
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Brian Moran
Title: Leadership Coaching: A repeatable methodology...
Abstract:
Leadership Coaching: A repeatable methodology for Leadership Development.
Leadership coaching is the practice of using relational influence, the people kind, not the database kind ?, to develop and empower adult leaders. Coaching embraces a set of structured techniques designed to help you make other people more effective in reaching their goals and developing as leaders and is very different from mentoring or counseling and is being embraced more and more by management guru’s around the world. Do you have a systematic approach for developing yourself as a leader? Do you have a systematic approach for investing in and equipping the next generation... (I will edit this to fit...)
SessionID: 29380
EMC Strategy with Microsoft Technology
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 3
Speaker: Dilip Tailor
Title: EMC Strategy with Microsoft Technology
Abstract:
EMC will be presenting it's overall EMC strategy in conjunction with Microsoft technology solutions including SQL, Sharepoint and Exchange with an emphasis on best practices around Microsoft SQL. EMC has a long history of partnership with Microsoft in terms of integration and solution deployment and EMC will walk through the partnership synergies and it's product portfolio innovation around SQL Server including storage, backup and recovery, virtualization and security.
SessionID: 29866
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1
Speaker: Dean Richards
Abstract:
Ignite doesn't just show health metrics, it correlates the most important performance data to build a complete picture of SQL Server performance for the DBA, Developer, and DBA manager. Response time, queries, sessions, and server resources, are all analyzed by Ignite Performance Intelligence to show both historical and real-time conditions affecting database applications.
SessionID: 29867
Monitoring SQL Server in a VMware Environment
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 3
Speaker: Dean Richards
Title: Monitoring SQL Server in a VMware Environment
Abstract:
SessionID: 30018
Characteristics of a Great Relational Database
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development
Speaker: Louis Davidson
Title: Characteristics of a Great Relational Database
Abstract:
SessionID: 30061
Master Data Management with Master Data Services
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1
Speaker: Eric Melcher
Title: Master Data Management with Master Data Services
Abstract:
This session will provide attendees with an overview of how Master Data Management solutions can be delivered using SQL Server Master Data Services. This will include a brief overview of MDM concepts, a walkthrough of the Master Data Services capabilities, and a demonstration of the product.
SessionID: 30112
Diagnosing connectivity issues with SQL Server
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 3
Speaker: Evan Basalik
Title: Diagnosing connectivity issues with SQL Server
Abstract:
Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs,
Kerberos, and general connectivity. He will demonstrate how to use UDLs and network traces to
easily identify the problem, plus provide tips that often solve the problem in seconds.
SessionID: 30137
SSIS Data Flow Buffer Breakdown
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1
Speaker: Eric Wisdahl
Title: SSIS Data Flow Buffer Breakdown
Abstract:
SessionID: 30236
SQL “Denali” AlwaysOn High Availability Solutions
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 2
Speaker: Geoff Hiten
Title: SQL “Denali” AlwaysOn High Availability Solutions
Abstract:
AlwaysOn is the new High Availability branding for Microsoft SQL Server that combines the best in Clustering, Mirroring, and Log Shipping for a simple, seamless experience. See what Microsoft is building into SQL Server Codename “Denali” and how you can plan for this new way to increase database availability in your shop.
SessionID: 30261
7 Different Solutions for Bad Parameter Sniffing
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 2
Speaker: Grant Fritchey
Title: 7 Different Solutions for Bad Parameter Sniffing
Abstract:
SessionID: 30564
Getting Started with Powershell
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell
Speaker: Jon Boulineau
Title: Getting Started with Powershell
Abstract:
Powershell is becoming an essential skill for any IT professional working with Microsoft products. Many of the concepts upon which Powershell is built are new to non-developers . In this session, we learn the skills necessary to get started. You will learn the object-oriented concepts that are essential to understanding Powershell and see some examples of how Powershell can change the way you think about your job.
SessionID: 30720
What's New for Business Intelligence in SQL Server
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1
Speaker: Jen Underwood
Title: What's New for Business Intelligence in SQL Server
Abstract:
This session will cover SSIS, SSRS, SSAS, PowerPivot, BISM and Crescent. We will walk through high level overviews of new features in SSIS, SSRS, SSAS and take a deeper look at improvements in PowerPivot, the new Business Intelligence Semantic Model and new Project Crescent for ad-hoc reporting.
SessionID: 30721
PowerPivot Basics and Creative Implementations
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1
Speaker: Jen Underwood
Title: PowerPivot Basics and Creative Implementations
Abstract:
This session will cover what you need to know about PowerPivot, how to build PowerPivot models from a variety of data sources, common challenges and basic DAX. We will also look at some often overlooked creative implementations of PowerPivot to expedite BI application delivery and expand Self-Service BI.
SessionID: 30850
Using StudioShell to Automate Visual Studio
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell
Speaker: Jim Christopher
Title: Using StudioShell to Automate Visual Studio
Abstract:
StudioShell is an open-source deeply integrated PowerShell host available inside of Visual Studio 2010. It’s goal is to fundamentally change the way you interact with your IDE and your code. It exposes many of Visual Studio’s extensibility points in a simple and consistent way, and it makes the Visual Studio programmability features interactive and discoverable. What an add-in does in a compiled binary, StudioShell can accomplish with a one-liner. Come see the possibilities in a session of practical demonstrations given by the author.
SessionID: 30851
Stupid PowerShell Tricks
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell
Speaker: Jim Christopher
Title: Stupid PowerShell Tricks
Abstract:
Let's face it - I'm no SQL guy, and you're no .NET developer. But that just means there is a ton we can learn from each other.
Some spend an hour hearing and sharing practical, time-saving PowerShell hacks you can start using today. Start taking your one-liners and turn it into a crisp, clean, reusable PowerShell!
SessionID: 30982
Do More (ETL) with Less (Effort) - Automating SSIS
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 2
Speaker: John Welch
Title: Do More (ETL) with Less (Effort) - Automating SSIS
Abstract:
SessionID: 31311
Top 10 Admin Mistakes on SQL Server
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 3
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: 31599
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1
Speaker: Mary Ledbetter
Abstract:
WhereScape and Microsoft have partnered for the newly announced Microsoft SQL Server Fast Track Data Warehouse 3.0. WhereScape RED provides Native support for Microsoft SSIS, SSAS, and T/SQL for the agile production of enterprise-level data integration and transformations solutions.
WhereScape RED is an IDE for managing data warehouses, marts, stores and vaults. RED is the only product that supports the entire data management life cycle by integrating source system exploration, schema design, metadata management, scheduling and enhancement into a single integrated design.
SessionID: 31879
Iceberg, Dead Ahead!
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 3
Speaker: Mike Walsh
Title: Iceberg, Dead Ahead!
Abstract:
What does a plane crash have to do with technical skills? You might be surprised. There are many lessons to be learned from disasters. Most accidents are caused not by one factor, but by a series of seemingly-small missteps; It’s the same for us. Even if a freak accident occurs, training and preparation can make all the difference; it's the same for us. In this session we’ll discuss as a group some real-life disasters and see what skills, attitudes and thought processes we can take back to our day jobs. We'll look at a handful of aviation disasters and look for patterns of behavior at fault or that saved the day. Hopefully you'll leave looking for those behaviors in yourself and on your project teams. Fasten your seatbelt!
SessionID: 31932
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 2
Speaker: Melissa Coates
Abstract:
The Microsoft BI stack has a few choices for visualization. We will explore options, flexibility, limitations, and ease of use for creating dashboards scorecards with:
- PerformancePoint Services 2010
- Reporting Services 2008 R2
- SharePoint Server 2010
- PowerPivot
- Crescent.
This session will be a fun one! We will compare and contrast options available in each tool, such as: charts, gauges, maps, indicators, sparklines, data bars, and decomposition trees. The goal is to determine when you might choose one tool in the Microsoft BI stack versus another.
SessionID: 32069
PowerShell: Are you checking out my profile?
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell
Speaker: Nicholas Cain
Title: PowerShell: Are you checking out my profile?
Abstract:
In this session we'll talk about the power a profile puts at your fingertips. I will also demo (and share) several PowerShell functions that I use frequently for common tasks like checking database backups and disk space.
I'll show you my PowerShell profile if you show me yours.
SessionID: 32070
Centralized auditing of permissions with SQL Serve
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell
Speaker: Nicholas Cain
Title: Centralized auditing of permissions with SQL Serve
Abstract:
As a DBA it can be a challenge to know who has permissions to what SQL instances and what objects. The more instances you have the more complex that task. In this presentation I'll share a method using PowerShell and TSQL that can be used to capture permissions from all of your SQL instances and load them into a centralized location. We'll even take it a step further by auditing those permissions so that we can quickly and easily identify any that might have changed.
SessionID: 32088
SQL Developer's Intro to SSAS
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development
Speaker: Nathan Mourfield
Title: SQL Developer's Intro to SSAS
Abstract:
SessionID: 32588
Revenge: The SQL!
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development
Speaker: Rob Volk
Title: Revenge: The SQL!
Abstract:
Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!
SessionID: 32792
The 4-hour DBA: Automate, Audit and Relax
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1
Speaker: Sarah Barela
Title: The 4-hour DBA: Automate, Audit and Relax
Abstract:
Do you feel that you are overworked and always fighting fires and never can get ahead? In this session, I will help you identify what is important to your job and how to find the time to address those critical tasks. I will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores. The flip side of automation is auditing. Routine auditing your server is essential to avoid nasty surprises that can lead to a loss of control. We will create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office.
SessionID: 33106
Social Marketing 2011 for Microsoft Professionals
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Mark Tabladillo
Title: Social Marketing 2011 for Microsoft Professionals
Abstract:
Developing a social media platform is a challenge for high-end professionals and consultants. The presenter has successfully leveraged web media to establish a blog (http://marktab.net), cofound an online journal (http://solidq.com/sqj), become a paid video presenter, and secure a spot at Microsoft TechEd 2011. This presentation introduces the basic elements for 2011 of a successful web strategy, starting with discovering your own best personal focus given current market needs. The presenter includes experiences with website development, WordPress blog hosting, leveraging social media services (including Twitter, Linked in, YouTube and Facebook), and working with Microsoft.
SessionID: 33251
SQL Server XML 201
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development
Speaker: Stuart Ainsworth
Title: SQL Server XML 201
Abstract:
The xml datatype in SQL Server expands the potential of the relational platform to store increasingly complex forms of data, but without the use of the appropriate query language, much of that potential can remain unused. This session will cover the basics of SQL Server XQuery and FLWOR; the assumption is that attendees will have some basic exposure to XML (including the use of XML in SQL Server). Learn how to "run queries within a query", and how to extract XML data into a tabular format. Coverage will include the five basic XML methods (.exist(), .value(), .query(), .nodes(), and .modify()) and FLWOR (for, let, where, order by, and return).
SessionID: 33292
Storing BLOBs in SQL Server using FILESTREAM
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development
Speaker: Sven Aelterman
Title: Storing BLOBs in SQL Server using FILESTREAM
Abstract:
SessionID: 33310
Active Directory Content in a SQL Server Database
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1
Speaker: Scott Russell
Title: Active Directory Content in a SQL Server Database
Abstract:
This session will describe an ETL-based approach to loading Active Directory (AD) content into a SQL Server DB. This DB can then be used to provide program-based or interactive access to AD content using familiar SQL syntax without the complexity or limitations of using special AD tools or LDAP queries to directly access AD content. AD content includes users, computers, groups, and group memberships.
SessionID: 33410
Transaction Log Deep Dive
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1
Speaker: Kevin Boles
Title: Transaction Log Deep Dive
Abstract:
Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.
SessionID: 33602
It's TEMPDB Why Should You Care
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Tim Radney
Title: It's TEMPDB Why Should You Care
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated each time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 33711
Introducing Business Intelligence Semantic Model
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 2
Speaker: Teo Lachev
Title: Introducing Business Intelligence Semantic Model
Abstract:
SQL Server 2011 "Denali" unveils the Business Intelligence Semantic Model (BISM) that will support the full spectrum of BI needs for personal, team, and organizational business intelligence. This session introduces you to BISM and focuses on its tabular capabilities. My goal is bring you up to speed on the new developments in Analysis Services and PowerPivot for the "Denali" release.
SessionID: 34100
Many-to-Many: Multiple Calendars in a Single Cube
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 2
Speaker: William E Pearson III
Title: Many-to-Many: Multiple Calendars in a Single Cube
Abstract:
Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to some organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services "many-to-many" dimension scenario.