sqlsathistory

Nr: 89

Back to Main list

SQLSaturday #89 - Atlanta 2011

Start Time (24h) Speaker Track Title
00:00:00 Aaron Nelson Powershell ETL Smackdown with Julie Smith
00:00:00 Adam Jorgensen BI Track 1 Zero to Cube
00:00:00 Alex Tocitu DBA Track 3 Log Your Database Objects Execution
00:00:00 Adam Machanic DBA Track 1 15 Powerful SQL Server Dynamic Management Objects
00:00:00 Adam Machanic DBA Track 1 SQL Server Parallelism and Performance
00:00:00 Audrey Hammonds BI Track 2 Database Makeover: Renovate Your Data Model
00:00:00 Bobby Dimmick Professional Dev Breaking out of your shell: Cube Dweller to Leader
00:00:00 Bob Ward DBA Track 2 Inside SQL Server Wait Types
00:00:00 Bob Ward DBA Track 2 Inside SQL Server Latches
00:00:00 Bob Ward DBA Track 2 More of Bob Ward
00:00:00 Brian Moran Professional Dev Are you a Linchpin? Career management lessons...
00:00:00 Brian Moran Professional Dev Leadership Coaching: A repeatable methodology...
00:00:00 Dilip Tailor DBA Track 3 EMC Strategy with Microsoft Technology
00:00:00 Dean Richards DBA Track 1 Light the Fire on Database Performance
00:00:00 Dean Richards DBA Track 3 Monitoring SQL Server in a VMware Environment
00:00:00 Louis Davidson Development Characteristics of a Great Relational Database
00:00:00 Eric Melcher BI Track 1 Master Data Management with Master Data Services
00:00:00 Evan Basalik DBA Track 3 Diagnosing connectivity issues with SQL Server
00:00:00 Eric Wisdahl BI Track 1 SSIS Data Flow Buffer Breakdown
00:00:00 Geoff Hiten DBA Track 2 SQL “Denali” AlwaysOn High Availability Solutions
00:00:00 Grant Fritchey DBA Track 2 7 Different Solutions for Bad Parameter Sniffing
00:00:00 Jon Boulineau Powershell Getting Started with Powershell
00:00:00 Jen Underwood BI Track 1 What's New for Business Intelligence in SQL Server
00:00:00 Jen Underwood BI Track 1 PowerPivot Basics and Creative Implementations
00:00:00 Jim Christopher Powershell Using StudioShell to Automate Visual Studio
00:00:00 Jim Christopher Powershell Stupid PowerShell Tricks
00:00:00 John Welch BI Track 2 Do More (ETL) with Less (Effort) - Automating SSIS
00:00:00 Kevin Kline DBA Track 3 Top 10 Admin Mistakes on SQL Server
00:00:00 Mary Ledbetter BI Track 1 Does your Query and Reporting tool 'work'?
00:00:00 Mike Walsh DBA Track 3 Iceberg, Dead Ahead!
00:00:00 Melissa Coates BI Track 2 Dashboards...How to Choose Which MSBI Tool?
00:00:00 Nicholas Cain Powershell PowerShell: Are you checking out my profile?
00:00:00 Nicholas Cain Powershell Centralized auditing of permissions with SQL Serve
00:00:00 Nathan Mourfield Development SQL Developer's Intro to SSAS
00:00:00 Rob Volk Development Revenge: The SQL!
00:00:00 Sarah Barela DBA Track 1 The 4-hour DBA: Automate, Audit and Relax
00:00:00 Mark Tabladillo Professional Dev Social Marketing 2011 for Microsoft Professionals
00:00:00 Stuart Ainsworth Development SQL Server XML 201
00:00:00 Sven Aelterman Development Storing BLOBs in SQL Server using FILESTREAM
00:00:00 Scott Russell DBA Track 1 Active Directory Content in a SQL Server Database
00:00:00 Kevin Boles DBA Track 1 Transaction Log Deep Dive
00:00:00 Tim Radney Professional Dev It's TEMPDB Why Should You Care
00:00:00 Teo Lachev BI Track 2 Introducing Business Intelligence Semantic Model
00:00:00 William E Pearson III BI Track 2 Many-to-Many: Multiple Calendars in a Single Cube

SessionID: 28384

ETL Smackdown with Julie Smith

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within is the data you need to help solve virtually any performance problem, quickly debug issues, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions--information gleaned from heavy use of the objects in a number of environments. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. Attend this session and you will be the master of your SQL Server instance.

SessionID: 28636

SQL Server Parallelism and Performance

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1

Speaker: Adam Machanic

Title: SQL Server Parallelism and Performance

Abstract:

Over the past five years, multi-core processors have made the jump from semi-obscure to commonplace in the data center. Today we regularly expect to see 16, 32, or 64 cores in even our lower-end servers. Are you getting everything you can out of the wealth of processing power at your disposal? Attend this session to take a detailed look at how and why SQL Server processes queries in parallel, as well as methods for controlling parallel processing via configuration options, the Resource Governor, and query-level hints. This session will enable you to immediately evaluate, understand, and improve the state of parallel processing on your servers. .

SessionID: 28890

Database Makeover: Renovate Your Data Model

Back to calendar

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:

You know the concepts of normalization, logical modeling, and physical implementation. But what happens when you’ve inherited a less than perfect data model? You need to renovate while keeping the production system humming. In this session, we’ll talk about how to evaluate an existing model, how to approach design when your system is up and running and how to incrementally apply database design changes in a fast-moving environment. Every database, even ones consisting of a collection of flat, unrelated tables, has the potential to become a beautiful database. All you need is an eye for design and a strategy to get you there.

SessionID: 29115

Breaking out of your shell: Cube Dweller to Leader

Back to calendar

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

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 2

Speaker: Bob Ward

Title: Inside SQL Server Wait Types

Abstract:

Have you ever encountered a wait type with SQL Server but can’t find any information on what it means? Perhaps you have thought the meaning of these is hidden away somewhere in a dark closet? In this talk, we will explore the internals of wait types within the SQL Server Engine. Rather than cover some of the more common wait types such as lock and latches, we will explore the more advanced and obscure wait types that may be surfaced by the engine. The ones you can’t find much information about.

SessionID: 29129

Inside SQL Server Latches

Back to calendar

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

Back to calendar

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...

Back to calendar

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...

Back to calendar

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

Back to calendar

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

Light the Fire on Database Performance

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: DBA Track 1

Speaker: Dean Richards

Title: Light the Fire on Database Performance

Abstract:

Come learn how Ignite for SQL Server is the one SQL Server performance monitoring solution that identifies, analyzes and resolves all of the performance problems affecting applications and users depending on a Microsoft SQL Server instance.

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

Back to calendar

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:

SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.

SessionID: 30018

Characteristics of a Great Relational Database

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development

Speaker: Louis Davidson

Title: Characteristics of a Great Relational Database

Abstract:

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more will be discussed

SessionID: 30061

Master Data Management with Master Data Services

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1

Speaker: Eric Wisdahl

Title: SSIS Data Flow Buffer Breakdown

Abstract:

This session will examine the different types of data flow components, execution trees, data buffers, performance metrics and logging mechanisms. In determining how the buffers are built and used, the developer will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The developer will further learn how to capture performance metrics to identifiably track these impacts. Finally, the session will take a look at the controls and effects of parallel package and parallel task execution.

SessionID: 30236

SQL “Denali” AlwaysOn High Availability Solutions

Back to calendar

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

Back to calendar

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:

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. In this session we'll gain an understanding of what exactly parameter sniffing is and why it's usually so helpful. Then, we'll explore how parameter sniffing can wrong and I'll show you seven different ways you can deal with it when it does. You'll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment.

SessionID: 30564

Getting Started with Powershell

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

SessionID: 31311

Top 10 Admin Mistakes on SQL Server

Back to calendar

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

Does your Query and Reporting tool 'work'?

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 1

Speaker: Mary Ledbetter

Title: Does your Query and Reporting tool 'work'?

Abstract:

Studies show that in most cases the Query Tool is not the problem! Today's challenge is Data, and no one can help manage your data better than WhereScape RED.

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!

Back to calendar

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

Dashboards...How to Choose Which MSBI Tool?

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: BI Track 2

Speaker: Melissa Coates

Title: Dashboards...How to Choose Which MSBI Tool?

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:

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?

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Powershell

Speaker: Nicholas Cain

Title: PowerShell: Are you checking out my profile?

Abstract:

PowerShell is a very powerful management tool and you can spend hours writing magical scripts to provide automation for frequently run tasks. Often forgotten is the PowerShell profile, a place you can add your own functions which can provide you lightning fast access to information.

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

Back to calendar

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

Back to calendar

Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Development

Speaker: Nathan Mourfield

Title: SQL Developer's Intro to SSAS

Abstract:

This session covers a basic overview of SSAS in 08. The session will go over how cube and dimensions are build and developed, basic data mining, and the other information SQL Devs and Data Analysts need to know moving into Analysis Services.

SessionID: 32588

Revenge: The SQL!

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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.