Nr: 77
SQLSaturday #77 - Pensacola 2011
SessionID: 28379
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Aaron Nelson
Abstract:
Continuously gathering performance data to log history and developing a performance baseline is a really important task in any environment. Having quick access to what’s happening right now is equally important. In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info. We’ll also take a look at how to Visualize the data using charts.
SessionID: 28380
Loading Data with PowerShell
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC
Speaker: Aaron Nelson
Title: Loading Data with PowerShell
Abstract:
In this session we’ll take a look at how to load data into SQL Server using various data sources such as: text, csv, table. We’ll also load data from XML files; update data inside of XML files; and even kick off SSIS packages all from PowerShell. Finally we'll re-use our newly found XML scills to modify an SSIS package before we run it.
SessionID: 28888
T-SQL Awesomeness: 3 Ways to Write Cool SQL
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL
Speaker: Audrey Hammonds
Title: T-SQL Awesomeness: 3 Ways to Write Cool SQL
Abstract:
Come learn three new-school ways to expand your T-SQL repertoire with: • Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY
We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills.
SessionID: 28967
PowerPivot, Idea to Solution in 60 Minutes
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC
Speaker: Barry Ralston
Title: PowerPivot, Idea to Solution in 60 Minutes
Abstract:
SessionID: 29303
Deploying Kentico CMS Applcaition to Windows Azure
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV
Speaker: Bryan Soltis
Title: Deploying Kentico CMS Applcaition to Windows Azure
Abstract:
In this session, Bryan Soltis will demonstrate deploying a Kentico CMS application to Windows Azure. Topics covered will include converting a Kentico CMS site to a web application, adding and configuring a Windows Azure web role, implementation and configuration of Windows Azure storage accounts, deployment of a Kentico CMS database to SQL Azure, and deploying the application to Windows Azure. Bryan will demonstrate several code examples, real world applications, and best practices in developing Kentico CMS in the cloud.
SessionID: 29324
Dynamic SSIS: Configurations, Expression and Vari
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI
Speaker: Bradley Schacht
Title: Dynamic SSIS: Configurations, Expression and Vari
Abstract:
SessionID: 29360
Up and Running with SSIS in 5,4,3,2, (Datachix)1 !
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI
Speaker: Julie Smith
Title: Up and Running with SSIS in 5,4,3,2, (Datachix)1 !
Abstract:
This presentation is for those familiar with SQL Server, but absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour, stepping through a classic "old pro" DBA forced into Beginner ETL Developer scenario. We'll quickly cover not just developing the package, but also ways to deploy and execute.
SessionID: 30141
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Eric Wisdahl
Abstract:
SessionID: 30832
Windows Phone Garage
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Windows Phone Garage
Speaker: Joe Healy
Title: Windows Phone Garage
Abstract:
SessionID: 31032
Pulp SQL
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Jorge Segarra
Title: Pulp SQL
Abstract:
Pulp SQL: Stories, all have them. In this session Brad and Jorge will tell the tales of how SQL in shops can go horribly wrong, and how to properly go about doing it. This story will be told Tarrantino-style so prepare for some twists, characters and ninja-like tactics* to help you avoid your own SQL mistakes!*fight scenes may or may not break out
SessionID: 31202
Windows Phone Garage (Continued)
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Windows Phone Garage
Speaker: Karla Landrum
Title: Windows Phone Garage (Continued)
Abstract:
SessionID: 31203
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Karla Landrum
Abstract:
TBA
SessionID: 31330
Building Occasionally Connected Apps Using SQL Azu
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV
Speaker: Kevin Grohoske
Title: Building Occasionally Connected Apps Using SQL Azu
Abstract:
SessionID: 31435
Introduction to Data Warehousing
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Devin Knight
Title: Introduction to Data Warehousing
Abstract:
In this session you will learn why you need a Data Warehouse, how to plan for one, and what the key steps to developing one. You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse. This session will focus more on the concepts of development rather than demonstrating the development itself.
SessionID: 31436
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Devin Knight
Abstract:
In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.
SessionID: 31651
Windows Azure Overview
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV
Speaker: Vincent Mayfield
Title: Windows Azure Overview
Abstract:
SessionID: 31776
Using PowerShell to Rapidly Deploy SQL Server
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC
Speaker: Michael Wells
Title: Using PowerShell to Rapidly Deploy SQL Server
Abstract:
This session will cover a PowerShell project that is designed to allow organizations to rapidly deploy new SQL Server instances to their environment. The process includes automating all aspects of the SQL Server install from Operating System pre-configurations, the SQL Server install, to deploying standard SQL objects such as databases, tables, jobs, and stored procedures.
SessionID: 31905
The Power of ASP.NET 4.0 Dynamic Data
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV
Speaker: Mike Huguet
Title: The Power of ASP.NET 4.0 Dynamic Data
Abstract:
ASP.NET Dynamic Data is now a matured offering of the .NET framework. In this session we will take a feature tour demonstrating its power and flexibility. We’ll discuss practical usages and customizations.
SessionID: 31906
Leveraging Open XML to Create More Dynamic Docs
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV
Speaker: Mike Huguet
Title: Leveraging Open XML to Create More Dynamic Docs
Abstract:
SessionID: 32469
Introduction to SQL Azure
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL
Speaker: Ryan Duclos
Title: Introduction to SQL Azure
Abstract:
SessionID: 32589
Revenge: The SQL!
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
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: 32627
T-SQL Alphabet Soup
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL
Speaker: Rodney Landrum
Title: T-SQL Alphabet Soup
Abstract:
Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.
SessionID: 32682
How to Make (more) Money with WP7
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Windows Phone Garage
Speaker: Russ Fustino
Title: How to Make (more) Money with WP7
Abstract:
When you get your app running… and even more so when published… you are most likely feeling pretty good and on cloud 9. It feels great, doesn’t it? Here are a few suggestions in this chapter to make you feel even better. Of course, more work is needed. Getting your app noticed in marketplace will not happen automatically or optimally by publishing alone. There specific suggestions I will offer up to help the cause. So, grab a deep breath and get ready to settle in and focus on making more money. Make all the time you have invested so far, well worth it. Many of the suggestions are common sense when you think them through, but are a few I found out the hard way and hopefully will save you some pain. Topics include: Marketing Basics, Gettin
SessionID: 32742
Entity Framework v4.1: What's New in 2011
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC
Speaker: Sven Aelterman
Title: Entity Framework v4.1: What's New in 2011
Abstract:
Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a "code only" approach, which has many benefits, including for testability and long-term evolution of your code.
SessionID: 32743
Entity Framework Quick Introduction
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DEV
Speaker: Sven Aelterman
Title: Entity Framework Quick Introduction
Abstract:
For those attendees who want to attend the Entity Framework version 4.1 session, but aren’t quite sure what Entity Framework is, and how to get started with the basics, this talk with some background info and basic demos will get you up to speed. This will use the traditional EF approach of creating a model using a designer based on an existing or new database.
SessionID: 32914
Building SMO Apps for the Non-Programmer DBA
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Shawn McGehee
Title: Building SMO Apps for the Non-Programmer DBA
Abstract:
SessionID: 32931
Branding Yourself for a Dream Job - The Modern Res
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: MISC
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job - The Modern Res
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 32932
Preparation for Disaster
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Steve Jones
Title: Preparation for Disaster
Abstract:
This session will showcase how a DBA can be ready for any problems that might occur in their environment. Steve Jones will talk about how you can develop a well thought out backup and recovery solution for all kinds of disasters, learn about practicing restores, and the value of regularly running checks for corruption in your databases..
SessionID: 33339
SSIS: The DBA multiplier
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI
Speaker: Ted Krueger
Title: SSIS: The DBA multiplier
Abstract:
SessionID: 33447
SQL Server Partitioning from A to Z
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA
Speaker: Kevin Boles
Title: SQL Server Partitioning from A to Z
Abstract:
We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.
SessionID: 33448
SQL Server Memory Deep Dive
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Kevin Boles
Title: SQL Server Memory Deep Dive
Abstract:
SessionID: 33565
Execution Plan Basics - Beginners
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance
Speaker: Thomas LeBlanc
Title: Execution Plan Basics - Beginners
Abstract:
This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?
SessionID: 33608
You inherited a database, now what?
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL
Speaker: Tim Radney
Title: You inherited a database, now what?
Abstract:
SessionID: 33713
Transition from DBA to BI Architect
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI
Speaker: Thomas LeBlanc
Title: Transition from DBA to BI Architect
Abstract:
SessionID: 33794
Predictive Analytics - You Can, Too!
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL
Speaker: Troy Ketsdever
Title: Predictive Analytics - You Can, Too!
Abstract:
Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…
SessionID: 33866
Table Vars and Temp Tables: What you NEED to know!
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: DBA and TSQL
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables: What you NEED to know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, 'When do I use one or the other and what are the various impacts of doing so?"
SessionID: 34144
Attribute Discretization in Analysis Services (BI)
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI
Speaker: William E Pearson III
Title: Attribute Discretization in Analysis Services (BI)
Abstract:
SessionID: 34147
Design and Implement BI Like Edison!
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: SSIS and BI
Speaker: William E Pearson III
Title: Design and Implement BI Like Edison!
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
SessionID: 34497
SQL Server DMV Overview
Event Date: 04-06-2011 - Session time: 00:00:00 - Track: Performance
Speaker: William Assaf
Title: SQL Server DMV Overview
Abstract: