sqlsathistory

Nr: 150

Back to Main list

SQLSaturday #150 - Baton Rouge 2012

Start Time (24h) Speaker Track Title
00:00:00 Brandon Cornett Windows Phone Dev Track ASP.NET Web API
00:00:00 Billy Chism Windows Phone Dev Track WP7 - Simple texting app using MPNS and Azure
00:00:00 Brian Sullivan .net 2 MicroORMs:Data Access That Won't Make Your DBA Cry
00:00:00 Bryan Smith SQL Dev The New T-SQL Analytic Functions
00:00:00 Bryan Smith SQL BI 2 Building Writeback Applications in SSAS
00:00:00 Cassius Dsouza SQL Dev SAS and SQL -- Introduction
00:00:00 Cody Gros SharePoint SQL Server Best Practices for SharePoint 2010
00:00:00 Cody Gros IT Pro The Power of SharePoint Search
00:00:00 Kimberly Boyd, DTM Career Toastmasters. Where Leaders Are Made
00:00:00 David Reid Career How to Ace The Technical Interview
00:00:00 Eric Trivette SharePoint SharePoint Development for ASP.NET Developers
00:00:00 Forest Marie .net 1 Tools, Tips and Nuget for ASP.NET Developers
00:00:00 Christine Assaf Career Interviewing Tips for Managers
00:00:00 James Sampson Windows Phone Dev Track Windows Phone Development - Visual Studio Approach
00:00:00 James Sampson Windows Phone Dev Track Windows Phone 7 Development – Code Garage
00:00:00 Jeremy Beckham .net 2 ASP.Net MVC and Workflow Foundation
00:00:00 Jennifer McCown SQL Dev T-SQL Brush-up:The Best Things You Forgot You Knew
00:00:00 Jennifer McCown SQL Dev Beginning T-SQL
00:00:00 Wayne Odom Career 10 Things I Wish Developers Learned In College
00:00:00 Jim Murphy SQL DBA 1 AlwaysOn - Finally, A usable 'mirror'!
00:00:00 Jonathan Gardner Career Adventures in Project Management
00:00:00 J Sawyer SQL Dev Introducing StreamInsight 2.1
00:00:00 Kate Treadwell SQL BI 2 Data Visualizations: From Zero to Hero
00:00:00 Chris Eargle .net 1 The Legend of Lambda
00:00:00 Mark Verret SQL BI 2 Introduction to Data Quality Services
00:00:00 Mark Verret SQL BI 1 Moving to a data warehouse
00:00:00 Mark Holmes SQL DBA 2 Developer vs DBA: Can They Coexist?
00:00:00 Mike Byrd SQL DBA 1 Nuts and Bolts of Table Compression
00:00:00 Mike Carter .net 2 Automated Deployment with TFS 2010 and MSDeploy
00:00:00 Nancy Hidy Wilson SQL DBA 2 Managing SQL Server in the Enterprise with TLAs
00:00:00 Nancy Hidy Wilson SQL DBA 2 SQL Server 2012 Database Engine – Why Upgrade?
00:00:00 Paul Kennedy SQL BI 1 SSIS for ETL in the Enterprise Environment
00:00:00 Paul Johnson Windows Phone Dev Track Design Windows Phone Apps with Expression Blend
00:00:00 Ryan Duclos SQL DBA 2 Lap Around SQL Azure
00:00:00 Ryan Duclos SQL BI 1 SQL Azure Reporting
00:00:00 Ryan Richard .net 2 Code First with Entity Framework
00:00:00 Ryan Adams SQL DBA 1 How Active Directory affects SQL Server
00:00:00 Santos Martinez and Elias Mereb IT Pro System Center 2012 Configuration Manager Overview
00:00:00 Santos Martinez and Elias Mereb IT Pro Windows 8 Demo and QA
00:00:00 Santos Martinez and Elias Mereb IT Pro Windows Server 2012 Demo and QA
00:00:00 Santos Martinez IT Pro ConfigMgr 2012: Plan, Deploy, and Migrate from 2k7
00:00:00 Sean McCown SQL DBA 2 Beginning Powershell for DBAs 1.0
00:00:00 Sean McCown SQL DBA 1 The Backup Tune-up
00:00:00 Latish Sehgal .net 1 The .Net Ninja's Toolbelt
00:00:00 Steve Schaneville .net 1 Unit Testing - Solving some Tough Issues
00:00:00 Thomas LeBlanc SQL BI 1 Using SSIS 2012 for ETL in a Data Warehouse
00:00:00 Tim Costello SQL BI 2 Pro Tips: Performance Tuning SSIS
00:00:00 Tim Costello SQL BI 1 Dimensional Design primer: What you need to know
00:00:00 Tom Resing SharePoint Mapping Mashups with SharePoint Designer
00:00:00 Tom Resing SharePoint Integrate with Business Connectivity Services
00:00:00 Trey Cook .net 1 Windows Azure and Smooth Streaming
00:00:00 Bill Watters SharePoint Adding Metro Style Navigation to a SharePoint Site
00:00:00 George Mauer .net 2 What you don't know underscore.js yet?
00:00:00 Kristen Reeves SQL BI 2 Why Data Warehousing?
00:00:00 Wesley Brown SQL DBA 1 Benchmarking, Baselines and Monitoring Storage

SessionID: 10175

ASP.NET Web API

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Modern ORMs like NHibernate and Entity Framework are powerful, flexible tools that are the right choice for many projects. But they feel like overkill for that little internal app with three tables and one screen. And even after a ton of tuning, the SQL they produce for that massive screen in your mission-critical enterprise app can be abysmal. It turns out that both of these problems might have the same answer: a Micro ORM. These lightweight tools leverage the power of dynamic typing and other advanced .NET framework features to give you a simple way to get your data that's also easy to optimize. Brian will give an overview of the various tools available, and dive deep into PetaPoco to show you how powerful these little frameworks can be.

SessionID: 11057

The New T-SQL Analytic Functions

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev

Speaker: Bryan Smith

Title: The New T-SQL Analytic Functions

Abstract:

In this session, we will explore the new T-SQL analytic functions introduced with Microsoft SQL Server 2012, looking not only at what challenges they help us solve but also how they simplify T-SQL development and improve query performance.

SessionID: 11058

Building Writeback Applications in SSAS

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2

Speaker: Bryan Smith

Title: Building Writeback Applications in SSAS

Abstract:

Write-back is a powerful feature of Analysis Services that provides the ability to input data directly into complex models. In this session, you will learn the basic techniques for Analysis Services write-back and how these techniques may be applied to address various business needs.

SessionID: 11373

SAS and SQL -- Introduction

Back to calendar

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

Back to calendar

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:

SessionID: 11743

The Power of SharePoint Search

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: IT Pro

Speaker: Cody Gros

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:

SessionID: 12128

Toastmasters. Where Leaders Are Made

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career

Speaker: Kimberly Boyd, DTM

Title: Toastmasters. Where Leaders Are Made

Abstract:

A demonstration of the tools, techniques, and benefits of Toastmasters International program. We will present a Toastmaster meeting that will allow the participants to see, hear, and experience the effects of communication and leadership development.

SessionID: 12319

How to Ace The Technical Interview

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: Career

Speaker: David Reid

Title: How to Ace The Technical Interview

Abstract:

You will learn hoiw to initially prepare for the interview. Provide the company with the best information highlighting your talents. Provide you with insights and information to get you in front of the right people looking for talent..

SessionID: 13999

SharePoint Development for ASP.NET Developers

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SharePoint

Speaker: Eric Trivette

Title: SharePoint Development for ASP.NET Developers

Abstract:

Getting started in the world of SharePoint development? Have ASP.NET development experience? In this session, you will learn how SharePoint 2010 is built off the ASP.NET platform. We will also bridge the gap between both platforms by covering the basics of the SharePoint platform and set you on the path to developing your own SharePoint solutions.

SessionID: 14304

Tools, Tips and Nuget for ASP.NET Developers

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1

Speaker: Forest Marie

Title: Tools, Tips and Nuget for ASP.NET Developers

Abstract:

A high level discussion of the tools used in a large enterprise by a professional .NET team. On a budget? No worries, most of these tools are free courtesy of the open source .NET developer community that you need to know about. Discussion to include awesome debugging skills, catching performance issues before they go live (we learned the hard way), how to have a professional error logging system set up in minutes, working with other developers and productivity tools. We'll also spend some on some critical design tips to keep your applications running faster and avoiding the "clean slate syndrome."

SessionID: 15027

Interviewing Tips for Managers

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Ready to get started on your Windows Phone application? Bring your laptop with the pre-installed SDK to this session to get started with your app ideas. There will be a developer or two familiar with the platform to help you get started.

SessionID: 16035

ASP.Net MVC and Workflow Foundation

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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'!

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL Dev

Speaker: J Sawyer

Title: Introducing StreamInsight 2.1

Abstract:

StreamInsight provides real-time analytics on large volumes of data with a response time measured in milliseconds, bringing a new level of capabilities to the Sql Server platform. This session will provide an overview of StreamInsight, its capabilities and use cases. It will also provide details on StreamInsight 2.1, what's been added and how it makes your real-time applications easier and more robust.

SessionID: 17965

Data Visualizations: From Zero to Hero

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2

Speaker: Mark Verret

Title: Introduction to Data Quality Services

Abstract:

Having clean data is a critical component in data warehousing and business intelligence systems. With the release of SQL Server 2012 Microsoft has provided a powerful tool to help organizations in tackling their data quality issues. We will look at this new Data Quality Services tool and how it can help clean the data that will eventually end up in your warehouse.

SessionID: 19623

Moving to a data warehouse

Back to calendar

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?

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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?

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL DBA 2

Speaker: Ryan Duclos

Title: Lap Around SQL Azure

Abstract:

SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations.

***It is assumed that you have familiarity with SQL Server.

SessionID: 22742

SQL Azure Reporting

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 1

Speaker: Ryan Duclos

Title: SQL Azure Reporting

Abstract:

SQL Azure Reporting is a CTP offering and part of the SQL Azure and Windows Azure Platform. The SQL Azure Reporting component is based on SQL Server Reporting Services (SSRS). It is a cloud-based service offerring a subset of SSRS technology. In this session we will go over the basic of getting SQL Azure Reporting setup and wired up.

***It is assumed that you have familiarity with designing/managing SSRS reports.

SessionID: 23707

Code First with Entity Framework

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

Building on the Deployment and Infrastructure Design session, this technical session walks you through planning and deploying a Microsoft System Center 2012 Configuration Manager hierarchy, including migration from an existing Configuration Manager 2007 hierarchy. Learn about the various migration scenarios, tools such as Package Conversion Manager (PCM) and Physical-to-Virtual (P2V), and share best practice guidance as your customers go to Configuration Manager 2012

SessionID: 24267

Beginning Powershell for DBAs 1.0

Back to calendar

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

Back to calendar

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

The .Net Ninja's Toolbelt

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1

Speaker: Latish Sehgal

Title: The .Net Ninja's Toolbelt

Abstract:

As developers, we all have our favorite utilities, some used occasionally and then there are others that we refuse to work without. We might not use all of them everyday, but a good developer should know his options when the need arises. In this session, we'll go through the tools, utilities and hacks that can make you much more productive as a .Net developer.

SessionID: 25307

Unit Testing - Solving some Tough Issues

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: .net 1

Speaker: Steve Schaneville

Title: Unit Testing - Solving some Tough Issues

Abstract:

Unit Tests are common place in our tools for creating quality code. However, we still run into several road blocks that often prevent us from writing a thorough suite of tests. This session will suggest ways of solving 2 specific problems that I have personally experienced when trying to write suites of unit tests. Specifically, I'll attempt to address:

SessionID: 26513

Using SSIS 2012 for ETL in a Data Warehouse

Back to calendar

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

Pro Tips: Performance Tuning SSIS

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2

Speaker: Tim Costello

Title: Pro Tips: Performance Tuning SSIS

Abstract:

Tuning the data flow is all about choices. In this session we'll explore some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we'll walk through creating a performance baseline, tuning the data source, the destination and all the ‘stuff’ in the middle. This is a demo-driven session.

SessionID: 26783

Dimensional Design primer: What you need to know

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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

Back to calendar

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:

This is a walk through of how to create a Metro Sytle Navigation to a SharePoint Site, potentially including exposing high level Core Metrics in tiles to bubble that key information to users.

SessionID: 34635

What you don't know underscore.js yet?

Back to calendar

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:

SessionID: 34710

Why Data Warehousing?

Back to calendar

Event Date: 04-08-2012 - Session time: 00:00:00 - Track: SQL BI 2

Speaker: Kristen Reeves

Title: Why Data Warehousing?

Abstract:

This presentation will serve as an introduction into the world of Data Warehousing. We will start by covering the key characteristics and concepts of a Data Warehouse as well as go over the differences between a Warehouse and transactional Database Management System. We will then go into the internal design and processes involved in building an efficient Data Warehouse. We will end by discussing why Data Warehouses are useful to a business and how a business can leverage the key information stored to drive future business decisions.

SessionID: 9028

Benchmarking, Baselines and Monitoring Storage

Back to calendar

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!