Nr: 150
SQLSaturday #150 - Baton Rouge 2012
SessionID: 10175
ASP.NET Web API
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Windows Phone Dev Track
Speaker: Brandon Cornett
Title: ASP.NET Web API
Abstract:
In recent years, the WCF team at Microsoft has released multiple REST services, while the ASP.NET team has helped developers build basic APIs by allowing JSON to be returned from MVC controllers. ASP.NET Web API is a joint effort by both teams to provide a single RESTful API framework. This session will cover the basics of how to use ASP.NET Web API to build simple HTTP services. We will start with a new MVC 4 project and build a functional API that can be consumed by numerous clients in order to query and manipulate data from the host.
SessionID: 10470
WP7 - Simple texting app using MPNS and Azure
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Windows Phone Dev Track
Speaker: Billy Chism
Title: WP7 - Simple texting app using MPNS and Azure
Abstract:
Demo: Build a simple texting application for Windows Phone 7 using Microsoft Push Notification Services and Windows Azure Toolkit for Windows Phone.
SessionID: 10533
MicroORMs:Data Access That Won't Make Your DBA Cry
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 2
Speaker: Brian Sullivan
Title: MicroORMs:Data Access That Won't Make Your DBA Cry
Abstract:
SessionID: 11057
The New T-SQL Analytic Functions
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Bryan Smith
Title: The New T-SQL Analytic Functions
Abstract:
SessionID: 11058
Building Writeback Applications in SSAS
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2
Speaker: Bryan Smith
Title: Building Writeback Applications in SSAS
Abstract:
SessionID: 11373
SAS and SQL -- Introduction
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Cassius Dsouza
Title: SAS and SQL -- Introduction
Abstract:
In this session we will introduce accessing data and writing queries in SAS. If time permits, we will cover statistical modeling techniques on datasets to depict its implementation in business intelligence projects. No prior knowledge of SAS is assumed. However, knowledge of basic SQL techniques is assumed.
SessionID: 11737
SQL Server Best Practices for SharePoint 2010
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SharePoint
Speaker: Cody Gros
Title: SQL Server Best Practices for SharePoint 2010
Abstract:
Are you a SharePoint administrator and now have to maintain all your SharePoint databases? This session will provide you with the information you need to maintain your SharePoint databases including:
- Backup/Recovery of databases
- Determining your recovery model
-Building maintenance plans
- SQL Aliases
SessionID: 11743
The Power of SharePoint Search
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: IT Pro
Speaker: Cody Gros
Title: The Power of SharePoint Search
Abstract:
SharePoint 2010 brings to the table an enterprise level search solution that allows you to search content inside and outside of your organization. This session will dive into the various features that are included in SharePoint search. This session will cover the following topics:
- Searching content inside your organization
- Searching people/expertise inside the enterprise
- Searching external LOB data using BCS
- Using search to build a Corporate Directory Search
SessionID: 12128
Toastmasters. Where Leaders Are Made
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career
Speaker: Kimberly Boyd, DTM
Title: Toastmasters. Where Leaders Are Made
Abstract:
SessionID: 12319
How to Ace The Technical Interview
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career
Speaker: David Reid
Title: How to Ace The Technical Interview
Abstract:
SessionID: 13999
SharePoint Development for ASP.NET Developers
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SharePoint
Speaker: Eric Trivette
Title: SharePoint Development for ASP.NET Developers
Abstract:
SessionID: 14304
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1
Speaker: Forest Marie
Abstract:
SessionID: 15027
Interviewing Tips for Managers
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career
Speaker: Christine Assaf
Title: Interviewing Tips for Managers
Abstract:
If you are a Manager needing some interviewing education - this is your course! This session focuses on basic interviewing guidelines, including: preliminary interviews, types of testing, secondary or follow-up interviews, while keeping in mind EEO guidelines and best practices. Learn tips and tricks of the trade from an HR guru who is "in the trenches."
SessionID: 15535
Windows Phone Development - Visual Studio Approach
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Windows Phone Dev Track
Speaker: James Sampson
Title: Windows Phone Development - Visual Studio Approach
Abstract:
In this session, you will learn to develop a new Windows Phone 7.5 application using Visual Studio from the ground up. Feel free to bring your laptop to join in. After going through getting started and developing a small application, I will try to help anyone with their own development projects for Windows Phone as well.
SessionID: 15536
Windows Phone 7 Development – Code Garage
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Windows Phone Dev Track
Speaker: James Sampson
Title: Windows Phone 7 Development – Code Garage
Abstract:
SessionID: 16035
ASP.Net MVC and Workflow Foundation
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 2
Speaker: Jeremy Beckham
Title: ASP.Net MVC and Workflow Foundation
Abstract:
Workflow Foundation is a very powerful part of the .Net Framework that has been mostly ignored by the .Net development community. The main reason developers don't learn it is because they just have no idea how to apply it to their current architectures.
This presentation focuses on using Workflow Foundation inside of an ASP.Net MVC application with a n-tiered architecture. We will step through creating a workflow with Workflow Services and then we will see how to use the workflow from an ASP.Net MVC application.
SessionID: 16482
T-SQL Brush-up:The Best Things You Forgot You Knew
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Jennifer McCown
Title: T-SQL Brush-up:The Best Things You Forgot You Knew
Abstract:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos.
SessionID: 16483
Beginning T-SQL
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev
Speaker: Jennifer McCown
Title: Beginning T-SQL
Abstract:
If you'd like to become a database professional - or if you already work with SQL Server at all - you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
SessionID: 16620
10 Things I Wish Developers Learned In College
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career
Speaker: Wayne Odom
Title: 10 Things I Wish Developers Learned In College
Abstract:
I've interviewed a lot of potential software developers and DBAs in the last 3 years. My managers look to myself and my peers to decide who can do the job. As a lead I'm pretty in tune to what you need to know to get the job done. Here are some things that'll help young and old IT pros get a job especially if I'm the interviewer you've got to convince.
SessionID: 16807
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 1
Speaker: Jim Murphy
Title: AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
SessionID: 17327
Adventures in Project Management
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career
Speaker: Jonathan Gardner
Title: Adventures in Project Management
Abstract:
Projects that run long, run over budget, or flat out fail always get management's attention, and not good attention. This session will cover the project management process and demonstrate how it can help deliver higher quality results on time and on budget.
Case studies and real world examples will arm managers and team leads with tools including communication management plans, requirements documentation, stakeholder management plans, and change management. These tools will help mitigate and manage common project pitfalls like status update meetings, gold plating, and scope creep.
At the end of the session attendees will be armed with the knowledge necessary to streamline projects and how to deliver a top quality work product.
SessionID: 17637
Introducing StreamInsight 2.1
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev
Speaker: J Sawyer
Title: Introducing StreamInsight 2.1
Abstract:
SessionID: 17965
Data Visualizations: From Zero to Hero
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2
Speaker: Kate Treadwell
Title: Data Visualizations: From Zero to Hero
Abstract:
I will discuss one of the easiest ways to make our bosses happy: using data to answer their most difficult questions. Our challenge is to take massive amounts of data and transform it into meaningful visualizations for the business teams that that IT department services. The most difficult problem often lies at the intersection of millions of lines of data and the team’s ability to sort through pages upon pages of Excel or printed reports. I will discuss simple methods of transforming that data from Excel, SQL Server, Oracle, and even flat text files into visualizations which answer some of the biggest questions in a matter of seconds; SSRS or BI development experience is not required.
SessionID: 18662
The Legend of Lambda
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1
Speaker: Chris Eargle
Title: The Legend of Lambda
Abstract:
Lambda expressions are a powerful feature of C#, one that can be wielded for good or evil. Attend this session for an adventure through the evolution of the C# language, from the depths of the delegate keyword to the expressiveness of the lambda expression. I will show you how anyone can easily learn to wield and empower code with lambda expressions. It's dangerous to go alone! Take this: =gt;
SessionID: 19622
Introduction to Data Quality Services
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2
Speaker: Mark Verret
Title: Introduction to Data Quality Services
Abstract:
SessionID: 19623
Moving to a data warehouse
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 1
Speaker: Mark Verret
Title: Moving to a data warehouse
Abstract:
This presentation will walk through the key concepts and decisions necessary for moving from a transactional system to an analytical system based on a data warehouse. Concepts and demonstrations will be based on the process implemented at the LSU Highway Safety Research Group as the case study. The discussion will be based on a more business approach while also presenting technical details.
SessionID: 19630
Developer vs DBA: Can They Coexist?
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 2
Speaker: Mark Holmes
Title: Developer vs DBA: Can They Coexist?
Abstract:
The developer vs DBA rivalry is as classic as pirate vs ninja. Find out why the rivalry exists, why they must learn to work together, and get some tips on coexisting with your nemesis, whether you're a developer or a DBA.
SessionID: 19943
Nuts and Bolts of Table Compression
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 1
Speaker: Mike Byrd
Title: Nuts and Bolts of Table Compression
Abstract:
Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results -- they were surprising to me!
SessionID: 20431
Automated Deployment with TFS 2010 and MSDeploy
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 2
Speaker: Mike Carter
Title: Automated Deployment with TFS 2010 and MSDeploy
Abstract:
Automating deployment of web solutions using Team Foundation Server 2010, Team Build and MSDeploy.
SessionID: 21292
Managing SQL Server in the Enterprise with TLAs
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 2
Speaker: Nancy Hidy Wilson
Title: Managing SQL Server in the Enterprise with TLAs
Abstract:
Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server 2008 and 2008 R2 features designed to make a DBA’s life easier. If you aren’t using CMS, PBM, EPM, MDW, UCP or DAC – come learn what they are and the potential benefits for managing your environment.
SessionID: 21294
SQL Server 2012 Database Engine – Why Upgrade?
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 2
Speaker: Nancy Hidy Wilson
Title: SQL Server 2012 Database Engine – Why Upgrade?
Abstract:
There seems to be lots of buzz about AlwaysOn (new high availability \ disaster recovery feature) and new BI features in SQL Server 2012. But, what else do you need to be aware of specifically for the database engine to make your case for upgrading? This session will provide an overview of changes to the installation process, enhancements for manageability (PowerShell updates, new DMVs and T-SQL functions), updates to security features and more! You’ll leave this session with a list of SQL Server 2012 features to help you develop your upgrade justification.
SessionID: 21777
SSIS for ETL in the Enterprise Environment
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 1
Speaker: Paul Kennedy
Title: SSIS for ETL in the Enterprise Environment
Abstract:
Design walkthrough of an ETL solution developed using the Microsoft SSIS system for an enterprise level Data Warehouse. Managing the ETL process migration from a single data warehousing SQL Server to a multi-server environment can often be a complex task. This session will walk you through the design of a ETL system that has been created for such a scenario. The design takes into consideration several of the shortcomings inherent in the SSIS system and provides a structure for coordinated loading and processing of data from extraction to presentation.
SessionID: 22168
Design Windows Phone Apps with Expression Blend
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Windows Phone Dev Track
Speaker: Paul Johnson
Title: Design Windows Phone Apps with Expression Blend
Abstract:
In this session we will take a design approach to building a Windows Phone app with Expression Blend.
SessionID: 22741
Lap Around SQL Azure
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 2
Speaker: Ryan Duclos
Title: Lap Around SQL Azure
Abstract:
***It is assumed that you have familiarity with SQL Server.
SessionID: 22742
SQL Azure Reporting
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 1
Speaker: Ryan Duclos
Title: SQL Azure Reporting
Abstract:
***It is assumed that you have familiarity with designing/managing SSRS reports.
SessionID: 23707
Code First with Entity Framework
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 2
Speaker: Ryan Richard
Title: Code First with Entity Framework
Abstract:
Most developers are probably more familiar with the database first and model first design methods in Entity Framework, simply because these areas reached maturity earlier in the product life cycle. However, beginning with Entity Framework 4.1, the code first method has also become fully developed. This session will introduce you to the main concepts and core objects, methods, properties, etc. used to build your data access layer with code first methodology in Entity Framework.
SessionID: 23712
How Active Directory affects SQL Server
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 1
Speaker: Ryan Adams
Title: How Active Directory affects SQL Server
Abstract:
There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent. We'll discuss how the location of your server in AD is important, how security can be compromised, and even AD DNS configuration. By the end of the session you'll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policies Objects.
SessionID: 23886
System Center 2012 Configuration Manager Overview
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: IT Pro
Speaker: Santos Martinez and Elias Mereb
Title: System Center 2012 Configuration Manager Overview
Abstract:
Attendees will be able to gain general knowledge of ConfigMgr 2012 and its functionality
SessionID: 23887
Windows 8 Demo and QA
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: IT Pro
Speaker: Santos Martinez and Elias Mereb
Title: Windows 8 Demo and QA
Abstract:
A review of the new Windows 8 operating system and QA with Microsoft PFE Santos Martinez.
SessionID: 23888
Windows Server 2012 Demo and QA
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: IT Pro
Speaker: Santos Martinez and Elias Mereb
Title: Windows Server 2012 Demo and QA
Abstract:
A review of the new Windows Server 2012 operating system and QA with Microsoft PFE Santos Martinez.
SessionID: 23971
ConfigMgr 2012: Plan, Deploy, and Migrate from 2k7
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: IT Pro
Speaker: Santos Martinez
Title: ConfigMgr 2012: Plan, Deploy, and Migrate from 2k7
Abstract:
SessionID: 24267
Beginning Powershell for DBAs 1.0
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 2
Speaker: Sean McCown
Title: Beginning Powershell for DBAs 1.0
Abstract:
The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
SessionID: 24269
The Backup Tune-up
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 1
Speaker: Sean McCown
Title: The Backup Tune-up
Abstract:
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success.
SessionID: 24299
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1
Speaker: Latish Sehgal
Abstract:
SessionID: 25307
Unit Testing - Solving some Tough Issues
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1
Speaker: Steve Schaneville
Title: Unit Testing - Solving some Tough Issues
Abstract:
- how to write test for older code libraries that do not currently have unit tests so that the code can be changed with confidence (a look at the new Fakes framework in VS 2012).
- how to write tests for logic/data access code that uses Entity Framework without hiding the flexiblilty of Entity Framework (note, I actually don't prefer the repository pattern).
SessionID: 26513
Using SSIS 2012 for ETL in a Data Warehouse
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 1
Speaker: Thomas LeBlanc
Title: Using SSIS 2012 for ETL in a Data Warehouse
Abstract:
This session will go through some old and new features of Integration Service 2012 to help with loading data into a Data Warehouse/Mart. The GUI has been improved visually during design and execution. The storage of packages has been update with Integration Service Catalogs. The Change Data Capture task helps with incremental updates. Logging has been improved for debugging. A demostration of creating your own Slowly Changing Dimension with current Tasks will be shown with some design hints.
SessionID: 26782
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2
Speaker: Tim Costello
Abstract:
SessionID: 26783
Dimensional Design primer: What you need to know
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 1
Speaker: Tim Costello
Title: Dimensional Design primer: What you need to know
Abstract:
Everybody wants a data warehouse. What IS a data warehouse? How is it different from a data mart? What is a star Schema? What are snowflakes? Why is the dimensional bus important? In this session we'll cover all the key concepts you need to know to better understand what a data warehouse is and how to start building one.
SessionID: 26989
Mapping Mashups with SharePoint Designer
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SharePoint
Speaker: Tom Resing
Title: Mapping Mashups with SharePoint Designer
Abstract:
Mapping Mashups with SharePoint Designer including an Overview of Current Map Service Providers, an Introduction to Customizing the Data View Web Part, and a Demonstration of Dynamic Mapping from List Data
SessionID: 26990
Integrate with Business Connectivity Services
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SharePoint
Speaker: Tom Resing
Title: Integrate with Business Connectivity Services
Abstract:
Business Connectivity Services with Microsoft SQL Server including an Overview of the Business Connectivity Services, an Introduction to Configuring BCS, and Demonstrations of using External Lists and External Data Columns.
SessionID: 27111
Windows Azure and Smooth Streaming
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1
Speaker: Trey Cook
Title: Windows Azure and Smooth Streaming
Abstract:
Learn how to leverage Windows Azure and the Content Delivery Network to host HD quality video, and Visual Studio to build and deploy a Smooth Streaming Media player to play the video.
SessionID: 27672
Adding Metro Style Navigation to a SharePoint Site
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SharePoint
Speaker: Bill Watters
Title: Adding Metro Style Navigation to a SharePoint Site
Abstract:
SessionID: 34635
What you don't know underscore.js yet?
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 2
Speaker: George Mauer
Title: What you don't know underscore.js yet?
Abstract:
Nearly everyone working with javascript knows jQuery but there are lot's of useful javascript libraries! Come learn about the incredibly popular underscore.js - a utility jackknife that is the "bow tie to jQuery's tux". This session will cover the basics of what you can do with underscore and why you should include it in your javascript projects. Always.
SessionID: 34710
Why Data Warehousing?
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2
Speaker: Kristen Reeves
Title: Why Data Warehousing?
Abstract:
SessionID: 9028
Benchmarking, Baselines and Monitoring Storage
Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 1
Speaker: Wesley Brown
Title: Benchmarking, Baselines and Monitoring Storage
Abstract:
Benchmarking, Baselines and Monitoring Storage
There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life.
We will cover:
SQLIO, a specific SQL Server benchmarking tool.
Iometer, a general IO benchmarking tool and simulator.
SQLIOSim a specific SQL Server base lining tool and simulator.
TPC style testing focused on TPC-C, TPC-E and TPC-H.
Monitoring your system using WMI and virtual file stats.
Finally, what it all really means, how to read these results and compare them with each other.
With these tools you can plan, deploy and manage your storage for years to come!